reorganize excel spreadsheet for online store
- Status: Closed
- Prize: $15
- Entries Received: 7
- Winner: karentzd
I have two spreadsheets of products for our online store downloaded as CSV files. One sheet has photos and all information for an old product list with old pricing. It is in the Shopify coordinated [login to view URL] other is the current inventory list with current pricing but no photos or descriptions. It is a report from our brick and mortar store. There are approximately 5,000 items in each full spreadsheet. I need the two merged into one current product list with the current pricing in one column. Matching the UPC number row for the products would organize the line items with the current pricing. The spreadsheet would be then uploaded as a CSV file compatible with Shopify to update the photos and remove items that do not exist on the new price list. .
The uploaded examples are the first 250 items in the store. If they are organized, the freelancer awarded the project will get the entire spreadsheet and it should organize easily with the same query.
I am not sure why Freelancer show that the supported file types are jpeg, gif, etc. I need the files in excel compatable with the proper csv compatible with Shopify.
“Karen did the work for my request during the contest phase. When the full files were sent to her, she adjusted the query to change them as needed. She communicated well all during the process”
jonington, Costa Rica.