Magento – Change order of configuration options in customer product view

attributesconfigurable-productmagento2product-attribute

I have configurable products with many attributes like size and color in v2.2.7.
They are listed in the admin area and in Stores > Attributes > Attribute Set > Default.
The order currently is "Size", then "Color".

But on the customers view for the product, attributes are listed as "Color" and then "Size".

This post in the magento forums outlines how to do it while creating a configurable product. However, if products are already created and you go to configuration options, there is not a way to edit attributes order without also recreating all configured products.

Making the change suggested in "Stores > Attributes > Product > Storefront Properties" from this post, changes the order of how things show up in layered navigation. But it doesn't change the order of configuration options the customer sees.

I'm trying to make "Size" appear above "Color" when customer is looking at product page. How do I change the order of configuration options for products already created?

UPDATE

The order attributes show up in customer view / layered navigation is changed from Stores > Attributes > Product > [attribute] > Storefront Properties > [Position].
The order configuration options show up in customer view / product
details page are controlled by position column in the
catalog_product_super_attribute table (see accepted answer).
The order attributes show up in admin section when adding new
products is based on the order in Stores > Attributes > Attribute
Set > [set] > [Groups]. Note that custom attributes added to the "Product Details" group don't always follow the order in v2.2.7. So it's best to click "Add New" under Groups and add the custom attributes you need to show up in a set order during product on-boarding to the group you created.

Best Answer

The position of the attributes of Configurable Product are stored at catalog_product_super_attribute

Use SQL to update position in PDP

192 = Id attribute Size
193 = Id Attribute Color
update catalog_product_super_attribute set position = 1 where attribute_id = 192 AND product_super_attribute_id <> 0;
update catalog_product_super_attribute set position = 2 where attribute_id = 193 AND product_super_attribute_id <> 0;

update:

Where you can find attribute id => You can look up in the table named eav_attribute

select attribute_id from eav_attribute where attribute_code = '[attribute code]';

Related Solutions

Magento – Order of Values/Labels of Configurable attribute options and custom options on cart page

I'm not 100% sure on this, I've ever actually used custom options, but tracing back from the template, I think you'd need to rewrite Mage_Catalog_Helper_Product_Configuration::getCustomOptions. I'm assuming the custom option comes from the additional_options field so at the bottom of that function you can just re-arrange the order:

$addOptions = $item->getOptionByCode('additional_options');
if ($addOptions) {
    // switch around the order of the items in the array like so
    $options = array_merge(unserialize($addOptions->getValue()), $options);
}

Magento – Magento category layout update: Set “Position of attribute in layered navigation block”

Not without custom code. There is a block class for the filter display, Mage_Catalog_Block_Layer_State, but the filter data comes from the model Mage_Catalog_Model_Layer_State, which is populated by Mage_Catalog_Model_Layer and cannot be influenced from the block.

If your alternative sort order can be expressed with an SQL order clause, you could override Mage_Catalog_Model_Layer::_prepareAttributeCollection() and change the sort order of the collection depending on the current category. It's set to $collection->setOrder('position', 'ASC') before this method is called. But rewriting the layout model is better avoided.

A better option without rewrites is to create a custom block that extends Mage_Catalog_Block_Layer_State:

class Stack_Catalog_Block_Layer_State extends Mage_Catalog_Block_Layer_State
{
    public function getActiveFilters()
    {
        $filters = parent::getActiveFilters();

        // $filters is an array of Mage_Catalog_Model_Layer_Filter_Item objects
        // sort it with usort() to your needs

        return $filters;
    }
}

And another one that extends Mage_Catalog_Block_Layer_View because this is where the state block is created:

class Stack_Catalog_Block_Layer_View extends Mage_Catalog_Block_Layer_View
{
    protected function _initBlocks()
    {
        parent::_initBlocks();
        $this->_stateBlockName = 'stack_catalog/layer_state';
    }
}

Then replace the layer block in your categories custom layout update:

<reference name="left">
    <block type="stack_catalog/layer_view" name="catalog.leftnav" after="currency" template="catalog/layer/view.phtml"/>
</reference>

It's adding a new block, but using the same name catalog.leftnav of the original block, so it will be replaced. This is because you cannot change the type of an existing block.

Best Answer

update:

Related Solutions

Magento – Order of Values/Labels of Configurable attribute options and custom options on cart page

Magento – Magento category layout update: Set “Position of attribute in layered navigation block”

Related Topic