Export data from invoice totals to text file

[Cath]

Hello. Is it possible to export the data from the invoice totals to a text file so that I can work with it in Excel?

I'd like the Date of Order, Invoice No., Payment Method, Customer Name, Tax, Total (excluding tax), Total (including tax).

I don't need the totals for the individual items the customer bought, just the totals for the invoice.

Can anyone provide code for this?

When I googled I found a person called Thom in one of the groups who creates a .csv file, but the thread was closed and he's uncontactable. I've checked the wiki, faqs, forum & downloads (just so you know I've made some effort!)

I'm not setting up the shopping cart myself so please don't assume any knowledge of Zen-Cart on my part. I'll forward any replies I receive to the developer.

Thank you in advance - Cath G

[Cath]

Hi again - I've posted some code in the downloads section & also a thread in the contributions section of the forum, if anyone else needs this feature.

[eztrumpet]

Hi Cath,
Appreicate your work on Export invoice function and works well and giving us a lot of help. Thank you!
I wonder how can I add more information on this contribution eg, customer's billing/shipping address, Item purchased, etc.
Please tell me how can I do this or you have any new idea or contribution could do this.

[Cath]

Hi, EzTrumpet - I'm sorry I can't help - I paid a RentACoder to make this mod for me. Regards - Cath

[eztrumpet]

Thanks cath, do you have this mod in hand? really no idea make an offer @RentAcoder. Could you please tell me more about your mod or may I share the cost of the mod with you since you have it already. Or anyway if you think I can donate to your mod hopefully.

[sooraj]

Hi Cath,
Does it works fine with 1.37 version???

[Cath]

Hi - the mod is in the downloads section - search for Excel.

I'm sorry, I have no idea whether it works with other versions of ZC.

All the best - Cath

[sooraj]

Hi,
Tested and works fine with 1.3.7 .. Thanks for posting the module.