We have an inventory that needs to be inputted into a 3D cart application. Part of the inventory's data is currently stored in an Excel file, part of the data is in a txt file and the images associated with each product are on an FTP server. Each image has a file name associated with the product name in the excel file. We need a new excel file created with the image paths that also follows the 3D Cart data formatting rules and will upload to the cart without any problems. The new excel file will need new columns and special formatting for the categories. There are approximately 40,000 products in the original excel file. Many products under certain categories will be mass removed. Only about a third of the products will make it to the new excel file.
Take data for products split across 1 excel file, 1 txt file, 1 ftp server with images
Consolidate and format categories into 1 new excel file