Hello,
I am trying to manage my products strictly with SQL queries and have come across an issue. I recently wanted to group all my Simple Products into a Grouped Product where the Name of the product was the same.
I updated the following 3 tables:
- Product
- Product_Category_Mapping
- Product_Picture_Mapping
EXAMPLE:
New product in [Product] table, Id = 8296. This is set to a Grouped Product using the ProductTypeId=10 and ProductTemplateId=2
All other products with same name as this group were set the following way:
ParentGroupProductId=8296
VisibleIndividually=0
The Id 8296 was inserted via SQL into the Product_Picture_Mapping and Product_Category_Mapping tables.
When I locate the Grouped Product on my site I see it and it displays the image but the title is not a hyperlink.
TO FIX
If I go into Admin panel and Edit the Grouped Product and just click Save then the Grouped Product is now a hyperlink and works correctly.
What is the code doing in the Save button that I am not doing with a SQL update?
Thank you for any information.
PS: I have cleared the cache on the site and recycled the web app hoping that there was some initialization procedure that could fix my issue but that didn't work. :(