Export orders to Spreadsheet / Excel to email to suppliers

[econcepts]

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.

[apemusic]

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

[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 :)

[econcepts]

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.

[noa]

Hi econcepts.

I was just finding that kind of mod you made.

Can I use your mod too?

[econcepts]

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.

[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?