Export Shipping & Order Information

[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

[econcepts]

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)?

[econcepts]

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.

[econcepts]

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.

[brihan]

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

[brihan]

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

[brihan]

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?

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

[brihan]

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

[brihan]

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