Export Shipping & Order Information

I'm using the "Export Shipping & Order Information" add-in
version 1.2.1, our finance and shipping people appreciate it!

Feature requests:

- optionally split first & last name (columns)
- reset the 'export' flag! based on date (and/or order number)

Bug fix requests:

- if using all fields including 'export full product' info, the columns prior (such as comments and notes) must all be correctly quoted otherwise spurious commas and such in strings will not clearly indicate columns correct (and not import into excel easily).

- if you can only select one of something, use radio buttons instead of checkboxes

Quote:

---

Originally Posted by dhcernese

I'm using the "Export Shipping & Order Information" add-in
version 1.2.1, our finance and shipping people appreciate it!

Feature requests:

- optionally split first & last name (columns)
- reset the 'export' flag! based on date (and/or order number)

---

I am working on the next release which already has a "date" feature in it so that may cover what you are looking for here. I'll look into the first and last name issue, but that seems like it would be something that could easily be combined on the side after export? In any event, I can look into it for the next release.

Quote:

---

Originally Posted by dhcernese

Bug fix requests:

- if using all fields including 'export full product' info, the columns prior (such as comments and notes) must all be correctly quoted otherwise spurious commas and such in strings will not clearly indicate columns correct (and not import into excel easily).

- if you can only select one of something, use radio buttons instead of checkboxes

---

The first bug fix was already addressed in the most recent version (1.2.2).

The second isn't really a bug. Just a more user friendly option. I'll look into that with the next release as well.

Thanks!

Glad you like it. :)

Quote:

---

Originally Posted by econcepts

I'll look into the first and last name issue, but that seems like it would be something that could easily be combined on the side after export?

---

Everyone here imports it into their excel. The shipping people use it as-is. The finance folks keep a "subscription" database where the first and last name are stored separately.. ..so they asked to split it, otherwise they have to edit each and every order by hand.

Thanks! I didn't know there was a more recent version, great! Yes, I agree the checkbox/radio thingy is not a 'bug'.. ..btw, I've had two people comment that they expected the export to live under "reports" rather than "tools", but makes no difference to me!

Quote:

---

Originally Posted by econcepts

The first bug fix was already addressed in the most recent version (1.2.2).

---

I just installed 1.2.2 and I think you forgot to update 'VERSION'. The export column 'bug' is fixed, it looks great now!

Quote:

---

Originally Posted by dhcernese

I just installed 1.2.2 and I think you forgot to update 'VERSION'. The export column 'bug' is fixed, it looks great now!

---

Oops, spoke too soon. It's better bug not completely correct.

[FONT=Arial]I'll try to attach an example. Note my product notes have tricky characters in them from my securepay module.[/FONT]

I see the cause. I'll put out a bug fix here for that. I have yet to see it come from others, but it looks like the info passed back to you in the note field (from your cc processor) contains some information that has characters (the quote) which push your data to the next cell.

Again, thanks for the heads up. I'll get this out in a bug fix. Thanks!

Let me start by saying that this mod is a lifesaver! Have it working in 2 sites, and really couldn't have kept the clients happy without it.

But (isn't there always a "but"), I have a couple problems:

1. The only comments that are downloaded are the messages from Authorize.net, like "Credit Card payment. AUTH: xxxxxx. TransID: xxxxxxxxxx", but never the original comment input by the customer during checkout. Both comments are in the orders_status_history table, but only the 2nd gets exported. Anything I can do to get both, ideally in separate Excel cells?

2. This is a little more weird - the first site only used one "Order Total" function (or module, or whatever it's called), so didn't discover this problem until I uploaded the second site. This 2nd site used 2 "order Total" whatevers - sub-total and total, and when I exported the orders, I got duplicates of each. That is, if I had 10 orders, the mod exported 20 lines, even though there were only 10 records in the orders table. When I deleted the "sub-total" records in the orders_total table, problem solved. Neither site needs anything more than just the total, so no sweat for now, but what about the next client who may need sub-total and tax?

BTW, I did change the admin->shipping_export.php file in 2 ways:
- deleted the lines "AND ot.class = 'ot_shipping'" so I could export all orders
- changed delivery_xxx to billing_xxx to see customers' billing info instead of shipping stuff
I was very careful while makng these changes, then compared files (WinMerge) to make sure nothing else was accidently changed.

Site details: Zen Cart version 1.3.7.1, mod version 1.2.2, PHP 5 and MySQL 5. Also, we always export "1 product per row".

Any idea what I can do to fix these problems? Let me know if you would like access to either of the sites' admin areas.

Thanks!

The comment issue I will look into. I do know that in past trials, the only way to get things working smoothly was to have the system export only the first comment (which is ideal anyhow as you would want to know if the customer had any special order instructions over knowing all the data that is passed back through your cc processor.)

In any event, why it is choosing the second set of comments I will have to look into.

I have been working on the next version of this mod based on user requests and various feedback and hope to have that out soon. I will address this issue in that release as well.

On your second point.

I've heard of a few things with others here and there with regard to the "ot" class. I am looking into that as well.

If I need access to either site, I'll let you know (I'll PM you). With the recent feedback, I am going to try to move up the release of the next version.

I'll keep you posted.

Hi Eric,


I did receive your email yesterday and replied back. I just wanted to make sure you received it. I know you are busy, but was just wondering if you had a chance to look at it yet.


Thanks!

Anyone????

Don't know if this helps, but after installing Dr. Byte's AIM_UPDATE patch (to fix an "apostrophe in name" problem with Authorize.net transactions) in my test site, the correct (original) comment did indeed download for the test orders I placed. Maybe there's something in that new AIM file that changes the way the mod works?

Quote:

---

Originally Posted by econcepts

I see the cause. I'll put out a bug fix here for that. I have yet to see it come from others, but it looks like the info passed back to you in the note field (from your cc processor) contains some information that has characters (the quote) which push your data to the next cell.

Again, thanks for the heads up. I'll get this out in a bug fix. Thanks!

---

Did you release a bug fix somewhere?
By the way, it doesn't appear to be caused by a quote. My cell in broken right in the middle of a string, one of many quoted strings.

Quote:

---

Originally Posted by rbobzin

Don't know if this helps, but after installing Dr. Byte's AIM_UPDATE patch (to fix an "apostrophe in name" problem with Authorize.net transactions) in my test site, the correct (original) comment did indeed download for the test orders I placed. Maybe there's something in that new AIM file that changes the way the mod works?

---

This doesn't actually change the export mod. It does address the issue though (which is the way apostrophes are handled).

Quote:

---

Originally Posted by dhcernese

Did you release a bug fix somewhere?
By the way, it doesn't appear to be caused by a quote. My cell in broken right in the middle of a string, one of many quoted strings.

---

No bug fix yet. I was working on a few projects here.

It is coming soon. From the sample files I got here with users that mention this problem (there are only a few), it is indeed due to the way the quoted strings are passed back by the processor.

I have an odd problem with this mod..

It was all working great last week, now it's not! When I go to the export page in admin, it shows orders to be exported but when I export them all I get is the headers.

I've tried exporting in test mode, csv only has headers, tried it for real, still only headers and the order is maked up as having been exported. It all seems fine except for the empty csv file.

I've tried re installing all of the original files, uninstalling the sql and then putting it back in.

Can anyone suggest something else to try?

Thanks.

Quote:

---

Originally Posted by vitalchip

I have an odd problem with this mod..

It was all working great last week, now it's not! When I go to the export page in admin, it shows orders to be exported but when I export them all I get is the headers.

I've tried exporting in test mode, csv only has headers, tried it for real, still only headers and the order is maked up as having been exported. It all seems fine except for the empty csv file.

I've tried re installing all of the original files, uninstalling the sql and then putting it back in.

Can anyone suggest something else to try?

Thanks.

---

Please address all questions on this mod to the original thread found at:

http://www.zen-cart.com/forum/showthread.php?t=65715

That question has been addressed in a number of posts one shown below for example.

http://www.zen-cart.com/forum/showpo...5&postcount=94

Hi Eric, yes, I'd read the other thread and tried the suggestions but it still doesn't work.

It's quite odd because it used to. I made some changes to export_shipping.php before, to include some static text between the exported fields, even these don't show up, it's as if it's not actually assembling the export file.

I tried removing the while( !$order_details->EOF ) { and the closing bracket, just to see what happened.. it exported one instance of all the static text when that statement was removed.

here's what I changed things to:

$str_export = "\"" . $order_details->fields['delivery_name'] . "\"" .
",\"" . $order_details->fields['delivery_name'] . "\"" .
",\"" . $order_details->fields['delivery_name'] . "\"" .
",\"". $order_details->fields['delivery_street_address'] . "\"" .
",\"". $order_details->fields['delivery_suburb'] . "\"" .
",\"". " " . "\"" .
",\"". $order_details->fields['delivery_city'] . "\"" .
",\"". $order_details->fields['delivery_state'] . "\"" .
",\"". $order_details->fields['delivery_postcode'] . "\"" .
",\"". "GB" . "\"" .
",\"" . $order_details->fields['customers_telephone'] . "\"" .
",\"". " " . "\"" .
",\"" . $order_details->fields['customers_email_address'] . "\"" .
",\"". " " . "\"" .
",\"". "1" . "\"" .
",\"". " " . "\"" .
",\"". " " . "\"" .
",\"". " " . "\"" .
",\"". " " . "\"" .
",\"" . $order_details->fields['date_purchased'] . "\"" .
",\"". $order_details->fields['orders_id'] . "\"" .
",\"" . $order_details->fields['delivery_name'] . "\"" .
",\"". $order_details->fields['delivery_postcode'] . "\"" .
",\"". $order_details->fields['order_total'] . "\"" .
",\"". $order_details->fields['value'] . "\"";


as i say, if i remove the eof checking it will export the GB and the 1 etc, in the correct places but nothing from the database.

I don't know if any of that helps.

Ok, got it sorted, i'd failed to realise that there was more than one instance of

AND ot.class = 'ot_shipping' in the file shipping_export.php

I'd only deleted one. Now I have deleted them all I'm back in business,

Thanks Eric.

Glad you got it working.

The new release I am finishing up here (1.2.3) will address that issue as well as some new features that others have requested.

I'm having a similar issue and was encouraged when I read this thread. However, you post from 2007 indicates you were about to release version 1.2.3 of this module, yet I cannot find it anywhere. Did it ever come out?:unsure:

I just installed the module today. I have ZenCart 1.3.7.1 running PHP 4.4.8. I could (and probably should) upgrade to ZC 1.3.8, but I would really like to take care of some business before doing so. Is it necessary to do so before trying to use this module?

1.2.3 was postponed for a time and should be out here sometime within the coming week. I ended up adding a number of items that were requested by various users so ti took more time than originally planned.

Be on the lookout here. Just finishing it up.

I'm happy to announce that I've finally completed the new version 1.2.3 of the Shipping and Order Export module.

It's been almost a year since the last release and a number of items have been added to this release which have been requested.

Some features present in this release include:

1) Added option to export the following new fields: Order Tax Amt, Order Subtotal, Order Discounts, Payment Method, Order Status
2) Added option to split first and last name into 2 separate columns in export
3) Added ability to re-export data that had previously been exported
4) Added date range select ability so reports could be run based on a selected date range.
5) Added ability to export on any order status or a pre-selected order status.

Misc. Changes to this version:
1) Bug fix. Corrected comments bug that caused the comment field to split across multiple columns when apostrophe was present.
2) Changed File layout option to radio field from checkboxes


You can download version 1.2.3 from
http://www.zen-cart.com/index.php?ma...roducts_id=604

Upgrading from version 1.1.1 or higher:
If upgrading from another version 1.1.1 or higher then all you need to do is copy all the included files over to your site as is and overwrite the current files. There are no database upgrades for this version if upgrading.

If you have made any customizations to your current version then you will want to merge those changes with this one and backup your files.


Enjoy!

Thanks for your efforts! I hope to try this out in the coming weeks.

Quote:

---

2) Added option to split first and last name into 2 separate columns in export

---

I'm curious, how did you decide where to split the name? It's not stored separately in the database, how can you know where it should be split? First space? Last space? I know two-part first or last names should really be hyphenated, but not everyone does it that way. For example "Chang Ho Kim"?

Quote:

---

Originally Posted by dhcernese

I'm curious, how did you decide where to split the name? It's not stored separately in the database, how can you know where it should be split? First space? Last space? I know two-part first or last names should really be hyphenated, but not everyone does it that way. For example "Chang Ho Kim"?

---

Split using a standard "string split" PHP function altered a bit to take into account first name, middle, last name. Splits based on a "blank space" between the parts of a name.

If a name is not hypenated correctly then it will see the first part as the first name and the middle part as the middle name (not part of the first name). You can't assume that the two are actually part of the first name unfortunately.

Quote:

---

Originally Posted by econcepts

Split using a standard "string split" PHP function altered a bit to take into account first name, middle, last name. Splits based on a "blank space" between the parts of a name.

If a name is not hypenated correctly then it will see the first part as the first name and the middle part as the middle name (not part of the first name). You can't assume that the two are actually part of the first name unfortunately.

---

I should just test this when I get it installed, but I don't quite understand yet.

You split the example three names into first, middle, and last. Do you then eliminate the middle name in the export when the name is split into first and last columns for export?

Quote:

---

Originally Posted by dhcernese

I should just test this when I get it installed, but I don't quite understand yet.

You split the example three names into first, middle, and last. Do you then eliminate the middle name in the export when the name is split into first and last columns for export?

---

That is correct. That is how it should work.

I'm running v1.3.7. I just installed this mod and I'm having trouble getting it to work. It displays the first 20 orders placed, but there is no export button. I double checked in phpmyadmin and the changes to the database were made. I tried resetting the orders downloaded to "no" and this didn't help. Any ideas?

Thanks!

Quote:

---

Originally Posted by Lisk

I'm running v1.3.7. I just installed this mod and I'm having trouble getting it to work. It displays the first 20 orders placed, but there is no export button. I double checked in phpmyadmin and the changes to the database were made. I tried resetting the orders downloaded to "no" and this didn't help. Any ideas?

Thanks!

---

Two questions:

1) Did previous versions work?

2) Can you look at the information provided for order #21 (the one it fails on) and see if it is missing delivery information (no shipping address) or the comments have some weird characters in it?

I thought I covered the comments issue, but may have missed something. I have heard as well (even with previous versions) that when a record has NO shipping address information (maybe it is a "virtual / download" type product) that you might see no orders export. Not usually what you are seeing, but it is worth checking.

If it turns out to be the "comment" issue mentioned above, you could edit the comments for the order having the problem and see if that helps.

Let me know what you find out.

This is the first time I have installed the mod, so I don't know if previous versions worked. Should I install an older version?

Order #21 does have a shipping address and it does not have any comments. I compared it to order #20 and there do not seem to be any differences.

Quote:

---

Originally Posted by Lisk

This is the first time I have installed the mod, so I don't know if previous versions worked. Should I install an older version?

Order #21 does have a shipping address and it does not have any comments. I compared it to order #20 and there do not seem to be any differences.

---

No, don't install an older version. I was just asking to see if it was an issue with the new version (I have not heard any reports of any).

Can you get me a link to the screenshot of what you are seeing? SO I can determine if the page is ending pre-maturely or having some other issue?

Sent you a link! :)

It says to install the sql patches to finish install, but there aren't any sql files included in the zip? any help? i don't see any added menu under tools section. thanks

Quote:

---

Originally Posted by afterglow

It says to install the sql patches to finish install, but there aren't any sql files included in the zip? any help? i don't see any added menu under tools section. thanks

---

The line you need to run is in that same instruction (look down in the read me file a line or two more and you'll see it). In future releases I'll include it in a separate file.

The patch you need to run to install is:

ALTER TABLE orders ADD downloaded_ship ENUM( 'yes', 'no' ) NOT NULL DEFAULT 'no';

I'm not getting an export button either & things seem to quit after encountering an error - in the right column just under the checkbox for payment method it says:
Catchable fatal error: Object of class queryFactoryResult could not be converted to string in /home/m*******/public_html/store/admin/includes/functions/html_output.php on line 262
Do you know what may be the problem here? I'm using the latest release - 1.3.8
Otherwise this mod seems to be just what I've been looking for.

By the way, I just installed 1.2.2 over 1.2.3 & it does work. I'd like to use the 1st & last name split in the new version though.

I was using v1.2.1 before and everything was working fine. I loaded v1.2.3 and now I don't get the export button. I have zencart 1.3.8a loaded.

I was able to get v1.2.3 working by using this updated version of the html_output file for the admin section:
http://www.zen-cart.com/forum/showpo...0&postcount=10

I am having a problem.

Running latest PHP MySQL 5

Installed all files (first time install)

Installed sql patch - all tables confirmed

Yet I get

1146 Table 'db216894675.zen_clean_orders' doesn't exist
in:
[select count(*) as total from zen_clean_orders o where downloaded_ship='no' ]
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 help please.

I get this in my admin-->Tools-->Export Order/Shipping Info:

Catchable fatal error: Object of class queryFactoryResult could not be converted to string in /home/paynem5/public_html/shop/admin/includes/functions/html_output.php on line 262




Anyone know why this is happening?

Yes I am getting similar error.

Rob

updating the html_output.php files from the link in #37 fixes the Catchable Fatal Error

anyone know how to add another field to the export shipping information module to download. such as the weight of each product.

after copying all the files to my server, and running the sql code. i get a 500 internal server error when click on Tools>Export Shipping/Order Information

any idea how to fix this?

What is the purpose of magpie RSS in this Add on?

Thanks,

Greg

I installed per the documentation. I don't have any orders in the lower part of the screen to select. Only the upper part of the screen which describe the add-an and the RSS info at the right. What have I missed?

Thanks!

Quote:

---

Originally Posted by beyerg

What is the purpose of magpie RSS in this Add on?

Thanks,

Greg

---

The purpose of that is to push the RSS tips / articles found in the upper right hand corner to the page. It has nothing to do with actual export at this time.

Eric

Quote:

---

Originally Posted by yaby

after copying all the files to my server, and running the sql code. i get a 500 internal server error when click on Tools>Export Shipping/Order Information

any idea how to fix this?

---

500 Errors usually mean something is not configured correctly on the server with regard to that application.

500 comes directly from the server.

Have you resolved this?

Quote:

---

Originally Posted by beyerg

I installed per the documentation. I don't have any orders in the lower part of the screen to select. Only the upper part of the screen which describe the add-an and the RSS info at the right. What have I missed?

Thanks!

---

I've heard this report from a number of people recently. I am looking into the cause. What version of PHP / MySQL are you running? I am trying to point it back to that maybe.

I found the solution in post #35 of this thread. Perhaps those files need to be included in your package.

Thanks for the reply,

Greg

Greg,

I think what you found the solution for is something different than those that are seeing no export button (but not getting the error you describe.)

The "catchable error" deal is something that is zen cart related and is outside of the module itself. Either way, that solution in #35 is how you correct that (I also posted a help file on it.)

The reason I am not going to include that file within the download is simply because it is a "core" file of zen cart and it controls quite a bit of how the rest of zen cart works. If one person were to use it in place of another it might render their cart non-functional.

In place of that file I decided to post the fix (as seen in that link as well) instead. In future version of zen etc... this should automatically work itself out so it won't make any difference then.

I think I may have found a reason for the export button not showing in 1.2.3 but want to be sure before I post a fix.

Quote:

---

Originally Posted by Lisk

I'm running v1.3.7. I just installed this mod and I'm having trouble getting it to work. It displays the first 20 orders placed, but there is no export button. I double checked in phpmyadmin and the changes to the database were made. I tried resetting the orders downloaded to "no" and this didn't help. Any ideas?

Thanks!

---

I have exactly the same problem (only that it displays orders 185-206 - current order being at 259). My Zen version is 1.3.8.
No export button although nothing downloaded. I also did the reset without any result.

Curious to know if you worked this out?

Thanks in advance,

Erik

Quote:

---

Originally Posted by vitalchip

Ok, got it sorted, i'd failed to realise that there was more than one instance of

AND ot.class = 'ot_shipping' in the file shipping_export.php

I'd only deleted one. Now I have deleted them all I'm back in business,

Thanks Eric.

---

Hi,
Is there any way to add a ot.class to the ot_shipping?
I have a cod fee I'd like to have added to the csv, but can't figure out how to do it.
Any idea?

Cheers
Endre

Hello everybody,

I would also like like to export the product_id, does anyone know what code i would have to include in shipping_export.php.

My products exist of the product id + attribute, witch i have to emerce together to a new "product model name".

example: product id = 2100 and attribute = -41, new product model name = 2100-41 .

All help will be appreciated.

Thanks alot.

Quote:

---

Originally Posted by econcepts

Greg,

I think I may have found a reason for the export button not showing in 1.2.3 but want to be sure before I post a fix.

---

When will this fix be available, I could test it for you. I'm getting the problem described with no export button.

Quote:

---

Originally Posted by karimm

Hello everybody,

I would also like like to export the product_id, does anyone know what code i would have to include in shipping_export.php.

My products exist of the product id + attribute, witch i have to emerce together to a new "product model name".

example: product id = 2100 and attribute = -41, new product model name = 2100-41 .

All help will be appreciated.

Thanks alot.

---

Any one ??? i have tryed to rename prcdcut_model to product_id in the script, but that doesn't work.

I would already be satisfield with only the export of the product_id !!

:dontgetit

I just tried to install it (1.2.3) on ZC1.3.8a and am having a problems as well. I am not getting the export button. Instead I am getting the flowing error where I presume that the export button would be:

Catchable fatal error: Object of class queryFactoryResult could not be converted to string in /home/growligh/public_html/admin/includes/functions/html_output.php on line 262

Anyone have any ideas?
-Christopher

Quote:

---

Originally Posted by growlight

I just tried to install it (1.2.3) on ZC1.3.8a and am having a problems as well. I am not getting the export button. Instead I am getting the flowing error where I presume that the export button would be:

Catchable fatal error: Object of class queryFactoryResult could not be converted to string in /home/growligh/public_html/admin/includes/functions/html_output.php on line 262

Anyone have any ideas?
-Christopher

---

Check out my 3rd post on page 4 of this forum - you'll replace the html_output file in the admin section only.

denliv,
That did the trick!! THANKS...:clap:

Hi people.

First of all a big thank you to econcepts for the excellent work on this module.

I have a quick question, probably a blond moment!
I am using V1.2.3 with 1.3.7 Zencart

I always export my processing orders to get ready for shipping. This time round i forgot to put it in test mode and now I have exported all the orders i cannot do it again.

I tried "include orders already downloaded in export" option and it gave me the same file which was great. But when I did a new export in test mode it only gave the new orders in the that were in "processing".

is there a way to reset my exports so i can get all current processing orders again without breaking anything?

Thanks
Samantha

Quote:

---

Originally Posted by econcepts

Greg,

I think what you found the solution for is something different than those that are seeing no export button (but not getting the error you describe.)

I think I may have found a reason for the export button not showing in 1.2.3 but want to be sure before I post a fix.

---

Eric, All

Good Evening

First respect and thanks for a very useful tool

Have you had any further thoughts regarding this bug?

I have the same problem. The odd thing is ver 1.2.3 works fine on my localhost xampp system 1.3.8 cart, but will not show the dates or the export button in the live production version. I have installed ver 1.2.2 to my production 1.3.8 Cart and it works fine! The local xampp version is running mysql 5.067 and php 5.2.6 whilst the production server is running mysql 4.1 and php 5.2.6 (until it is upgraded to msql 5 in a couple of weeks).

I have compared the main file admin/shipping_export.php and there is quite a bit of difference isnt there

So I will retest when the upgraded version of php is running

Cheers
Centec 2b

Haven't seen anyone with this problem yet, but I installed this shipping export add-on, on v.1.3.8 I tried to run the sql but it said that it failed because the column already existed, although I haven't used this add-on before now. Now when I go to Admin > Tools > Shipping Exporter I get a 500 Internal Error. The rest of my admin is working fine, but I can't get this to work. I also installed orders exporter, but it exported everything except the info I needed price. I need to know how much each customer has paid for their order and shipping so I can do my taxes and accounting properly. Thanks for any help!

Quote:

---

Originally Posted by Tereadia

Haven'........shipping export add-on, on v.1.3.8 I tried to run the sql but it said that it failed because the column already existed, although I haven't used this add-on before now. ..................I get a 500 Internal Error...... I also installed orders exporter, but it exported everything except the info I needed price

---

Ignoring the 2nd contribution comments

Are you happy the rest of the installation was ok? Can you see the contribution ok in admin?

The server error is a general error message saying an unexpected condition prevented it from fulfilling the request. If you are comfortable with something like phpmyadmin, I would go and have a look directly at your database files. If your server is saying the column already existed, there has to be a reason for it being there - sounds odd that some other contribution requires the same SQL alteration. What other contributions do you have? Do they require a SQL insertion?

My personal inclination would be to identify if there has been an alteration to the data files and either remove the offending alterations/data or possibly a safer bet restore from an earlier backup and reapply the SQL statement. I should caveat these remarks with the comment BACKUP before you start delving in the database.

Hope this helps

Centec2b

Quote:

---

Originally Posted by Tereadia

Haven't seen anyone with this problem yet, but I installed this shipping export add-on, on v.1.3.8 I tried to run the sql but it said that it failed because the column already existed, although I haven't used this add-on before now. Now when I go to Admin > Tools > Shipping Exporter I get a 500 Internal Error. The rest of my admin is working fine, but I can't get this to work. I also installed orders exporter, but it exported everything except the info I needed price. I need to know how much each customer has paid for their order and shipping so I can do my taxes and accounting properly. Thanks for any help!

---

What column did it say already existed? The only column added during this install is a "downloaded_ship" column. You could have received this error if you tried to install and it failed at one point. Then tried to re-install (refresh etc...) and the system saw the column which was already added during the first attempt.

A 500 Internal server error usually means something on the server end had issues (these come directly from the server side).

If you want to install my advice would be to run the uninstall program (a small sql file) and then re-run the install program (the first time install) and that should do it.

Report back what you find and I'll see if I can walk you thorough how to get it moving.

Quote:

---

Originally Posted by Centec2b

Eric, All

Good Evening

First respect and thanks for a very useful tool

Have you had any further thoughts regarding this bug?

I have the same problem. The odd thing is ver 1.2.3 works fine on my localhost xampp system 1.3.8 cart, but will not show the dates or the export button in the live production version. I have installed ver 1.2.2 to my production 1.3.8 Cart and it works fine! The local xampp version is running mysql 5.067 and php 5.2.6 whilst the production server is running mysql 4.1 and php 5.2.6 (until it is upgraded to msql 5 in a couple of weeks).

I have compared the main file admin/shipping_export.php and there is quite a bit of difference isnt there

So I will retest when the upgraded version of php is running

Cheers
Centec 2b

---

Centenc,

I mentioned possibly finding a reason as to why some were experiencing part f the screen not loading (and no export button) in a post a short while back.

Have you got your end working yet and if not, would I be able to get into your system to try to correct the error (I think I have a fix). I have yet to be able to duplicate the issue (think it a combination of coding and PHP verision along one area of the code.) but want to try it on a site that is missing that button to be sure.

Let me know.

Eric:

I am experiencing the same problem reported in previous posts. The mod installs fine, but the bottom half of the screen is missing, with no order data shown, and no Export button. I have ZC version 1.3.8a and your mod version 1.2.3 installed on a working server, but the store is hidden from the public for setup and testing purposes.

Reply to me by PM, and I can set you up with access to my Admin and root if you want to try something.

Quote:

---

Originally Posted by Sailman

Eric:

I am experiencing the same problem reported in previous posts. The mod installs fine, but the bottom half of the screen is missing, with no order data shown, and no Export button. I have ZC version 1.3.8a and your mod version 1.2.3 installed on a working server, but the store is hidden from the public for setup and testing purposes.

Reply to me by PM, and I can set you up with access to my Admin and root if you want to try something.

---

Jim,

Ok, thanks for the PM and login details. Check it now. I didn't have any problems with the install (less than 3 minutes) and it all looks ok to me. I posted a link to the page I see (works fine) in your PM area. For privacy reasons I'll leave it there.

Can you confirm that you see it OK now as well? I never did get the same thing you or others have reported (it worked for me from the start) which puzzles me.

If it works for you now then I am wondering if it has something to do with installation for some (incorrect install). I'd like to work through it to see what might be the culprit for others that have seen the issue.

Report back your findings here.

Thanks!

econcepts:

You are correct, sir.... The Admin page is complete and functional. I was very careful in the insertion of the files, and checked back on my backup copy and the files were correctly placed.

Here is my guess as to what the installation problem was: For the other "orders export" mod in the Download section, the file -orders_Exporter\admin\includes\boxes\extra_boxes\ordersExport_tools_dhtml.php - has the same name.

If the file was not removed, or my FTP didn't overwrite it, then that could have been the problem.....

However, thanks to your efforts, the Admin page is working, but the .csv file exported contains only headers, no data.

Thanks again for your help, but what do you think the problem is?

Hi - i am hoping you can help me here. I am modifying this add on to include a "Product Cost" column to the report. I have it working except I can't quite figure out how I take the value and place it into the new column I created. It is essentially making the same query to the db as what is used for filling the "Products Atrributes" column only I don't need to format the multiple attribute options, i.e. like below where the field I am pulling out of the db is "options_values_price_w":

Code:

---

$product_attributes_rows="SELECT Count(*) as num_rows
FROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . "
WHERE orders_id = " . $order_details->fields['orders_id'] . "
AND orders_products_id = " . $order_details->fields['orders_products_id'] . "";
$attributes_query_rows = $db->Execute($product_attributes_rows);
$num_rows = $attributes_query_rows->fields['num_rows'];

        If ( $num_rows > 0) {
        $product_attributes_query="SELECT *
        FROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . "
        WHERE orders_id = " . $order_details->fields['orders_id'] . "
        AND orders_products_id = " . $order_details->fields['orders_products_id'] . "";
        $attributes_query_results = $db->Execute($product_attributes_query);
        $str_export = $str_export . "\"";
                for ($i = 0, $n = $num_rows; $i < $n; $i++) {
                $str_export = $str_export . $attributes_query_results->fields['options_values_price_w'] .
                $attributes_query_results->MoveNext();
                }
        $str_export = $str_export . "\"";

}

---

If I replace this code with what is used to fill the "Product Attributes" column it shows the cost value properly. But I would like both columns displayed - "Products Attributes" and "Product Cost". I added the name of the column successfully like below, but don't know what would make the data go into that column:

Code:

---

if ($_POST['product_details'] == 1) { // add to header row
        if ($_POST['filelayout'] == 2) { // 1 Product Per row RADIO
                        $str_header = $str_header . ",Product Qty,Products Price,Product Name,Product Model,Product Attributes,Product Cost";
        } else { // File layout is 1 OPR
        /**************the following exports 1 OPR attribs****************/
          $oID = zen_db_prepare_input($order_details->fields['orders_id']);
          $oIDME = $order_details->fields['orders_id'];
          $order = new order($oID);
                for ($i = 0, $n = $max_products; $i < $n; $i++) {
                        $str_header = $str_header . ",Product " . $i . " Qty";
                        $str_header = $str_header . ",Product " . $i . " Price";
                        $str_header = $str_header . ",Product " . $i . " Name";
                        $str_header = $str_header . ",Product " . $i . " Model";
                        $str_header = $str_header . ",Product " . $i . " Attributes";
                        $str_header = $str_header . ",Product " . $i . " Cost";
            }
        /*****************************************************************/
        } // End if to determine which header to use
} // end Row header if product details selected

---

hope that makes sense - I feel like I am really close to figuring it out, but I am kinda crash coursing learning db and php coding to make this work..any help would be appreciated....thanks

Hi All

Great contribution and exactly what we are looking for to use, however I must be doing something wrong....

I don't have any error messages, just the download button is not being shown no matter what I try.

Also the order list does not seem to change when I alter the status on the right.

I am using Export shipping module 1.2.3 and zencart 1.3.8a.



Thanks in advance.

Quote:

---

Originally Posted by ccn1

Hi All

Great contribution and exactly what we are looking for to use, however I must be doing something wrong....

I don't have any error messages, just the download button is not being shown no matter what I try.

Also the order list does not seem to change when I alter the status on the right.

I am using Export shipping module 1.2.3 and zencart 1.3.8a.



Thanks in advance.

---

I've heard this report more and more frequently now. I worked with another zen cart user who had the same issue and all I did was re-install the mod to get it working.

I'd like to look into your issue for you. Send me a private message and we can figure out a way for me to get in and look at it.

I have yet to be able to duplicate this problem on any site (even those I have helped resolve the issue) and I am eager to find out why it seems to occur so another site to look at (yours) would be great.

Please send me a private message and we'll get in to look at it.

Thanks!

Quote:

---

Originally Posted by misscotton

Hi - i am hoping you can help me here. I am modifying this add on to include a "Product Cost" column to the report. I have it working except I can't quite figure out how I take the value and place it into the new column I created. It is essentially making the same query to the db as what is used for filling the "Products Atrributes" column only I don't need to format the multiple attribute options, i.e. like below where the field I am pulling out of the db is "options_values_price_w":

Code:

---

$product_attributes_rows="SELECT Count(*) as num_rows
FROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . "
WHERE orders_id = " . $order_details->fields['orders_id'] . "
AND orders_products_id = " . $order_details->fields['orders_products_id'] . "";
$attributes_query_rows = $db->Execute($product_attributes_rows);
$num_rows = $attributes_query_rows->fields['num_rows'];

        If ( $num_rows > 0) {
        $product_attributes_query="SELECT *
        FROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . "
        WHERE orders_id = " . $order_details->fields['orders_id'] . "
        AND orders_products_id = " . $order_details->fields['orders_products_id'] . "";
        $attributes_query_results = $db->Execute($product_attributes_query);
        $str_export = $str_export . "\"";
                for ($i = 0, $n = $num_rows; $i < $n; $i++) {
                $str_export = $str_export . $attributes_query_results->fields['options_values_price_w'] .
                $attributes_query_results->MoveNext();
                }
        $str_export = $str_export . "\"";

}

---

If I replace this code with what is used to fill the "Product Attributes" column it shows the cost value properly. But I would like both columns displayed - "Products Attributes" and "Product Cost". I added the name of the column successfully like below, but don't know what would make the data go into that column:

Code:

---

if ($_POST['product_details'] == 1) { // add to header row
        if ($_POST['filelayout'] == 2) { // 1 Product Per row RADIO
                        $str_header = $str_header . ",Product Qty,Products Price,Product Name,Product Model,Product Attributes,Product Cost";
        } else { // File layout is 1 OPR
        /**************the following exports 1 OPR attribs****************/
          $oID = zen_db_prepare_input($order_details->fields['orders_id']);
          $oIDME = $order_details->fields['orders_id'];
          $order = new order($oID);
                for ($i = 0, $n = $max_products; $i < $n; $i++) {
                        $str_header = $str_header . ",Product " . $i . " Qty";
                        $str_header = $str_header . ",Product " . $i . " Price";
                        $str_header = $str_header . ",Product " . $i . " Name";
                        $str_header = $str_header . ",Product " . $i . " Model";
                        $str_header = $str_header . ",Product " . $i . " Attributes";
                        $str_header = $str_header . ",Product " . $i . " Cost";
            }
        /*****************************************************************/
        } // End if to determine which header to use
} // end Row header if product details selected

---

hope that makes sense - I feel like I am really close to figuring it out, but I am kinda crash coursing learning db and php coding to make this work..any help would be appreciated....thanks

---

In order to get that to work and keep your current setup correct you'll need to ad a few items.

1) add a new header row column for that new field and don't forget to only show that IF the user chose that option otherwise it will through off the export.

2) Add the exported data to two sections in the program. (a) the section that exports data "one order per row" and (b) to the section that exports data "one product per row".

3) You'll also need to update the query itself to pull that extra field in order to have the "data" to put into the export.

Make a backup file of your current working copy before you change anything so you have a working version.

So you're looking at a number of edit areas to get it to work.

I am getting the same error as everyone else:

Catchable fatal error: Object of class queryFactoryResult could not be converted to string in /home/growligh/public_html/admin/includes/functions/html_output.php on line 262

But when I try to use the updated version of html_output.php I get only the green bar portion of the header in the admin side of the site and this error:

Fatal error: Call to undefined function zen_catalog_href_link() in /home/needgcom/public_html/elocin/includes/header.php on line 219

If I switch back to the core file from the 1.3.7 download then I can access my admin again but still have no export button for this mod.

Any suggestions?

Thanks,
Marc

Hi,

A really interesting contribution.


Please could you show me how to get as default some of the options "on", 1 line for order, discount, etc,... All of them are desable as default.

I want the options we are used to "activate" before do the batch will be activated already when we are on this page in order to save time and human faults.

thanks for your help

Quote:

---

Originally Posted by tat2nu

I am getting the same error as everyone else:

Catchable fatal error: Object of class queryFactoryResult could not be converted to string in /home/growligh/public_html/admin/includes/functions/html_output.php on line 262

But when I try to use the updated version of html_output.php I get only the green bar portion of the header in the admin side of the site and this error:

Fatal error: Call to undefined function zen_catalog_href_link() in /home/needgcom/public_html/elocin/includes/header.php on line 219

If I switch back to the core file from the 1.3.7 download then I can access my admin again but still have no export button for this mod.

Any suggestions?

Thanks,
Marc

---

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

Wow, thanks a lot. The correction showed up on line # 550 in Notepad though not 543. I was able to find it by looking at the last items that did show up on the screen before the error.

Thanks again,
Marc

Quote:

---

Originally Posted by tat2nu

Wow, thanks a lot. The correction showed up on line # 550 in Notepad though not 543. I was able to find it by looking at the last items that did show up on the screen before the error.

Thanks again,
Marc

---

Weird, in DW, its 543...are you using version 1.2.3?

Yeah, it is 1.2.3 not sure why it would be different.

For some reason the "company" field is left blank in the excel output. In the database almost every single order has a company name. I saw one other post with the same problem, but can't find the solution.

I changed the "delivery_company" in admin/shipping_export.php to "customers_company" (on lines 151,441,452,459) just to test the result and the field is still left empty.

Anyone know what's wrong?

Great Contribution by the way.

Thanks.

Quote:

---

Originally Posted by AATECH

For some reason the "company" field is left blank in the excel output. In the database almost every single order has a company name. I saw one other post with the same problem, but can't find the solution.

I changed the "delivery_company" in admin/shipping_export.php to "customers_company" (on lines 151,441,452,459) just to test the result and the field is still left empty.

Anyone know what's wrong?

Great Contribution by the way.

Thanks.

---

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?

Quote:

---

Originally Posted by tat2nu

I am getting the same error as everyone else:

Catchable fatal error: Object of class queryFactoryResult could not be converted to string in /home/growligh/public_html/admin/includes/functions/html_output.php on line 262

But when I try to use the updated version of html_output.php I get only the green bar portion of the header in the admin side of the site and this error:

Fatal error: Call to undefined function zen_catalog_href_link() in /home/needgcom/public_html/elocin/includes/header.php on line 219

If I switch back to the core file from the 1.3.7 download then I can access my admin again but still have no export button for this mod.

Any suggestions?

Thanks,
Marc

---

The "catchable fatal error" message is a zen cart / php compatability issue. Not actually a contribution issue.

The answer to the "catchable error" is found here:

http://www.zencartoptimization.com/2...r-html-output/

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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/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.)

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.

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:

Quote:

---

Originally Posted by 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:

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

Quote:

---

Originally Posted by 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);?>&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.

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

Thanks Eric...

Marc

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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)

Quote:

---

Originally Posted by 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!