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.

deleted

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

i get it done :smile:

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

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

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" ?

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.).

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!

quick1:

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.

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.).

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.

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!

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:

Please help!

Any answer on this? Please...

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!

I thought that was corrected, but I'll look to make sure it is in this new version.

Doodlebuckets:

Any answer on this? Please...

Here are some links that might help you resolve this. My question would be

1. Have they upgraded to a different version of MySQL, and if so what version?

2. Did they install any other mods that affect any of the tables this mod pulls from? It could be that one of them changed the table collation?

Here are the links to look at:

http://bugs.mysql.com/bug.php?id=20123

http://www.vbulletin.com/forum/showthread.php?195137-The-right-way-to-fix-the-Illegal-mix-of-collations-problem

http://www.google.com/search?hl=en&safe=off&rlz=1G1GGLQ_ENUS271&q=1267+Illegal+mix+of+collations+%28latin1_general_ci%2CIMPLICIT%29+and+%28latin1_swedish_ci%2CIMPLICIT%29+for+operation&aq=f&oq=&aqi=

Let me know answers to the above to see if we can narrow down what caused it.

I assume that it wasn't corrected jet, because (at least in the downloads section) there's not a version dated later than my post.

Just a note :cool:

This is not meant unfriendly, but just want to help. :D
Really, this mod is great!

Ok no problem! I'll put that in this next release (working on it now).

I was working on it anyhow as I just customized it for one of my members at my site to work better with PayPal.

I'm hoping to have this new version up in these forums here within the week.

I've got 3 items (which include 2 bug fixes) that will be included in the new release.

Later versions are slated to revamp a few portions and provide more export file options (XML, etc...)

But that is later.

Eric

I have downloaded the Mod, Suits one of my needs perfectly, However when I ran it the Delivery Company Name column was empty. This is a slight problem as this is required as we deliver to some Blue Chip corps.

Any help would be appreciated??

http://www.zen-cart.com/forum/showpost.php?p=765690&postcount=99

This may be what you're looking for. The bug isn't fixed yet in the release (Eric is working on it).

Yes, I have been working on the next release and that has this bug fix in it. Will shoot for having it available at weeks end here.

Will post to the board when ready.

econcepts:

Here are some links that might help you resolve this. My question would be

1. Have they upgraded to a different version of MySQL, and if so what version?

2. Did they install any other mods that affect any of the tables this mod pulls from? It could be that one of them changed the table collation?

Here are the links to look at:

http://bugs.mysql.com/bug.php?id=20123

http://www.vbulletin.com/forum/showthread.php?195137-The-right-way-to-fix-the-Illegal-mix-of-collations-problem

http://www.google.com/search?hl=en&safe=off&rlz=1G1GGLQ_ENUS271&q=1267+Illegal+mix+of+collations+(latin1_general_ci%2CIMPLICIT)+and+(latin1_swedish_ci%2CIMPLICIT)+for+operation&aq=f&oq=&aqi=

Let me know answers to the above to see if we can narrow down what caused it.

Sorry, I never got an email saying you had replied to this. No mods were added, I am the only one working on the site. I'll look at the links. It had worked for months and then all of the sudden not.

Doodlebuckets:

Sorry, I never got an email saying you had replied to this. No mods were added, I am the only one working on the site. I'll look at the links. It had worked for months and then all of the sudden not.

No problem. Yes, under the circumstances I listed in my response (if that is indeed the case) then it would work for months (or years) up until MySQL was altered (by possible upgrade, host changes, other means sometimes outside your control.)

Take a look at those links and let me know if they help. It seems as though the answer is in the collation of the tables.