Export orders to Spreadsheet / Excel to email to suppliers

[nils]

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

[Erik011]

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

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

[juniper]

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/showpo...0&postcount=10

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

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

[10gallons]

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?

[10gallons]

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.

[10gallons]

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

[juniper]

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

Thanks.