Export Shipping & Order Information

AATECH:

Just Tried a different test. When you replace "delivery_suburb" with "delivery_company" in all 7 lines (34,53,152,232,441,452,461) The company name shows up in the "Delivery Suburb" section of the excel output.

So there are 4 instances of "delivery_company" and 7 instances of "delivery_suburb". Is there a reason for this?

"delivery_suburb" is a portion of the shipping address.
"delivery_company" is the actual company name as entered by the customer.

I am working on a number of updates based on some feedback and additions that might be helpful which might alleviate these issues.

i am on zen 1.3.8a php 4.4.9 and installed the latest version of the exporter. have installed the files to the admin directory, ran the sql command but do not have a any button under tools. I have seen other posts but did not see a final resolution. any ideas what could be wrong.

crafterscafe:

i am on zen 1.3.8a php 4.4.9 and installed the latest version of the exporter. have installed the files to the admin directory, ran the sql command but do not have a any button under tools. I have seen other posts but did not see a final resolution. any ideas what could be wrong.

Here is one answer that seems to work:

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

I am looking into trying to confirm this as others have tried it and ended up missing some order info (but there have been so many that have tried this and they all tried it in different areas.)

I've talked with nrg77 (the one who posted this possible fix) and they say it seems to be working fine for them.

I will be releasing a fix and a few updates to this mod soon with any luck.

If this is the answer it will be included (but you can implement it right now using the instructions at the above link.)

Hi.

Apologies in advance if I am posting this in the wrong place.

I am looking for clarification on the changes made to admin/includes/functions/html_output.php to rectify the catchable fatal error issue and the version of this file released regarding the recent security vulnerability as per post http://www.zen-cart.com/forum/showthread.php?t=130161

The version of admin/includes/functions/html_output.php ($Id: html_output.php 13598 2009-06-19 14:20:12Z wilt $) released in the security zip fix is, other than the security fix changes, identical to the file ($Id: html_output.php 3089 2006-03-01 18:32:25Z ajeh $) in the version 1.3.7 & 1.3.8a releases, hence minus the changes made to this file regarding the catchable fatal error as per the post http://www.zen-cart.com/forum/showpost.php?p=487360&postcount=10

Are the changes made to this file regarding the catchable fatal error no longer required or is this an oversight?

Thanks.

First of all... This is a REALLY useful mod! Thanks for that :D

But... I can't get it to work. First I had the famous problem with no export button visible. Fixed that with the solution from this tread (orders -> order). On my live site I've another problem, I click export, but get a message like:

Can't download shipping_export.php from (site URL)
Internet Explorer can't download this website. The requested page isn't available or can't be found. Please try again later.

So, is this a common problem, and does someone know the solution?

BTW, on my test hosting (VERY low budget) is it working. It can't have something to do with a renamed admin folder, right?

Zen Cart 1.3.8
PHP 5

Solved it by some searching on google. It seems to be a common problem with IE and an SSL connection. (tried FF at home, and it's fine)

See over here: http://support.microsoft.com/kb/316431

Excuse me, but I have another question...

Is it possible to have the iso country codes instead of the name of the country? I looked into the database, but it seems that the country code isn't stored per order... We need those for our shipper.

Maybe you know some php code that can replace several country names to an iso code? It's only for 3 countries, so there's no need for a complicated system, I think.

If someone could manage that (I can't code PHP yet), I would be very grateful for that!!:clap:

nrg77:

In shipping_export.php of the root admin folder, on line 543 change the word "orders" to order". You will see your export button after that...

I just downlaoded this for my test site and had to make this change again to get the contribution working. Somebody with some clout around here should make the change to the original file in the add-ons section to help others avoid hunting down this piece of information every time.

Also I find that the change shows up on line 550 and not 543 in notepad. In fact the line to change is:

to:

Marc

tat2nu:

I just downlaoded this for my test site and had to make this change again to get the contribution working. Somebody with some clout around here should make the change to the original file in the add-ons section to help others avoid hunting down this piece of information every time.

Also I find that the change shows up on line 550 and not 543 in notepad. In fact the line to change is:

<?php echo zen_draw_checkbox_field('**orders**_status', '1', $order_status_checked);?> <?php echo TEXT_ORDER_STATUS_FIELD; ?><br />

to:

<?php echo zen_draw_checkbox_field('**order**_status', '1', $order_status_checked);?> <?php echo TEXT_ORDER_STATUS_FIELD; ?><br />

Marc

Eric (econcepts) is working on a new release, so probably this fix will be included. See a few posts above.

I guess that I missed that one. Just trying to be helpful and save some people a little unneeded aggravation.

Thanks Eric...

Marc

Briann:

Solved it by some searching on google. It seems to be a common problem with IE and an SSL connection. (tried FF at home, and it's fine)

See over here: http://support.microsoft.com/kb/316431

Hello Briann

What do you mean with: tried ff at home, and it's fine ?

Thanks

Briann:

Excuse me, but I have another question...

Is it possible to have the iso country codes instead of the name of the country? I looked into the database, but it seems that the country code isn't stored per order... We need those for our shipper.

Maybe you know some php code that can replace several country names to an iso code? It's only for 3 countries, so there's no need for a complicated system, I think.

If someone could manage that (I can't code PHP yet), I would be very grateful for that!!:clap:

Brian,

You could pull the country codes from the table in the database but a change to the current query would need to be made to allow for that. The reason the current country name was used is for shipping purposes.

In my next release I'll also look at including the country code as an option as well.

Just uploaded a new version of the contribution to the zen cart downloads section. This is version 1.2.4 and includes a bug fix as well as a small new addition (per request).

Version 1.2.4 Features:

Bugfix:
Corrected issue with the Order Export button not showing up on some users machines.

New Option:

Added option to export ISO country codes. Both 2 character and 3 character codes were added.

IMPORTANT NOTE:
This version addresses the bug problem some users experienced with the order export button not showing up.

A post was put into this thread a few back that suggested users alter the code around line 550 or so of the "shipping_export.php" file in order to get the button to show.

There is a native problem with doing this that will NEGATIVELY affect the export file itself if you choose "order status" as part of the export file.

By making that change one would likely cause a conflict with another variable in the program of the same name and in doing so, wipe out the ability to actually be able to export the order status as a separate field in your final file.

This new release 1.2.4 corrects that issue using another method.

It is advised that you upgrade to the newest 1.2.4 to make sure the program works as intended.

Enjoy!

Am I getting there too fast or is it not up in the Add-ons yet?

Marc

tat2nu:

Am I getting there too fast or is it not up in the Add-ons yet?

Marc

It takes the zen cart team a little time to get it up so it may not be up yet.

If you want it now and don't want to wait, you can get it from here:

http://www.zencartoptimization.com/downloads/

Thank you so much!!!!:clap:

I just saw you post... (I don't know why I didn't recieve a notification, because I'm subscribed to this thread.) Anyway, thanks for the great work, and very very quick support!:D

karimm:

Hello Briann

What do you mean with: tried ff at home, and it's fine ?

Thanks

FF is the short word for FireFox. It's definitely an IE bug..:no:

I feel quite ashamed now, but I have another question...
Is it easy to built an option in it to disable state being exported?
Same for country (otherwise you have 2 times the country defined, if you use the ISO codes).

If it's much work, you don't have time, or anything, I will just delete those functions.

Thanks in advance!!!:clap:

After some trial and error I managed to the above done.

But, when I was processing some orders, I found out that the company wasn't exported. :blink:

So, I looked at the code, and at some places delivery_company wasn't grabbed from the database.

I've added some entries, and now should it be fine.
Maybe handy to check and then include in some new version?

In the attachment is what shipping_export.php should look like in my opinion. (this is without my personal changes)

Briann:

After some trial and error I managed to the above done.

But, when I was processing some orders, I found out that the company wasn't exported. :blink:

So, I looked at the code, and at some places delivery_company wasn't grabbed from the database.

I've added some entries, and now should it be fine.
Maybe handy to check and then include in some new version?

In the attachment is what shipping_export.php should look like in my opinion. (this is without my personal changes)

I'll take look at this Brian. I have never had anyone mention the company not being exported. Did this happen after you made some alterations or was this something you noticed before you made alterations?

I certainly can look at the code and if there is reason to include a patch for the company in a new version I will.

Let me know the answer to that portion about what circumstances you noticed the company not being exported so I can look into it.

Thanks!