Line items on invoice are alphabetical, we want them in the order that customer entered them

[lepusa]

We are using PS v.1.6.1.5, and presently when the initial order confirmation is emailed to the customer, the products are listed in the same sequence that the customer added them to the order.

However, the PDF Invoice (Sales Order) prints them alphabetically by name.

For sake of ease for the customer, these items should be displayed in the same sequence they were added to the order.

 

This is also true for the PDF Delivery Slip and Packing Slip.

 

Is there a way to retain the original sequence of line items as entered by the customer?

Edited June 21, 2016 by lepusa (see edit history)

[lepusa]

Bump, and ideas on this?

[rocky]

I checked the code and found it's sorting by name on line 147 in the OrderInvoice::getProductDetail() function:

		'.($this->id && $this->number ? ' AND od.`id_order_invoice` = '.(int)$this->id : '').' ORDER BY od.`product_name`');

You could try overriding this and removing the ORDER BY. For example, create override/classes/OrderInvoice.php with the following:

<?php

class OrderInvoice extends OrderInvoiceCore
{
    public function getProductsDetail()
    {
        return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
		SELECT *
		FROM `'._DB_PREFIX_.'order_detail` od
		LEFT JOIN `'._DB_PREFIX_.'product` p
		ON p.id_product = od.product_id
		LEFT JOIN `'._DB_PREFIX_.'product_shop` ps ON (ps.id_product = p.id_product AND ps.id_shop = od.id_shop)
		WHERE od.`id_order` = '.(int)$this->id_order.'
		'.($this->id && $this->number ? ' AND od.`id_order_invoice` = '.(int)$this->id : ''));
    }   
}

Remember to go to Advanced Parameters > Performance and click the "Clear cache" button (or manually delete cache/class_index.php) so PrestaShop can find the override.

[lepusa]

 

I checked the code and found it's sorting by name on line 147 in the OrderInvoice::getProductDetail() function:

		'.($this->id && $this->number ? ' AND od.`id_order_invoice` = '.(int)$this->id : '').' ORDER BY od.`product_name`');

You could try overriding this and removing the ORDER BY. For example, create override/classes/OrderInvoice.php with the following:

<?php

class OrderInvoice extends OrderInvoiceCore
{
    public function getProductsDetail()
    {
        return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
		SELECT *
		FROM `'._DB_PREFIX_.'order_detail` od
		LEFT JOIN `'._DB_PREFIX_.'product` p
		ON p.id_product = od.product_id
		LEFT JOIN `'._DB_PREFIX_.'product_shop` ps ON (ps.id_product = p.id_product AND ps.id_shop = od.id_shop)
		WHERE od.`id_order` = '.(int)$this->id_order.'
		'.($this->id && $this->number ? ' AND od.`id_order_invoice` = '.(int)$this->id : ''));
    }   
}

Remember to go to Advanced Parameters > Performance and click the "Clear cache" button (or manually delete cache/class_index.php) so PrestaShop can find the override.

 

 That did the trick, thanks!