Export Shipping & Order Information

[DML73]

If I check the checkbox "Save file to server and automatically email to supplier", where is the file saved on my server?? in what folder?

Ok, I just found this info in the shipping_export.php file, so I can answer my own question: by default they are saved to images/uploads/

[econcepts]

Glad you got it all worked out!

[trickobrien]

Hi
I would like to add a function to the export shipping orders-the discount code used for orders,the discount itself is already there but what would be involved in adding the actual discount code that the customer used also?

[econcepts]

To add that you would need to alter the SQL queries. You'll need to add the coupon table to the mix and then link that up on something like the 'coupon_redeem_tracking' table which would then be linked to the order table.

The order table is the only one in the mix now (the discount total is simply pulled from there as a number.)

So you would need to go through the code and add the proper sql language to tie those two new tables in with the current (tie the coupon table to the coupon_redeem_tracking table by coupon id and then tie the 'redeem' table to the orders on order id.

It could likely take some time to implement but that is generally how it would be done.

[tonsai]

Just installed the module and getting this error message when I try to run the export:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND cc.countries_name = o.delivery_country WHERE o.orders_id = ot.orders_id AND' at line 1
in:
[SELECT o.orders_id, customers_email_address, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, shipping_method, customers_telephone, order_total, op.products_model, products_name, op.products_price, final_price, op.products_quantity, date_purchased, ot.value, orders_products_id, order_tax, o.orders_status, o.payment_method, cc.countries_iso_code_2, cc.countries_iso_code_3 FROM (orders o LEFT JOIN orders_products op ON o.orders_id = op.orders_id), orders_total ot, countries cc AND cc.countries_name = o.delivery_country WHERE o.orders_id = ot.orders_id AND ot.class = 'ot_shipping' AND o.orders_status = '1' ORDER BY orders_id ASC]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any ideas why

[econcepts]

Yes, this is occurring b/c there are two lines that need to be switched in the shipping_export.php file (in the admin).

This is corrected in the next release (soon to be out.)

In the meantime, here is how you fix it:

1) Open the file admin/shipping_export.php

2) Find the section that looks like this (around line 95 / 96 or so):

	if ($_POST['iso_country2_code'] == 1 || $_POST['iso_country3_code'] == 1) { $order_info = $order_info . " AND cc.countries_name = o.delivery_country "; };

	$order_info = $order_info . " WHERE o.orders_id = ot.orders_id ";

3) REPLACE those lines with this:

	$order_info = $order_info . " WHERE o.orders_id = ot.orders_id ";
	if ($_POST['iso_country2_code'] == 1 || $_POST['iso_country3_code'] == 1) { $order_info = $order_info . " AND cc.countries_name = o.delivery_country "; };

[jamie]

The module is installed and all looks correct, however when I export the file, it's completely blank except for the header row.
Can anyone direct me on how to fix this?
Thanks in advance

[econcepts]

The module is installed and all looks correct, however when I export the file, it's completely blank except for the header row.
Can anyone direct me on how to fix this?
Thanks in advance

What version are you using?

What happens if you run it in "test mode" and select "previously downloaded orders"?

There was an issue in older versions that caused what you are saying, but that has been corrected in the most recent version.

[jamie]

Thanks! Just downloaded the newest version and it works perfectly!
Thank you.

[tonsai]

Anybody got any ideas on how I can automate the export of these files. Somehow at the end of each 'order completion'.