-
All Invoices Report [support]
I'm the author if the All Invoices report, I'm just starting this as a support thread for any questions / suggestions for improvements.
This report allows you to print out all invoices for a given order status in one go, without having to open each order and invoice individually.
Mat
-
Re: All Invoices Report
Hi There,
I installed the All Invoices Report Module.
It partially loads but I get an error:
SOLD TO:
Customer
1 test street
testville, 6000
Western Australia, Australia
[email protected]
SHIP TO:
Customer
1 test street
testville, 6000
Western Australia, Australia
Invoice No. 23
Date Ordered: Tuesday 06 April, 2010
Payment Method: PayPal
THEN ERROR part below:
Qty Model Products Price Total
1 x my Product
Fatal error: Call to undefined function dmc_ProductName() in H:\wamp\www\zencart\myadminfoldername\includes\templates\tpl_all_invoices.php on line 181
Any ideas?
LINE 181 from the tpl_all_invoices.php
echo ' <td class="dataTableContent" valign="top" align="left">' . dmc_ProductName($order->products[$i]['name']);
-
Re: All Invoices Report
Yes, my error ... I didn't notice the custom function in there that is being called (dmc_productname). I'll get that updated for you and upload a revised version.
Thanks
Mat
-
Re: All Invoices Report
I'm just working on another project, so to save you waiting. In the file:
Quote:
/admin/includes/templates/tpl_all_invoices.php
You will find the following around line 181:
Quote:
echo ' <td class="dataTableContent" valign="top" align="left">' . dmc_ProductName($order->products[$i]['name']);
Edit this line to read as follows:
Quote:
echo ' <td class="dataTableContent" valign="top" align="left">' . $order->products[$i]['name'];
This will resolve the issue for you. I'll get the download file updated later on with this.
Thanks for pointing it out, and my apologies for not checking it.
Thanks
Mat
-
Re: All Invoices Report
Thanks Fozzyo.
That did that fixed the issue :)
Did a print preview and all invoices load to print separately also which is great.
One suggestion if possible.
I have the standard 4 order status.
1 of my status is empty.
If I select this status it loads with a blank white page.
Though I understand that I have no invoices in that area.. perhaps an if statement that checks to see if there are invoices or not in the selected status and if value equals 0 to then have some text stating the status selected has no invoices to list ??
By the way great MOD. Very happy with it. WD.
-
Re: All Invoices Report
Thanks! I've just updated the download file to v1.1 which resolves the issue you raised. Good idea, I'll include that - only a simple addition that improves some usability.
Thanks
Mat
-
Re: All Invoices Report [support]
Mat,
Recently installed Zen Cart; bout 1 month now; new to Zen, but enjoying the experience so far. Still poking around; wonderful module. I wondered why I needed to go back and forth to print each invoice, again, still learning and poking around, and stumbled upon your module. Very nice, easy install. fix was easy, too. Thanks for this wonderful contribution. Haven't gone live with Zen yet, but looking forward to in the near future.
Marcia
-
Re: All Invoices Report [support]
Hi
Great Mod, it is just what I need :)
I have installed the module and it works for printing of orders processing, pending and update but not for shipped, I just get a white screen. There is rather a lot of shipped invoices but I need copies of all of them.
Is there a way to break them down into batches, or is there something else I can do to get past the white screen?
Regards
AfterHouR
-
Re: All Invoices Report [support]
Problem has been resolved by adding
memory_limit = 64M
to php.ini file and asking hosting to restart server.
all is now well
Regards
AfterHouR
http://www.allgoodideas.co.uk
-
Re: All Invoices Report [support]
Great mod. Thank you:bigups:
The shipped orders are only displaying the totals, but not the products seperately with the prices.
What can be wrong?
If I select anather status like pending, all the prices show.
-
Re: All Invoices Report [support]
Maybe this is just a general issue with how I have ZenCart installed, but everytime I try to execute a report it takes me back to the login screen and never executes the report. I'm totally at a loss, everything else seems to be working.
Thanks,
Brad
-
Re: All Invoices Report [support]
I solved my problem with the price from the products not showing:D
They just weren't there.
I imported a couple of invoices from an older Zen Cart installation, but lost some data.
@Brad
The report should open in a new browserwindow.
Is your browser properly setup to do so?
Regards,
Nick
-
Re: All Invoices Report [support]
cannot find 'All Invoices' from instruction after uploading to server.
1. Login to your admin page, from the 'Reports' menu select 'All Invoices'.
All files uploaded to right folders following site map layout.
ver. 1.39
this is the first add on
site not customized yet.
hosting company is hostgator
first problem after site starts running
-
Re: All Invoices Report [support]
Would it be possible to print by date as well as status with this mod. For instance if you need to print the last 3 months invoices?
Could someone tell me please, thank you :smile:
-
Re: All Invoices Report [support]
Hello,
I installed all_invoices and tried to print them but that goes wrong, first I need to print them landscape and I have a problem with the
lenght of the pages. Is there a way to adjust the page-lenght?
regards, Ceesdk
-
Re: All Invoices Report [support]
I had the same issue as this guy, I installed the files to the proper directories but the 'All Invoices' does not show. Any ideas?
Quote:
Originally Posted by
ybabs
cannot find 'All Invoices' from instruction after uploading to server.
1. Login to your admin page, from the 'Reports' menu select 'All Invoices'.
All files uploaded to right folders following site map layout.
-
Re: All Invoices Report [support]
FWIW, I submitted an updated version (v2.0.0) of this plugin that supports Zen Cart v1.5.0 and later ... last May ... and "forgot" :shocking: to note that change here! The plugin can be downloaded here: http://www.zen-cart.com/downloads.php?do=file&id=1083
-
Re: All Invoices Report [support]
v2.1.0 was just submitted to the Plugins:
- Now provides capability to print all packing slips, too
- BUGFIX: Page breaks didn't work in Google Chrome
-
Re: All Invoices Report [support]
-
Re: All Invoices Report [support]
I am finally found most of what I was looking for! Thank you! two questions.
1) I would like to display all statuses at once.
1) I would like to make orders display descending on the page.
Can someone please provide the code changes for this. It can be for either invoices or packing slips.
Thank you!
-
Re: All Invoices Report [support]
It'll be a small edit to /YOUR_ADMIN/includes/templates/tpl_all_invoices.php (for the invoices). Locate the lines that read:
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) {
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." ORDER BY orders_id DESC";
$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.
-
Re: All Invoices Report [support]
How do I make the admin/all_invoices.php select both pending and processing statuses at the same time? Ideally this would just be a default setting. Delivered and updated don't even matter to me. But I do need to see pending and processing on the same report simultaneously.
Thank you.
-
Re: All Invoices Report [support]
Quote:
Originally Posted by
southshorepizza
How do I make the admin/all_invoices.php select both pending and processing statuses at the same time? Ideally this would just be a default setting. Delivered and updated don't even matter to me. But I do need to see pending and processing on the same report simultaneously.
Thank you.
Make a change similar in nature to the change I identified in post #21:
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_id IN (1,2) ORDER BY orders_id DESC";
$pending_orders = $db->Execute($sql);
while (!$pending_orders->EOF) {
-
Re: All Invoices Report [support]
That didn't work due to a typo but it set me on the right path. Here is the fix in case anyone else is ever interested.
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 IN (1,2) ORDER BY orders_id DESC";
$pending_orders = $db->Execute($sql);
while (!$pending_orders->EOF) {
-
Re: All Invoices Report [support]
Sorry 'bout that!:blush: I'm glad I was able to point you in the right direction.
-
Re: All Invoices Report [support]
This isn't really doing what I need it to do. On the admin/all_invoices.php how could I make the drop down box give me all statuses or mutliple statuses? I have the template_all_invoices.php to refresh and I can clear them off when orders are complete. However when a new order comes in with a status different than the one chosen on admin/all_invoices.php it will not show up automatically.
I tried duplicating the array but that didn't work. Another report (sales report) has a similar feature where status "doesn't matter" I haven't figured out how to make that work though.
-
Re: All Invoices Report [support]
Quote:
Originally Posted by
southshorepizza
This isn't really doing what I need it to do. On the admin/all_invoices.php how could I make the drop down box give me all statuses or mutliple statuses? I have the template_all_invoices.php to refresh and I can clear them off when orders are complete. However when a new order comes in with a status different than the one chosen on admin/all_invoices.php it will not show up automatically.
I tried duplicating the array but that didn't work. Another report (sales report) has a similar feature where status "doesn't matter" I haven't figured out how to make that work though.
Perhaps if you'd describe the problem you're trying to solve (i.e. what you "need it to do"), I could either suggest an alternate plugin or a quick change to All Invoices that would provide you with a solution.
-
1 Attachment(s)
Re: All Invoices Report [support]
I need a monitor in the kitchen to make orders from. So I've been trying to design a program to put all orders on the screen and clear them as they are completed instead of waiting on a printer. I redesigned your template to show only what I wanted on the "report" you made which is now my monitor screen. Then had some help adding ajax to clear the order when it was made. A meta refresh kept it active until all orders of the status selected were cleared. Then it reverted to the select status screen. A meta refresh there allowed any new orders under that status to automatically reappear on the screen. The problem I had is orders came in with two statuses. Your report only allowed one status at a time. The solution I have now puts a checkbox not a drop down list. Now you can select several statuses at once.
Code:
<?php
//$statuses_array = array();
$statuses = $db->Execute("select orders_status_id, orders_status_name
from " . TABLE_ORDERS_STATUS . "
where language_id = '" . (int)$_SESSION['languages_id'] . "'
order by orders_status_id");
while (!$statuses->EOF) {
echo '<label>' . zen_draw_checkbox_field('status_'.$statuses->fields['orders_status_id'], $statuses->fields['orders_status_id'], (($statuses->fields['orders_status_id'] == 1 || $statuses->fields['orders_status_id'] == 2) ? true : false)) . ' ' . $statuses->fields['orders_status_name'] . '</label>';
/*$statuses_array[] = array('id' => $statuses->fields['orders_status_id'],
'text' => $statuses->fields['orders_status_name'] . ' [' . $statuses->fields['orders_status_id'] . ']');*/
$statuses->MoveNext();
}
echo zen_draw_hidden_field('action', 'list');
//echo zen_draw_pull_down_menu('status', $statuses_array);
?>
Attachment 13997
I continue to be amazed at how zen-cart can be adapted to fit the needs of users that were probably never even thought of at the beginning of the project. It works so well universally in filling individual and specific needs.
Thank you to all!
-
Re: All Invoices Report [support]
Cool! That's a neat solution.
-
Re: All Invoices Report [support]
Quote:
Originally Posted by
lat9
Hi,
I am still on version 1.1 of this plugin because I am still running ZenCart 1.39h. I would love to have the print all packing slip functionality. Would the 1.1 code be easy to modify to allow for printing of all packing slips? Any help is greatly appreciated... thanks!
-
Re: All Invoices Report [support]
Quote:
Originally Posted by
lolwaut
Hi,
I am still on version 1.1 of this plugin because I am still running ZenCart 1.39h. I would love to have the print all packing slip functionality. Would the 1.1 code be easy to modify to allow for printing of all packing slips? Any help is greatly appreciated... thanks!
Taking a quick look at the code, there are no core file overwrites and I check before using the v1.5.0+ functions. The code should work, it just won't integrate into your v1.3.9h admin's menu structure so you'll need to enter its address directly into your browser:
yourhost.com/YOUR_ADMIN/all_invoices.php
yourhost.com/YOUR_ADMIN/all_packingslips.php
If it doesn't work in a ZC 1.3.9h environment, just remove the files copied (the full file list is in the readme).
-
Re: All Invoices Report [support]
Quote:
Originally Posted by
lat9
Taking a quick look at the code, there are no core file overwrites and I check before using the v1.5.0+ functions. The code should work, it just won't integrate into your v1.3.9h admin's menu structure so you'll need to enter its address directly into your browser:
yourhost.com/YOUR_ADMIN/all_invoices.php
yourhost.com/YOUR_ADMIN/all_packingslips.php
If it doesn't work in a ZC 1.3.9h environment, just remove the files copied (the full file list is in the readme).
Thanks a bunch! The new versions notes said it was strictly for 1.5 so I was worried that the code was drastically different. I'm happy to hear that isn't the case!
I got this 2.1 version working on my 1.39h install flawlessly. I managed to add the menu items for it by including this file:
/admin/includes/boxes/extra_boxes/all_invoices_reports_dhtml.php
Code:
$za_contents[] = array('text' => BOX_ALL_INVOICES, 'link' => zen_href_link(FILENAME_ALL_INVOICES, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_ALL_PACKINGSLIPS, 'link' => zen_href_link(FILENAME_ALL_PACKINGSLIPS, '', 'NONSSL'));
Thank you!
-
Re: All Invoices Report [support]
You're welcome! I'm glad you got it working ... menus and all.
-
Re: All Invoices Report [support]
Hi. I am having an issue with invoices not printing 1 per page and no page break. I am running the following:
Windows 7
IE 11
ZC Version 1.5.1
Everything was fine until I upgraded to IE 11. Is there something that needs to be updated or code altered for IE 11? The functions work correctly in all other browsers.
I would prefer to sort this out for IE 11 as we use this for all other site functions.
-
Re: All Invoices Report [support]
I'm not seeing the IE11 issue. When printing the invoices, each new invoice starts on a new page (same configuration: IE11, Win7, ZC 1.5.1).
-
Re: All Invoices Report [support]
Any ideas? Only seemed to happen when I upgraded to IE11.
-
Re: All Invoices Report [support]
Like I said, I can't reproduce the issue running IE11 (11.0.9600.17207).
-
Re: All Invoices Report [support]
Quote:
Originally Posted by
Axeman
Hi. I am having an issue with invoices not printing 1 per page and no page break. I am running the following:
Windows 7
IE 11
ZC Version 1.5.1
Everything was fine until I upgraded to IE 11. Is there something that needs to be updated or code altered for IE 11? The functions work correctly in all other browsers.
I would prefer to sort this out for IE 11 as we use this for all other site functions.
I am having the same issue, but in my case, it doesn't seem to matter whether I'm using IE11, Chrome, etc., and it happens on multiple different PCs. I'm wondering if I messed up something in the addon installation.
-
Re: All Invoices Report [support]
/templates/tpl_all_invoices.php has a div style around line 270. This must be coded correctly for your browser type and version. If you upgraded to a new version of ie and it stopped working than the code isn't supported by the new browser. Add the code for your particular browser into that line.
-
Re: All Invoices Report [support]
Quote:
Originally Posted by
southshorepizza
/templates/tpl_all_invoices.php has a div style around line 270. This must be coded correctly for your browser type and version. If you upgraded to a new version of ie and it stopped working than the code isn't supported by the new browser. Add the code for your particular browser into that line.
Thanks. That led me to a solution for my case. It may not be the preferred solution, but moving the style into the <table> tag works for me:
Code:
<table style="page-break-after: always;" border="0" width="100%" cellspacing="0" cellpadding="2">
-
Re: All Invoices Report [support]
-
Re: All Invoices Report [support]
The solution for me was similar. I move the style and it worked fine. I also found this was in a <br> tag not a div just after <!-- Add page break for print out -->.
When I moved the style to the first <table> I also deleted the <br> where the style was originally located.
One slightly annoying thing is that the addon has always chucked out a blank page before printing the invoices. After the change it does the same but after the invoices are printed. Any ideas why this could be happening? I have found this since the very first version that I have installed and on different printers using different operating systems (currently Windows 7 Ultimate) and different browsers (currently IE 11. Given all these facts I would say it would be a coding issue rather than system, software or printer problem.
-
Re: All Invoices Report [support]
I heavily modified this report but what I can tell you is there is something making it generate that blank page. So there is some content after the page break. I'm assuming this is after every invoice so if you are printing 10 invoices you are getting 10 blank pages and not 10 invoices with 1 blank page at the end. The fact that you say it went from a blank page before to blank page after confirms this.
-
Re: All Invoices Report [support]
I've checked the default version of All Invoices on a 17-page printout on the most recent version of both FireFox and IE11 and I don't see the extra-page issue.
-
Re: All Invoices Report [support]
-
Re: All Invoices Report [support]
-
Re: All Invoices Report [support]
hi,
i just started looking at this module for a specific need. while it does get installed on the admin side; i would still cleanse the $orderStatus variable prior to its use. from:
PHP Code:
$orderStatus = $_GET['status'];
to
PHP Code:
$orderStatus = zen_db_prepare_input($_GET['status']);
or perhaps making use of the bindVars instead.
i have a need to print a range of invoices; i am not sure if others have a need for that. which seems like easy enough to do. however, on first glance, this does look to be like a valuable module. thanks!
-
Re: All Invoices Report [support]
Good point, carlwhat, I'll add that to the plugin's change-list. I'm not as concerned about the sanitizing since it's on the admin side.
-
Re: All Invoices Report [support]
lat9,
which one was the good point: adding an invoice range? or sanitizing the $_GET variables?
i agree, the sanitizing is not as big a concern as it is on the admin side. the invoice range is for what i needed the module. i suppose the tricky part is what invoices to include, as we have a cancelled order status which we do not want to see; but then all of other statuses we do.
i suppose the selection process could go on and on...
in addition, we implemented the super_orders and super_invoices module, so i needed to modify the formatting of the invoice to match that...
that said, a very helpful starting point for me. thanks again for this contribution.
best.
-
Re: All Invoices Report [support]
carlwhat, I was responding to the need to sanitize the $_GET variable (just using a simple integer-cast is sufficient).
I'll add the order-range specification as a change-request to the plugin.
-
Re: All Invoices Report [support]
Just a quick query if there's an updated version for 1.5.5a in the pipeline? Thank you for making this available!
-
Re: All Invoices Report [support]
Quote:
Originally Posted by
terraGirl
Just a quick query if there's an updated version for 1.5.5a in the pipeline? Thank you for making this available!
Should be good-to-go! That's one of the benefits (usually) of a no-core-file-overwrites plugin.
-
Re: All Invoices Report [support]
Hi lat9,
I just submitted an update (called it 2.5) which allows the storeowner to optionally update all the selected orders' status after generating the report.
It involved rearranging a couple things between files.
And the foreach which loops thru orders is v1.5.5 specific. I guess it could be changed to a "while !EOF, MoveNext()" if really needed on older versions.
https://www.zen-cart.com/downloads.php?do=file&id=1083
-
Re: All Invoices Report [support]
Quote:
Originally Posted by
DrByte
Hi lat9,
I just submitted an update (called it 2.5) which allows the storeowner to optionally update all the selected orders' status after generating the report.
It involved rearranging a couple things between files.
And the foreach which loops thru orders is v1.5.5 specific. I guess it could be changed to a "while !EOF, MoveNext()" if really needed on older versions.
https://www.zen-cart.com/downloads.php?do=file&id=1083
Thanks, DrByte. I'll download your changes and create a v2.5.0 release in the plugin's GitHub repository.
-
Re: All Invoices Report [support]
Hi..
I have just downloaded and installed the 2.1.0 version (since I have 1.5.4). The readme file is telling me that I have to go to Reports->All Invoices or Reports->All Packing Slips. But I do not see the option All invoices or reports under the reports-button (only the standard ones like customers order total and so on)
Do you happen to know what went wrong?
-
Re: All Invoices Report [support]
Quote:
Originally Posted by
LadyoftheCave
Hi..
I have just downloaded and installed the 2.1.0 version (since I have 1.5.4). The readme file is telling me that I have to go to Reports->All Invoices or Reports->All Packing Slips. But I do not see the option All invoices or reports under the reports-button (only the standard ones like customers order total and so on)
Do you happen to know what went wrong?
That's weird, since this plugin is a "drop-in" (i.e. no existing files modified). Are you sure that you "dropped" the files in the right directory?
-
Re: All Invoices Report [support]
an easy way to tell if you loaded the files to the right place would be to directly call the script:
www.yoursite.com/YOUR_ADMIN/all_invoices.php
does that work?
unfortunately i do not remember exactly how things appear on the admin menu w/o doing a little digging....
good luck.
-
Re: All Invoices Report [support]
Quote:
Originally Posted by
lat9
That's weird, since this plugin is a "drop-in" (i.e. no existing files modified). Are you sure that you "dropped" the files in the right directory?
I think I did, but I will check everything again in case I missed something..
-
Re: All Invoices Report [support]
Yes, I did something wrong, it must have been the heat (extremely hot day in the Netherlands) :oops:
It is working now, but since it is working, I have two other questions (sorry :blush:):
1) The invoices are shown in the standard design, not in the design that I have made for the invoices. Can this being changed?
2) Is it not possible to make a selection, for example, I want to print out order 8000 till 9000)?
Best Regards
-
Re: All Invoices Report [support]
I'm glad you got it sorted; in answer to your questions:
- 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.
- 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.
-
Re: All Invoices Report [support]
Quote:
Originally Posted by
lat9
I'm glad you got it sorted; in answer to your questions:
- 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.
- 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?
-
Re: All Invoices Report [support]
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.
-
Re: All Invoices Report [support]
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.
-
Re: All Invoices Report [support]
Quote:
Originally Posted by
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"?
-
2 Attachment(s)
Re: All Invoices Report [support]
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. Attachment 17750Attachment 17751
-
Re: All Invoices Report [support]
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.
-
Re: All Invoices Report [support]
Thanks, I'll keep an eye out for any updates.
-
Re: All Invoices Report [support]
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
-
Re: All Invoices Report [support]
@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".
-
Re: All Invoices Report [support]
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.
-
Re: All Invoices Report [support]
Anyone using this with ZC 1.5.7?
-
Re: All Invoices Report [support]
Quote:
Originally Posted by
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.
-
Re: All Invoices Report [support]
It installed fine and works with 1.5.7b
-
Re: All Invoices Report [support]
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"
-
Re: All Invoices Report [support]
Quote:
Originally Posted by
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) ...
Code:
} 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.
-
Re: All Invoices Report [support]
Quote:
Originally Posted by
lat9
Line 82 of /admin/all_invoices.php (highlighted below) ...
Code:
} 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 :)
-
All Packing Slips not displaying shipping info
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?
-
Re: All Packing Slips not displaying shipping info
@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.
-
Re: All Packing Slips not displaying shipping info
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>
-
Re: All Packing Slips not displaying shipping info
Quote:
Originally Posted by
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.
-
Re: All Packing Slips not displaying shipping info
I have 2.6 installed on 1.5.7c and after generating a report and choosing to print it the print job always adds a blank page at the end. Does this under edge and chrome. When you are viewing the webpage there is no extra blank page. Does not matter which printer or save to pdf is selected. Preview shows it and it will print the blank. I looked into the code and noticed in the admin\includes\templates\tpl_all_invoices.php in the foreach loop it adds the page break at the end of each loop. I am guessing ideally it would either do a page break at the beginning of each loop (but have a condition to skip for the first loop) or check if it was the last record and if not then add the page break otherwise skip it. Just playing around I commented the page break at the end of the loop and instead inserted it into the beginning. This fixed the problem and even though there is an immediate page break it doesn't seem to add it to the print job. So the beginning of my loop looks like (line 63):
Code:
foreach($pending_orders as $oID) {
$order = new order( (int)$oID);
?>
<div style="page-break-before: always;"></div>
-
Re: All Packing Slips not displaying shipping info
Quote:
Originally Posted by
spyderrobotics
I have 2.6 installed on 1.5.7c and after generating a report and choosing to print it the print job always adds a blank page at the end. Does this under edge and chrome. When you are viewing the webpage there is no extra blank page. Does not matter which printer or save to pdf is selected. Preview shows it and it will print the blank. I looked into the code and noticed in the admin\includes\templates\tpl_all_invoices.php in the foreach loop it adds the page break at the end of each loop. I am guessing ideally it would either do a page break at the beginning of each loop (but have a condition to skip for the first loop) or check if it was the last record and if not then add the page break otherwise skip it. Just playing around I commented the page break at the end of the loop and instead inserted it into the beginning. This fixed the problem and even though there is an immediate page break it doesn't seem to add it to the print job. So the beginning of my loop looks like (line 63):
Code:
foreach($pending_orders as $oID) {
$order = new order( (int)$oID);
?>
<div style="page-break-before: always;"></div>
I'll give that a look, no guarantee on timeframe at this point. GitHub tracking issue: https://github.com/lat9/all_invoices/issues/12
-
Re: All Invoices Report [support]
I have installed All Invoices on a new install of Zen Cart 2.01 running PHP 8.3 When I try to open it from admin I get and Http error 500.
Is it possible to make this work on my current install? I have relied on this for years now and have no idea what would give the same results.
-
Re: All Invoices Report [support]
Quote:
Originally Posted by
Foghead
I have installed All Invoices on a new install of Zen Cart 2.01 running PHP 8.3 When I try to open it from admin I get and Http error 500.
Is it possible to make this work on my current install? I have relied on this for years now and have no idea what would give the same results.
As I've noted in other forum threads, I've not had the chance (as you've seen) to update this for zc200 and later. It's relatively low on my priority list right now as I'm addressing paying client's requests and trying to get some of the base Zen Cart 2.1.0 processing working correctly.