If you are like me and have more than 1300 different SKU's for a warehouse to manage the picking and packing of, you might have noticed that sometimes, products do not appear sensibly in SKU order on the invoices. This makes it fairly hard for warehouse staff to get everything they need for a large order in one trip to an area and wastes steps. This tiny hack is for 6.1.1, to print invoices with products in sku order per shipment address.
Open
lib/order.printing.php
1. Around line 272 inside the function
generatePrintableInvoice find this line of code
and change it to the following:
Code: Select all
ORDER BY op.order_address_id, p.prodcode ASC
To make the same change for packing slips:
Around line 763 inside the function
generateOrderPackingSlip find the following:
Code: Select all
WHERE orderorderid='".(int)$orderId."'
and add this line below it