M2ePro slow to add products to listings groups on large catalog

M2ePro slow to add products to listings groups on large catalog

If your running a Magento store with a large catalog of products you may notice that when adding products using the ‘Add from product list’ option that it can become very slow to load.

The problem is related to the fact that MySql query used for adding the products to the Listing works differently on the different versions of MySql servers.

There is an alternative query already written in the code that should be much faster.
Please look at the specified files:

app/code/community/Ess/M2ePro/Block/Adminhtml/Ebay/Listing/Product/Grid.php
app/code/community/Ess/M2ePro/Block/Adminhtml/Common/Amazon/Listing/Product/Grid.php
app/code/community/Ess/M2ePro/Block/Adminhtml/Common/Buy/Listing/Product/Grid.php
app/code/community/Ess/M2ePro/Block/Adminhtml/Common/Play/Listing/Product/Grid.php

1. Find and comment out these lines:
$collection->getSelect()
->joinLeft(array(‘sq’ => $dbExcludeSelect), ‘sq.product_id = e.entity_id’, array())
->where(‘sq.product_id IS NULL’);

2. Find and uncomment this line:
// $collection->getSelect()->where(‘`e`.`entity_id` NOT IN (‘.$excludeProductsSelect->__toString().’)’);

3. Flush Magento cache, refresh compilation (if it is enabled) and check. It should help.

Please remember that every time M2ePro is updated then this will revert back to normal.

Share this post

Leave a Reply

Your email address will not be published. Required fields are marked *