All Invoices Report [support]

[Carbonless]

Anyone using this with ZC 1.5.7?

[DrByte]

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.

[Carbonless]

It installed fine and works with 1.5.7b

[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"

[lat9]

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);

    $status = 2; // set to Processed
    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.

[angdrumm]

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);

    $status = 2; // set to Processed
    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 :)

[HeleneWallis]

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?

[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.

[HeleneWallis]

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>

[HeleneWallis]

@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.