Export Shipping & Order Information

[noi.ng]

Aaargh.

AND ot.orders_id = 1GROUP BY o.orders_id ORDER BY orders_id ASC ==> (as call

There is a space missing from the front of the GROUP statement.
I have updated the GitHub file https://github.com/OldNGreyBMR/expor....7/files/admin

Please let me know if you have any other problems with this. I couldn't operate without it for monthly reconciliations.

Great it works now for the blank options too! Yes this program helps a lot with accounting :)

However I looked at the exported data more closely just now for '1 Order per row', i think there is some errors in the exported data.
Some orders are duplicated. I couldn't possibly run the whole years check now but I did quick random 2024 checks.
Once the duplicated orders are removed, the sums & orders tallied.
Any idea where is the bug?

Thanks again for your quick resolution.

Noi

[OldNGrey]

However I looked at the exported data more closely just now for '1 Order per row', i think there is some errors in the exported data.
Some orders are duplicated.

A problem arises with the differences between MariaDB and MySQL and the many optional SQL Modes set by the user/administrator.
MySQL allows the ANY_VALUE setting to get around the GROUP BY clause when ONLY_FULL_GROUP_BY setting is used but the ANY_VALUE setting does not exist in MariaDB. [ I've learned a lot in the past few weeks.]
In the past I removed the ANY_VALUE on comments to allow the export to run on MariaDB. This caused duplicate records for "1 Order per row" when multiple comments existed against an order.

In test I can now get "1 Order per row" without duplicates even if comments are included.
I'm also parsing more so quotation marks in fields do not break the csv export.

[noi.ng]

A problem arises with the differences between MariaDB and MySQL and the many optional SQL Modes set by the user/administrator.
MySQL allows the ANY_VALUE setting to get around the GROUP BY clause when ONLY_FULL_GROUP_BY setting is used but the ANY_VALUE setting does not exist in MariaDB. [ I've learned a lot in the past few weeks.]
In the past I removed the ANY_VALUE on comments to allow the export to run on MariaDB. This caused duplicate records for "1 Order per row" when multiple comments existed against an order.

In test I can now get "1 Order per row" without duplicates even if comments are included.
I'm also parsing more so quotation marks in fields do not break the csv export.

That's interesting to note. Thanks for the information!

Best Regards, Noi

[OldNGrey]

I have an updated version (v1.5.1.c) in my GitHub https://github.com/OldNGreyBMR/expor...ing_export.php

This corrects issues:
#8 unicode names are not being parsed correctly, and
#9 additional blank columns are created on some records when one product per row is selected

Could you download this latest version and run it in your test system? If you detect any issue please post them here or as an issue in my Github.

[noi.ng]

I have an updated version (v1.5.1.c) in my GitHub https://github.com/OldNGreyBMR/expor...ing_export.php

This corrects issues:
#8 unicode names are not being parsed correctly, and
#9 additional blank columns are created on some records when one product per row is selected

Could you download this latest version and run it in your test system? If you detect any issue please post them here or as an issue in my Github.

Sorry I missed this thread. I have just downloaded. I will try in a few days when I can avail the time. Many thanks for the updated version.

[noi.ng]

Sorry I missed this thread. I have just downloaded. I will try in a few days when I can avail the time. Many thanks for the updated version.

An Update as at 24 Feb 24:
@OldNGrey

"I have an updated version (v1.5.1.c) in my GitHub https://github.com/OldNGreyBMR/expor...ing_export.php"

Hi, I assumed only this file "shipping_export.php"is changed.
I have replaced this file from the last version & it looks good now.
No more duplicates also for OneRowPerOrder too.

Just wondering, when I tried to get the complete version v1.5.1.c once more from this link below:

https://github.com/OldNGreyBMR/expor.../ESIv1.5.1.zip

I actually noted that the "shipping_export.php" is still the older version (so I took the single file from the link you gave & replace).
Am I taking from the wrong link? Other than that all is good now.

Many thanks! This plugin is really useful

Noi

[OldNGrey]

Hi, I assumed only this file "shipping_export.php"is changed.

That is correct. That is the only file that changed for the zc157 version.

Thanks for testing it. Now that we have no errors I'll create a new release as a zip file and submit it to the admins.

[n8pbm]

Testing out ZC 2.0.1. Uploaded Version 1.5.1 of this plugin. If I install V1.5.0 (Part of the plugin), I get the menu listed under tools. If I upgrade to V1.5.1 using the Plugin Manager, the menu under tools disappears. Doing a fresh install of V1.5.1 in plugin manager does not add the menu under tools.

I can get to the plugin page by manually typing the URL. But it removed the menu when I apply V1.5.1.

Thank you

[OldNGrey]

V1.5.2 is in the GitHub repository https://github.com/OldNGreyBMR/expor.../tag/ESIv1.5.2
and it fixes that problem.
It displays under the Tools menu as "Export Shipping & Order Info II"

[diptimoy]

IF I select 1 order per row I am getting error , whow to fix ? version of zencart is 1.5.7c
ASC
ORDER BY max_num_of_products DESC
LIMIT 1' at line 4 :: SELECT COUNT( * ) AS max_num_of_products
FROM (orders o LEFT JOIN orders_products op ON o.orders_id = op.orders_id), orders_total ot
WHERE o.orders_id = ot.orders_id
AND ot.class = 'ot_shipping' AND date_purchased BETWEEN '2024-07-01 00:00' AND '2024-08-28 23:59' GROUP BY o.orders_id ASC
ORDER BY max_num_of_products DESC
LIMIT 1