Yes, this is the support forum for the "Export Shipping Information" module.Quote:
Originally Posted by tsrplatelayer
Printable View
Yes, this is the support forum for the "Export Shipping Information" module.Quote:
Originally Posted by tsrplatelayer
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?
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.Quote:
Originally Posted by quick1
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.Quote:
Originally Posted by quick1
You would need to alter a number of sections of code to do this (just making that box a checkbox won't work.)Quote:
Originally Posted by quick1
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?
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.Quote:
Originally Posted by waterbender
Send me a PM if you need assistance on 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.Quote:
Originally Posted by worldmaker