Monthly Sales and Tax Summary Report [support thread]

well doing that does provide an end around to the fact the dropdown isn't populating but on clients site I can hear the whining already....I have one client with 12 statuses......not that he needs all of them but who am I to tell him any different......

Well it looks like there is a conflict in the code.
I have changed the drop down code in this file let me know if it works.

Skip,
the code that was in the file did not work properly,

However im sure Barco will send you the corrected file....

Ok here is what we have and works like a champ

Thanks for the help I need to get better at looking at code.

Skip

Which one of these would be the latest file to download? The one in the original post (was it updated) or one of the others? Thank you!

The one in my post is just one of the files that needed to be adjusted. I don't know if the whole module is being updated or not.

Verision 1.3 has barco57 update
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_41&products_id=1043

Thank you to both of you! Wish me luck installing it :)

This seems like a great module, I love modules that don't make you edit any of the files. One problem, I'm getting inaccurate tax totals.

I'm guessing this is because I'm using the local sales tax module
http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=623

for example;
I have 3 local taxes and a state tax that gets collected.

My "total" for the month is $3.90 on the main report page

When I click that total to get a detailed report, I see my local taxes;
(// entry for popup display of tax detail
// show=ot_tax )

    0.08 - local
0.04  - local 
0.07  - local
    5.97  - state

So I'm not sure where the $3.90 total is coming from, it looks like the query is selecting only the standard sales tax.
around line 446
// Retrieve totals for products that are NOT zero VAT rated
I'm not sure how to setup the correct query for this at the moment.

I'm using this for tax tracking for now;
http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=768

I have not had the need to use local sales tax module. So I have no test bed setup.
In time I will most likely need to add that mod because you know the gov needs more money. So I will be working on it.

To bad you can't back bill the gov for all the add bookkeeping you need to do.
Say a 10% collection fee :D

I just wanted to say thank you. This is exactly what we needed!

Hi,

I don't know if I'm asking this in the correct topic. If not, I apologize and please direct me to the right topic. :oops:

I want to keep track of the product cost( the price I pay for) and the price I sell it for, so that I can keep track of Revenue. So, in addition to the sales reports, I was wondering if this module have revenue reports.

I had thought this is what the NET and GROSS prices are for while adding the products, but after some research it turns out they are for taxing products.

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 :bigups:

IronTank:

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 :bigups:

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?main_page=product_contrib_info&cPath=40_41&products_id=278

Skip

Hi Skip,

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

ITF

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

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

skipwater:

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?main_page=product_contrib_info&cPath=40_41&products_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

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

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