Export Shipping & Order Information

Hi,

Please see private message.

thanks!

Anybody knows how to add the Currency of all order placed. I read through the whole thread and found no one ever mentioned it. Is it not important enough if you run a store with muti-currencies? This is the only thing lacked for import to our ERP system. Anybody can do help would be much appreciated!

When I install this plugin (v1.3.2.1) on Zen Cart v1.5.1 (using the for_v1.5.0 directory's files from the plugin) and the currently signed-in admin is not a superuser (but has been given authority to use this tool), they are receiving the message "Sorry, your security clearance does not allow you to access..". To correct this problem, you'll need to edit the file /admin/includes/extra_datafiles/shipping_export.php as described below to remove the .php from the filename definition:

<?php
//
// +----------------------------------------------------------------------+
// |zen-cart Open Source E-commerce                                       |
// +----------------------------------------------------------------------+
// | Copyright (c) 2003 The zen-cart developers                           |
// |                                                                      |
// | http://www.zen-cart.com/index.php                                    |
// |                                                                      |
// | Portions Copyright (c) 2003 osCommerce                               |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.0 of the GPL license,       |
// | that is bundled with this package in the file LICENSE, and is        |
// | available through the world-wide-web at the following url:           |
// | http://www.zen-cart.com/license/2_0.txt.                             |
// | If you did not receive a copy of the zen-cart license and are unable |
// | to obtain it through the world-wide-web, please send a note to       |
// | [email protected] so we can mail you a copy immediately.          |
// +----------------------------------------------------------------------+
//  $Id: shipping_export.php  2007-06-01  econcepts $
//
//define('FILENAME_SHIPPING_EXPORT', 'shipping_export.php');
define('FILENAME_SHIPPING_EXPORT', 'shipping_export');
define('BOX_TOOLS_SHIPPING_EXPORT', 'Export Shipping/Order Information');

?>

If you've installed the plugin on v1.5.0 or v1.5.1, you'll need to edit the file /YOUR_ADMIN/includes/extra_datafiles/shipping_export.php

econcepts:

You would need to open up the "shipping_export.php" file (in the admin directory) and then my recommendation would be to copy the lines for the "shipping information" and alter to include the billing info for the customer. You will need to alter this in multiple areas of the script and may also need to alter some SQL queries for it to work.

If you need help adding this let me know (just send me a private message). I've customized this for many others.

We are in need of the customer's billing address in export as well, could you help please? Did send a private message but never heard back from you.

I've have tried to install this module, all files are installed, ren sql. it tells me 1 item processed,however cant find the export under tools. what im doing wrong?

yoyospike:

I've have tried to install this module, all files are installed, ren sql. it tells me 1 item processed,however cant find the export under tools. what im doing wrong?
See post#363.

i have edited the file below and still no option under tools. using v1.51. any advise?

<?php // // +----------------------------------------------------------------------+ // |zen-cart Open Source E-commerce | // +----------------------------------------------------------------------+ // | Copyright (c) 2003 The zen-cart developers | // | | // | <http://www.zen-cart.com/index.php> | // | | // | Portions Copyright (c) 2003 osCommerce | // +----------------------------------------------------------------------+ // | This source file is subject to version 2.0 of the GPL license, | // | that is bundled with this package in the file LICENSE, and is | // | available through the world-wide-web at the following url: | // | <http://www.zen-cart.com/license/2_0.txt>. | // | If you did not receive a copy of the zen-cart license and are unable | // | to obtain it through the world-wide-web, please send a note to | // | [email protected] so we can mail you a copy immediately. | // +----------------------------------------------------------------------+ // $Id: shipping_export.php 2007-06-01 econcepts $ define('FILENAME_SHIPPING_EXPORT', 'shipping_export.php'); define('BOX_TOOLS_SHIPPING_EXPORT', 'Export Shipping/Order Information'); ?>

Hi, great mod!

I am in the process of customizing so that default values are selected. However, my php ability is exceeded when it comes to the drop down tables for ORDER STATUS.

Can anyone help me modify the code below so that I can define which order status to use as default rather than the drop down menu.

Thanks in advance

<hr />
<table border="0" cellspacing="0" cellpadding="2">
<tr>
<td><strong>Update Order Status on Export</strong><br/>(If this is set then the order status will update to what you select here after a successful export.)</td>
</tr>
<tr>
<td>
<?php echo zen_draw_checkbox_field('status_setting', '1', order_status_setting_checked);?>Set Order Status After Export to 
<!--</td> </tr> <tr> <td>--><?php echo zen_draw_pull_down_menu('order_status_setting', $status_array, $_POST['order_status_setting'], 'id="order_status_setting"'); ?></td>

      </tr>
    </table>

<hr /> <table border="0" cellspacing="0" cellpadding="2"> <tr> <td><strong>Order Status Export Options</strong></td> </tr> <tr> <td>

          <input type="radio" name="status_target" value="2" checked="yes">Assigned Order Status (select below)
        </td>
      </tr>
      <tr>
        <td><?php echo zen_draw_pull_down_menu('order_status', $status_array, $_POST['order_status'], 'id="order_status"'); ?></td>
      </tr>
    </table>

I have tried to look and see if this issue has already been addressed but have not seen it so I will post a question. I have installed this and it has been working fine. But now I have 100 orders and when I run my report, and include all orders even if they have already been downloaded, it only shows 98 orders. Do you know why it would not include my two latest orders in the report? I need help ASAP.

elsiesfinds.com

I am running Zen 1.5.1 with the Edit Orders and Add Orders plugin so I can add wholesale orders as they come in. Orders are successfully being added from the Admin UI.

I am also running the "Export Shipping+Order Information" plugin to use for sending shipping files to a fulfillment warehouse. When I go into this tool I can see all of the orders I have added from the Admin and that have been added from the customer side.

When I try and export the orders to a CSV I am not getting the orders that I manually added from the Admin. I do get the customer side orders though.

Any thoughts?

I believe "Export Shipping+Order Information" will not export an order unless the order has an order_total line for ot_shipping. Make sure you are adding shipping information to the order or modify "Export Shipping+Order Information" to include orders without an order_total line for ot_shipping.

This requirement for orders has been previously mentioned in this support thread.... See #7.

lhungil:

I believe "Export Shipping+Order Information" will not export an order unless the order has an order_total line for ot_shipping. Make sure you are adding shipping information to the order or modify "Export Shipping+Order Information" to include orders without an order_total line for ot_shipping.

This requirement for orders has been previously mentioned in this support thread.... See #7.

This is correct. When I started the module originally it was keying off of the shipping information (so if shipping information was not present the order would not show in the export.) I'm sure it can be altered to work around that if needed. I've been working on updating a number of my modules here recently but haven't looked into this one yet.

Are you entering a shipping total when editing / adding the order?

Eric

I'm interested in adding the Product Category to the product details being exported. I've tried searching first to see if anyone else has done this already, but found nothing thus far. How much trouble would it be to do this?

Hi there, brill module and well done, this is great for exporting the data.

Can I ask how and where I could change the order the CSV fields are exported ?

I have recently changed couriers and would like to streamline the upload to there site and would like to change the export of fields in order as follows;

A Address line 1 (mandatory)
B Address line 2
C Address line 3
D Address line 4
E Postcode (mandatory)
F First name
G Surname (mandatory)
H [Blank]
I [Blank]
J Phone
K Email
L Weight (in kg)
M [Blank]
N [Blank]
O Reference/Order No
P [Blank]
Q [Blank]

Thank you in advance :)

Chris

Thanks for a great mod!

I did change the admin->shipping_export.php file in 2 ways:

• deleted the lines "AND ot.class = 'ot_shipping'" so I could export all orders

I also want to export all orders and tried deleting those lines/parts above and can't get it right. How exactly should the three instances be changed?

line 102 $order_info = $order_info . "AND ot.class = 'ot_shipping'";
line 134 AND ot.class = 'ot_shipping' ";
line 162 AND ot.class = 'ot_shipping'";

And what's the simplest way to block fields from appearing in the spreadsheet, like "delivery_suburb."?

Did you manage to get this working in the end? I have just had this crop up for the first time after adding some virtual products and I can't get the report to show the orders with free shipping either. Deleting those three lines doesn't seem to help; it still works but the same orders are missing from the output.

It's a shame because the solution in post #7 sounds so perfect and this is a magnificent mod in all other respects!

Still not...and after I played around with a dozen variations to delete those lines/codes in question.

To be clear, I'm getting all order info except for the customer name and address.

Finally...

102= $order_info = $order_info . "AND ot.class = 'ot_shipping'";

change to

    $order_info = $order_info;   

Or block out the part after the above with //

134= delete or block, but add "; to the end of the previous line, 133. They should look like:

$order_info = $order_info . " WHERE o.orders_id = ot.orders_id ";
// AND ot.class = 'ot_shipping' ";

162= same as 134, should look like:

WHERE o.orders_id = ot.orders_id ";
// AND ot.class = 'ot_shipping'";

Then change all "delivery_" to "billing_".

What I'd like to do now is have each product attribute in its own spreadsheet column instead of all of them into one (many of my items have 2+ attributes). Is that possible?

giftmeister:

What I'd like to do now is have each product attribute in its own spreadsheet column instead of all of them into one (many of my items have 2+ attributes). Is that possible?

This is possible with the default module (no special programming updates needed.) You'll find a sample of this in action in the 'sample_exports' directory (third file in list.)

Let me know if this helps or if you need more information.