How to sort the attribute values setup in the Product Variants tab?

Question

We use product variants. And our attribute is size, such as 7,8,9,10 etc. For example, initially we only selling size 7,8,9, later we found we will start to sell size 5 and 6. Then we will add size 5 and 6 to be the attribute values. That will result in our size setup in the sequence of 7,8,9,5,6. And when we are entering the sales order using the size grid, it will show up in the sequence the size were setup, like 7,8,9,5,6. But we want to see the size sorted from small to large.
Is it possible

Tim Drinkwater · Accepted Answer

Bump, anyone found a solution to this?
Edit:
Did some digging.  I think my instance was a kind of fluke.  In studio I changed the widget from handle to integer so I could see the values. Two of them were set to zero and for some reason moving them around didn't force the list to renumber.  I then moved the value that had sequence number 1 and that forced the renumber of the whole list. After that I was  able to reorder the list and the sequence moved as expected.

MARLACENTER · Answer

Hello, any progress on this?

Yong Chye Tay · Answer

Sorting For Odoo v18:
The sequence value from older versions is now hidden, so older posts are confusing since they feature a sequence value.
In newer versions to sort product variants do this:
1) Go Sales > Settings > Product Attributes.
2) Select the Attribute
3) Drag the 6 dots (row) up/down and save.
4) [Optional] If there's pagination (1/40 of 150 eg).
5) Click the 1/40 and add a 0 behind => 1/400 of 150
6) This will open up all the variants and let you drag/drop all 150 of them.
Note:
The

Rabbit Trade · Answer

Finally found a solution for this, by importing with the required sequence, any value with a 0 in the sequence will be sorted on the website alphabetically, but if you give the sequence a value it will be sorted in the sequence you indicated, click here for an example import sheet

[1] https://docs.google.com/spreadsheets/d/1sGidk_Rlqa-pD9G_5aLYtagHOgv8rtxpEVZn5y6oQRw/edit?usp=sharing

Eric Pinnell · Answer

won't change the variants in the product and on the website

Michael S · Answer

Go to edit mode on the product template, navigate to the product variant tab, and for the attribute you need to correct the values ordering for, simply remove them all and re-add them. As long as the same values are selected (even if in a different order than originally), the product variant records will be the same when you save.

Related Posts	Replies	Views
Attached PDF file is not formatted properly v14	1 Dec 25	344
Odoo14 alternative for Automated Translations through Gengo API module v14	3 Sep 25	3784
Odoo Community v14 Slow on High-End Servers, Fast on i5/i7 PCs v14	0 Aug 25	1177
How to Managing Birthdate and Age in Odoo v14	1 Aug 25	3557
How to import Products Variants specific data variants	2 Aug 25	1462

This question has been flagged

Enjoying the discussion? Don't just read, join in!