When I add products to a category through the admin pages, the product is not showing up on the relevant category page.
Ive have searched for an answer for this extensively and carried out all the necassary checks:
product enabled is in stock has a positive quantity is assigned to a store view etc..
I have done this many times but now it has all stopped working.
This includes creating new products to add to categories and also adding existing products to other categories.
the product does not appear. This is after reindexing and clearing cache etc..
After looking in the database, i found the the Category ID - Product ID pair does not appear in the table
After adding the necassary records to this table manually and then performing a reindex, the products have appeared in their categories.
I have a lot more products to add and this is not an ideal solution in the long term as i shouldnt be manually adding records to the database like this.
does anyone know what could cause this issue and if it is a known issue and if there is a possible patch to it?