Export Shipping & Order Information

tsrplatelayer:

:blush:I dont have Tools > Export Shipping and Order Info
I have Tools > Orders Export - click this and I go to Mat's Orders Exporter page. (which does export order details)

When I installed I renamed the 'Admin' install folder to match my the name of my admin folder.

Ah - ha - there are 2 different add ons for exporting orders
Orders Exporter 1.0 and Export Shipping Information 1.3.2

I'lll try installing the 'other' one -:oops:

Yes, this is the support forum for the "Export Shipping Information" module.

hello, i need to export the orders of several order status,
what do i change <?php echo zen_draw_pull_down_menu('order_status', $status_array, $_POST['order_status'], 'id="order_status"'); ?> to checkbox?

can i export the file with format type SQL?

with this mod, i can export the delivery country iso code correctly, what do i export both delivery country iso code and billing country iso code?

quick1:

with this mod, i can export the delivery country iso code correctly, what do i export both delivery country iso code and billing country iso code?

What version are you running? Older versions had a bug when those options were selected together. I believe this was corrected in the most recent version.

quick1:

can i export the file with format type SQL?
No. The options available at this time are CSV and TXT. It's mainly meant for order / shipping fulfillment and not database building etc... If you want to get data out in SQL format you could setup a query that runs directly through something like PHPMyAdmin etc... (or cron) that would enable you to export what you need in SQL format. There are also come backup programs available in the zen cart downloads section which could help with this regard.

quick1:

hello, i need to export the orders of several order status,
what do i change <?php echo zen_draw_pull_down_menu('order_status', $status_array, $_POST['order_status'], 'id="order_status"'); ?> to checkbox?

You would need to alter a number of sections of code to do this (just making that box a checkbox won't work.)

That is the box you need to alter, but you'll also need to change the SQL statement to accommodate multiple options in that field (likely from an array or something.)

It would then need to be tested to see if it works.

To get around this you could run multiple exports.

The first for one order status, the second for the second order status, third for the third order status, etc...

Or you could export all order statuses then open your file in a program like Excel and edit it there (removing the orders statuses you do not need.)

hello, i send you a message, please check, thanks

I'm just testing the export function with five orders on the test cart.

Two orders have customer comments (from me :smile: ) attached and those are the ones not being exported into the CSV.

Is this a known problem or have I missed something?

I've searched the thread and there's nothing I can find about this.

Hi,

Is it possible to automatically export new orders every few hours?

waterbender:

Hi,

Is it possible to automatically export new orders every few hours?

Yes. You would have to setup a new script that is similar to the current, take into account the sessions etc... and then setup a CRON job to run it. I've helped a few others do this as custom jobs but none used the standard conventions (all had custom fields etc...) so there is no version outside of those, but it does work quite well.

Send me a PM if you need assistance on this.

worldmaker:

I'm just testing the export function with five orders on the test cart.

Two orders have customer comments (from me :smile: ) attached and those are the ones not being exported into the CSV.

Is this a known problem or have I missed something?

I've searched the thread and there's nothing I can find about this.

They should still export, but let me know this (just out of curiosity sake). Do any of those orders which don't export have apostrophes, commas, etc... in them (in the comments section)? I thought I had a syntax cleaner built in for that but wanted to find out.

Can we also import shipping addresses for the system with this one? If not, any idea how to import in bulk many shipping addresses that are same among the customers? (There is a customer, a big company, who wants the different order makers at their company to have their own accounts for the shop but all of them need the same additional shipping addresses to be available)
Would it be relatively easy directly via db sql?

This module is only for exporting information from the cart. If you want to import information you could use phpMyAdmin (which might be best in your case) or use a tool like EZPopulate (which might be overkill for what you need.)

Hey! This looks like a great addon! I see in the file admin\shipping_export.php that you have the following text:
//$available_export_formats[3]=array('id' => '3', 'text' => 'XML');

Does this mean that you will make an option to export to XML? This is exactly what i'm looking for! :)

panservolvo:

Hey! This looks like a great addon! I see in the file admin\shipping_export.php that you have the following text:
//$available_export_formats[3]=array('id' => '3', 'text' => 'XML');

Does this mean that you will make an option to export to XML? This is exactly what i'm looking for! :)

In the future, I did account for the ability to add XML exports as an option. Just haven't added it to this point as there are numerous ways to build an XML file and with the little demand never got to it.

Yes, though, the opportunity is there for me to add it if needed.

Does this contribution work with 1.5.0 RC1?

It should work with that as well.

Let me know if you have any issues however and I can look into them.

econcepts:

Quantity is already included in the mod. Just select "product details" as an export option. I can easily add weight to the next version as an option. I have that in a customized version used for real time printing of packing slips on another computer so I can add that to this one.

Anybody know how to add the products weight field to the export???

very good addon. 2 questions:

1. how i can add "Shipped" into drop down menu that has Pending, Processing, Delivered.
2. When i try to use "Delivered", file comes empty, even i have lots of delivered orders in database. How to fix this? thanks.

A big thank you for this contribution by the way.

I have a customer who isnt comfortable working in his Zen Cart admin,this contribution allows him to login,export and log out in under a minute.Couldnt be easier :)

simpledomaining:

very good addon. 2 questions:

1. how i can add "Shipped" into drop down menu that has Pending, Processing, Delivered.

This should be added automatically as long as you have the 'shipped' option added in your actual zen cart status section (in the admin.) This module just pulls that data and populates the drop down with it. So if it is missing in your status section of the cart, it won't show here either.

simpledomaining:

2. When i try to use "Delivered", file comes empty, even i have lots of delivered orders in database. How to fix this? thanks.

If you already ran an export then you'll need to select more options in addition to the "delivered" option. Specifically you'll need to select "include orders already exported" as well. This will enable the module to pull orders that have already been exported at a previous date (and thus marked in the database as to the fact.)