Messed up product size order on frontend

[Jojobaa]

Hi, 

On my backend the order for product sizes for a configurable product is showing correctly. See screenshot: http://prntscr.com/nurrsp
But on the frontend the size order is messed up. See screenshot: http://prntscr.com/nursal

Anyone got the solution to this?

[Sunil Patel · Accepted solution]

Hello @Jojobaa 

Go to that attribute 

Stores -> Attributes (Product), find needed attribute and also using drag&drop with your mouse change position of options -

Hope it will help you, if works then mark as a solution.

[Vimal Kumar]

Hi @Jojobaa ,

Please go through the following url once. You will get better idea to sort attribute and attribute options as well. 

https://www.mag-manager.com/product-information/magento-product-management/change-sort-order-of-attr...

I hope it will help you!

[Jojobaa]

---

@Vimal Kumar wrote:

Hi @Jojobaa ,

Please go through the following url once. You will get better idea to sort attribute and attribute options as well. 

https://www.mag-manager.com/product-information/magento-product-management/change-sort-order-of-attr...

I hope it will help you!

---

Thanks for the reply. The problem is we have around 5000 products in our store. So it's impossible to rearrange all products individually. Isn't there a database query or something that can handle this process for us. For example to rearange sizes from small to large etc?

[Vimal Kumar]

@Jojobaa

You don’t need to edit each product manually.

You need to rearrange size attribute option value only from

Admin -> Store-> Attribute-> Product

Edit size and rearrange options small, large etc.

After reindexing all products will be updated automatically.

[Jojobaa]

---

@Sunil Patel wrote:

Hello @Jojobaa 

Go to that attribute 

Stores -> Attributes (Product), find needed attribute and also using drag&drop with your mouse change position of options -

Hope it will help you, if works then mark as a solution.

---

I didn't have time the last week to check the issue further. But now it is solved. All suggestions worked perfectly! Thanks