Model sort order checkout page

[jasmel]

I was hoping that someone would point me in the correct direction to add a statement to have the products in one's cart to sort by model number.

I would also like this to follow along to the packing slips and invoices. The ability to sort by model number would help us greatly after the sale has been completed.

Thanks!

[jasmel]

Anybody got a clue what I can do? Still would like to be able to sort by product model.

[Ajeh]

In the Catalog ... where do you want this sorted by products_model field?
shopping_cart
checkout_confirmation
shopping_cart (sidebox)
email to customer
email to admin
account_history_info


In the Admin ... where do you want this sorted by products_model field?
orders.php
invoice.php
packingslip.php

to name a few ...

[jasmel]

In the Catalog ... where do you want this sorted by products_model field?
shopping_cart
checkout_confirmation
shopping_cart (sidebox)
email to customer
email to admin
account_history_info


In the Admin ... where do you want this sorted by products_model field?
orders.php
invoice.php
packingslip.php

to name a few ...

What I really want is the packing slip to sort by model.. but, I was under the impression that if you fix it in the buy-flow (checkout page) it will continue through to the invoice and packing slip with the same sorted order.

thanks for looking into this for me.

[jasmel]

hello?

[jasmel]

Ajeh, did I lose you?

[edadk]

See if this works:

In admin/includes/classes find orders.php

Find this section:

$orders_products = $db->Execute("select orders_products_id, products_id, products_name, products_model,
                                              products_price, products_tax, products_quantity,
                                              final_price, onetime_charges,
                                              product_is_free
                                       from " . TABLE_ORDERS_PRODUCTS . "
                                       where orders_id = '" . (int)$order_id . "'
                                       order by orders_products_id");

Change to:

$orders_products = $db->Execute("select orders_products_id, products_id, products_name, products_model,
                                              products_price, products_tax, products_quantity,
                                              final_price, onetime_charges,
                                              product_is_free
                                       from " . TABLE_ORDERS_PRODUCTS . "
                                       where orders_id = '" . (int)$order_id . "'
                                       order by products_model");

Careful making changes. Back up everything first, and you might be able to use an override so you don't change the original file.

This should change all products listed in orders, invoices and packing slips to list by products_model.

Ed

[jasmel]

Careful making changes. Back up everything first, and you might be able to use an override so you don't change the original file.

This should change all products listed in orders, invoices and packing slips to list by products_model.

Ed

Worked like a charm! Thank you