Export orders to Spreadsheet / Excel to email to suppliers

First off, thank you so much, eConcepts. I'm always impressed with how helpful people are to other users. This add-on is an essential one.

I've searched and searched but can't figure this one out. When I export orders, there is no 'State' field. I saw that the state field was commented out in the .php files so I uncommented them out. Now the field is there in the .xls files but is blank. Any ideas? Also, is it possible to export all of the other data from the order as well? This could include order total, comments, payment method, etc.

Thanks in advance for any help anyone can offer.
http://www.utahwoodturning.com

-Nils

Hi and MANY THANKS for a great module!

I just installed it, but have an issue. Although I have not downloaded/exported anything there is no "export" button. I also tried the SQL query to reset the downloaded to "no" - just in case. But still no "export" button???
Also a strange thing is that I do not see the latest orders in your module.

Apart from this all seems OK, like in the screenshot.

I´m running Zencart 1.3.8a, on PHP 5.2.5 (Zend: 2.2.0). I also have Swedish installed as language (which messed up things before I copied shipping_export.php to swedish/extra_definitions).

Did I miss something in the install, or maybe something in my SQL-database?

Thanks for any help

Erik, Sweden

I've not set the time aside to read the last 17 pages, but I think this may be the answer to my question. Here is my question, and the question I have after reading a part of this thread.

1. Is there a way that I can download the customer information, their orders, etc? I'm using the shopping cart as a registration form so I need to be able to provide all this information to the people that make the nametags, order the food, etc.

And if this is the mod I am looking for, where can I get it?

Thanks for your help!

No worries - I've figured it out and have successfully downloaded the mod, and corrected the errors that were brought to my attention with the mod. I had to upload the newer files of the html_output files found here: http://www.zen-cart.com/forum/showpost.php?p=487360&postcount=10

Thanks for the mod, I hope it works well once we open up for registration!

Hi,

I uploaded version 1.0.0, ran the sql command and it worked OK, but I didn't have an entry in my Tools menu for Export Shipping/Order Information. I upgraded to 1.2.3, overwrote the old files, didn't re-run the sql command and I still don't have the Export Shipping/Order Information command in my Tools menu.

I'm using Zen Cart 1.3.8. Any ideas what might be going on?

Many thanks in advance.

juniper:

I've not set the time aside to read the last 17 pages, but I think this may be the answer to my question. Here is my question, and the question I have after reading a part of this thread.

1. Is there a way that I can download the customer information, their orders, etc? I'm using the shopping cart as a registration form so I need to be able to provide all this information to the people that make the nametags, order the food, etc.

And if this is the mod I am looking for, where can I get it?

Thanks for your help!

You can find it here.

10gallons:

Hi,

I uploaded version 1.0.0, ran the sql command and it worked OK, but I didn't have an entry in my Tools menu for Export Shipping/Order Information. I upgraded to 1.2.3, overwrote the old files, didn't re-run the sql command and I still don't have the Export Shipping/Order Information command in my Tools menu.

I'm using Zen Cart 1.3.8. Any ideas what might be going on?

Many thanks in advance.

I just had a look in phpMyadmin and not being an sql guru or anything but I did manage to see the 'download_ship' entry in the 'zen_orders' table.

I just don't have an "Export Shipping/Order Information" entry in my Tools menu.

Any ideas?

Sorry I'm an idiot. One day I learn to copy files to their correct location. Please delete these posts in the thread if you wish.

One thing I'd like to be able to do is ... My product has 3 visitor selectable attributes, I can see these in the report I get, but it would be great if they could all be in their own column with their descriptive field removed. At the moment I get this ...

Packaging & Handling: $X.00 per bar | Height (in mm's): 550 | Width (in mm's): 510 | Colour: black |

in a single column called Product 0 Attributes. It'd be great to get Height, Width and Colour exported into their own columns, but without the wording of Height Width and Colour in the column as well, if that makes any sense.

Also, all the text on the right hand side where you select your options is all text_this and text_that. Like this ...

TEXT_ADDITIONAL_FIELDS
TEXT_SHIPPING_METHOD_FIELD
TEXT_SHIPPING_TOTAL_FIELD
TEXT_PHONE_NUMBER_FIELD
TEXT_ORDER_TOTAL_FIELD
TEXT_ORDER_DATE_FIELD
TEXT_ORDER_COMMENTS_FIELD

Is that normal??

The only columns that are populated are the email and order id. Is there something I am missing?

Thanks.

Can anyone help? When I do an export the customer's information does not export. Is there something I am doing wrong, a box I need to check off? :( Thanks.

The columns that are empty are:
First Name Last Name Company Delivery Street Delivery Suburb Delivery City Delivery State Delivery Post Code Delivery Country

hi, thank you for this mod, i need it very much, but i got a problem, the customer names and addresses on my order page including the special characters é è ç , after i export the information, those characters become ? ? ? , :unsure:

myworld20091:

hi, thank you for this mod, i need it very much, but i got a problem, the customer names and addresses on my order page including the special characters é è ç , after i export the information, those characters become ? ? ? , :unsure:

This is not my mod but I have run into similar situations with other internet related items and typically the situation you are listing is a result of the HTML page "character set" being used. For example, if the page character set is UTF-8 and you export in a different character set format (or don't recognize the UTF-8 conversion) then characters you think should bee one thing change themselves to be another.

It sounds like that is what you are experiencing, but again, since this is not my mod I don't know how it works with character sets etc...

Hope that helps.

econcepts:

This is not my mod but I have run into similar situations with other internet related items and typically the situation you are listing is a result of the HTML page "character set" being used. For example, if the page character set is UTF-8 and you export in a different character set format (or don't recognize the UTF-8 conversion) then characters you think should bee one thing change themselves to be another.

It sounds like that is what you are experiencing, but again, since this is not my mod I don't know how it works with character sets etc...

Hope that helps.

i cant get it work but i have an idea, perhaps i could display all the columns on the page shipping_export.php, then copy and paste them to my excel?
i dont know what do i make all the colums showing on shipping_export, currently there are 10 colums:
Order ID, Email, Customer Name, Company, Delivery Street, Delivery Suburb, Delivery City, Post Code, State, Country
i need to show all the others:
Shipping Method, Shipping Total, Phone Number, Order Total, Order Date, 1st Order Comment, Full Product Details, Order Tax Amount, Order Subtotal, Order Discount, Payment Method, Order Status
could you help me with this modification? thanks in advance.

myworld20091:

i cant get it work but i have an idea, perhaps i could display all the columns on the page shipping_export.php, then copy and paste them to my excel?
i dont know what do i make all the colums showing on shipping_export, currently there are 10 colums:
Order ID, Email, Customer Name, Company, Delivery Street, Delivery Suburb, Delivery City, Post Code, State, Country
i need to show all the others:
Shipping Method, Shipping Total, Phone Number, Order Total, Order Date, 1st Order Comment, Full Product Details, Order Tax Amount, Order Subtotal, Order Discount, Payment Method, Order Status
could you help me with this modification? thanks in advance.

Ah, now it sounds like you're talking about the module I created. The columns / options you are listing are those that are in my mode.

I could help you with customization of this to make it work for you.

Send me a private message and we can go over the details.

I could look at this today if needed.

• Eric

Great contribution!

I am having a similar issue to the ones previously described. I have gone back and attempted that fix that was described back in post 69 but that line seems to already been removed most likely when the newest version was released.

When I export orders, I only get 4 in the csv while I have a couple hundred orders displayed on the screen. These four orders also happen to be the ones that I created from the back end using the Add Customer module.

I have since uninstalled the Add Customer module as well as all other add ins to my cart and run the appropriate sql queries to uninstall them, I uninstalled and reinstalled this module, and I created a new order - same problem!

I am out of ideas to resolve it, please help!!!

Rich

Hi there

I have one quick question about Export Shipping Information mod.

Is it possible to export customers email addresses only into the spreadsheet, as this is what I need to do.

Also, is it quite safe to install this mod, as I have no idea how to back up my website and I don't have an access to mysql

Cheers in advance

Hi,

I hope someone can help me. I used to use the addon some time ago on 1.3.7 and was working great. An excellent module.
I have now created a new site and using 1.3.8a.
I have tried using all the options but no information is downloaded. I get all the information showing on the left hand side. All I get are the field names and no orders data. I always use test mode so they can be re-expored if required.
I dont know if there is a problem with this in 1.3.8a?
I have updated with the SQL statement. So cant see where I am going wrong, some help would be really appreciated if possible.

Many Thanks
Samantha

ffemtshok:

Great contribution!

I am having a similar issue to the ones previously described. I have gone back and attempted that fix that was described back in post 69 but that line seems to already been removed most likely when the newest version was released.

When I export orders, I only get 4 in the csv while I have a couple hundred orders displayed on the screen. These four orders also happen to be the ones that I created from the back end using the Add Customer module.

I have since uninstalled the Add Customer module as well as all other add ins to my cart and run the appropriate sql queries to uninstall them, I uninstalled and reinstalled this module, and I created a new order - same problem!

I am out of ideas to resolve it, please help!!!

Rich

The most recent version had a few bugs in it that are corrected in my version 1.2.7 (soon to be released).

The most stable version is 1.2.5 at the moment.

safeg:

Hi there

I have one quick question about Export Shipping Information mod.

Is it possible to export customers email addresses only into the spreadsheet, as this is what I need to do.

Also, is it quite safe to install this mod, as I have no idea how to back up my website and I don't have an access to mysql

Cheers in advance

It is safe to install this mod.

But to export just email addresses only I recommend the following module by Dr. Byte:

Email Address Exporter