Confirmation E-mail - Sort products by manufacturer?

[Danielle]

I can get the manufacturer to show up for each product in the order confirmation e-mail, but I would like to go beyond that and have the products display in order of manufacturer, so that all the products from one manufacturer are together. I'm just not sure how to go about this. I thought of going all the way back to the cart and doing the sort there, but I played around a bit and am not sure how to do that either

[mc12345678]

I can get the manufacturer to show up for each product in the order confirmation e-mail, but I would like to go beyond that and have the products display in order of manufacturer, so that all the products from one manufacturer are together. I'm just not sure how to go about this. I thought of going all the way back to the cart and doing the sort there, but I played around a bit and am not sure how to do that either

The cart order display basically has been put together to give a top down view of product addition such that newly added product go towards the bottom.

What you would likely want to do say just before processing to display/output the cart contents is to first determine what the sort order of each product should be then create a temporary cart that is to receive the content of each of the product and add the product from the live cart to the temporary cart in the desired order, then process the display using the temporary cart. An alternative could be to maintain two different cart values such that whenever something is added to the main cart it is added to this other cart variable but in a sorted manner (even if it means after an add to resort the array).

The only thing that I can see as a concern is where in the process is this to be introduced because might it not cause confusion if say the sequence has been changed during checkout making the customer second guess site operation? If it's for some report or offered as a sort option when viewing the cart contents I get it, but not sure otherwise.

[carlwhat]

hi danielle,
to change the sort for ONLY the email confirmation, you need to modify the following code in includes/classes/order.php:

    $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 . "'
                                  order by orders_products_id";

in version 155e, this starts on line 168. you can change the code to:

$orders_products_query = "select orders_products_id, op.products_id, op.products_name,
    op.products_model, op.products_price, products_tax,
    op.products_quantity, op.final_price,
    onetime_charges, p.manufacturers_id,
    op.products_priced_by_attribute, op.product_is_free, op.products_discount_type,
    op.products_discount_type_from
    from " . TABLE_ORDERS_PRODUCTS . " op
    left join " . TABLE_PRODUCTS . " p on op.products_id = p.products_id
    where orders_id = '" . (int)$order_id . "'
    order by p.manufacturers_id";

good luck!

[Danielle]

hi danielle,
to change the sort for ONLY the email confirmation, you need to modify the following code in includes/classes/order.php:

    $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 . "'
                                  order by orders_products_id";

in version 155e, this starts on line 168. you can change the code to:

$orders_products_query = "select orders_products_id, op.products_id, op.products_name,
    op.products_model, op.products_price, products_tax,
    op.products_quantity, op.final_price,
    onetime_charges, p.manufacturers_id,
    op.products_priced_by_attribute, op.product_is_free, op.products_discount_type,
    op.products_discount_type_from
    from " . TABLE_ORDERS_PRODUCTS . " op
    left join " . TABLE_PRODUCTS . " p on op.products_id = p.products_id
    where orders_id = '" . (int)$order_id . "'
    order by p.manufacturers_id";

good luck!

Thank you, unfortunately it didn't work.

[carlwhat]

danielle,
can you be more specific? did the email come in, and the products were the same as the way it was placed? or did you not get an order confirmation email?

this would NOT change the order of how the products get displayed on the admin side.

thanks.

[Danielle]

danielle,
can you be more specific? did the email come in, and the products were the same as the way it was placed? or did you not get an order confirmation email?

this would NOT change the order of how the products get displayed on the admin side.

thanks.

The e-mail came, but the products in it were not sorted.