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? :blink:

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/

Glad you got it all worked out!

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?

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.

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

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 "; };

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

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

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.

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

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

You would have to develop a CRON job and alter the script a bit to get that to work.

Hi Eric,

Is 1.3.3 available yet? I don't see it on the download page.

Thanks.

Hi Eric,

One other question. Thanks for your post a few months ago that contained examples for changing the php code so that it remembers default settings.

I think you may have a mistake. You put:

<input type="radio" name="status_target" value="1">Any Order Status<br /> 

But judging by the code you already have in there, I think you meant

<input type="radio" name="status_target" value="1" checked>

Also I wonder if you could give us an example for a radio button being drawn by zen_draw, such as

<?php echo zen_draw_radio_field('filelayout', '1')?> <?php echo TEXT_FILE_LAYOUT_OPR_FIELD; ?>

Thanks.

susb8383:

Hi Eric,

Is 1.3.3 available yet? I don't see it on the download page.

Thanks.

Not yet. It looks to be mainly a bug fix at the moment and the goal is to get it out here within the next several weeks at the latest.

I was looking to see what added functionality might be worth including as well, but again, looks to be mainly a bug fix at the moment.

Will post here when it is ready.

susb8383:

One other question. Thanks for your post a few months ago that contained examples for changing the php code so that it remembers default settings.

I think you may have a mistake. You put:

<input type="radio" name="status_target" value="1">Any Order Status<br />

> 
> But judging by the code you already have in there, I think you meant
> ```
<input type="radio" name="status_target" value="1" checked>

Yes, you are correct here. IF the field is defined as you listed then to make it checked, you must add the 'checked' indicator to the tag. Thanks for that. Read on below to see how to do it when zen is drawing the checkbox or radio button.

susb8383:

Also I wonder if you could give us an example for a radio button being drawn by zen_draw, such as

To default check a radio button that zen draws do this:

To do the same thing with a checkbox drawn by zen do this:

econcepts:

To default check a radio button that zen draws do this:

That worked great, thanks.

For some reason when I export, only 20 orders are exported, no matter if ran per order/per product and including already downloaded orders.

The latest version crashes when Product Details is selected. The new version has bug fix for states which drop orders, but trying to fix this bug in the older version and download the browsers in a state of constant loading.

Any ideas?

Thanks guys

So what version are you using now?

Does anything show up in your error log? (admin cache)

What's the url to the site?

Hi,

We are running our report and beyond the testing data (live customer info), the reports are NOT including name (first or last) and address.

Any ideas why it would have been doing it, now it is not?

v1.3.9h

Thanks

I am using this on 1.3.8a installation, and it works great. I was wondering if you could implement, or tell me how to be able to export only a certain group of orders, based on group pricing. I am no programmer, and maybe there is a simple way to do this. It would be a huge help. Thank you.