We are looking to upgrade or current websites and will be starting from fresh with cre loaded. We would like a module designed that allows daily imports of csv stock feeds from suppliers.
the module is to support up to 15 csv or excel feeds,each of which will contain data such as sku,quantity,price,image and description etc. There should be a column matching function so that we can map columns in the file to fields in the database.
There should be options to
clear previously uploaded products from the feed and replace with only the latest stock file
ignore header row
upload a stock feed file automatically once it is updated on the ftp site
add a prefix to the sku so we can identify which feed aa product had come from
Once a sku exists in the database the daily feed should just update price and quantity,this allows us to populate missing data such as barcode and description without it being overwritten by the daily feed