Forums / Managing Customers and Orders / Sorting "Products Model" in numerical order on INVOICE?

Sorting "Products Model" in numerical order on INVOICE?

Locked

Views: 1,311

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
20 Feb 2010, 5:00 PM
#1
raygabriel avatar

raygabriel

New Zenner

Join Date:
Apr 2009
Posts:
8
Plugin Contributions:
0

Sorting "Products Model" in numerical order on INVOICE?

Hi All,

I am using:
Zen Cart 1.3.8a
Patch: 1::
Database Patch Level: 1.3.8

Is there a way that I can sort "Product Model" numbers in numerical order (ASCENDING order) on my invoices to make it easier to pick from inventory?

Thanks in advance!

Ray Gabriel
http://www.raygabriel.com

20 Feb 2010, 5:33 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Sorting "Products Model" in numerical order on INVOICE?

You can try customizing the order class and change the order by ... currently it is set to match the way the products were added to the Order based on how the customer ordered them:

    $orders_products_query = "select orders_products_id, products_id, products_name,
                                 products_model, products_price, products_tax,
                                 products_quantity, final_price,
                                 onetime_charges,
                                 products_priced_by_attribute, product_is_free, products_discount_type,
                                 products_discount_type_from
                                  from " . TABLE_ORDERS_PRODUCTS . "
                                  where orders_id = '" . (int)$order_id . "'
                                  [B]order by orders_products_id[/B]";

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!