Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Conolidating supplier data into my price list


dan_tm

Recommended Posts

Hi guys,

 

finally got around to registering recently and figured this would be the best place to post as it is an issue I am experiencing when I am expanding onto the web :D

 

So I have a list from a few suppliers that has the latest prices supplied in a CSV format, I wish to extract just the buy price from the spreadsheets but I want it to map into the excel file I have made to import into my oscommerce site.

 

So I figure the way I would do it would be to have one spreadsheet and at the start of each day download each of the suppliers latest lists and delete every field except for part no and buy price and the list would populate my database.

 

the basic syntax I can think of is: Where column C (my part number column) = column A (there part number column, copy column B (there buy price) to column D (my buy column).

 

Does anyone know the best function to put this into practice in excel?

 

Regards,

Dan

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...