Export Shipping & Order Information

nightfly:

Running 1.3.7 here and I also get an empty export (ticked the box "include orders already downloaded"). :dontgetit

I have a 1.3.1 version that should correct this issue. I have not uploaded to the zen cart downloads section yet, but others who are testing it say it solved their problem.

You can download the newest version now from the following link.

http://www.zencartoptimization.com/downloads

econcepts:

I have a 1.3.1 version that should correct this issue. I have not uploaded to the zen cart downloads section yet, but others who are testing it say it solved their problem.

You can download the newest version now from the following link.

http://www.zencartoptimization.com/downloads

Is this working with 1.3.9d?

Thanks,
Marc

econcepts:

I have a 1.3.1 version that should correct this issue. I have not uploaded to the zen cart downloads section yet, but others who are testing it say it solved their problem.

Strange, but it doesn' work in my case. I have ZenCart 1.3.9d, and tried both addons ver. 1.3.0 and 1.3.1. Both produce empty CVS/TXT files. When checkbox "Include Header Row In Export" is checked I get just header line in export files, but no customer data.

gulf:

Strange, but it doesn' work in my case. I have ZenCart 1.3.9d, and tried both addons ver. 1.3.0 and 1.3.1. Both produce empty CVS/TXT files. When checkbox "Include Header Row In Export" is checked I get just header line in export files, but no customer data.

That is odd. It should work on all versions regardless as it only pulls data that has already been stored in the db.

I'll load it on a 1.3.9d install here today and see what the outcome is. I have heard others using it on that with success. I would not use 1.3.0 as it has some bugs that cause the export not to run. But I have heard 1.3.1 is ok.

gulf:

Strange, but it doesn' work in my case. I have ZenCart 1.3.9d, and tried both addons ver. 1.3.0 and 1.3.1. Both produce empty CVS/TXT files. When checkbox "Include Header Row In Export" is checked I get just header line in export files, but no customer data.

I concur that I am experiencing the same issue. If I go back to version 1.2.6 it works fine, but of course it's missing the useful new features!

Thanks for the great plugin anyway! :D

Zen Cart 1.3.9d
Database Patch Level: 1.3.9d

Server OS: FreeBSD 8.0-RELEASE-p3
Database: MySQL 5.0.90-log
HTTP Server: Apache/2.2.15 (FreeBSD) mod_ssl/2.2.15 OpenSSL/1.0.0a DAV/2 PHP/5.3.2 with Suhosin-Patch
PHP Version: 5.3.2 (Zend: 2.3.0)

ArtisticD:

I concur that I am experiencing the same issue. If I go back to version 1.2.6 it works fine, but of course it's missing the useful new features!

Thanks for the great plugin anyway! :D

Zen Cart 1.3.9d
Database Patch Level: 1.3.9d

Server OS: FreeBSD 8.0-RELEASE-p3
Database: MySQL 5.0.90-log
HTTP Server: Apache/2.2.15 (FreeBSD) mod_ssl/2.2.15 OpenSSL/1.0.0a DAV/2 PHP/5.3.2 with Suhosin-Patch
PHP Version: 5.3.2 (Zend: 2.3.0)If you saw my posts, my shop doesn't work with the ACCOUNT_STATE and COUNTRY code he added. I had to remove it all.

dhcernese:

If you saw my posts, my shop doesn't work with the ACCOUNT_STATE and COUNTRY code he added. I had to remove it all.

Yes, this is something you might want to try. I am working on leaving it in as most of those using it for shipping will need this info.

The way the mod use to work was it only account for those that did not use ACCOUNT_STATE as a drop down. This was causing those that used it as a drop down on their create an account / login page to get zero rows exported. I had to add an exception in there to trigger one portion of the query or another based on drop down or not.

Let me look at that portion of code to see if there are other naming conventions that might be causing it to not pick that up. The other method (which I would hate to do) is to create two versions ... one for those who use the state drop down field and one for those who have it as text entered. But that would hurt if there was a switch between one or the other for any reason so I am trying to avoid that.

Let me take a peek at that section of code again here. I've got it (1.3.1) running on 1.3.8 and know a few others with it working as well. So it might be a 1.3.9 issue (testing that today here) but not sure yet.

Will post results here either way.

Ok everyone. I just completed testing the 1.3.1 version on a fresh 1.3.9d zen cart install and I get it working just fine with all order types.

In no instances did I get just the header row.

So what I need to do to debug this is to figure out what is common between all those users who are getting just the header row and nothing else.

To do that I have a few questions I would like those people to answer. Without this info it will be hard to replicate the situation you might be experiencing so any feedback would be appreciated.

1. What internet browser and version are you using to export the info?

2. Is your state field on the account creation for a "drop down" selection or a standard "text input field"?

3. Are you trying to export one product per row or one order per row?

4. Does your site sell any products that do NOT require the customer to enter a shipping address?

Let me know the answer to those questions if you could and I'll see if I can figure a way out to duplicate the issue.

Thanks in advance!

econcepts:

1. What internet browser and version are you using to export the info?

2. Is your state field on the account creation for a "drop down" selection or a standard "text input field"?

3. Are you trying to export one product per row or one order per row?

4. Does your site sell any products that do NOT require the customer to enter a shipping address?

1. IE8 but mostly Firefox 3.6.5/3.6.6
2. drop down. however, when we edit an account there is no dropdown
3. one product per row but it doesn't matter, i've tested both.
4. yes

Also, remember your "country" code has to be removed too.
I have nearly 200 zones defined, 1 zone definition, and 240 countries.

dhcernese:

1. IE8 but mostly Firefox 3.6.5/3.6.6
2. drop down. however, when we edit an account there is no dropdown
3. one product per row but it doesn't matter, i've tested both.
4. yes

Also, remember your "country" code has to be removed too.
I have nearly 200 zones defined, 1 zone definition, and 240 countries.

Super. Thanks for the initial feedback. (Others ... please do the same and let me know your setups. I'm trying to find a pattern here.)

I am going to setup a site with the configuration you have listed here and see what I come up with (testing on those browser platforms as well.)

Thanks for the valuable feedback.

ArtisticD:

Zen Cart 1.3.9d
Database Patch Level: 1.3.9d

Server OS: FreeBSD 8.0-RELEASE-p3
Database: MySQL 5.0.90-log
HTTP Server: Apache/2.2.15 (FreeBSD) mod_ssl/2.2.15 OpenSSL/1.0.0a DAV/2 PHP/5.3.2 with Suhosin-Patch
PHP Version: 5.3.2 (Zend: 2.3.0)

econcepts:

1. What internet browser and version are you using to export the info?

2. Is your state field on the account creation for a "drop down" selection or a standard "text input field"?

3. Are you trying to export one product per row or one order per row?

4. Does your site sell any products that do NOT require the customer to enter a shipping address?

1. Firefox.
2. Drop down.
3. One PRODUCT per row, but also tried the other.
4. No

Thanks for your hard work!

hello, i've exported all orders without using test mode, now i want to export them again, i select "Include orders already downloaded in export", set date from the first day of my store created to today, and select any order status, but only several orders have been exported.
according to the order date, order status, i guess these few orders exported are random.

i use zencart 1.38a
shipping export 1.24, also tried 1.31
IE, also tried firefox
drop down for account creation
one order per row, also tried one product per row
shipping address required for costomers

and i installed a new mod gob_package_trackers

thanks

bear1728:

hello, i've exported all orders without using test mode, now i want to export them again, i select "Include orders already downloaded in export", set date from the first day of my store created to today, and select any order status, but only several orders have been exported.
according to the order date, order status, i guess these few orders exported are random.

i use zencart 1.38a
shipping export 1.24, also tried 1.31
IE, also tried firefox
drop down for account creation
one order per row, also tried one product per row
shipping address required for costomers

and i installed a new mod gob_package_trackers

thanks

So the first time it DID in fact export all orders correct? It was only the second time trying to reexport them that the problem occured. Is this accurate?

yes, when new orders placed, i can export them correctly, if i want to reexport them, then i get only several orders even i select "Include orders already downloaded in export". and i'm not sure if the problem occured due to the new mod gob_package_trackers i installed.

bear1728:

yes, when new orders placed, i can export them correctly, if i want to reexport them, then i get only several orders even i select "Include orders already downloaded in export". and i'm not sure if the problem occured due to the new mod gob_package_trackers i installed.

I wouldn't think it is due to that new mod install. The export module simply takes the information already entered into the DB with each order and pulls it for export. Install of new mods (unless the specifically alter order fields in the db) should have little or no effect.

What happens if you select the "include orders already downloaded in export" and also add a date range to the export? Does it pull all orders then or still just a few?

Thanks for the feedback here.

i select the "include orders already downloaded in export",
then i tried different date range, different order status, but always only a few orders are exported.
according to purchase date, order status, order id ... it seams those orders exported are random.

i guess i know what the problem is, cause i changed the country name from "united kingdom" to "uk" from admin, now those orders of "united kingdom" couldnt be exported

i also modified other countries names, i have forgotton when i modified them and which countries i modified.
now i know the orders exported are just part of my orders, but i dont know what do i export all orders i need.
any ideas?

bear1728:

i also modified other countries names, i have forgotton when i modified them and which countries i modified.
now i know the orders exported are just part of my orders, but i dont know what do i export all orders i need.
any ideas?You could try this version until his is fixed. As a test anyway. http://www.zen-cart.com/forum/showpost.php?p=887384&postcount=204
its one file to replace after installing the package (no instructions, you're on your own).

Hi,

I just upgraded from 1.3.8 to 1.3.9b but I can't get this to work now.

I filled out the export fields the same way I always did. The screen shows me my new orders, but the export creates a blank file. It then updates the new orders to download_ship = yes, so it thinks it exported them correctly. But my file is empty except for the header.

I will mention that for some reason when I upgraded, it wiped out all of these files. Not sure why, but I reinstalled.

Any ideas?

Thanks,
Susie