We are looking to automate our product and stock.
We are supplied with a CSV file which is fairly detailed -
Category / Sub Category (Attribute set) / Sub Category (Used for category mapping) / SKU / Brand / Label / Description / price / Delivery Price / Picture / Availability / Weight / Weight-Volume / Express Delivery / EAN / Manufacturer Reference / WEEE / Reprography / Private Copying
We need to add a product if it does not exist with image included in CSV file, delete a product if it does not exist on the file with all associated images and if it exists update the stock and price.
We have category mapping already done and would need some manipulation of data including prices to be set with a predetermined mark-up. Meta information we also have mapped but will need additional information from the file added depending on category. Not all fields in the CSV will be used.
We currently have Icecat running on the site which will take care of product specifications and additional images, product relations, cross sells, and up sells.
This will need to run daily at maybe 6.00am GMT for example.