Export Shipping & Order Information

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,

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?

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.

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.

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,

Anytime. Glad you got it working.

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?

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.

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

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

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?

Has anything else changed other than the version upgrade. I can take a look and see what it might be on this end. Let me know that answer and I'll see what I can do.

Non-really. Just reapplied all the modules I've used in 1.51.

Only real changes were: Easy populate 1.3.9gp + 4.0, Walk-in Pickup shipping module, and Order Total optionals insurance.
Easy Populate 1.3.9gp, and Easy Populate 4.0 stopped working in ZC 1.5.3. So I've gotten rid of EP 1.3.9gp, and updated EP 4 to the latest patch.
The built in Walk-in store pickup module was broken so you can't restrict by regions with 1.5.3, applied modification fix.
Finally, there's Order Total Insurance, was added shipping insurance even if Walk-in option was selected. Also a modification fix, by Ajeh.

Just really puzzled at why only the two fields aren't being exported, and the most important fields for accounting at that! No errors were thrown on the screen during export either. But ZC 1.5.3 seems to be quite the buggy release.

econcepts:

Has anything else changed other than the version upgrade. I can take a look and see what it might be on this end. Let me know that answer and I'll see what I can do.

chibipaw:

... Just really puzzled at why only the two fields aren't being exported ...
The Export Shipping & Orders Information module is not compatible with Zen Cart 1.5.3+. If one wishes to use this module in newer versions of Zen Cart, the module will need to be updated.

NOTE 1: In particular, this module uses direct "mysql_*" functions (mixed with $db method calls). Best practice is for Zen Cart plugins (modules) to only use $db methods for accessing the database. This provides better long term compatibility with Zen Cart (and future versions).

NOTE 2: Zen Cart 1.5.3+ no longer uses "mysql_" functions (these functions were removed from upstream versions of PHP). Instead Zen Cart now uses the newer "mysqli_" functions. This means modules using "mysql_" functions and relying on Zen Cart to open a MySQL connection for the "mysql_" functions (instead of only using $db) will fail in Zen Cart 1.5.3+.

Ummm that could be a problem. Are there any other alternative to dump details into a CSV file?
right now Im using Sales Report 2.0. It does seem to do that, but lack detailed information, like order status. payment methods etc.

lhungil:

The Export Shipping & Orders Information module is not compatible with Zen Cart 1.5.3+. If one wishes to use this module in newer versions of Zen Cart, the module will need to be updated.

NOTE 1: In particular, this module uses direct "mysql_*" functions (mixed with $db method calls). Best practice is for Zen Cart plugins (modules) to only use $db methods for accessing the database. This provides better long term compatibility with Zen Cart (and future versions).

NOTE 2: Zen Cart 1.5.3+ no longer uses "mysql_" functions (these functions were removed from upstream versions of PHP). Instead Zen Cart now uses the newer "mysqli_" functions. This means modules using "mysql_" functions and relying on Zen Cart to open a MySQL connection for the "mysql_" functions (instead of only using $db) will fail in Zen Cart 1.5.3+.

Is anyone known to be working on a fix for this? Or can anyone recommend an alternative? I've barely enough experience with Zen Cart to create a site, but boy was this every a helpful module for the last site I created on 1.5.1...

With the amount of cricket noise out there, it's pretty safe to say this is abandoned-ware.

kzabbott:

Is anyone known to be working on a fix for this? Or can anyone recommend an alternative? I've barely enough experience with Zen Cart to create a site, but boy was this every a helpful module for the last site I created on 1.5.1...

This awesome plugin has been a workhorse for me.
I have modified it heavily as I only wanted to export Customer, Order ID, Part Name & Quantity.

Recently I added the Date of purchase using "date_purchase" as shown below to my exported data (*.csv file)

+++++++++++++++++++++++
I need some help with this:
The date is the full date and time stamp: 1/14/2015 1:52:31 PM
I only want the date: 1/14/2015
+++++++++++++++
I modified ordersExport.php accordingly and In shipping_export.php I added this line around line 370 to populate the spread sheet date column:
$str_export .= $FIELDSEPARATOR . $FIELDSTART . $order_details->fields['date_purchased'] . $FIELDEND;

Here's a bigger slice of the code where I added that line.

//eof State Abbr Codes*******//
/***********************************************************************************************************************************/

if ($_POST['product_details'] == 1) { // Order details should be added to the export string.

if ($_POST['filelayout'] == 2) { // 1 PPR RADIO

$str_export .= $FIELDSEPARATOR . $FIELDSTART . $order_details->fields['products_name'] . $FIELDEND;
// $str_export .= $FIELDSEPARATOR . $FIELDSTART . $order_details->fields['final_price'] . $FIELDEND;
$str_export .= $FIELDSEPARATOR . $FIELDSTART . $order_details->fields['products_quantity'] . $FIELDEND;
// $str_export .= $FIELDSEPARATOR . $FIELDSTART . $order_details->fields['products_model'] . $FIELDEND . $FIELDSEPARATOR;
$str_export .= $FIELDSEPARATOR . $FIELDSTART . $order_details->fields['date_purchased'] . $FIELDEND;

$product_attributes_rows="SELECT Count(*) as num_rows

I'm going to work on an update for this. I've been working on a few other updates to other plugins of mine and am now just getting around to this one.

Woo hoo! Excited to see this get resurrected!

econcepts:

I'm going to work on an update for this. I've been working on a few other updates to other plugins of mine and am now just getting around to this one.

linuxguy2:

This awesome plugin has been a workhorse for me.
I have modified it heavily as I only wanted to export Customer, Order ID, Part Name & Quantity.

Recently I added the Date of purchase using "date_purchase" as shown below to my exported data (*.csv file)

+++++++++++++++++++++++
I need some help with this:
The date is the full date and time stamp: 1/14/2015 1:52:31 PM
I only want the date: 1/14/2015
+++++++++++++++
I modified ordersExport.php accordingly and In shipping_export.php I added this line around line 370 to populate the spread sheet date column:
$str_export .= $FIELDSEPARATOR . $FIELDSTART . $order_details->fields['date_purchased'] . $FIELDEND;

Here's a bigger slice of the code where I added that line.

//eof State Abbr Codes*******//
/***********************************************************************************************************************************/

if ($_POST['product_details'] == 1) { // Order details should be added to the export string.

if ($_POST['filelayout'] == 2) { // 1 PPR RADIO

$str_export .= $FIELDSEPARATOR . $FIELDSTART . $order_details->fields['products_name'] . $FIELDEND;
// $str_export .= $FIELDSEPARATOR . $FIELDSTART . $order_details->fields['final_price'] . $FIELDEND;
$str_export .= $FIELDSEPARATOR . $FIELDSTART . $order_details->fields['products_quantity'] . $FIELDEND;
// $str_export .= $FIELDSEPARATOR . $FIELDSTART . $order_details->fields['products_model'] . $FIELDEND . $FIELDSEPARATOR;
$str_export .= $FIELDSEPARATOR . $FIELDSTART . $order_details->fields['date_purchased'] . $FIELDEND;

$product_attributes_rows="SELECT Count(*) as num_rows

Still working on this and I know the solution is simple but I can't get it sorted... :blush:
Any takers?

I have another Issue: :(
Although I have this in my code around lines 675 I am not getting the date displayed on the main screen after I do an export.