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	Cevaplar	Görünümler
Reset user session v14	0 May 25	11
Odoo wrong company logo in email Solved v14	2 Oca 25	2333
Update Initial Stock of Product using XMLRPC API [Odoo14] Solved v14	1 Ara 24	6039
Disable Tour for all users v14	1 Kas 24	2476
ODOO 14: Disable tour for all users v14	1 Kas 24	1848

This question has been flagged

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