Why are the attributes displayed out of order?

Question

Electronic commerce

Why are the attributes displayed out of order? that is, the prices of some products are inconsistent, but you need to descend or ascend, the import of goods is carried out through an exel file here

Answer 1

In the attributes in editing, you can change the sort type
Or sort manually.

Answer 2

I have no idea how and where you import it from, but I can say one thing, there is sorting, but it is not by number, but by text line: the line starts with 1, the line starts with 2, the line starts with 5 ...
To sort correctly, you need to import grams and the price as numbers and also store it in the database (then just glue it back into a string), then the sorting will be by number, not by string.