Export Shipping & Order Information

I was working on translation of this plugin when I realized there was some text here and there hard coded in PHP files instead of using constants... Which prevents on the fly language change!

GitHub version Works! The one in the zen-cart.com repo did not.

Thanks!!

pilou2:

I was working on translation of this plugin when I realized there was some text here and there hard coded in PHP files instead of using constants... Which prevents on the fly language change!
Thank you. That is good work with the updates.
I have released V1.5.4 for moderator approval.

It can also be downloaded from Github https://github.com/OldNGreyBMR/export_shipping_information/releases/tag/ESIv1.5.4

Already downloaded v1.5.4 from GitHub. It works very well on ZC 2.1.0 and is now translated in French and Japanese. Language files will be available with respective language packs when new version is released. For now you can download them from language packs GitHub repositories.
French Language Pack for ZC
ZenCart Japanese Language Pack
Fill free to add them to this plugin if you want.

ZC2.1
php 8.3.23
MySQL 10.11.14-MariaDB

Fresh installation via ftp with upgraded 1.57c database
Only other change is bootstrap template installed and some styling changes made via css or overrides.

v1.5.4
When running a bog standard export with just 1st/last name/header/phone # selected the csv exports fine.

If I try and export with full order details as I will be using it and have been using for the last 6+ years (1st/last name/header/phone #/one product per row/full product details) I get a blank screen and the following error log.

[26-Aug-2025 19:54:41 UTC] Request URI: /index.php?cmd=shipping_export2, IP address: xx.xx.xxx, Language id 1
#0 /zc_plugins/ExportShippingInformation/v1.5.4/admin/shipping_export2.php(521): zen_debug_error_handler()
#1 /admin/index.php(28): require('/home/xxxx/p...')
--> PHP Warning: Undefined variable $orders_subtotal in /zc_plugins/ExportShippingInformation/v1.5.4/admin/shipping_export2.php on line 521.

[26-Aug-2025 19:54:41 UTC] PHP Fatal error:  Uncaught Error: Call to a member function RecordCount() on null in /zc_plugins/ExportShippingInformation/v1.5.4/admin/shipping_export2.php:521
Stack trace:
#0 admin/index.php(28): require()
#1 {main}
  thrown in /zc_plugins/ExportShippingInformation/v1.5.4/admin/shipping_export2.php on line 521

[26-Aug-2025 19:54:41 UTC] Request URI: admin/index.php?cmd=shipping_export2, IP address: xx.xx.xxx
--> PHP Fatal error: Uncaught Error: Call to a member function RecordCount() on null in /zc_plugins/ExportShippingInformation/v1.5.4/admin/shipping_export2.php:521
Stack trace:
#0 admin/index.php(28): require()
#1 {main}
  thrown in /zc_plugins/ExportShippingInformation/v1.5.4/admin/shipping_export2.php on line 521.

[26-Aug-2025 19:54:41 UTC] Request URI: admin/index.php?cmd=shipping_export2, IP address: xx.xx.xxx
--> PHP Fatal error: Uncaught Error: Call to a member function RecordCount() on null in /zc_plugins/ExportShippingInformation/v1.5.4/admin/shipping_export2.php:521
Stack trace:
#0 admin/index.php(28): require()
#1 {main}
  thrown in /zc_plugins/ExportShippingInformation/v1.5.4/admin/shipping_export2.php on line 521.

i also tried with the github 1.5.3 version with the same result.

Any help would be appreciated.

You need to check $orders_subtotal for EOF.

swguy:

You need to check $orders_subtotal for EOF.

Sorry, I'm not quite sure what you mean.
There's no EOF for $orders_subtotal. There's no BOF either.
There is EOF for sub-totals @ shipping_export2.php:456 but there are $orders_subtotal entries after this.

Not bof and eof from code block comments, but

if (!$orders_subtotal->EOF) { ...

See line 336 for an example of how this is done.

But looking up, it appears that variable might not even be set so you should be doing more:

$num_rows = 0;
if (isset($orders_subtotal) && !$orders_subtotal->EOF) {

And looking more deeply there are a bunch of issues with this logic:

line 434:
if (isset($_POST['order_subtotal']) == 1) {
should be

if (isset($_POST['order_subtotal'])) {

(same change in other places that is used - line 270, 277, 278, etc

line 149:
if (!empty($_POST['iso_country2_code']) == 1 || !empty($_POST['iso_country3_code']) == 1) {
should be

if (!empty($_POST['iso_country2_code']) || !empty($_POST['iso_country3_code']) ) {

same changes in other places that pattern is used - line 156, etc

Thanks. That’s all a bit above my skill level.

I've done a bit more testing.

If I select test mode/1st+last name/header/any status/1 product per row/shipping total/order total/order date/order tax amt/order subtotal/order discount/payment method/shipping method/full product details
the csv exported as it should.

Checking one by one, unchecking order subtotal causes the whitescreen.
Checking include orders already downloaded results in a hanging page.
Also for some reason an apostrophe is being added to the front of phone numbers.

So I could in theory use as-is by checking sub-total as well as my regular outputs but would not be able to re-download already downloaded orders if I had reason to.

To be certain I also tried the 1.5.4 version from Github in case there was a difference.
Same results.

Are these conflicts due to my installation or the module itself?

None of my clients use this mod so I can't say how well it works. File an issue with the author at

https://github.com/OldNGreyBMR/export_shipping_information/issues

Thanks, will do.

A bit more testing and checking the "dl previous orders" button works with a set that will work for me. It still throws errors though, different depending on the checked boxes.

I thought I had posted a reply to this previously but obviously not.

gsh68:

ZC2.1
If I try and export with full order details as I will be using it and have been using for the last 6+ years (1st/last name/header/phone #/one product per row/full product details) I get a blank screen and the following error log.

Does this only occur when you deselect "Order Subtotal"?
If not can you please post a screen shot of your 'Additional Fields and Option" settings.

OldNGrey:

I thought I had posted a reply to this previously but obviously not.
Does this only occur when you deselect "Order Subtotal"?
No.
This works. I use these settings about 50% of the time.
[Attachment no longer available]

If I try and export with the following I get a white page and the error log posted above.
[Attachment no longer available]

If I use the same settings as above but check the order subtotal box it exports as it should.
[Attachment no longer available]

Thanks.

Seems the images I uploaded have disappeared, so here they are again.

This works.
https://imgur.com/BMJAHXW

If I try and export with the following I get a white page and the error log posted above.
https://imgur.com/5aYRxwV

If I use the same settings as above but check the order subtotal box it exports as it should.
https://imgur.com/StNDdMh

I have released version 1.5.5 which correct the subtotal check issue plus makes asome additional checks.

It is available from GitHub at https://github.com/OldNGreyBMR/export_shipping_information/releases/tag/ESLv1.5.5

Please uninstall any previous version and reinstall this new one.

Thanks. First tests as I currently use it has it working correctly. I'll do some more testing of combinations of checkboxes another time.
Cheers.

V1.5.6 is available from GitHub https://github.com/OldNGreyBMR/export_shipping_information/releases/tag/ESLv1.5.6
and corrects the logic so one order per row works + full product details now lists correctly.

This version has been submitted to the administrators for inclusion in the Plugin Library.

Thanks.