We need to cross reference information from 5 CSV files into one. Each file has 400,000 + products descriptions, weights, costs, rates, etc.
The expected results are:
1) a CSV to upload to shopify. With fields Handle, Title, Body (HTML), Vendor, Type, Tags, Published, Option1 Name, Option1 Value, Option2 Name, Option2 Value, Option3 Name, Option3 Value, Variant SKU, Variant Grams, Variant Fulfillment Service, Variant Price, Variant Compare At Price, Variant Barcode, SEO Title, SEO Description, Google Shopping / Google Product Category, Google Shopping / Gender, Google Shopping / Age Group, Google Shopping / MPN, Google Shopping / Condition, Google Shopping / Custom Product, Variant Weight Unit
2) a Shopify shop with a basic theme that shows all the products uploaded via CSV file.
1) Building the CSV files will require cross referencing data from one CSV to another and including calculations in the process.
2) Shopify store will only be used as reference for our staff. There is no need to create a fancy theme or upload images.