Products not showing in category view in magento 1.4.0.1

Posted: June 14, 2010 in Magento

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

Update database ::
Next four records MUST HAVE id = 0 (zero) in primary key field:
core_store.code=’admin’
core_website.code=’admin’
core_store_group.name=’Default’
customer_group.customer_group_code=’NOT LOGGED IN’

If step 1 is not helpful than go to step2

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);
$process->reindexAll();

I hope this will help to solve product not showing bug

Thanks,
Bijal Bhavsar 🙂

Advertisements
Comments
  1. Andreas says:

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

  2. Amol Kharat says:

    Hi,

    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.

    • Mage Cracker says:

      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.

      Thanks,
      Bijal Bhavsar 🙂

      • Amol Kharat says:

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

  3. Anand says:

    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 1.4.0.1. […]

  5. Chandu says:

    Thanks a lot . Your solution is 100 % working.

  6. Chris Blackburn says:

    Thanks so much for this. Much lost sleep here.

  7. […] 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 1.4.0.1. […]

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s