Project Description:
Our online product management system needs a basic way to import via excel new product pricing from our vendors as the data is received. We need a script (coldfusion definitely is preferred and will be considered first) that does the following:
Checks a server folder for new excel files to import
Takes a look at the data and makes sure its data we want to import
Imports the data and as it imports each row, it looks to see if the product sku is in the system and updates pricing, or adds the row as a new sku/product
Moves excel file to different folder after completion
This should be relatively straight forward, my team is just currently tapped out on time available.
