Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email

Magento Forum

Batch database Import to establish product to category relationships
Jr. Member
Total Posts:  6
Joined:  2008-06-04

When I imported my data i only set subcategory to product relationships.  So if I click on a main category no products show up.  Only if I select a subcategory.

Thousands of products.

Does anyone know what tables to update in the database to establish this.

I tried adding rows to catalog_category_product and updating the categorys_id column in catalog_products_entity.

Refreshed cache cataolg index, etc.

But the products do not show when I click on the category link.

I am not using seo urls rewrites so that is out of the equation.

Any guidance much appreciated.  Hopefully, I can achieve this via batch update script to database.  Versus manually editing each product in the admin interface.

Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top