Magento Question posted in
The official documentation can be found here.

Magento 1.9 categories not loading after import

I’m currently stuck at my magento shop and I can’t find a solution. I want to import almost 600.000 products. The process of it is really slow. The more product are in the system, the slower the import of new products works. I also can’t open some category pages. Its simply not loading.

Any idea what could be the problem?

Tags:

3

Answers


  1. 0

    If your indexes are set to auto-update you should switch them to manual mode before importing. this is a common reason for decreasing performance (and db locks)

    $collection = Mage::getSingleton('index/indexer')->getProcessesCollection(); 
foreach ($collection as $process) {
  $process->setMode(Mage_Index_Model_Process::MODE_MANUAL)->save();
}

    after import you could switch back to

      $process->setMode(Mage_Index_Model_Process::MODE_REAL_TIME)->save();
    Login or Signup to reply.
  2. 0

    You should look into https://github.com/avstudnitz/AvS_FastSimpleImport

    This one is based on Mage_ImportExport_Model_Import_Entity_Product and is therefore much faster, than instantiating new product model on each iteration

    Login or Signup to reply.
  3. 0

    For Faster import, you can use Magmi : http://wiki.magmi.org/index.php?title=Main_Page

    once you upload products through, reindex through system > Index Management….

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search