Zen Cart Export Shipping Information Contribution
Written by Eric Leuenberger June 1, 2007
This module enables you to export shipping information in Excel (csv) format for orders placed in Zen Cart.
What you do with that file is up to you. Some ideas: Drop shipping fulfillment, Analysis of data in Excel spreadsheets,
bulk printing of labels, bulk printing of envelopes, etc.. you get the idea.
Features:
- Adds export functionality for shipping information to Zen Cart.
- Compatible with Zen 1.2.6 thru 1.3.7.
- Fully customizable from within the Admin
- Files to overwrite = NONE.
Module Compatibility
Has been tested with and works on Zen Cart versions 1.2.6 thru 1.3.7
Current Version
1.0.0
There are future plans to include additional capabilities to this module. If you have ideas you would like to see integrated, let me know by posting them below.
Enjoy!
To download the Contribution, click the link below:
If you enjoyed this post, make sure you subscribe to my RSS feed!
Thanks very much for the Free Zen Cart Add On.
Hello
Thank you for the effort you have putten in. I tryied to install, but after installation i get this message when starting the addon from the admin pane: 1146 Table ‘hbhorsesbe1.zen_orders’ doesn’t exist
in:
[select count(*) as total from zen_orders o where downloaded_ship=’no’ ]
problem is that he is looking for zen_orders instead of ZEN_orders.
How can i solve this?
Best regards
Bart
The caps vs. non-caps shouldn’t pose any problem in this situation.
A few things to check.
1) Is “zen_ the actual prefix in your db or is yours something else?
2) What version of the mod are you using?
3) Did you run the included SQL Patch (via copy and paste in the admin?)
Hello
Thanks for the information.
I have found the issue. In one of the files an upper statement of the table name is in, so i had to put that line in comment and it works fine now.
Best Regards
Bart
Hi Eric,
thanx a lot for your contrib… After installing your files, the sql, everthing like mentionend in your installation hints I’ve got the same problem like bart in his post from the 30th of April this year. The error message is: “1146 Table ‘usr_web153_7.13s01b69_zc_orders’ doesn’t exist”. I’m using ZenCart 1.3.9h. The prefix of the table is correct but same like bart mentionend:the _zc_ in between is written in upper cases in my DB. Correct should be “usr_web153_7.13s01b69_ZC_orders”. Could you gimme a hint where to search and how to fix this issue? thnx in advance…
I wish you a merry christmas and a very happy new year 2012…
Greetz
Lutz