Export Shipping & Order Information

[econcepts]

In the SQL Query for that you would want to add an ORDER BY clause to it then specify the Order / Product Name as the criteria. That should do it.

I would like to export my orders sorted by Order/product Name. Instead they are exported by Order/order entered in cart.
Any suggestions/code on how to do this?

Thanks,

[linuxguy2]

Thanks, for your support/reply.
Got it working!

With Ajeh's help I figured out how to sort my address books by Company and I applied that same tweak to the ESOI
shipping_export.php around line 115. Need to test a bit more but it seems to work GREAT for my purposes!

$order_info = $order_info . " ORDER BY orders_id ASC, products_name";
//echo $order_info;

I'm only exporting 4 columns that I mapped to custom headers for import into QB.
Customer,RefNum,Item,QTY
RefNum is the order ID

I'm using a app by B.. S.... TIP5 to import CSV into QB which works very well.

I do have a question. I have to use the TXT format as I have leading zeros in my Products Name (Items)
I changed the delimiter in the TXT export to a comma (otherwise my headers were not delimited correct) and the headers are OK but the data is still using the tab as the delimiter so I have to manipulate the file with Excel before importing into QB. If I change the \t to a comma strange thins happen.

I can't use the CSV export because many of my item numbers have leading zeros and they get stripped when exported.

Any thoughts?

[econcepts]

What if the items that come over as numbers (with leading zeros) are enclosed in quotes? Does that make them 'text' fields in excel when opening (if a text field is used the zeros will not be dropped by excel)? If you look at the raw CSV file my guess is the leading zeros are there but when opening in excel those rows are inserted as 'numbers' and thus the leading zero is dropped.

Other options would be to open the CSV in a program other than Excel (maybe notepad?) and / or setting the fields in excel to "text" for those items that have leading zeros.

Let me know if that helps.

[linuxguy2]

What if the items that come over as numbers (with leading zeros) are enclosed in quotes? Does that make them 'text' fields in excel when opening (if a text field is used the zeros will not be dropped by excel)? If you look at the raw CSV file my guess is the leading zeros are there but when opening in excel those rows are inserted as 'numbers' and thus the leading zero is dropped.

Other options would be to open the CSV in a program other than Excel (maybe notepad?) and / or setting the fields in excel to "text" for those items that have leading zeros.

Let me know if that helps.

Ahh... I was missing the quotes part so Yes that should solve my problem.
Currently we give the file a *.txt extension and open it with excel so we can make that a text field and that save it as a *.csv file but I was trying to skip all that and just import the file directly into QB.

Thanks You very much,

[econcepts]

Anytime. Glad you got it working.

[jrcook416]

I am having a similar problem from a few posts back (post 385)

I only want to export orders that have a certain status and the module is marking everything exported.

Would you take a look at my code just to make sure I haven't overlooked anything?

[econcepts]

I've got a fix for that here in a newer version. Send me a PM and I'll email it to you. Will be uploading the newer version here with that fix at some point.

[Axeman]

Has anyone got any suggestions to my post? I would really like to stop the keep alive timer coding from interfering with this module.

[jrcook416]

I also have an issue with one of my carts duplicating lines. Any ideas as to where to start to fix the issues?

[chibipaw]

Apparently Export Shipping & Order Information version 1.3.2.1 is not compatible with Zencart 1.5.3 .
When exporting a CSV file, Order Subtotal and Order Status fields does return with any results.

I have two separate shopping carts with two different domains behaving the same after upgrading to ZC 1.5.3. Worked fine in ZC 1.5.1

Anyone else having the same problem?