Forums / General Questions / Export data from invoice totals to text file

Export data from invoice totals to text file

Locked

Views: 2,215

Results 1 to 8 of 8
This thread is locked. New replies are disabled.
21 Jun 2006, 3:46 PM
#1
cath avatar

cath

New Zenner

Join Date:
Jun 2006
Posts:
21
Plugin Contributions:
0

Export data from invoice totals to text file

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

23 Jun 2006, 8:06 AM
#2
cath avatar

cath

New Zenner

Join Date:
Jun 2006
Posts:
21
Plugin Contributions:
0

Re: Export data from invoice totals to text file

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.

2 Sep 2006, 5:22 PM
#3
eztrumpet avatar

eztrumpet

New Zenner

Join Date:
Aug 2006
Posts:
7
Plugin Contributions:
0

Re: Export data from invoice totals to text file

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.

2 Sep 2006, 11:30 PM
#4
cath avatar

cath

New Zenner

Join Date:
Jun 2006
Posts:
21
Plugin Contributions:
0

Re: Export data from invoice totals to text file

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

3 Sep 2006, 6:52 PM
#5
eztrumpet avatar

eztrumpet

New Zenner

Join Date:
Aug 2006
Posts:
7
Plugin Contributions:
0

Re: Export data from invoice totals to text file

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.

26 Oct 2007, 6:21 PM
#6
sooraj avatar

sooraj

New Zenner

Join Date:
Oct 2007
Location:
singapore
Posts:
25
Plugin Contributions:
0

Re: Export data from invoice totals to text file

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

26 Oct 2007, 8:12 PM
#7
cath avatar

cath

New Zenner

Join Date:
Jun 2006
Posts:
21
Plugin Contributions:
0

Re: Export data from invoice totals to text file

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

3 Nov 2007, 4:52 AM
#8
sooraj avatar

sooraj

New Zenner

Join Date:
Oct 2007
Location:
singapore
Posts:
25
Plugin Contributions:
0

Re: Export data from invoice totals to text file

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