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.