Export Shipping & Order Information

Hi there,

I am having real problem with installation.

I have followed all instructions and when i open my admin and click on export shipping/order information i get internal server error:

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Any ideas what's wrong with it?

I am using Zen Cart 1.3.8a

Thanks

dpalmer4217:

Hi,

We are running our report and beyond the testing data (live customer info), the reports are NOT including name (first or last) and address.

Any ideas why it would have been doing it, now it is not?

v1.3.9h

Thanks

That is a good question. I have no specific answer for you but we can certainly try to get to the bottom of why it is happening.

If it works in test mode it should work in live mode. The queries are the same in both. The only difference is one single element is left out of the test and that is the update query to set each order to 'downloaded'. Other than that, everything else is identical.

Is everything you are selecting (from test to live) exactly the same (no changes at all)?

solidrock:

I am using this on 1.3.8a installation, and it works great. I was wondering if you could implement, or tell me how to be able to export only a certain group of orders, based on group pricing. I am no programmer, and maybe there is a simple way to do this. It would be a huge help. Thank you.

There is no way to do this from the admin. It would require custom programming (not sure how much as I haven't looking into it.) You would likely need to alter a number of SQL queries to include the information desired to segment by group pricing.

vita:

Hi there,

I am having real problem with installation.

I have followed all instructions and when i open my admin and click on export shipping/order information i get internal server error:

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Any ideas what's wrong with it?

I am using Zen Cart 1.3.8a

Thanks

An internal server error means you did something wrong somewhere on install (obviously) or that your server has issues handling the requests needed to run the program (very unlikely as this should run on any reliable server.)

The 404 error document has nothing to do with the install as such. If you are getting that, it means you are missing file(s) that are required to run the program.

Make sure you go back and ensure ALL files are uploaded and in the proper location.

Hi, Thank you for this Mod, I hope to have it working soon.

I just installed the version 1.3.2 on my ZC 1.3.9h.

My issue is that in the menu bar under tools there is not
Tools > Export Shipping/Order Information

I uploaded the complete admin folder (and verified that the files are there on the remote server) but I may have misunderstood the directions on line #2

2)Login Admin > Tools > Install SQL Patches and run the query (copy and paste into the admin to run) found in the "INSTALL.sql" file provided with the download.

I opened the INSTALL.sql, copied the contents and pasted it in the first text box "Enter the query
to be executed:"

I clicked "Send" and did not get an error, I assume everything worked fine. I tried logging out and back in but there is still not an "Export Shipping/Order Information" under Tools (or anywhere else on the menu).

Your help would be greatly appreciated.

Thank you,

Brian

A quick update to my post above. I just looked at the mysql files and I believe there should be one called "downloaded_ship" Is this correct? I do not have this added to the mysql.

I'm guessing that I'm misunderstanding #2 in the directions.

Any help is greatly appreciated.

Thank you,

Brian

Sorry, I do not see a link to edit my post so I am replying to it.

More info. I just checked all the php files in the admin folder that I uploaded and they are 644. Should they be something different?

So I tried to copy the contents of the INSTALL.sql into the Install SQL Patches page again and received

" Failed: 1
ERROR: Cannot ADD column downloaded_ship because it already exists.
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

So apparently downloaded_ship is there.

Still can not find "Export Shipping/Order Information" in the Tools menu. Pulling hair out.

I saw this line too

NOTE: If there are no orders found to export, then the "Export" button will not show.

I was doing test purchases under a current account so I made a purchase with a new account and it still does not show the "Export Shipping/Order Information" under Tools.

I'm hoping someone can assist me.

Thank you,

Brian

I have one other mod, Fast and Easy Checkout. Would this cause any problems?

brihan:

I have one other mod, Fast and Easy Checkout. Would this cause any problems?

No, it won't cause any problems.

brihan:

So I tried to copy the contents of the INSTALL.sql into the Install SQL Patches page again and received

" Failed: 1
ERROR: Cannot ADD column downloaded_ship because it already exists.
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

So apparently downloaded_ship is there.

Still can not find "Export Shipping/Order Information" in the Tools menu. Pulling hair out.

If you don't see the drop down (it doesn't matter if there are orders in your db or not ... you still should see the add on link under "Tools".)

1. Check to see if you have something like "Admin Profiles" installed. If so, make sure the sure you are logged in under has permission to view the new add-on.

2. If the above does not work then check to make sure you have uploaded all files to the correct locations. The SQL patch has nothing to do with installing the drop down link (that is strictly file related.)

3. You can ignore the error message about the download_ship field already being in place. It means you already installed the SQL patch and it worked.

Let me know if that helps.

Thank you econcepts.

As I was going through your reply I realized that I had made a bone head mistake. In my local directory there was admin and then another renamed admin folder. I read the directions and was warned about this but was fooled by the admin file that was in my system.

I uploaded to the proper folder and now have the link.

So I have advanced and now have the link and can get into the program however I am not getting all the information for each account (see the gif below).

When I export the CSV it includes information in:
*Order ID
*Customer email
*Ship Dest Type
*Customers Telephone
*Order Total Order notes (Credit card AUTH info, not the comments from the customer)

The headers are there for all fields but no info other than the fields I listed above.

Once again any help would be greatly appreciated.

Thank you for your time.

Brian

brihan:

Thank you econcepts.

As I was going through your reply I realized that I had made a bone head mistake. In my local directory there was admin and then another renamed admin folder. I read the directions and was warned about this but was fooled by the admin file that was in my system.

I uploaded to the proper folder and now have the link.

So I have advanced and now have the link and can get into the program however I am not getting all the information for each account (see the gif below).

When I export the CSV it includes information in:
*Order ID
*Customer email
*Ship Dest Type
*Customers Telephone
*Order Total Order notes (Credit card AUTH info, not the comments from the customer)

The headers are there for all fields but no info other than the fields I listed above.

Once again any help would be greatly appreciated.

Thank you for your time.

Brian

What happens if you export it and select "include previously downloaded orders" (one of the options)?

Hi Econcepts,

Thank you for the reply.

I have tried many combinations of options (and use "Include orders already downloaded in export") and the results are always the same. I never receive data for

First Name
Last Name
Company
Delivery Street
Delivery Suburb
Delivery City
Delivery State
Delivery Post Code
Delivery Country

Now that has me thinking. My cart is used as a registration for an event so there is no shipping. Would that make a difference?

I was thinking that it was going to give me the information for the customer account but now that I think about it I bet you are getting the information from the shipping. That makes sense.

I think I just answered my own question.

OK, let me go change one of my registration to require shipping and see what happens.

I thank you for your help and hope I have not wasted to much of your time.

brihan:

Hi Econcepts,

Thank you for the reply.

I have tried many combinations of options (and use "Include orders already downloaded in export") and the results are always the same. I never receive data for

First Name
Last Name
Company
Delivery Street
Delivery Suburb
Delivery City
Delivery State
Delivery Post Code
Delivery Country

Now that has me thinking. My cart is used as a registration for an event so there is no shipping. Would that make a difference?

I was thinking that it was going to give me the information for the customer account but now that I think about it I bet you are getting the information from the shipping. That makes sense.

I think I just answered my own question.

OK, let me go change one of my registration to require shipping and see what happens.

I thank you for your help and hope I have not wasted to much of your time.

Yes, without the shipping it could pose problems as the system is built to pull based on shipping information.

Let me know what happens when you change it.

That solved the problem.

In my product listing I changed it to "No, Shipping Address Required" and "Yes, Always Free Shipping"

It adds the free shipping field on the checkout which I did not want but I will work through that so I can capture the information for export.

One other question that I think I saw somewhere else but can't remember where.

Is there a way to export the customer comments that are entered on the checkout page? Right now the comment field that is exported is the credit card info.

Thank you again for your help.

Brian

Just downloaded and installed - no problems.

Reading through this thread I have seen references to 'test mode' and 'product per row' and 'order per row'

where and how are these configured?

AM I being thick - I havent spotted any configuration liks.:unsure:

tsrplatelayer:

Just downloaded and installed - no problems.

Reading through this thread I have seen references to 'test mode' and 'product per row' and 'order per row'

where and how are these configured?

AM I being thick - I havent spotted any configuration liks.:unsure:

These are found in the same area as the rest of the configuration options for the module (and where you actually perform the export).

Tools > Export Shipping and Order Info

:blush:I dont have Tools > Export Shipping and Order Info
I have Tools > Orders Export - click this and I go to Mat's Orders Exporter page. (which does export order details)

When I installed I renamed the 'Admin' install folder to match my the name of my admin folder.

Ah - ha - there are 2 different add ons for exporting orders
Orders Exporter 1.0 and Export Shipping Information 1.3.2

I'lll try installing the 'other' one -:oops: