Video Tutorial – Export Shipping and Order Information From Zen Cart
June 14, 2007
Below you will find a video tutorial on how to use the Export Shipping Information version 1.2.0 module for Zen Cart.
If you do not already have the module installed and would like to get a copy, you can do so by going to my Downloads Page on this site, or by visiting the official Zen Cart downloads page and looking under the “Administration” category.
How to use this module to export shipping and order information from Zen Cart.
Subscribe Today and Start Winning More Customers
Gain valuable insights and strategies that will help you win over more customers and increase your sales.
Click here to Subscribe to my RSS feed.
How do you load this module?
There is a read me file that comes with the module. That contains the installation instructions. It reads as follows:
Install / Ugrade:
=================
1. Upload the entire contents of the “admin” folder to your website. All directories are already named for you and there are no files to overwrite so it should be easy.
NOTE: If you changed the name of your “admin” directory to something else, then upload to that directory.
2. Login Admin > Tools > Install SQL Patches and run the following file query:
NOTE: If you are upgrading from a previous version, you do not need to re-run this SQL command as your database should already contain this field.
ALTER TABLE orders ADD downloaded_ship ENUM( ‘yes’, ‘no’ ) NOT NULL DEFAULT ‘no’;
3. Enjoy!
can this module export the product attributes data automatically when an order is placed or during an order being processed. to a specific folder for processing.
for instance, I have a business card builder, a company will enter their information and choose specific graphics, when a generate graphics button is pressed a file with the attributes can be exported to a build folder where another server is watching for data files, when a file exists it is processed and the graphics are generated and the customer sees their proof. once the proof is approved the customer can finish the checkout process.
thanks for your help. Bob
Bob,
The current module does not have that capability. However, if you are interested in adding it as a custom job, feel free to contact me. I’m sure we can get a solution for you in place.
Hi!
I love this module. It’s exactly what I’ve been searching for. I have two questions. I exported my sales report; however, I have 1361 sales and it only exported 1219. How could I have gotten it to export more than the 1219?
Also, can I reset it so I can export again? I know about the test mode. I tried that first. When it didn’t export all 1361, I tried it without the test mode, and it still only exported 1219. Help!
Thanks in advance for your quick response! I really appreciate your help.
Is there any way to have the customer’s first and last name be output to separate columns?
One more question….if I have several attributes associated with a product is it possible to have each of those show up in a separate column?
This can be done, but it would have to be custom programmed. I’ve been trying to get a new version out here of this for some time now … just haven’t got around to final completion with other projects.
Again, this is possible with custom programming. There is one big problem with that though. One of the very first releases of this module did that. The problem is that because some products may have multiple attributes while others do not (or have less), the resulting set of columns generated is thrown off.
Most import programs don’t like this differentiation.
If you wanted it completed, I can get it done, but I won’t release that to the public as it can cause most import programs to refuse the file.
Totally new to this, so excuse my ignorance. I am suppose to load all the files included within the “admin” folder you provide with your product to the Admin folder that Zen Cat already provides?
Thanks for your patience.
Exactly what i’ve been looking for!! But…..I tried to use it for the first time today. An error came up saying that the information could not be downloaded at this time. Nothing happend. Then I unchecked a few boxes, including the “test run” box, and nothing happend again. Except for the error message “can’t download…..”. Now my shipping info isn’t there since I unchecked the test box! Eventhough it didn’t download anything! Can I get it back so that I can get it downloaded?? And has anyone else had that error? help!!
I have a new version coming out within the next week or so that will enable you to re-export the information by date range as well (even if it has already been exported.)
how can I change some of the checkboxes by default “ON” ?
Currently the only way you would be able to do that is to know some PHP coding. You could use the “show email checkbox checked” (shown on the login page during checkout) to figure out how you can set a checkbox etc… to selected.
Either way, you would have to know your way around PHP code at this point. Maybe your idea is something that would work into a future release. I’ll have to see what it takes to get it in.
I have an issue!
I installed this hopefully very helpful module today, and everything went well for a while! Until I tried to use it – there is no export to excel button. I am confused about this because, according to the instructions, “If there are no orders found to export, then the “Export” button will not show,” and that’s fine. But, as I’ve never exported any orders, all of them should show up, right? The bottom line, I suppose, is I have no “export” button and would like one!
Such a mistake has appeared after installation, how I change to do, help me
1054 Unknown column ‘downloaded_ship’ in ‘where clause’
in:
[select count(*) as total from zen_orders o where downloaded_ship='yes' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Jon,
I have heard this from a number of users and am working on what the issue is. Will post an updated version when ready.
Thanks.
Hi. Great mod but I am also getting an error where the export button should be:
Catchable fatal error: Object of class queryFactoryResult could not be converted to string in /home/xxx.com/public_html/order/admin/includes/functions/html_output.php on line 262.
Any help would be really appreciated.
Great mod! I am having one small problem and was wonder if it was a “user” issue on my part. I can’t seem to get it to export the Company Name field. It puts a column for it in the spreadsheet, but never populates it with data. Is this a known bug or something that I’m doing wrong on my end?
Thanks,
Mitch
Rob,
Your error message
is a zen cart issue that can be resolved using this post.
Mitch,
There is no known bug of this type. If the field is present and there is no data in it then it has something to do with the data that is in your database. Maybe there isn’t any information in that company field.
I installed this, but am getting the following error:
1054 Unknown column ‘downloaded_ship’ in ‘where clause’
in:
[select count(*) as total from zen_orders o where downloaded_ship='no' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Any idea what’s gone wrong?
Gary,
You need to run the small SQL patch found in the read me (Step 3 I believe).
That will solve your issue.
Any chance there can be an option to put the Sub total – before shipping & tax?
Zencart 1.3.8a: clean install
Uploaded files, and manually added the ROW ‘downloaded_ship’ in TABLE ‘orders’ , ENUM (’yes’,'no’), NOT NULL, Default ‘no’
Received this error
Catchable fatal error: Object of class queryFactoryResult could not be converted to string in /home/……../includes/functions/html_output.php on line 262
Try this link for a solution to your problem:
http://www.zencartoptimization.com/2008/10/15/zen-cart-catchable-fatal-error-html-output/
Thanks for you quick action. Works great now, no more error messages.
Is there anyway you can add customfields into the csv file? or remove some of the defualt fields?
Many thanks
There is currently no way to add custom fields into the export (will consider looking into this for a future version). To remove any of the default fields would require editing the code (but it can be done.)
If you need help with that let me know through my contact form.
I just wanted to comment on how valuable this utility has been for us. We were hit with a massive number of unexpected orders and had to ship the USPS. I exported the data from Zen cart and (after a little reformatting to fit the USPS requirement) had every pending order in the USPS Address book.
I made the Order ID the USPS Shortname and copied that column to another caller “Reference number” before I did the import. That way, I could search in the USPS Address book by the Zen Cart invoice number as well as print it on the USPS mailing label. This let me do a final verify that the shipping label matched the order.
Once again,thanks. You saved me uncountable hours (not to mention possible carpel tunnel) with this one tool.
Mike,
Glad you like the tool and find it a time saver. That was the idea in creating it originally. Looking forward to providing more helpful tools to help store owners do their jobs better.
Eric
How do you get the export spreadsheet to include the company name?
There was a bug in earlier versions that caused this feature to not export. I just released a new version 1.2.6 that corrects the issue.
Hi Eric,
The new version looks sweet (and I’m sure will be very useful). The install was straight forward and the description once install is 2nd to none (I wish more modules provided such good detail)
….but we perform the EXPORT which allows us to download/open the file. The XLS headers shows (first row) show but no content.
Any ideas why this may be happening?
If you are using version 1.2.6 then go back to 1.2.5 (to do this just download the 1.2.5 version and upload the /includes/admin/shipping_export.php file (overwriting the one you currently have in place). 1.2.6 introduced some new bugs.
I am actually working on a 1.2.7 version as we speak (very close to completion) that corrects the bugs introduced and provides a lot of new abilities.
In specific response to your quesiton, try what I listed above (go back to 1.2.5 (or even 4) and give that try.
The system also bases a lot of it’s exported data off of shipping fields so if you do not offer shipping, that MIGHT be a cause.
Let me know answers to the above (shipping or no) and try what I outlined here temporarily until 1.2.7 comes out. That version is really slick with some unique functionality.
Hi,
I downloaded v1.3.0 and it seems working perfect except one.
after I exported the file, it only export newest order. even data is never downloaded.
please advice.
The system is setup to only export the newest orders that have not already been downloaded (for obvious reasons.)
If you do not select “test” when exporting, then once you export orders, the system sets those to “exported” and the only way you can re-download them again is if you select the option to “include all orders previously downloaded”. This will export all orders (within the date range you choose) regardless of whether they were exported previously or not.
Let me know if that helps.
Hi,
Thank you for your advice.
I checked on “include all orders previously downloaded” but still I could download only newest order in data base.
I also tried with version 1.2.4 and this version works normal as I expected.
I have a new version I am going to upload that might solve the issue for you … will post the link to it here in a bit.
Tommy,
Go to the following link and download the most recent 1.3.1 version. This should have bug fixes that hopefully remedy your problem. Let me know how it works for you.
http://www.zencartoptimization.com/downloads/
Thanks!
hi,
Thank you very much for following up my request!
It worked perfectly now.
Great. Glad to hear that!
hi,
i’ve just tried to export for the first time and the fields exported fine but there is no data in them. I am only in test stages so I just have one order and its status is delivered. Checked that I am in test mode and that I am exporting all orders regardless of status. Any ideas? (I’m a newbie so feel free to state the obvious – it usually is something obvious!)
Thanks
Hi Eric
Any ideas on my issue would be welcome? (see earlier post)
Is it because I am running v 1.3.9b?
I would really like to be able to use your module as it will simplify my life no-end.
Thanks
Siobhan
@Siobhan I am looking at what may have been changed in 1.3.9 zen cart that may have an impact on the exports. I tested it on my end with a 1.3.9 install and all went well with no issues. I suspect it is something else causing the issue in a few cases.
Once I determine what may be the cause I will post.
On a side note, are you running 1.3.1 version of my mod? If not, upgrade to that. The 1.3.0 version has some problems in it that prevented data from being exported. Hope that helps.
I’m running v1.3.1 on ZenCart V1.3.9d. When I export, I get the csv file with the header row, but none of the orders are present.
I have it set to Any Order Status.
I have tried selecting and unselecting the various settings but the results are always the same.
For example:
Include orders already downloaded in export.
Run In Test Mode
Any ideas?
I’m looking into a number of reports of this. I have the program running on 1.3.9+ and it works fine but it seems as though the section with Country / Ship State might be throwing things off.
I had people answer some questions for me on this and duplicated their systems but no luck in duplicating the issues. Still trying to nail it down. Once I do (hopefully soon) I’ll post a fix.
Since you are unable to reproduce it, feel free to send me a special version with print statements and other debug statements and I would be glad to tell you what I see.
Thanks,