Export orders to Spreadsheet / Excel to email to suppliers

[econcepts]

Basically the lines items of the cart...

Not sure how it would handle multi lines or even attributes...but basically what I'm looking for is a way to import the orders into a different database instead of manually retyping everything.

Order ID
Product
Qty
Model
Any Attributes
Price
Shipping Total
Order Total

Thanks for looking into it!
Michelle

Michelle,

Order Id is already in the export. Shipping total and Order Total are easy to add (had them in a version I was using). The other items I'll look at adding here.

I have an idea on the module that may make it easier for people. Let me do some work here and in the next build version, I'll have these items for you.

[VS4Hire]

Great, thank you so much!

Michelle

[apemusic]

Hi everyone!

wow thanks for all the help and econcepts, awesome work!!

Just with that shipping information exporter, I tried it out, but in order to be able to use it for our dropshipping there are some other important fields it must include, basically COMPANY NAME needs to go on the shipping labels as part of the address, also PHONE NUMBER I see the column heading in the export but no-ones phone numbers are actually exported (it is all blank below).
Of course we also need some fields with PRODUCT NAME and QTY to send to suppliers in the export. Lastly I would also like to export the NOTES field (extra info a customer types in, which the suppliers often need to see):

So extra fields in summary:
COMPANY NAME
PHONE NUMBER
PRODUCT ORDERED
QUANTITY ORDERED
NOTES

As mentioned this was what I needed before:

Name:
Company:
Address 1 :
Address 2 :
City :
State :
Zip Code :
Country :
Telephone:

Product Ordered:
Qty:
Notes:

Also with product ordered and qty, some customers order a few different products in the one order, so may be helpful to have extra columns, product ordered name A, product ordered quantity A, product ordered name B, product ordered quantity B, etc.

thanks everyone, cheers!

[econcepts]

apemusic,

Glad you like it so far. I am already working on version 1.1.0 which will include some recent requests. I'll put your's in the mix as well.

Thanks for the feedback.

[Hometownf]

I would like to have the items ordered exported as well if possible

[econcepts]

I would like to have the items ordered exported as well if possible

Yes, I have had that request a number of times now. It will be in the next version more than likely. I have most of the current requests in there now (BETA in the new version that I am completing). Just had a few thoughts doing it that may help other users after hearing all your requests.

[lyricwings]

Just wanted to say thank you for this mod!

I also would love for it to include not just the order # but the specific products ordered and the quantity of each.

Like others mentioned here, I'd also be using it to export info from ZC and then import it into another database.

Thanks so much for considering our requests, and for all your work!

~LW

[OneWorldStudios]

not sure if this helps, but this is the info i used to get from my old cart (it was the only good thing about it.)

OrderNo
PayerEmail
FirstName
LastName
Address
City
State
Zip
Country
Payment
Qty
ProductNo
Product
ExtPrice

[econcepts]

Order # is already in the current version.

The next version here should address the rest of the concerns. :)

[jessiebags]

Wow Econcepts, great contribution!! :) However I am in the same boat as VS4Hire and would like to be able to export product info also ... I will be looking forward to next version!!!