59 replies to this topic

[mitchind]

I put this in place for myself because it was driving me crazy trying to get the product options displayed in the order I wanted. All the sorting contributions I came across were difficult to implement or changed a lot of code.

All I wanted was something that showed my options in order of price. Or at the very least showed them in the order I entered them.

It's a simple fix that takes less than a minute.

What it does...
First - sorts by price
Second - if price is same (or 0), it sorts based on the order that the option was entered.

File to change ... /catalog/product_info.php

Replace this line

$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'");

With this line

$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix, pa.products_attributes_id from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'" . " order by pa.options_values_price, pa.products_attributes_id");

Hope someone else will find this useful.

[deadmatt]

Brilliant Just what i was looking for thanks

Helps to prevent my customers from automatically choosing the most expensive upgrades because they didnt see the options lol

anyway cheers

[plasmz]

Thank you for posting this... I've been going around in circles for days... pmb

[OSCnewbie]

Thank you so much for posting this SORT code, it works GREAT!

Do you know how I could get it to sort by product attributes HERE too:

(a) account_history_info.php
AND
( the order confirmation email message

(My PHP skills are "hurtin' for certain")

Thanks!

OSCnewbie.

[erik_1099]

You are my hero. This has been driving me nuts.

mitchind, on Nov 29 2004, 08:49 PM, said:

I put this in place for myself because it was driving me crazy trying to get the product options displayed in the order I wanted. All the sorting contributions I came across were difficult to implement or changed a lot of code.

[OSCnewbie]

Hi,

Is anyone else having problems getting the sort order to work in "account_history_info.php" and the order-confirmation email message that goes out?

--OSCnewbie.

[bobsi18]

FANTASTIC!!! THANKS!!!

~Barbara~

[mperez3100]

bobsi18, on Apr 17 2006, 07:08 AM, said:

FANTASTIC!!! THANKS!!!

~Barbara~

SUPER!!!

[Wigzilla]

Hi,
I am having a similar problem, but, it is with colors. I want my color drop down to go 1, 1B, 2, etc. but instead of the way I put it in, it just mixes itself up. Will this coding help me for that? If so could you please give me a step by step of how to install it, i'm very new, any help would be great.
thank you

[survequip]

Wigzilla, on Sep 21 2006, 11:14 PM, said:

Hi,
I am having a similar problem, but, it is with colors. I want my color drop down to go 1, 1B, 2, etc. but instead of the way I put it in, it just mixes itself up. Will this coding help me for that? If so could you please give me a step by step of how to install it, i'm very new, any help would be great.
thank you

Wicked! But I have to agree, any idea on getting colours in order that we wish or to default to one colour?

Thanks

[Barefoot Kid]

this sorts the attribute by price all right but for me it fails to take into account whether theres a + or - sign in front of the price so the smallest prices are listed last

[rassa]

thank you so much for the code

[rkscscc]

Don,

If this site had a rating function on users, you'd get about 493 out of 10 right now... Been browsing contribs, fighting on the forum and basically all I ended up doing is being more bald than 2 weeks ago.....

You sir, are an absolute star!!!!!

Riaan

mitchind, on Nov 29 2004, 10:49 PM, said:

I put this in place for myself because it was driving me crazy trying to get the product options displayed in the order I wanted. All the sorting contributions I came across were difficult to implement or changed a lot of code.

All I wanted was something that showed my options in order of price. Or at the very least showed them in the order I entered them.

It's a simple fix that takes less than a minute.

What it does...
First - sorts by price
Second - if price is same (or 0), it sorts based on the order that the option was entered.

File to change ... /catalog/product_info.php

Replace this line

$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'");

With this line

$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix, pa.products_attributes_id from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'" . " order by pa.options_values_price, pa.products_attributes_id");

Hope someone else will find this useful.

[noelove]

is there any way to code this so it sorts products alphabetically, even if they are already entered?

[dp1726]

Great idea
But does anybody know how to change the code so that it sorts by model number.
example 1 2 4 7 12 14 18 ect.
Dave

[R1Andy]

YOU ARE A LIFESAVER!!! Thanks so much, I was really starting to question my choice of shopping carts until I stumbled on this post which put 126 of my entries in order.

THANK YOU!!!

[benspun]

Yes, indeed, a great post, very useful for me as well!

It's interesting how a single message can continue to collect thanks from people more than 2 years after having been written!

[kewlceo]

benspun, on Apr 20 2007, 08:06 AM, said:

Yes, indeed, a great post, very useful for me as well!

Same here. I have a line of watch bands in the catalog I'm building, and as an option, you can add a Rolex watch. Before applying this mod, the watch would be included by default, and I was worried about people getting sticker shock on accident. Now it's all sorted properly. Whew!

The original poster averages one post per year, it seems. I'm off to go see if his other two messages are as helpful as this one!

[xecutech]

Just like everyone else here..... you are the man!!!!!

I have been fighting with this for days and you saved me from hours of searching this forum. I actually found this with a google search, as I had given up on the search feature on the forum.

Thank you very much!

[Jayman007]

How can I setup the order or Product Options (not attributes)? This has been driving me crazy as I have found and implemented contribs for sorting products and product attributes but NOTHING for sorting the product options. I will need to be able to ender a value for the option sorting and not just use price or order entered.