Export Shipping & Order Information

[econcepts]

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 -

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

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

[quick1]

can i export the file with format type SQL?

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

[econcepts]

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.

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.

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

[inception]

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

[worldmaker]

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

Two orders have customer comments (from me ) 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.

[waterbender]

Hi,

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

[econcepts]

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.

[econcepts]

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

Two orders have customer comments (from me ) 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.