Just another WordPress.com weblog

3 Steps to solve this bug of magento version
Transfer project in new server this bug occurs.

Update database ::
Next four records MUST HAVE id = 0 (zero) in primary key field:
customer_group.customer_group_code=\’NOT LOGGED IN\’

If step 1 is not helpful than go to step2


Reindexing catalog from admin panel
But here there is problem of reindexing catalog search table and prices
So to solve this issue

truncate catalogsearch_fulltext;

And run below code once:

$process = Mage::getModel(’index/process’)->load(7);

I hope this will help to solve product not showing bug

Bijal Bhavsar 🙂


Comments on: "Products not showing in category view in magento" (8)

  1. Thank you, this article was very helpfull, we have lost hours on this problem 😡

  2. Amol Kharat said:


    I am new in Magento and i am facing this problem….
    But i have one query that where we have to run this blocks of code

    Thank You,
    Amol Kharat.

    • Hello Amol,

      You have to run this code once. For that you can place this code in any file eg. bottom of index.php. After placing Code run index.php in browser and than delete that code.

      Bijal Bhavsar 🙂

      • Amol Kharat said:

        Thanks for reply but I have just reindex the catalog products and it working fine…
        Thanks once again ….. 🙂

  3. Hello can you help me? this is my site and here category product are not showing.

  4. […] The busiest day of the year was July 20th with 96 views. The most popular post that day was Products not showing in category view in magento […]

  5. Thanks a lot . Your solution is 100 % working.

  6. Chris Blackburn said:

    Thanks so much for this. Much lost sleep here.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: