Re: Export orders to Spreadsheet / Excel to email to suppliers
Quote:
Originally Posted by
VS4Hire
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.
Re: Export orders to Spreadsheet / Excel to email to suppliers
Great, thank you so much!
Michelle
Re: Export orders to Spreadsheet / Excel to email to suppliers
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!
Re: Export orders to Spreadsheet / Excel to email to suppliers
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.
Re: Export orders to Spreadsheet / Excel to email to suppliers
I would like to have the items ordered exported as well if possible
Re: Export orders to Spreadsheet / Excel to email to suppliers
Quote:
Originally Posted by
Hometownf
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.
Re: Export orders to Spreadsheet / Excel to email to suppliers
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
Re: Export orders to Spreadsheet / Excel to email to suppliers
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
Re: Export orders to Spreadsheet / Excel to email to suppliers
Order # is already in the current version.
The next version here should address the rest of the concerns. :)
Re: Export orders to Spreadsheet / Excel to email to suppliers
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!!!:smile: