Configurable attribute options are not sorted

[mcjwsk]

Configurable attribute options are not sorted on the product page.

Preconditions

1. Magento CE 2.1.2

Steps to reproduce

1. Create a configurable attribute and add two options at least.
2. Create a configurable product for these options.
3. Go to the product page and see the configurable attribute select (options).
4. Change attribute options sort order and flush all caches.
5. Go to the product page and see the configurable attribute select (options) looks like before.

Expected result

1. Configurable options HAVE been reordered.

Actual result

1. Configurable options HAVE NOT been reordered.

The issue is related to the method ConfigurableAttributeData::getAttributeOptionsData() in the file app/code/Magento/ConfigurableProduct/Model/ConfigurableAttributeData.php.
I think you should load options sort order here and sort the output array.

[veloraven]

@dmaciej thank you for your feedback.
Please, identify exact version of Magento you are running.

[mcjwsk]

@veloraven updated

[schasiepen]

2.1.1 CE / CentOS 6.7 / PHP 7
See the same behavior with configurable products with 2 options: the second option is always sorted by label and not by sort order.

[jagdishram]

For the solution please visit on the link: http://magento.stackexchange.com/questions/141899/configurable-product-attribute-sort-order-in-dropdown-2-12/146858#146858

OR

As I checked this issue and found that while fetching the attribute options, there is no sorting filter added in the query by default in Magento 2.1.2, So to fix this issue need to add the below code to add the ORDER By in function getAttributeOptions on line no 282 in file: vendor/magento/module-configurable-product/Model/ResourceModel/Product/Type/Configurable.php Now, it's working fine for me.

->joinInner( ['attribute_opt' => $this->getTable('eav_attribute_option')], 'attribute_opt.option_id = entity_value.value', [] )->order( 'attribute_opt.sort_order ASC' );

If unable to edit the code then please replace this getAttributeOptions function with code as below:

`public function getAttributeOptions($superAttribute, $productId)
{
$scope = $this->getScopeResolver()->getScope();
$select = $this->getConnection()->select()->from(
['super_attribute' => $this->getTable('catalog_product_super_attribute')],
[
'sku' => 'entity.sku',
'product_id' => 'product_entity.entity_id',
'attribute_code' => 'attribute.attribute_code',
'value_index' => 'entity_value.value',
'option_title' => $this->getConnection()->getIfNullSql(
'option_value.value',
'default_option_value.value'
),
'default_title' => 'default_option_value.value',
]
)->joinInner(
['product_entity' => $this->getTable('catalog_product_entity')],
"product_entity.{$this->getProductEntityLinkField()} = super_attribute.product_id",
[]
)->joinInner(
['product_link' => $this->getTable('catalog_product_super_link')],
'product_link.parent_id = super_attribute.product_id',
[]
)->joinInner(
['attribute' => $this->getTable('eav_attribute')],
'attribute.attribute_id = super_attribute.attribute_id',
[]
)->joinInner(
['entity' => $this->getTable('catalog_product_entity')],
'entity.entity_id = product_link.product_id',
[]
)->joinInner(
['entity_value' => $superAttribute->getBackendTable()],
implode(
' AND ',
[
'entity_value.attribute_id = super_attribute.attribute_id',
'entity_value.store_id = 0',
"entity_value.{$this->getProductEntityLinkField()} = "
. "entity.{$this->getProductEntityLinkField()}",
]
),
[]
)->joinLeft(
['option_value' => $this->getTable('eav_attribute_option_value')],
implode(
' AND ',
[
'option_value.option_id = entity_value.value',
'option_value.store_id = ' . $scope->getId(),
]
),
[]
)->joinLeft(
['default_option_value' => $this->getTable('eav_attribute_option_value')],
implode(
' AND ',
[
'default_option_value.option_id = entity_value.value',
'default_option_value.store_id = ' . \Magento\Store\Model\Store::DEFAULT_STORE_ID,
]
),
[]
)->where(
'super_attribute.product_id = ?',
$productId
)->where(
'attribute.attribute_id = ?',
$superAttribute->getAttributeId()
)->joinInner(
['attribute_opt' => $this->getTable('eav_attribute_option')],
'attribute_opt.option_id = entity_value.value',
[]
)->order(
'attribute_opt.sort_order ASC'
);

return $this->getConnection()->fetchAll($select);

}`

[slopukhov]

@dmaciej thank you for your feedback.
Internal issue created: MAGETWO-61484

[dmatthew]

@slopukhov Is there a way for the Magento community to see the progress on an internal issue? If I decide to work on a fix for this issue, how do I know Magento has not already fixed this issue elsewhere but has not updated this ticket?

[harimayco]

is there any update about this issue?
I'm also having this issue with latest magento 2.1.7.