Option Type Feature - Listing out of order

[adam71o]

In checkout_confirmation.php, and the subsequent "order process" emails, the product option type attributes are listed out of order:
for example ()=correct order:

1 x Pet Memorial - 6x6 [Black Marble]
(4) - Text line 3: Your soul will find its way to
(3) - Text line 2: I'll always love you
(2) - b. Text line 1: Jimmy Bo Jangles
(1) - a. Font number: 5 (chancellor)
(5) - Text line 4: the halls of your fathers

It displays a different order almost everytime I test. It is strange. Again, every test I make, they are displayed in a different order, so there is no set order.

Any ideas how to make it display correctly?

[adam71o]

I suppose a "brute force" way of making it display correctly is to manually tell it to display in alphabetical order (which is how I named them). Although I have no idea how to do that.

[adam71o]

heres another example of the problem displayed in an "order process" email:

1 x Pet Marker - Flat Absolute Black SS [6x12x4] (FABSS-6x12x4) = $145.00
Text line 5 that would be freaky, right?
Text line 4 and memories a lane
a. Font number 9 (formal)
b. Text line 1 Goodbye sweetheart
Text line 3 if tears could build a stairway
Text line 2 take it easy

and then the invoice (admin/invoice.php) for the EXACT same order looks like this:

1 x Pet Marker - Flat Absolute Black SS [6x12x4]
- b. Text line 1: Goodbye sweetheart
- a. Font number: 9 (formal)
- Text line 4: and memories a lane
- Text line 5: that would be freaky, right?
- Text line 3: if tears could build a stairway
- Text line 2: take it easy

[adam71o]

No ideas huh? How would I go about manually forcing the "order process" email to put them in alphabetical order, IE:

- a. Font number:_____
- b. Text line 1:_____
- Text line 2:_____
- Text line 3:_____
- Text line 4:_____
- Text line 5:_____

========================
I mean couldn't I go into the actually php file that sends the "order process" email and add some code to make it sort them alphabetically? How would I do that, exactly?

[adam71o]

Is there no php function to sort something alphabetically?

[michael_s]

I think there is already a mod to put them in order. Look here:

http://www.oscommerce.com/community/...ributes+sorter

[adam71o]

I don't see anything in that contribution regarding the "order process" email, which is where this problem lies. By chance, did you post the wrong link?

[bdneuman]

Originally Posted by adam71o

I don't see anything in that contribution regarding the "order process" email, which is where this problem lies. By chance, did you post the wrong link?

This is a good point - I'd like to do this too. Maybe Michael can weigh in on this, but I believe the attributes query for the email sent at order completion is in catalog/checkout_process and looks like this:

          $attributes = tep_db_query("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa where pa.products_id = '" . $order->products[$i]['id'] . "' and pa.options_id = '" . $order->products[$i]['attributes'][$j]['option_id'] . "' and pa.options_id = popt.products_options_id and pa.options_values_id = '" . $order->products[$i]['attributes'][$j]['value_id'] . "' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '" . $languages_id . "' and poval.language_id = '" . $languages_id . "'");

Could you revise the last line to look like this?:

$languages_id . "' order by popt.products_options_name");

[adam71o]

I wish I could say yes or no. I'm not proficient enough at php to know.

[adam71o]

MSasek.... any suggestions?