It'll be a small edit to /YOUR_ADMIN/includes/templates/tpl_all_invoices.php (for the invoices). Locate the lines that read:
and make the following changes:Code:<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <?php $sql = "SELECT orders_id FROM ".TABLE_ORDERS." WHERE orders_status = ".$orderStatus; $pending_orders = $db->Execute($sql); while (!$pending_orders->EOF) {
That will select ALL the orders from your store and print them in descending order-id order.Code:<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <?php $sql = "SELECT orders_id FROM ".TABLE_ORDERS." ORDER BY orders_id DESC"; $pending_orders = $db->Execute($sql); while (!$pending_orders->EOF) {
Thread: All Invoices Report [support]
Results 1 to 10 of 84
Threaded View
-
15 Apr 2014, 06:51 PM #11
Administrator
- Join Date
- Sep 2009
- Location
- Stuart, FL
- Posts
- 13,874
- Plugin Contributions
- 96
Re: All Invoices Report [support]
Last edited by lat9; 15 Apr 2014 at 06:52 PM. Reason: Changed ascending to descending, per OP request
Reply With QuoteSimilar Threads
-
v152 Support Thread: Report All Errors (Even Warnings)
By lat9 in forum Addon Admin ToolsReplies: 34Last Post: 1 Feb 2020, 05:42 PM -
v154 Editable Invoices & Packing Slips [Support]
By dbltoe in forum All Other Contributions/AddonsReplies: 0Last Post: 7 Oct 2015, 11:44 PM -
v139h Print all outstanding invoices, print Avery labels, mark all orders sent
By dinki in forum General QuestionsReplies: 1Last Post: 27 Jan 2012, 06:35 PM -
Admin Activity Report [support thread]
By Steven300 in forum All Other Contributions/AddonsReplies: 17Last Post: 6 Aug 2009, 12:47 PM -
printing all invoices
By simplesat in forum General QuestionsReplies: 1Last Post: 28 Nov 2008, 04:03 PM
