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??
Re: Export orders to Spreadsheet / Excel to email to suppliers
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!!!
Re: Export orders to Spreadsheet / Excel to email to suppliers
Quote:
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.
Re: Export orders to Spreadsheet / Excel to email to suppliers
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
Re: Export orders to Spreadsheet / Excel to email to suppliers
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 :)
Re: Export orders to Spreadsheet / Excel to email to suppliers
Quote:
Originally Posted by
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:
Re: Export orders to Spreadsheet / Excel to email to suppliers
Hi econcepts.
I was just finding that kind of mod you made.
Can I use your mod too?
Re: Export orders to Spreadsheet / Excel to email to suppliers
Quote:
Originally Posted by
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.
Re: Export orders to Spreadsheet / Excel to email to suppliers
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:
Re: Export orders to Spreadsheet / Excel to email to suppliers
Quote:
Originally Posted by
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.