Export Shipping & Order Information

susb8383:

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

That's odd, an upgrade should not alter any of these files as non are native to zen. In any event, which version did you install after upgrade?

Did you try to install the same version you were running previously? If not, make sure you use the 1.3.1 version (if not using your previous version.)

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?

Since the contribution pulls and matched based on country (for shipping purposes) changing those will likely cause an incorrect match and thus skip any orders whose country did not match what the order had (when placed.)

The way around this is to remove the country portion of code totally (see link posted by dhcernese below).

I am thinking of removing countries all together because I am seeing those altered on various sites and see it causing problems. I know a lot of users need it however for shipping etc... so I hate to get rid of it.

econcepts:

hich version did you install after upgrade?

Did you try to install the same version you were running previously? If not, make sure you use the 1.3.1 version (if not using your previous version.)

Hi,

I had downloaded 1.3.0, but just now I downloaded and installed 1.3.1. Same problem, two orders show on the screen but the exported file is blank except for headers.

Maybe something changed with the way the fields need to be filled out?

Here are the fields I checked (all others left blank):

Export First and Last Name into Separate Fields.
Include Header Row In Export

Any order status

One product per row

Shipping Method
Shipping Total
Phone Number
Order Total
Order Date

Order Tax Amount
Order Subtotal
Order Discount
Payment Method
Order Status

Full Product Details

Could you try it with exactly these fields filled out and see if it works for you?

Thanks, Susie

Well, I tried it with different combinations of those fields filled out, and nothing works. I even clicked Include Orders Already Downloaded and gave it a big date range, but I still got no records.

Then I reinstalled the last version that worked for me which was 1.2.4. It worked fine.

So there's something about these latest versions that made it stop working for me.

I could just keep using 1.2.4 but I'm sure someday it won't work anymore as ZenCart progresses.

I'm using Firefox 3.6.6 on Windows XP Professional Version 2002 Service Pack 3.

I have Zen 1.3.9.

--Susie

susb8383:

Well, I tried it with different combinations of those fields filled out, and nothing works. I even clicked Include Orders Already Downloaded and gave it a big date range, but I still got no records.

Then I reinstalled the last version that worked for me which was 1.2.4. It worked fine.

So there's something about these latest versions that made it stop working for me.

I could just keep using 1.2.4 but I'm sure someday it won't work anymore as ZenCart progresses.

I'm using Firefox 3.6.6 on Windows XP Professional Version 2002 Service Pack 3.

I have Zen 1.3.9.

--SusieMy experience is the same as yours, only I stuck with 1.2.2 until I fixed the most recent one and posted it (by taking out code that doesn't work for me).

susb8383:

Well, I tried it with different combinations of those fields filled out, and nothing works. I even clicked Include Orders Already Downloaded and gave it a big date range, but I still got no records.

Then I reinstalled the last version that worked for me which was 1.2.4. It worked fine.

So there's something about these latest versions that made it stop working for me.

I could just keep using 1.2.4 but I'm sure someday it won't work anymore as ZenCart progresses.

I'm using Firefox 3.6.6 on Windows XP Professional Version 2002 Service Pack 3.

I have Zen 1.3.9.

--Susie

Thanks for the info Susie.

The big thing that changed between 1.2.4 and 1.3 versions was the addition of the country codes etc...

I am very much considering removing them in the code as dhcernese has done in their code to get it working for them.

I may do this until there is a viable way to get the countries integrated (right now there appears to be too many differences in users setups to make it work universally.)

To answer your previous questions, I tested all your settings and it works for me. But again, that is a setup which is likely different from yours in other respects.

Is anyone aware of any conflict isuues between Super Orders and Export Shipping & Order Information contributions

both running on 13.9d?

thanks in advance

trickobrien:

Is anyone aware of any conflict isuues between Super Orders and Export Shipping & Order Information contributions

both running on 13.9d?

thanks in advance

I'm running both and know of a number of stores running both with no issues.

Hi there,
I have installed this mod and it is fantastic! I'm just wondering if there is a way to split up the shipping method field into two fields, Shipping Method and Shipping Company. For example, if a customer uses UPS Ground, I want the Shipping Method to say Ground and the Shipping Company to say UPS. We are using it to send orders via FTP to a fulfillment warehouse, and they require it in that format.

Thanks!

Danielle:

Hi there,
I have installed this mod and it is fantastic! I'm just wondering if there is a way to split up the shipping method field into two fields, Shipping Method and Shipping Company. For example, if a customer uses UPS Ground, I want the Shipping Method to say Ground and the Shipping Company to say UPS. We are using it to send orders via FTP to a fulfillment warehouse, and they require it in that format.

Thanks!

Currently there is no way to do this. I could customize it for you if you wanted to include that ability. I wouldn't release it as a new upgrade as it is very specific to your needs.

If interested, send me a PM and we can find out how to get it done.

Thanks!

I’m running v1.3.1 on ZenCart V1.3.9d.

When I export, I get the csv file with the header row, but none of the orders are present.
I have it set to Any Order Status.
I have tried selecting and unselecting the various settings but the results are always the same.
For example:
Include orders already downloaded in export.
Run In Test Mode

Any ideas?

Is there specific status settings necessary before a order will show?
Does it matter what the "Payment Status", "Payer Status", Address Status" is?

What about if the product is virtual?

Things have gone from bad to worse.
Now when I enter "Export Shipping" No orders show on the screen. Yet if I go to Customers --> Orders, they are all listed.

So ignoring this, I tried setting "Include orders already downloaded in export." But again the csv file only contained a header row.

I tried this with IE8, Chrome, and Firefox 3.6, the results were the same.

My checkout pages uses the standard pull-down menus for state and country. I have not altered this that I can recall.

I have it set to one row per order

split63:

Things have gone from bad to worse.
Now when I enter "Export Shipping" No orders show on the screen. Yet if I go to Customers --> Orders, they are all listed.

So ignoring this, I tried setting "Include orders already downloaded in export." But again the csv file only contained a header row.

I tried this with IE8, Chrome, and Firefox 3.6, the results were the same.

My checkout pages uses the standard pull-down menus for state and country. I have not altered this that I can recall.

I have it set to one row per order

The reason the products don't show on the screen anymore is likely because when you ran the first export you did not run it in test mode. If you did not do that then your orders were marked as "exported" and thus will not show on the screen anymore (but could still be exported.)

If you are selling virutal products and do not require a shipping address on all orders then that could very well be the issue. This module uses the shipping information to generate some of the export data (used for importing into shipping label programs etc...)

I suspect that is why you are seeing no rows.

I have a set of questions (look further down the thread) that I am asking users to answer for me so I can try to get to the bottom of what some are seeing. I have yet to be able to duplicate the issues on any version of zen (including 1.3.9 up).

If you could answer the questions listed further down in the thread that would help me see if any patterns are developing which may be the cause of this type of non activity.

Thanks in advance!

I just ran another test order through. It was for a test product with a price of $0.01 and free shipping. The order went through fine and shows up in the "Export Shipping" screen. However, the csv file again only contains the header row.

1. What internet browser and version are you using to export the info? Tried IE8, Chrome, and FF3.6.8

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

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

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

Zen Cart: V1.3.9d
Export Shipping: V1.3.1

Thanks,

Thanks for creating this add-on. It's so crucial that I can't imagine using the online store without it. However, I'm having some trouble.

When I export data to a CSV file, two things go wrong.

First, it does not list the header row when I check "include header row."

Second, and much more troubling, the CSV file does not include all the orders. I've compared a couple of orders that did make it and a couple that did not, and I can't see any difference to explain it. Same order status, same product.

Browser: Safari 5.0.1

State field on account creation: Text input.

Export type: One product per row.

*Does your site sell any products that do NOT require the customer to enter a shipping address? *Yes, some PDF downloads. But the missing orders are for physical products that require shipping.

Thanks again.

csiadp:

Thanks for creating this add-on. It's so crucial that I can't imagine using the online store without it. However, I'm having some trouble.

When I export data to a CSV file, two things go wrong.

First, it does not list the header row when I check "include header row."

Second, and much more troubling, the CSV file does not include all the orders. I've compared a couple of orders that did make it and a couple that did not, and I can't see any difference to explain it. Same order status, same product.

Browser: Safari 5.0.1

State field on account creation: Text input.

Export type: One product per row.

*Does your site sell any products that do NOT require the customer to enter a shipping address? *Yes, some PDF downloads. But the missing orders are for physical products that require shipping.

Thanks again.

I'm going to release a 1.3.2 version here very soon that will address a few things and also will "revert back" to a few older ideas that should remedy the missing orders. These look to be caused by some new SQL statements that were introduced which are making things a bit too restrictive. The goal is to rework them, but until then, it may be best to remove them for a version ... but I have yet to determine if that is best or not.

Ok, uploading a new version to the downloads area here.

This is version 1.3.2.

• It corrects the header export issue.

• I believe it addresses the problem with the export dropping certain orders.

• It adds a new field for determining shipping type (residential / commercial) which is needed by some shippers (like UPS) (thanks to Scott Wilson for this addition).

• It REMOVES the "state abbreviation" option from the export totally. Right now I think this was the main reason the export failed (that was one of the new items added in recent versions and is when a number of people reported exports stopped working.)

I do plan on adding that state functionality in again in a later release but wanted to make sure this version worked for everyone before I tried that again. If this version works then I can say we have a "new stable version" for working with.

If you want it now you can download it now from this link until it goes live in the zen cart downloads area.

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

Please leave feedback here letting me know if this corrects a number of the issues reported recently. I have been unable to duplicate most of them so I went back to the most recent stable release and then backed out the "new items" that were added (and reworked others to keep them) in an attempt to isolate the initial problems.

Thanks everyone.

econcepts:

Ok, uploading a new version to the downloads area here.

This is version 1.3.2.
One nice feature would be for the utility to remember the check boxes/radio buttons selected previously. Otherwise, you must makes those selection each time you run it.
I went in and manual set them the way I needed in the php file. But obviously this is not ideal.

econcepts:

If you want it now you can download it now from this link until it goes live in the zen cart downloads area.

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

Hi Eric,

Just wanted to let you know that the link on your download page for the Export add-on gives me a 404.

--Susie