Export Shipping & Order Information

[econcepts]

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

No, it won't cause any problems.

[econcepts]

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.

[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

[econcepts]

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

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

[econcepts]

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.

[brihan]

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

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

[econcepts]

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.

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

[tsrplatelayer]

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 -