Export orders to Spreadsheet / Excel to email to suppliers

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.

Great, thank you so much!

Michelle

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!

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.

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

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.

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

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

Order # is already in the current version.

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

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:

Yeah, I'm just about there. Hoping to have it in the next few days at the latest.

This one is far better than the first. Since each user has different requirements, but all need the shipping address, etc.., I made it possible in this new version for you to actually select which "additional fields" you want included in the export file.

I also included a few other "bonus features" as well.

I have it running successfully on my test system. A screenshot of the newest version (to be released soon) is attached for reference.

Consider it a "sneak peak". :smile:

...sweet...

This looks wonderful. Thank you much!

This is just what I need, can I test the beta release please?

andes:

This is just what I need, can I test the beta release please?

Everybody is going to get to "test it" in the next day or so. I have one bug that just arose and am working that out. After that is out of the way, I think it's good to go.

I'll post here when it is ready, and upload to the Contributions section (updating the previous version 1.0.0 I initially released).

OK Everyone.

The new version of the Export shipping module is ready to go.

I uploaded to the contributions section here at Zen tonight (as an update to the previous version). I anticipate that being available and active within the next few days (sometimes they are faster with approving mods).

For those of you that want it now and can't wait, here is the link to a little more information on it:
http://www.zencartoptimization.com/2007/06/14/just-released-export-shipping-order-information-version-120-contribution/

And here is the link to my downloads page where you can get it (version 1.2.0) before it hits the "Zen Contributions" section.

Enjoy!
http://www.zencartoptimization.com/downloads/

This new version covers a lot of what users were asking for. There may be more to come in future releases. I think we're pretty close now though to the requested "wish list" you all provided.

great contribution! just a couple of things, wondered how easy or difficult to fix:

1. when a customer has purchased multiple products, every product appears on that line and then that line is repeated; is it possible to repeat the lines, but have each product appear in a single "product ordered" column? this would make it much easier to create tables and organize the data by type of item ordered etc.

2. is it possible to automatically have the field names included at the top of the spreadsheet? (in case it needs to be imported into a shipping program, it helps to have the headings).

3. foreign orders are causing the columns to go out of alignment (could be a setting in my excel? or maybe a blank space needs to be inserted in the u.s. orders to make it line up right?)

great work!

sorry...had some clearer ideas...but my editing time passed...

here's a better idea of what i meant...

1. it seems that orders are getting repeated; not sure why, it doesn't happen to every order...but most of them.

2. when a customer has purchased multiple products, currently every product appears on that line. is it possible to repeat the lines and have each product appear in a single "product ordered" column? (bonus: include each item's price as well for a quick daily revenue count)... this would make it much easier to create tables and organize the data by type of item ordered etc. and be easier to pick and pack.

3. is it possible to automatically have the field names included at the top of the spreadsheet? (in case it needs to be imported into a shipping program, it helps to have the headings).

4. foreign orders are causing the columns to go out of alignment due to address line 1, 2, 3. is it possible to fix the address section to include all the possible address fields? (this would align everything)

OneWorldStudios:

sorry...had some clearer ideas...but my editing time passed...

here's a better idea of what i meant...

1. it seems that orders are getting repeated; not sure why, it doesn't happen to every order...but most of them.

2. when a customer has purchased multiple products, currently every product appears on that line. is it possible to repeat the lines and have each product appear in a single "product ordered" column? (bonus: include each item's price as well for a quick daily revenue count)... this would make it much easier to create tables and organize the data by type of item ordered etc. and be easier to pick and pack.

3. is it possible to automatically have the field names included at the top of the spreadsheet? (in case it needs to be imported into a shipping program, it helps to have the headings).

4. foreign orders are causing the columns to go out of alignment due to address line 1, 2, 3. is it possible to fix the address section to include all the possible address fields? (this would align everything)

See if I can cover some things here for you.

1. I know why this "could" happen (it happened during testing once and I thought is was corrected). To diagnose, can you spot a "pattern" of when it happens? (Like when 3 products are added, like when there are multiple attributes, etc...)

2. Actually, my personal preference is to include EACH order per LINE instead of "each order per column" as it is now. However, so many people asked for it the way it is now, I figured that was the "safest bet". I'll work on another version here in the coming weeks once I get some more feedback. In that version I will attempt to give you the option of printing out "1 product per row" or "multiple products per row (as it is now).

As for the product pricing, that is not a problem to add. Pretty easy there.

3. Yes, and no. I had the headers in the original version, but due to the way people wanted the export to happen (different length records), it was hard to create a "standard header row". My plan was in the next version to figure out a way around that and provide header info as well.

4. Can you send me an example of an address (foreign) and using FAKE info (but in the same format as it comes across to you) so I can look at that.

Thanks!

I'm so excited - thank you so much for this add!!

Question - I did my first export and I selected to open the file instead of save it. It said the file could not be read, and the file size is 0.
This could very well be because I selected Open and not Save - I've encountered that problem before - so it may not even have anything to do with your module.

However, I can't try again with the Save option to see if I can export successfully because it thinks I've already exported everything, so there are no records to export.

Is there a workaround for this -- to re-export items that it thinks I've already exported?

Thanks!