Hi - first time posting, so apologies if this is not in the right place.

I'm a web designer, and have been asked to update a customers pricing on an e-commerce website.

Have exported the data in to a CSV and they have sent me an Excel file with their new pricing on. So far so good...

The export has 5,400 line items on and the received Excel file has just over 2,000 lines, meaning I can't just simply sort by order and replace the column price.

My question is - how can I match the new prices to the relevant rows in the export, without manually going through each line item?

I have the SKU as the consistent data to be matched, but not quite sure how to proceed...

TIA - Martyn