Option drop down not ordered

[Kimbot]

HI Forum.

 

I have a small problem with the drop down product options menu.

 

I have several options, each one numbered, each one a higher price than the one before it.

 

BUT the options in the drop down list appear out of order.

 

eg:

 

Where I want:

12x24 - $200

18x36 - $280

24x32 - $320

 

I get:

18x36 - $280

12x24 - $200

24x32 - $320

 

 

Like that, out of order, very disorderly indeed.

 

Any ideas or advice on this issue would be very welcome, my clients are screaming at me :-(

 

cheers / thanks

[bw92116]

This contribution may help you:

 

http://addons.oscommerce.com/info/1822

 

It adds a sort order column to the products_attributes table in your database, and it allows you to assign a sort order to each option of an attribute. Then you can put the options in the drop-down list in whatever order you want.

 

It requires running a one-line SQL query on your database to add that column, and it requires you to make edits to these files:

 

/catalog/product_info.php

/admin/includes/functions/general.php

/admin/products_attributes.php

 

It did not take very long and it was not difficult to make the changes. Once it is properly installed, there will be a new field in the line when you apply an attribute option to a product. In that field, you type in a number for that option, and the options will be listed in the drop-down menu according to that number (with the one that has 0 being listed first, etc.)

 

It has worked well for me, in making sure sizes are shown in the correct order (instead of seeing a drop-down list that said, "Medium, XL, Small, XXL, Large, XXXL" it now says, "Small, Medium, Large, XL, XXL, XXXL").

 

For adding new products and new attributes to existing products, it is easy and is just one minor additional thing to type in. But if you have a lot of products already with attributes, it may be very tedious to go through them all and add the sort order number to every option for every attribute for every product. If you do this, first make a list of the order the options should be in, starting from 0, and you will need to refer to that list constantly when you are adding in the sort order numbers. The list could be as simple as "Small = 0, Medium =1, Large = 2," etc. or more specific for each product. This list will help you greatly as you laboriously go through every attribute that has already been created, to assign sort order numbers.

 

As with all contributions, before you start, back up your database and then back up your entire installation, and keep the backup.

[Kimbot]

Hey! Thanks for that very detailed assist.

 

Excellent and very much appreciated, I shall follow thru on this one, don't see any problems, sound simple :-)

 

(ha, ha, sounds simple, wish life was like that, eh?)

 

Cheers / Thanks

 

 

This contribution may help you:

 

http://addons.oscommerce.com/info/1822

 

It adds a sort order column to the products_attributes table in your database, and it allows you to assign a sort order to each option of an attribute. Then you can put the options in the drop-down list in whatever order you want.

 

It requires running a one-line SQL query on your database to add that column, and it requires you to make edits to these files:

 

/catalog/product_info.php

/admin/includes/functions/general.php

/admin/products_attributes.php

[bw92116]

You're welcome. If you have a lot of products, you may want to consider any one of these contributions:

 

http://addons.oscommerce.com/info/3697

http://addons.oscommerce.com/info/1538

http://addons.oscommerce.com/info/4063

 

All of those are supposed to make working with attributes easier and faster. I have never tried any of those 3, so I can't comment on any of them, or whether they are compatible with the Sort Order contribution. You might ask the author of each one whether it will work with the Sort Order for attributes, and if so, it should make applying the sort orders a lot faster.