Export orders to Spreadsheet / Excel to email to suppliers

Hi Zenners,

Every time a customer places an order I have to fill out an order form in Excel and email it to my suppliers, the order form has fields like this below.

Surely it is possible for Zen-Cart to export certain orders into Excel? At the moment for every single order every day I am cutting and pasting into each field, there has to be a better way to export into Excel with these fields:

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

Product Ordered:
Qty:

I need to do this every day so ideally I could just put a checkbox next to several orders and have those exported?

cheers,
Dave

P.S. I see this thread: http://www.zen-cart.com/forum/showthread.php?t=54399
However how do you run an SQL query like that? Does that mean I have to login to my GoDaddy MySQL admin every day to do this? Still not sure how to run those SQL statements.

A button within Zen-Cart I could check and export would be great? Even better if I can tick and select certain orders only??

I would venture to guess that very few shop owners need or require orders to be in excel format...
So you are probably on your own obtaining this function and making it available in the admin

This could be a form of the order notification mail...but you need this in excel so a mysql export of the relavent order tables would be in order as a csv that you can then open in excel. Once you get this worked out you could then cron this to happen at some time each day...

Too bad you are with GoDaddy!!!

Surely it is possible for Zen-Cart to export certain orders into Excel? At the moment for every single order every day I am cutting and pasting into each field, there has to be a better way to export into Excel with these fields:

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

Product Ordered:
Qty:

I need to do this every day so ideally I could just put a checkbox next to several orders and have those exported?

I've got a mod I created to export ORDERS directly into Excel format (with the info you need here and more) that I used to integrate with UPS automatic shipping, scale (weight) and label printing for bulk orders.

Let me dig that out here and I'll send it over to you to download. It was accessible from the Tools Menu under the Admin.

Hang on a day or so. I'll get the files needed for it together.

It should do exactly what you want -- or need very little modification to get it to only include the fields you need. In mine, I had to include weight of the order etc.. as well as the shipping location.

Thanks econcepts! That module you are talking about sounds awesome I can't wait to check it out ...

Thanks Kobra as well, Godaddy seems fine though? Just now sure how exactly you export things and cron job though

hey econcepts

sounds like you have just what i need to link with our shipping people, would it be ok if you could let me have the export module you have

thanks buddy :)

studmuffin:

hey econcepts

sounds like you have just what i need to link with our shipping people, would it be ok if you could let me have the export module you have

thanks buddy :)

I sent it over in a PM to you a few days ago. Check your Private Message box. It should be there. :smile:

Hi econcepts.

I was just finding that kind of mod you made.

Can I use your mod too?

noa:

Hi econcepts.

I was just finding that kind of mod you made.

Can I use your mod too?

Not a problem. I didn't realize that so many users were looking for it. Let me put together an "official" contribution and I'll upload to the Zen site as well as send you a copy.

If you are versed in PHP, I could send you my altered file and you could mess with it to get it to do what you need. Just let me know.

I also need a mod like this ... I need to export order information in csv for my stamps.com program ... can I have the mod too? please? :smile:

jessiebags:

I also need a mod like this ... I need to export order information in csv for my stamps.com program ... can I have the mod too? please? :smile:

Yes, I am finishing up a full package to upload to the forums here. I didn't realize there was such a demand. It should be available in the coming days.

I am also looking for a mod like this, can I use it too?..
From the way it sounds it should make integrating UPS WorldShip, Fedex Ship Manager, and Endicia's DAZzle into my website a breeze.

Do you have to send an excel spreadsheet? I usually email each order to my distributer if I don't normally stock the item. So why not have the order emails simply bcc the order to distributer?

JP

Do you have to send an excel spreadsheet? I usually email each order to my distributer if I don't normally stock the item. So why not have the order emails simply bcc the order to distributer?

I don't know about everyone else but we stock everything we list on our websites with the exception of a few items (less then 100) which we have drop shipped. By time I get done we will probably have a little over 25000 line items listed on our site and we are hoping for 50-100+ sales per day. Right now we are using a custom made e-commerce solution which is starting to show its age and I am building a new test site with zen cart and a whole slew of mods. With any luck I will get the owner of the company to allow me to implement a zen cart based solution on all of our websites.

I could sure use this mod as well.
Be sure to let us know when you release it to the public.
Or, if you feel like sending it to me in the meantime that would be nice too.
:D
Thanks!

yongkoom:

I could sure use this mod as well.
Be sure to let us know when you release it to the public.
Or, if you feel like sending it to me in the meantime that would be nice too.
:D
Thanks!

Yeah, the plan is to release it sometime here within the next day or so. Once released, I'll post it to the contributions section and also post a message to this forum thread as well.

:smile:

can't wait... :)

Ok. The first version of "Export Shipping Information" is ready for download.

I uploaded the file tonight to the Contributions area so it should be ready for download from there within the next few days I would imagine.

For those of you that can't wait, you can **click here to download it now from my site**.

Enjoy!

Thank you for sharing the contribution!

If you ever get around to adding order information, I would definitely be interested in receiving a copy!!

Again, THANK YOU!
Michelle

VS4Hire:

Thank you for sharing the contribution!

If you ever get around to adding order information, I would definitely be interested in receiving a copy!!

Again, THANK YOU!
Michelle

I could pretty easily add order information as well. What part of the order information are you looking for?

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