Monthly Sales and Tax Summary Report [support thread]

[skipwater]

Hi,

I'm thinking maybe the Product Cost has to be added while I'm adding the products... so this might be the wrong topic. But, maybe this module could include a feature where I could put in a product's cost(price I paid for).

Thanks much in advance!
ITF

Because the data comes from the orders and orders_total tables for this mod there is no way that it could report on product cost.

I think you are looking for something more like this.
http://www.zen-cart.com/index.php?ma...roducts_id=278

Skip

[IronTank]

Hi Skip,

that looks like what I need! Thanks so much for pointing it out to me!


ITF

[marcps]

This module is THE BEST MODULE on the whole of the Zen Site........

Thanks for your time creating it....

I have 2 small sugestions to turn it from a GREAT MODULE to an EVEN GREATER MODULE....

2 more columns.....

number of orders (in the month)
Average order value (for that month)

this will help the site owner see visitor growth and trend growth too.

Will happily beta test on some very large sites that your script is running on and creating great reports.

Do you have a paypal link for donations?

Marc

[skipwater]

marcps
Thank you for the compliment. My work load at this time does not allow me to do any enhancements. In time I will get back to this and add some of the items suggested.

Skip

[JimLink]

Because the data comes from the orders and orders_total tables for this mod there is no way that it could report on product cost.

I think you are looking for something more like this.
http://www.zen-cart.com/index.php?ma...roducts_id=278

Skip

I'm looking for the same as IronTank, adding a cost field.
I'll look into the link.

But, it is possible to add 'Payment Fees' on your Monthly Report?
(1) Basically, we would like a column for our Paypal fees listed.
(2) Can we select "Year" ? Right now 2008 & 2009 are listed.

Btw Skip... I agree with everyone else here, great mod.

-Jim

[skipwater]

Jim
But, it is possible to add 'Payment Fees' on your Monthly Report?
(1) Basically, we would like a column for our Paypal fees listed.
(2) Can we select "Year" ? Right now 2008 & 2009 are listed.

To my knowledge there is no where in ZC that Payment Fees are stored. So at this point I can't report them.

The years that you see/active are the available dates in your data base. As time passes the years will just be added to the list. I have not considered only showing one year at a time.

I use the report as a comparison against last years numbers with the detailed month information showing all past years month numbers.
This gives you a time line with plus or minus dollars per day on sales.

Skip

[barco57]

In the paypal table in the mc_fee field is where my paypal fees are stored on my ipn transactions

[skipwater]

In the paypal table in the mc_fee field is where my paypal fees are stored on my ipn transactions

Thanks for the info never needed to use paypal.
With 2.0 coming out this mod will need a rewrite so at that time I am hoping to add a few new functions.

Skip