Updating Pricing from another spreadsheet

[tlsuk]

Hi

We have 1000s of products from different manufacturers and we have our own website information in a basic .csv
January the manufacturers will change all the pricing and although we have a common unique part number (i.e. a SKU) , what is the best way to pull across the new pricing on the other spreadsheet to import to our CSV.

We have being using simple commands like PROPER and TEXTJOIN to tidy up product titles, and meta description etc, but the ability to update the price from other spreadsheet is becoming vital?

 

[Logit]

.
I believe that would depend on the present layout of your CSV file.

What is the format of the new pricing worksheet, is it also CSV or something else ? Is the layout of the new price sheet the same as your current CSV file
or does the new pricing sheet data require manipulation to get the updated data into the correct locations/format for your existing CSV ?

Descriptions are fine ... pictures are only slightly better. The best example is a working example of your existing CSV and the new pricing sheet as well.
This forum doesn't allow attachments so you will need to post them to a download website and provide the link here.