A few months on and I still don’t have this working right so I have a couple of questions…
Firstly, here is the scenario: the store I am working on needs the stock updated daily. They provide this information as a CSV which imports nicely through dataflow. The only items on this daily list are the items that are ‘in stock’.
At present, each day I am deleting (through Admin) ALL the products. Then using dataflow to import the new stock list and when done - the store is correct. However, this means that any product reviews/tags etc get deleted each day too so far from ideal in the long run.
Question 1 - I have tried simply disabling all products (rather than deleting) first and then importing the new stock list but for some reason, even though they are listed as ‘Enabled’ on the stock list, they do not get changed through the Dataflow. They remain ‘disabled’ in the backend - is this the same for everyone? I would have thought it would have overwritten the ‘disabled’ status with ‘Enabled’.
Question 2 - is there a way of changing the XML of the profile so that it overwrites existing records with whatever is in the CSV? Is it something to do with changing <action type="dataflow/convert_parser_csv" method="parse"> in the top of the Actions XML for “overwrite” or something?
Thanks for any help with this folks…