Attribute Values Ordering_Odoo 18

Question

Dear Experts,
We have created a new attribute with value records starting from *0.01mm* onwards. The initial batch of *2,000 values* was successfully loaded and appears in proper *ascending order*.
However, when we add a new record or import an additional batch of values (another 2,000), these newly added values appear *at the top* of the existing list, causing the sequence to become disordered.
We would like to ensure that any new values added:

Appear at the *bottom* of the existing list, or

Chris TRINGHAM · Accepted Answer

There is a sequence number on attributes and it is possible to "drag and drop" to change the order manually (though that won't be practical if you have thousands of attributes, so see below):
Reorder%20variants%20%281%29 [2]
Reorder%20variants%20%282%29 [3]
The changed sequence is then used when selecting variants.
To correct this you can export this and update through an Excel spreadsheet.
You must select "I want to export data (import-compatible export)" and the fields *value_ids/id* and *valu

D Enterprise · Answer

Hii,
Use the sequence Field
*What is it?*
Each Attribute Value in Odoo has a hidden *sequence* field that determines the order in which values appear.

*How to Use It* A. Sort Existing Values in the UI
Go to *Sales / Configuration / Product Attributes*.

Open your attribute (e.g., "Length").

Click the ⚙️ (gear) icon near the attribute values list.

Choose *"Insert a column"* ➜ Add Sequence.

Manually assign ascending values (1, 2, 3…) matching your desired order.
B. While Importing New Values
P

Name	Attribute ID (External)	Sequence
0.01mm	product.attribute_length	1
0.02mm	product.attribute_length	2
0.03mm	product.attribute_length	3

Câu hỏi này đã bị gắn cờ

What is it?

How to Use It

A. Sort Existing Values in the UI

B. While Importing New Values

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!