nunogato Posted June 16, 2010 Posted June 16, 2010 Hi, I have write a php script to get one of our manufacturers stock xml file, parse it and add/remove/update products available. The script is updating the mysql database and products are being added correctly, I can see the products, categories etc, but the search is not working... and the total products for each category is not working too... Can anyone help me with this? If somebody needs to access the "test" store please contact me and I give the link. Regards Nuno Gato RoboSavvy.com
MrPhil Posted June 16, 2010 Posted June 16, 2010 There are three or four tables you have to update -- maybe you missed one? Rather than re-inventing the wheel, since you're trying to do a bulk/batch update, have you looked at the EasyPopulate add-on? It takes a CSV file, rather than XML, as input so you'll need to write a converter (XML to CSV... maybe one already exists?).
nunogato Posted June 16, 2010 Author Posted June 16, 2010 There are three or four tables you have to update -- maybe you missed one? Rather than re-inventing the wheel, since you're trying to do a bulk/batch update, have you looked at the EasyPopulate add-on? It takes a CSV file, rather than XML, as input so you'll need to write a converter (XML to CSV... maybe one already exists?). I, the script is to run once a day automatically that's why I have created this one. I have updated the tables: products products_description products_to_categories categories categories_description maybe I'm missing some table. Regards
Recommended Posts
Archived
This topic is now archived and is closed to further replies.