All Invoices Report [support]

lat9:

I'm glad you got it sorted; in answer to your questions:

2. The invoice display uses /YOUR_ADMIN/includes/templates/tpl_all_invoices.php to perform the formatting. If you've made modifications to the "standard" Zen Cart invoice, you'll need to merge those changes into that template.

3. The plugin displays/formats invoices and packing slips based on orders-status, not by order-id. I've created a change-request on the plugins GitHub repository so that I "remember" this request, but I can't guarantee when I'll get it finished.

Ok, thank you :smile: Do you happen to know if there is an other way or mod to print out invoices by selection?

When I've used this, I've found that the logical workflow is:

1. Select "Pending" from the list.
2. Click Generate. This will show all "Pending" invoices.
3. Print what's been generated.
4. Update status to "Processing". This will update all the "Pending" to "Processing". You do this as a separate step after printing just in case there's a problem when printing.

If all your orders are typically already in "Processing" status, you could choose "Processing" in the first step, and then update status to "Delivered" (or whatever) in the last step.

That way you never need to worry about manually typing in order-numbers.

Is there a separate forum thread for problems with the All packing slips add-on? I haven't been able to find anything for it and I've run into an odd problem.

It has apparently been doing this all along, but I only just noticed. When the packing slips are generated on the screen, everything looks great. But when they print out, the only one which has the full company information is the first one. All the others have just the company name at the top, but no address or phone number. I've been picking through the code trying to find the problem, but really don't have time for that any more.

HeleneWallis:

Is there a separate forum thread for problems with the All packing slips add-on? I haven't been able to find anything for it and I've run into an odd problem.

It has apparently been doing this all along, but I only just noticed. When the packing slips are generated on the screen, everything looks great. But when they print out, the only one which has the full company information is the first one. All the others have just the company name at the top, but no address or phone number. I've been picking through the code trying to find the problem, but really don't have time for that any more.
It depends on whether you've got a separately-installed version of "All Packing Slips"; the "All Invoices" plugin contains both an invoice and packing-slip element.

The packing-slip element of ***this ***plugin uses the "Store Name & Address" that you set in Configuration->My Store when it prints that information out. Would you post a screenshot of the packing-slip with and without the "full company information"?

It's been so long since I installed it that I don't remember whether I have a separately-installed version of All Packing Slips. The first screenshot shows what you see when you click on Generate. Everything looks fine. When you print it via the browser, though, you get a normal first sheet, with all the information showing. But on every subsequent sheet, you just get the company name and not the address and phone number.

I've just realized this is browser-dependent, so there may not be much anyone can do. It works all right in Chrome and IE, but has the above-described problem in Firefox. And I'm not going to switch browsers so I'll have to just use one of the others to print my packing slips.

I've replicated the behavior on FireFox (thanks for the detective work!). As you indicated above, the full address (store name, address) is printed on all pages on Chrome and IE, but not FireFox (58.0.2, 64-bit) which includes the store-name (but not address) on pages 2-to-last. The same behavior occurs (for me, anyway) on both the packing-slip and invoice print-outs.

I'll note the behavior in the plugin's GitHub repository.

Thanks, I'll keep an eye out for any updates.

We've just now hired a shipping helper who shouldn't be a superuser (shipping boss was a family member previously), and have discovered that the All Invoices and All Packing Slips functions are not available if you're not a superuser. Obviously something in the code is making that distinction but I no longer have time to go through the code and find it. Has anyone else done this and enabled it for all users? TIA

@HeleneWallis, did you grant your non-superuser admin access to those reports via the admin's Admins->Admin Profiles tool? The plugin creates two, separately-permissible pages ... one for the "All Invoices" and another for "All Packing-Slips".

This plugin is a brilliant thing - or would be with a couple of minor amendments. What would be ideal is the option of printing Packing Lists for all orders with a status of "Processing" then automatically setting the order status to "Pick in Procgrss" - And emailing the customers to inform then of the new status.
Then the Print Invoice function would be ideal if it could change all orders from a status of "Pick in Progress" to "Despatched" and again, email the customer.
I've amended the Invoice Report to get the appropriate status, but I can't seem to get it to send emails, and I can't get the Packing List report to update statuses at all.

Anyone using this with ZC 1.5.7?

Carbonless:

Anyone using this with ZC 1.5.7?
The plugin's files are/were based on v1.5.5. That is, the tpl_invoice and tpl_packing_slip files were derived from the admin/invoice and admin/packing_slip files in v155.

The changes to those admin files in v156 were mostly geared around css markup differences to work within admin UI changes, not so much in terms of actual generated order-related content. In v157 those changes were updated further to make customization easier by reducing in-page queries and reducing duplication of calculated content by substituting with variables calculated once. v157 added some logic to skip displaying a tax column if no tax applied to the order. It also includes product image thumbnails by default, but it's not uncommon for stores to not bother displaying those.

Thus, this all-invoices plugin will probably work fine on v157 with the caveat that there may be some missing UI updates (eg: it'll look more like an older version).
As with the original vision of the invoice/packingslip files, both in core and in this plugin, you are free to customize the appearance of the files' output however you wish, by editing the files directly.
So, as you would anyway, be prepared to update the tpl_invoice and tpl_packing_slip files that this plugin offers, to suit your needs.

It installed fine and works with 1.5.7b

Im using with 1.5.7b. Is there any way of changing the button that says Change the status to 2 - Processed, to my number 3 state which is "shipped"

angdrumm:

Im using with 1.5.7b. Is there any way of changing the button that says Change the status to 2 - Processed, to my number 3 state which is "shipped"
Line 82 of /admin/all_invoices.php (highlighted below) ...

} elseif (isset($_POST['resetids'])) {
    // clean POST list back to an iterable array
    $pending_orders = preg_replace('/[^0-9,]/', ',', $_POST['resetids']);
    $pending_orders = preg_replace('/,+/', ',', $pending_orders);
    $pending_orders = explode(',', $pending_orders);

 [B]   $status = 2; // set to Processed[/B]
    foreach ($pending_orders as $oID) {
        $sql = "UPDATE " . TABLE_ORDERS . " SET orders_status = " . (int)$status . ", last_modified = now() where orders_id = " . (int)$oID;
        $db->Execute($sql);
        $db->Execute("insert into " . TABLE_ORDERS_STATUS_HISTORY . "
            (orders_id, orders_status_id, date_added, customer_notified)
            values ('" . (int)$oID . "', " . (int)$status . ", now(), 0)");
    }

... change from 2 to 3.

lat9:

Line 82 of /admin/all_invoices.php (highlighted below) ...

} elseif (isset($_POST['resetids'])) {
// clean POST list back to an iterable array
$pending_orders = preg_replace('/[^0-9,]/', ',', $_POST['resetids']);
$pending_orders = preg_replace('/,+/', ',', $pending_orders);
$pending_orders = explode(',', $pending_orders);

[B] $status = 2; // set to Processed[/B]
foreach ($pending_orders as $oID) {
$sql = "UPDATE " . TABLE_ORDERS . " SET orders_status = " . (int)$status . ", last_modified = now() where orders_id = " . (int)$oID;
$db->Execute($sql);
$db->Execute("insert into " . TABLE_ORDERS_STATUS_HISTORY . "
(orders_id, orders_status_id, date_added, customer_notified)
values ('" . (int)$oID . "', " . (int)$status . ", now(), 0)");
}

> ... change from 2 to 3.

Brilliant, worked perfectly, thanks for the quick reply :)

The all_packing_slips portion of this plugin appears to be the original 2014 version. It was working fine with 1.5.5, but after our upgrade to 1.5.7d, it is no longer printing the shipping info on the packing slip. We have the shipping options highly customized so our customers will choose the optimum option for shipping. The packers can go by that information on the packing slip better than 99% of the time, so they don't have to decide what carton and shipping service to use for each order. Now that information is no longer appearing on the packing slip. I've looked at all_packing_slips.php, but I'm not yet sufficiently competent with php to see why the shipping info is apparently not being picked up any more. Can anyone help? @lat9, are you supporting this plugin now?

@HeleneWallis, I'm not currently supporting this; the last person who made changes was @mprough. You might try contacting her to see what's up.

Never mind, I found it. I was looking in the wrong place. \YOUR_ADMIN\includes\templates\tpl_all_packing_slips.php is missing two lines of code that were in the original version.

After line 134, you need to add

<td class="main"><b><?php echo 'Shipping Method' ?></b></td>
    <td class="main"><?php echo $order->info['shipping_method'] ?></td> 

So the full code at that point is

  <tr>
    <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>
    <td class="main"><?php echo $order->info['payment_method']; ?></td>
<td class="main"><b><?php echo 'Shipping Method' ?></b></td>
    <td class="main"><?php echo $order->info['shipping_method'] ?></td> 
  </tr>

lat9:

@HeleneWallis, I'm not currently supporting this; the last person who made changes was @mprough. You might try contacting her to see what's up.

Thanks, I'll do that and mention that the shipping method line may be really helpful to a lot of companies. I've put it back for us, but some newer users may not be aware that it was ever available.