Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Products not associated with categories...


SmellTheCoffee

Recommended Posts

Hi Everyone,

We recently imported an old shop database into the OsCommerce database and some of the products from our old database aren't associated with categories yet. However, they are associated with Manufactuers.

 

Is there a way in the admin to associate these products with a category? I can't seem to figure out how to do that. Thanks in advance!

 

Thanks,

 

John

Link to comment
Share on other sites

Hello John,

 

I'm not sure how to do it from admin, because frankly I have stopped using it as I found out it's really easy to do it manually by editing the mysql database yourself.

 

The table you are referring to is products_to_categories, and if your products aren't in there they won't show up on your website, at least they won't be searchable.

 

products_to_categories has two fields, products_id en categories_id. you can read the products_id from the table products_description and the categories_id from categories_description. Now that you know the products_id and the categories_id, you can input that into the table and from then on your products are linked to the categories. It would of course be a lot handier if you were to make the necessary changes to the original data and then import it 'en masse'.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...