Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Adding directly to categories table


dayOff

Recommended Posts

Hi

 

I have forty products, each of which have the same thirty or so sub categories. Is there any reason why I can't run a series of SQL statements automatically to populate the categories and categories_description tables? Are there any relationships I need to know about, or anything else? Obviously I've spotted the parent field, there doesn't seem to be anything more complicated than that.

 

Cheers

J

----------------------------

John Allsopp

http://www.johnallsopp.co.uk/

Link to comment
Share on other sites

Hi

 

I have forty products, each of which have the same thirty or so sub categories. Is there any reason why I can't run a series of SQL statements automatically to populate the categories and categories_description tables? Are there any relationships I need to know about, or anything else? Obviously I've spotted the parent field, there doesn't seem to be anything more complicated than that.

 

Cheers

J

 

I had the same thing, if I remember rightly I just did one and exported it with EPOP then added the rest and imported.

-----------------------------------------------------------------------------

OSC user for years and no coder, so I've earned my stripes.

 

Feel free to private message me.

Link to comment
Share on other sites

I had the same thing, if I remember rightly I just did one and exported it with EPOP then added the rest and imported.

 

Dunno what EPOP is, but I wrote a PHP script to populate the database and it seems to be working OK.

 

Cheers

J

----------------------------

John Allsopp

http://www.johnallsopp.co.uk/

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...