Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Problem Adding products directly with mysql


nunogato

Recommended Posts

Posted

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

Posted

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?).

Posted

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...