Magento Forum

   
Page 7 of 7
After update 1.4 no products showing
 
sonician
Member
 
Total Posts:  49
Joined:  2008-11-29
 
Theodore Doan - 31 March 2011 02:02 AM

Hello all,

To fix the “products do not display on the frontend” you have to run SQL script manually through PhpMyAdmin or any database management tools. Bellow is the scripts:

1. Get all entity_id of items which you have to delete

SELECT DISTINCT `tp`.`entity_id`
FROM `catalog_product_entity_tier_price` AS `tp`
INNER JOIN `customer_group` AS `cg` ON tp.all_groups = 1 OR (tp.all_groups = 0 AND tp.customer_group_id = cg.customer_group_id)
INNER JOIN `core_website` AS `cw` ON tp.website_id = 0 OR tp.website_id = cw.website_id
INNER JOIN `catalog_product_index_website` AS `cwd` ON cw.website_id = cwd.website_id
WHERE (cw.website_id != 0)

AND tp.entity_id NOT IN (SELECT `entity_id` FROM `catalog_product_entity`)

GROUP BY `tp`.`entity_id`, `cg`.`customer_group_id`, `cw`.`website_id` ORDER BY `tp`.`entity_id` ASC

2. Delete all items

DELETE FROM `catalog_product_entity_tier_price` WHERE `entity_id` IN ({GET_FROM_ABOVE_SELECT_QUERY})

Then run re-index process again,

PS: Maybe you have to delete all files at var/locks folder

Do you know if this solution works for Magento 1.5.0.1?

 
Magento Community Magento Community
Magento Community
Magento Community
 
sunilpatil
Jr. Member
 
Total Posts:  11
Joined:  2008-11-21
 

Hi All,

I have also same problem.

there is another way to solve this problem without cleared the table \’catalog_product_entity_tier_price\’.

regards,
sunil

 
Magento Community Magento Community
Magento Community
Magento Community
 
stokly82
Jr. Member
 
Total Posts:  22
Joined:  2012-01-25
 

For you that are just removing the Id where are you going to do that?  Im sure its right in front of my face and ill kick my self in the face for not knowing.  Help on this would be great.  Thank you.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
Page 7 of 7