Forums / General Questions / Would like a report of invoice information

Would like a report of invoice information

Views: 537

Results 1 to 4 of 4
23 Sep 2012, 6:07 AM
#1
kzabbott avatar

kzabbott

New Zenner

Join Date:
Sep 2012
Posts:
3
Plugin Contributions:
0

Would like a report of invoice information

I am new to Zen Cart, although feel pretty good about what I've accomplished so far :smile: - I'm setting up a site for a Christmas Tree Sales fundraiser for my church (http://www.saintmarkschristmastrees.org)

We have 16 products (different trees), and the choice at checkout for pickup (free), or delivery ($20).

Where this seems to fall short for me is in the area of reporting. What I really need is a report that will show pretty much everything that would be on an invoice:

Date of Purchase, order number, Customer Last Name, Customer First Name, Qty, Product/Item Name, cost, shipping method, customer address

Best option would be to be able to export this to Excel.

It really doesn't appear that this type of report exists within Zen Cart, or via any of the numerous addons for ZC 1.5 that I've looked through/tried to install.

I am really hoping this isn't something I'll (have to have someone else) write a custom SQL query to pull off.

Any help from the more experienced users out there would be greatly appreciated!

Zachary

(p.s., if I posted this in the wrong place, please forgive me and let me know where it should be posted!)

23 Sep 2012, 6:27 AM
#2
frank18 avatar

frank18

Deceased

Join Date:
Nov 2007
Location:
Sunny Coast, Australia
Posts:
3,427
Plugin Contributions:
2

Re: Would like a report of invoice information

kzabbott:

......I am really hoping this isn't something I'll (have to have someone else) write a custom SQL query to pull off.....

I am afraid to say that this may be necessary - sorry

NOTE: We are sorry that Frank is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

23 Sep 2012, 11:59 PM
#3
kzabbott avatar

kzabbott

New Zenner

Join Date:
Sep 2012
Posts:
3
Plugin Contributions:
0

Re: Would like a report of invoice information

I believe I just found what I need - http://www.zen-cart.com/downloads.php?do=file&id=406

It's title, "Export Shipping Information" doesn't really do it justice; the actual file when you download it is "Export Shipping and Order Information" which it does, allowing one to select all kinds of additional fields.

The creator of this add-on is my new hero!!

24 Sep 2012, 7:12 AM
#4
frank18 avatar

frank18

Deceased

Join Date:
Nov 2007
Location:
Sunny Coast, Australia
Posts:
3,427
Plugin Contributions:
2

Re: Would like a report of invoice information

kzabbott:

I believe I just found what I need - http://www.zen-cart.com/downloads.php?do=file&id=406

It's title, "Export Shipping Information" doesn't really do it justice; the actual file when you download it is "Export Shipping and Order Information" which it does, allowing one to select all kinds of additional fields.

The creator of this add-on is my new hero!!

Wasn't aware of this mod - sounds like a very useful tool.

NOTE: We are sorry that Frank is no longer with us.
We are grateful for all his contributions to the Zen Cart community.