Video Tutorial – Export Shipping and Order Information From Zen Cart

Written by  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.



If you enjoyed this post, make sure you subscribe to my RSS feed!

Related articles other people have read:

Comments

76 Responses to “Video Tutorial – Export Shipping and Order Information From Zen Cart”

  1. pwp on August 1st, 2007 5:14 am

    How do you load this module?

  2. econcepts on August 1st, 2007 7:48 am

    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!

  3. bob knight on December 20th, 2007 5:26 am

    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

  4. econcepts on December 20th, 2007 8:58 am

    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.

    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.

  5. Cindy on January 28th, 2008 4:10 am

    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.

  6. Howard S on March 8th, 2008 10:54 pm

    Is there any way to have the customer’s first and last name be output to separate columns?

  7. Howard S on March 9th, 2008 1:10 am

    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?

  8. Eric Leuenberger on March 12th, 2008 8:38 pm

    Is there any way to have the customer’s first and last name be output to separate columns?

    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.

    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?

    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.

  9. Bill on March 13th, 2008 9:00 am

    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.

  10. Jerrad on September 19th, 2008 5:14 pm

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

  11. Eric Leuenberger on September 20th, 2008 2:30 pm

    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.)

  12. Erwin on September 30th, 2008 4:32 am

    how can I change some of the checkboxes by default “ON” ?

  13. Eric Leuenberger on October 17th, 2008 6:47 am

    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.

  14. jon on November 3rd, 2008 3:18 pm

    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!

  15. Rain on November 17th, 2008 1:41 pm

    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.

  16. Eric Leuenberger on November 21st, 2008 2:47 pm

    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!

    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.

  17. Rob Snowden on December 4th, 2008 5:56 am

    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.

  18. Mitch G. on December 8th, 2008 3:22 pm

    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

  19. Eric Leuenberger on December 10th, 2008 8:30 am

    Rob,

    Your error message

    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.

    is a zen cart issue that can be resolved using this post.

  20. Eric Leuenberger on December 10th, 2008 8:34 am

    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?

    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.

  21. Gary on December 22nd, 2008 4:18 pm

    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?

  22. Eric Leuenberger on December 24th, 2008 1:41 pm

    Gary,

    You need to run the small SQL patch found in the read me (Step 3 I believe).

    That will solve your issue.

  23. Kiv on May 19th, 2009 11:17 am

    Any chance there can be an option to put the Sub total – before shipping & tax?

  24. Goshawk on June 8th, 2009 9:18 am

    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

  25. Eric on June 8th, 2009 9:33 am
  26. Goshawk on June 8th, 2009 11:39 am

    Thanks for you quick action. Works great now, no more error messages.

  27. Elliot on September 24th, 2009 6:15 am

    Is there anyway you can add customfields into the csv file? or remove some of the defualt fields?

    Many thanks

  28. Eric on September 24th, 2009 9:11 am

    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.

  29. Mike Price on January 16th, 2010 8:13 am

    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.

  30. Eric on January 16th, 2010 8:43 am

    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

  31. Tom on January 17th, 2010 10:11 am

    How do you get the export spreadsheet to include the company name?

  32. Eric on January 17th, 2010 10:51 am

    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.

  33. Jamie on March 3rd, 2010 9:40 am

    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?

  34. Eric on March 3rd, 2010 9:50 am

    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.

  35. Tommy on June 13th, 2010 9:51 pm

    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.

  36. Eric on June 14th, 2010 1:19 pm

    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.

  37. Tommy on June 21st, 2010 5:19 am

    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.

  38. Eric on June 21st, 2010 10:24 am

    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.

  39. Eric on June 21st, 2010 1:10 pm

    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!

  40. Tommy on June 22nd, 2010 6:44 am

    hi,

    Thank you very much for following up my request!
    It worked perfectly now.

  41. Eric on June 23rd, 2010 8:10 am

    Great. Glad to hear that!

  42. siobhan on June 28th, 2010 1:40 am

    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

  43. siobhan on July 2nd, 2010 1:47 am

    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

  44. Eric on July 6th, 2010 2:50 pm

    @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.

  45. Burce on July 31st, 2010 12:01 pm

    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?

  46. Eric on August 2nd, 2010 10:13 am

    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.

  47. Burce on August 3rd, 2010 1:20 pm

    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,

  48. Junker on November 8th, 2010 12:31 pm

    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.

  49. Eric Leuenberger on November 12th, 2010 9:01 am

    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?)

  50. Jamie on November 10th, 2010 5:09 pm

    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?

  51. Eric Leuenberger on November 12th, 2010 8:59 am

    Make sure you have the latest version. Previous versions had a similar bug, but the newest version addresses this.

  52. Joey Anderson on December 23rd, 2010 2:30 pm

    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?

  53. Eric Leuenberger on January 8th, 2011 10:26 am

    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?

  54. Eric Leuenberger on January 17th, 2011 12:52 pm

    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.

  55. Jason on April 6th, 2011 4:34 pm

    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!

  56. Gary on April 7th, 2011 3:24 pm

    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.

  57. Eric Leuenberger on April 12th, 2011 2:23 pm

    That was an error I thought was corrected. I’ll take a look and put out an update to correct it.

  58. mike on April 12th, 2011 3:47 pm

    It would be fantastic if this module could automatically export orders to a specific folder once and order is placed.

    Mike

  59. John Shea on April 25th, 2011 12:14 pm

    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?

  60. Eric Leuenberger on April 25th, 2011 10:25 pm

    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.

  61. John Shea on April 26th, 2011 3:12 pm

    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.

  62. Eric Leuenberger on May 5th, 2011 8:15 am

    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')

  63. Larry on April 26th, 2011 3:23 pm

    I’m also interested in the functionality that John mentioned. Can you please send me the necessary code modification to accomplish this? Thanks!

  64. Katie Palmer on May 3rd, 2011 3:31 pm

    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

  65. Eric Leuenberger on May 5th, 2011 8:18 am

    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.

  66. John Shea on May 5th, 2011 8:45 am

    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.

  67. Jim on July 6th, 2011 5:33 pm

    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..

  68. Eric Leuenberger on July 7th, 2011 8:09 pm

    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.

  69. webstar59 on November 3rd, 2011 6:51 pm

    I don’t see the prducts weight is this field exported?

  70. Eric Leuenberger on November 4th, 2011 2:49 pm

    This would be a custom change. Only the actual dollar amt of the shipping along with the shipping type is exported.

  71. BT on November 4th, 2011 2:23 am

    How can i add the products weight to the csv file?

  72. Eric Leuenberger on November 4th, 2011 2:54 pm

    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.

  73. Lee Brannon on February 8th, 2012 3:23 pm

    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

  74. Eric Leuenberger on February 15th, 2012 3:51 pm

    Have you registered the pages in the admin? Version 1.5 rewuires you to register the pages within the admin first.

  75. Eric Leuenberger on February 28th, 2012 2:25 pm

    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!

  76. Tom on September 9th, 2012 2:23 pm

    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

Feel free to leave a comment...
and oh, if you want a pic to show with your comment, go get a gravatar!