The Sizes are not listed in order

[Jackzzz]

I am trying to add attributes for items's sizes, I don't know why, The Sizes are not listed in order.

 

 

it should be from 40,41, 42, 43,44, 45, 46,

 

Size EUR 40 - UK 6 - US 7 - CM 25

Size EUR 41 - UK 7 - US 8 - CM 26

Size EUR 42 - UK 7.5 - US 8.5 - CM 26.5

Size EUR 43 - UK 8 - US 9 - CM 27

Size EUR 44 - UK 9 - US 10 - CM 28

Size EUR 45 - UK 10 - US 11 - CM 29

Size EUR 46 - UK 11 - US 12 - CM 30

 

but The Sizes are not listed in order as above when I check on my web site. it looks like the following order:

 

Size EUR 41 - UK 7 - US 8 - CM 26

Size EUR 40 - UK 6 - US 7 - CM 25

Size EUR 43 - UK 8 - US 9 - CM 27

Size EUR 42 - UK 7.5 - US 8.5 - CM 26.5

Size EUR 46 - UK 11 - US 12 - CM 30

Size EUR 45 - UK 10 - US 11 - CM 29

Size EUR 44 - UK 9 - US 10 - CM 28

 

Anyone knows why.

[♥geoffreywalton]

Is that the order you added them to the system?

 

Try looking in the table product options, using phpmyadmin available through your site admin tool, (cpanel?)

 

Is it in ascending products_options_values_id sequence?

 

 

G

[digilee]

I have the same problem.

I loaded them into the system in the correct order, in the attributes list their ID is in the correct order but still they load up in no obvious order.

[Gauravs]

A link to your site guys would really help to review which page and then which query gives the output and can be tweaked.

 

Cheers

GS

[Jackzzz]

Is that the order you added them to the system?

 

Try looking in the table product options, using phpmyadmin available through your site admin tool, (cpanel?)

 

Is it in ascending products_options_values_id sequence?

G

 

at admin, I set Expected Sort Order to desc. if i set ascending, The Sizes are not listed in order either.

 

what should i do from admin tool or cpanel, i do not see any options to set the size in order???

 

:rolleyes:

[redbone]

I've been using Sort Option Values 1.0. I was having the same problems with sizes not displaying in order. Have it running on three stores now and works great and will fix your problem.

[Jackzzz]

I've been using Sort Option Values 1.0. I was having the same problems with sizes not displaying in order. Have it running on three stores now and works great and will fix your problem.

 

 

Thanks for your quick reply, I am going to install this. by the way, which version you installed?? from the contrubition, the version 1.1 stated

that"if not then order they were inputed into the database (product_value_id). Just need to replace one section of code in product_info.php originally submitted by Don Mitchinson." where to find code to replace one section of code in product_info.php originally submitted by Don Mitchinson???

 

 

Big thankss

[Jackzzz]

I've been using Sort Option Values 1.0. I was having the same problems with sizes not displaying in order. Have it running on three stores now and works great and will fix your problem.

 

 

Many thankssss, it works great.

[Jackzzz]

Many thankssss, it works great.

 

 

I checked all sizes for all products, some works, some not. if you Clone A Product Attributes TO B Product Attributes, B will not listed in order.

[redbone]

I checked all sizes for all products, some works, some not. if you Clone A Product Attributes TO B Product Attributes, B will not listed in order.

 

 

You need to change the 'value' of the sort for the item. In other words, you can have 1 set for 'Small', 2 set for 'Medium', 3 set for 'Large' then they should appear in the order of the sort value.

 

I know when I clone a product then go to do some edits, the cloned product doesn't carry the attributes and I need to re-input them. Probably because I change the name of the product, etc. and that's where it loses the values as it doesn't match up to the original product title.

 

Is that what you're talking about?