Export Shipping & Order Information

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?main_page=product_contrib_info&products_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.

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

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.

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?

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!

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.

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

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/showpost.php?p=487360&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