Magento Solutions | The Magento Expert

Category page loading extremely slow (Magento 1)

24. Juni 2016 Magento Solutions

If the category page of your Magento store is loading really slow, the configurable swatches might be the problem. Override /app/code/core/Mage/ConfigurableSwatches/Helper/Mediafallback.php and move // normalize to all lower case before we start using them $optionLabels = array_map(function ($value) { return…

View solution

Category page loads extremely slowly (Magento 1)

Mex 24. Juni 2016 Magento Solutions

If your Magento category pages are extremely slow, Magento swatches may be the culprit. Override /app/code/core/Mage/ConfigurableSwatches/Helper/Mediafallback.php and remove

// normalize to all lower case before we start using them
$optionLabels = array_map(function ($value) {
 return array_map('Mage_ConfigurableSwatches_Helper_Data::normalizeKey', $value);
}, $optionLabels);

// normalize to all lower case before we start using them

$optionLabels = array_map(function ($value) {

return array_map('Mage_ConfigurableSwatches_Helper_Data::normalizeKey', $value);

}, $optionLabels);

from its original location, then insert that code immediately above the surrounding foreach loop. This can substantially improve category page load…

View solution

Magento 2 Expert

Mex 6. Mai 2016 Magento Solutions

If you are having trouble with your Magento 2 store or would like advice and development support for an upcoming Magento 2 project, simply get in touch. I will be happy to help. I look forward to hearing from you.

View solution

Fixing the Mage_Core_Model_Store::setWebsite() argument type error (Magento 1)

Mex 2. Mai 2016 Magento Solutions

You might encounter the message Argument 1 passed to Mage_Core_Model_Store::setWebsite() must be an instance of Mage_Core_Model_Website, null given when moving your store to another server. The solution is straightforward. Run the following SQL queries to resolve the issue:

SET FOREIGN_KEY_CHECKS=0;
UPDATE core_store_group SET group_id = 0 WHERE name = 'Default';
UPDATE core_store SET store_id = 0 WHERE code = 'admin';
UPDATE core_website SET website_id = 0 WHERE code = 'admin';
UPDATE customer_group SET customer_group_id = 0 WHERE customer_group_code = 'NOT LOGGED IN';
SET FOREIGN_KEY_CHECKS=1;

SET FOREIGN_KEY_CHECKS=0;

UPDATE core_store_group SET group_id = 0 WHERE name = 'Default';

UPDATE core_store SET store_id = 0 WHERE code = 'admin';

UPDATE core_website SET website_id = 0 WHERE code = 'admin';

UPDATE customer_group SET customer_group_id = 0 WHERE customer_group_code = 'NOT LOGGED IN';

SET FOREIGN_KEY_CHECKS=1;

View solution

Sort order items by SKU (Magento 1)

19. April 2016 Magento Solutions

If you want to change the default sorting of the ordered items on the order detail page, go ahead and override app/design/adminhtml/default/default/template/sales/order/view/items.phtml in your theme and replace

View solution

Sorting order items by SKU (Magento 1)

Mex 15. April 2016 Magento Solutions

To display ordered products sorted by SKU in the order view, override the app/design/adminhtml/default/default/template/sales/order/view/items.phtml in your theme and replace

<?php $_items = $this->getItemsCollection() ?>
    <?php $i=0;foreach ($_items as $_item):?>
        <?php if ($_item->getParentItem()) continue; else $i++;?>
        <tbody class="<?php echo $i%2?'even':'odd' ?>">
            <?php echo $this->getItemHtml($_item) ?>
            <?php echo $this->getItemExtraInfoHtml($_item) ?>
        </tbody>
    <?php endforeach; ?>

<?php $_items = $this->getItemsCollection() ?>

<?php $i=0;foreach ($_items as $_item):?>

<?php if ($_item->getParentItem()) continue; else $i++;?>

<?php echo $this->getItemHtml($_item) ?>

<?php echo $this->getItemExtraInfoHtml($_item) ?>

</tbody>

<?php endforeach; ?>

with

<?php $_items = $this->getItemsCollection() ?>
    <?php $_sortedItems = array(); ?>
    <?php foreach ($_items as $_item) : ?>
        <?php $_sortedItems[$_item->getSku()] = $_item;?>
    <?php endforeach;?>
    <?php ksort($_sortedItems); // Sort by array keys ?>
    <?php $i=0;foreach ($_sortedItems as $_item):?>
        <?php if ($_item->getParentItem()) continue; else $i++;?>
        <tbody class="<?php echo $i%2?'even':'odd' ?>">
            <?php echo $this->getItemHtml($_item) ?>
            <?php echo $this->getItemExtraInfoHtml($_item) ?>
        </tbody>
    <?php endforeach; ?>

<?php $_items = $this->getItemsCollection() ?>

<?php $_sortedItems = array(); ?>

<?php foreach ($_items as $_item) : ?>

<?php $_sortedItems[$_item->getSku()] = $_item;?>

<?php endforeach;?>

<?php ksort($_sortedItems); // Sort by array keys ?>

<?php $i=0;foreach ($_sortedItems as $_item):?>

<?php if ($_item->getParentItem()) continue; else $i++;?>

<?php echo $this->getItemHtml($_item) ?>

<?php echo $this->getItemExtraInfoHtml($_item) ?>

</tbody>

<?php endforeach; ?>

That’s it. When you open an order containing two or more products, they will now be displayed in…

View solution

“Reset password” page empty after installing SUPEE-6788 (Magento 1)

10. März 2016 Magento Solutions

If the password reset page is emtpy after you installed the Magento security patch SUPEE-6788, the problem is most likely to be found in the customer.xml file. Open the customer.xml file of your theme and replace customer_account_resetpassword with customer_account_changeforgotten. The…

View solution

Deleting all products using SQL (Magento 1)

10. März 2016 Magento Solutions

To delete all product related data, use the following query: DELETE FROM catalog_product_entity; Due to the constraints it will delete all related data from other tables as well.

View solution

Solving “Invalid login credentials” Magento Connect Manager error

8. März 2016 Magento Solutions

If you get the Invalid login credentials error when using the Magento Connect Manager, you most likely changed your FTP credentials some time ago and the Connect Manager still uses the old credentials. To get rid of this error, simply…

View solution

Fixing Invalid login credentials in Magento Connect Manager

Mex 8. März 2016 Magento Solutions

If the Magento Connect Manager displays the error Invalid login credentials , your FTP credentials may have changed while the Connect Manager still has the old ones stored. The simplest workaround is to delete or rename the file connect.cfg im…

View solution