Export Shipping & Order Information

[econcepts]

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.

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

[econcepts]

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/showpo...7&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.)

[lesposner]

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/showpo...0&postcount=10

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

Thanks.

[Briann]

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

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

[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

[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!!

[tat2nu]

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:

<?php echo zen_draw_checkbox_field('orders_status', '1', $order_status_checked);?>&nbsp;<?php echo TEXT_ORDER_STATUS_FIELD; ?><br />

to:

<?php echo zen_draw_checkbox_field('order_status', '1', $order_status_checked);?>&nbsp;<?php echo TEXT_ORDER_STATUS_FIELD; ?><br />

Marc

[Briann]

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);?>&nbsp;<?php echo TEXT_ORDER_STATUS_FIELD; ?><br />

to:

<?php echo zen_draw_checkbox_field('order_status', '1', $order_status_checked);?>&nbsp;<?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.

[tat2nu]

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

Thanks Eric...

Marc