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.
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,
Hi I have hjust downloaded and installed your util but nothing is showing up on the Export Page. I’ve have orders already in the system and I have added new orders. I’m using the latest version of your plugin and I’m using ZenCart 1.3.9g.
I have it working on 1.3.9 with the latest version so this must be an isolated incident.
Do all of your products require a shipping address (or are some downloads etc… that you do not ask for shipping addy?)
I installed module but when I try and export the shipping details, the file comes out blank except for the header row. If I uncheck “header row” the file is completely blank. I’m using version 1.3.1
Do you have any suggestions on how I can fix this? I really need this module!
If there’s an older version that works, is that still available for download?
Make sure you have the latest version. Previous versions had a similar bug, but the newest version addresses this.
Hi. I had my programmer install this module and its not working right on 1.3.9h. It exports the default info the first time via csv but then when you try a second time or select additional fields to export its a blank csv file….any ideas?
Once you export it marks the orders as exported. To export them again you need to select the option to include previously exported records.
Have you tried this? Doea that work?
After the first export the contribution marks each record as ‘exported’ (unless you ran it in test mode.)
To get the transactions to export again make sure you select ‘include already exported orders’ and see what you get.
This a great mod. I new to zen cart but found your instructions very easy to follow and so far I have I had zero problems. Thanks for making this install so easy for a newbie like me!
Do you for see adding an automatic feature where orders are automatically processed once or twice a day? I would assume there would have to be a cronjob built into the mod.
Not critical, just take one more thing off of my list of things to do. LOL
Thanks again for all the contribs!
Eric,
I installed version 1.3.2 files on Zen Cart 1.3.8a, ran the install SQL, and then tried to export some orders. I got this error. Can you help?
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AND cc.countries_name = o.delivery_country WHERE o.orders_id = ot.orders_id AND’ at line 1
in:
[SELECT o.orders_id, customers_email_address, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, shipping_method, customers_telephone, order_total, op.products_model, products_name, op.products_price, final_price, op.products_quantity, date_purchased, ot.value, orders_products_id, order_tax, o.orders_status, o.payment_method, cc.countries_iso_code_2 FROM (orders o LEFT JOIN orders_products op ON o.orders_id = op.orders_id), orders_total ot, countries cc AND cc.countries_name = o.delivery_country WHERE o.orders_id = ot.orders_id AND ot.class = ‘ot_shipping’ AND o.orders_status = ‘1’ ORDER BY orders_id ASC]
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.
That was an error I thought was corrected. I’ll take a look and put out an update to correct it.
It would be fantastic if this module could automatically export orders to a specific folder once and order is placed.
Mike
Hi Eric,
I had my site developer install this mod and it’s a real life saver! I use it to import my data into an Access database. The only thing is that every time I have to be sure to select the exact same settings so things are correct. Is there a way to “Save” the various options so I don’t make the occasional mistake and not export the proper fields?
It can be done but you need to have your developer do this within the code. It is not an option from within the admin.
If you need help with this let me know. I’ve custom programmed this type of thing for a number of others.
Thanks Eric,
My developer asked if you could send the “list of modifications”. Not exactly sure what these are but I would appreciate your help.
John,
What they want to do is find the locations they want to preselect and then change from something like this:
zen_draw_checkbox_field('shipmethod', '1', $shipping_method_checked);
to this
zen_draw_checkbox_field('shipmethod', '1', $shipping_method_checked=true);
All I did was add the “=true” to the portion that specifies whether the item is checked or not.
For radio buttons you’ll do something like this:
zen_draw_radio_field('filelayout', '1')
change to
zen_draw_radio_field('filelayout', '1', 'selected')
I’m also interested in the functionality that John mentioned. Can you please send me the necessary code modification to accomplish this? Thanks!
HELP! We are unable to get the name, address to display or included in our exports? We can click on each order to view, and the info is there.
The info is also being forwarded to our merchant account.
But the export file does not include it.
Any suggestions?
Katie
What version of the program are you using?
What are the items you are selecting (additional options)?
The name etc… should be exported by default.
Let me know answers to the above and we’ll see if we can work through it here.
I’m using V1.3.9h of Zen, and V1.3.2 of the Export program.
I select Ship Total, Phone, Order Total & Order Date as well as “Full Product Details”.
I’ll let you know how it works out.
I am having the same problem Katie Palmer is having on May 3rd 2011…company name does not export. How do I fix?
Did you have an answer for Mike on April 12th, 2011? This would really nice..
What version you have? Older versions introduced a big that caused thr company name to not export. This was fixed in the most recent version.
I don’t see the prducts weight is this field exported?
This would be a custom change. Only the actual dollar amt of the shipping along with the shipping type is exported.
How can i add the products weight to the csv file?
You would need to alter the shipping_export.php file in a number of locations. Make sure you update the SQL queries to reflect the change.
It isn’t just any easy ‘this is the place you add it’ unfortunately, but it can be done.
If you’re looking for someone to customize it for you my team can do that for you. We would quote it as a one time project.
Hi, I am trying to use this module with v1.5.0 of Zencart. I’ve installed all files as per instructions but I don’t see any Export function under tools for old orders or for any new ones that came in after the install. All files are in place on the server. Any ideas? Thanks
Have you registered the pages in the admin? Version 1.5 rewuires you to register the pages within the admin first.
Lee, in Zen Cart 1.5 you need to ‘register’ the pages within the Admin per the new requirements. Let me know if you need more information on how to do this.
Thanks!
Hi,
Thanks for this mod!
Is there capability now or future plans to include the customer billing address as part of the export spreadsheet?
We are very interested in this capability.
thanks,
Tom