Export Shipping & Order Information

[split63]

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?

[split63]

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?

[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

[econcepts]

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!

[split63]

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,

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

[econcepts]

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.

[econcepts]

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.

[split63]

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.

[susb8383]

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