Export Shipping & Order Information

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

[brian70809]

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

Thanks!!

[OldNGrey]

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/expor.../tag/ESIv1.5.4

[pilou2]

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.

[gsh68]

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.

[swguy]

You need to check $orders_subtotal for EOF.

[gsh68]

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.

[swguy]

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

[gsh68]

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?

[swguy]

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/expor...rmation/issues