I have 3 files that have all the data I need, the objective is to get the data I need into 1 simple csv file.
1. Identify the SKUs from the File #1
• This file has the SKUs you’re getting, but titles and other data can’t be trusted.
2. Use the master file File #2 to extract reliable information:
• Match SKUs to gather the necessary fields: Product Title, Sell Price, Cost, Vendor.
3. File #3 has the product Weight
Merge this data into a new master file containing:
• SKU, Product Title, Sell Price, Cost, Vendor, Weight
This is step 1
