Export Shipping & Order Information

[econcepts]

Ok, got your PM and am looking into this (in your admin now).

From initial glance, it looks like order #245 could be the culprit as it is missing all the shipping information.

I will run a few more tests here and report back.

Hang in there!

Ok, it is not order 245. I ran a test export on just 10/8 orders and nothing came out. I'll keep looking here.

[dhcernese]

deleted

[quick1]

hello eric,
i use this module to export the orders, i have one question,
for payment method, is it possible to export the payment module name replacing by payment title?

i have these files in my payment modules folders: paypal.php, moneyorder.php, wire.php,
i want to export "paypal", "moneyorder", "wire" as payment method text,
but now it exports the payment title: "PayPal", "Money Order or Check", "Wire Transfer".

any sugestion? thanks

[quick1]

i get it done

but another issue, i use quantity discount module, when i export orders, the tax doesn't calculate correctly cause it ignores quantity discount value. then the tax exported is not same as the tax in admin invoice.

what do i make the tax exported just be same as it shows in admin invoice?

[quick1]

i use quantity discount module, when i export orders, the tax doesn't calculate correctly cause it ignores quantity discount value. then the tax exported is not same as the tax in admin invoice.

what do i make the tax exported just be same as it shows in admin invoice?

i had a look at the mysql database,
the "order_tax" in table orders can't be used as the final tax value due to the quantity discounts module, the class: ot_tax in table orders_total is the correct tax value.

what do i change that "order_tax" to "ot_tax" ?

[dhcernese]

New bug: if a product's attributes have a newline in them, the export file also has a line break in it, making the import break. This can occur if there is a text entry field for a product attribute (such as a gift card memo, etc.).

[Doodlebuckets]

Hello! I installed this for a customer's website and she's been using it and doing fine until recently when we now get this in the file that is produced when we do an export:

<div class="systemError">1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='<br />in:<br />[SELECT o.orders_id, customers_email_address, delivery_name, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, shipping_method, customers_telephone, order_total, date_purchased, ot.value, comments, order_tax, o.orders_status, o.payment_method, cc.countries_iso_code_2, cc.countries_iso_code_3
FROM orders o, orders_status_history os, orders_total ot, countries cc
WHERE o.orders_id = ot.orders_id
AND ot.class = 'ot_shipping'
AND cc.countries_name = o.delivery_country
AND o.orders_id = os.orders_id AND downloaded_ship='no' GROUP BY orders_id ASC]<br />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.<br /></div>

Please help!

[econcepts]

i had a look at the mysql database,
the "order_tax" in table orders can't be used as the final tax value due to the quantity discounts module, the class: ot_tax in table orders_total is the correct tax value.

what do i change that "order_tax" to "ot_tax" ?

You can alter where the data comes from but make sure you have a backup of the original file (in case you need to revert.)

You'll likely need to pull the ot_tax field from the orders table (I the system is already pulling from this table so it should be pretty easy.)

I will put this on the list for the next release here.

[econcepts]

New bug: if a product's attributes have a newline in them, the export file also has a line break in it, making the import break. This can occur if there is a text entry field for a product attribute (such as a gift card memo, etc.).

Good catch. First report of this. I will need to add a filter for handling that as is the case with the comments field (which was doing the same thing with line breaks in original versions.)

This along with the tax suggestion will be added to the next version (I should be able to get that together pretty fast here.)

Will post here when the new version is ready.

[Briann]

Argh... those stupid e-mail notifications don't work for some reason.. Anyway, is the company bug also fixed in the new version? (the bug I noticed a few pages ago)

Still thanks for the very nice mod!