Export Shipping & Order Information

Give it a try now. I had the file named differently from the link. All better. I just tested and it should download from that original link now.

I'm able to download it now.

I plugged in the updated shipping_export.php file and gave it a try. It exported a test order just fine. I'll give it a more thorough test soon, but for now it looks like it is working. :clap:

Super. Glad to hear the export worked. Please confirm once you test it out more if this is still the case.

I am using Zen Cart v1.3.9d and just have tried both export shipping v1.3.1 and v1.3.2.

I am a newbie and believe I have a fundamental problem, after install this add-on module, there is no order/shipping data shown on the page after I click the Tools-> Export Shipping/Order Information. Can see the page image from this link
http://dl.dropbox.com/u/8946671/shipping.png

I guess I might have missed some fundamental steps but have googled and checked whole day still not able to detect what went wrong.

Appreciate help! Thanks

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

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

3. Are you trying to export one product per row or one order per row?
   No data shown and no show of checked box on the right

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

There are few orders I have made,and I have checked the orders table, the downloaded_ship flag for these orders are "no"

A few ideas.

1. The only way you won't show orders is if you either have none, or if you already ran an export NOT in test mode and the orders were marked as exported OR if you have a problem with installing it (which it looks like is the case here.) To re-export them (even though they don't show on the list ... this list only shows new, non-exported orders) select the option to export previously exported orders.

2. Try to reinstall the module from beginning to end again. From the looks of your screenshot, the page just "stops" at some point and doesn't continue to load. You should see an entire set of options down the right hand side of the screen as well as a note that would say "no orders to export" (or something similar) even if there were no orders.

Make sure when you installed it you put all files in the proper locations and do not miss any.

Let me know if that helps.

Dear Eric,

Thank you for your prompt response and contribute this excellent piece of works.

I have solved the problem which due to some permissions problem for certain directory like extlib, etc.

Thank you again.

Hi, I just installed your mod, and I see a list of orders that need to be processed, but when I export them, I get a blank csv file (well, I get the headers, but that's all). Here is what I have the options set as:
Attachment #7944

Any ideas?

I have similar requirement to put in weight and quantity. This is for printing shipping order. May I know what are the places in shipping_export.php need to add in these fields ?

Thanks

csiadp:

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.

The update took care of this. Great work!

Running Version 1.3.2

Normally I have no problems. Yesterday I exported orders by day as I always do. However, I discovered that the last two orders for the day did not show up in the export file. I figured it was a date stamp issue, So I then did the orders for the next day. The missing orders were not there either. So then I exported the orders for both days. Bingo, the missing two orders appeared.

I always run it in test mode,
INclude Header
one order per row
various additional fields
Then the date.

Oh, one other slight issue. When you click the calendar it always appears obscured by the window. I have to widen the browser to see it. I use Firefox.

Great tool!

There is one thing missing from this tool. There is no weight exported. We are currently manually changing the weight for orders that exceed 1lbs. It should combine the weight of all items ordered for a given order.

It would be a big time saver. :clap:

kkfok1:

Dear Eric,

Thank you for your prompt response and contribute this excellent piece of works.

I have solved the problem which due to some permissions problem for certain directory like extlib, etc.

Thank you again.

This is great to hear. This could very well solve similar problems that others are having. So what permissions did you have to set in order to get it to work?

I realize that write permissions need to be set for the file to be sent to a directory (this is in the instructions) but what were the permissions that were not working and what alterations helped it work for you?

Drexlin:

Hi, I just installed your mod, and I see a list of orders that need to be processed, but when I export them, I get a blank csv file (well, I get the headers, but that's all). Here is what I have the options set as:
Attachment #7944

Any ideas?

1. Are you using the newest version? You should be using 1.3.2.

2. Check the post a few down that mentions alteration of permissions got it working for another user. Apparently on their server they had issues with the extlib directory etc... and needed to set different permissions for them in order for it to work.

Let me know if any of this helps.

kkfok1:

I have similar requirement to put in weight and quantity. This is for printing shipping order. May I know what are the places in shipping_export.php need to add in these fields ?

Thanks

Quantity is already included in the mod. Just select "product details" as an export option. I can easily add weight to the next version as an option. I have that in a customized version used for real time printing of packing slips on another computer so I can add that to this one.

split63:

Running Version 1.3.2

Normally I have no problems. Yesterday I exported orders by day as I always do. However, I discovered that the last two orders for the day did not show up in the export file. I figured it was a date stamp issue, So I then did the orders for the next day. The missing orders were not there either. So then I exported the orders for both days. Bingo, the missing two orders appeared.

I always run it in test mode,
INclude Header
one order per row
various additional fields
Then the date.

Oh, one other slight issue. When you click the calendar it always appears obscured by the window. I have to widen the browser to see it. I use Firefox.

Great tool!

Can you do me a favor and look at the DATE and TIME stamp on the two orders that did not print for you? The issue is likely related to that however I need to know those issues to look at what may correct it.

I suspect these two orders might have been completed near the "turn of the day" (where one day turns into another ... i.e midnight etc...)

econcepts:

This is great to hear. This could very well solve similar problems that others are having. So what permissions did you have to set in order to get it to work?

I realize that write permissions need to be set for the file to be sent to a directory (this is in the instructions) but what were the permissions that were not working and what alterations helped it work for you?

When I extract these files, the default was set to 700, so I just changed all directory to 755 and files to 644.

econcepts:

Quantity is already included in the mod. Just select "product details" as an export option. I can easily add weight to the next version as an option. I have that in a customized version used for real time printing of packing slips on another computer so I can add that to this one.

Sorry, I overlooked the quantity.:blush:

That is great to know weight will be added in the next version.:clap:

Is that possible if you allow me to have a preview of the "weight" version ? If so, my email is kkfok1<at>gmail<dot>com.

Many thanks.

econcepts:

Can you do me a favor and look at the DATE and TIME stamp on the two orders that did not print for you? The issue is likely related to that however I need to know those issues to look at what may correct it.

I suspect these two orders might have been completed near the "turn of the day" (where one day turns into another ... i.e midnight etc...)

Here are the timestamps for the last four of that day.
Aug 22, 2010 11:56:53 PM
Aug 22, 2010 11:58:28 PM
Aug 22, 2010 11:59:26 PM (failed to export)
Aug 22, 2010 11:59:44 PM (failed to export)