The report data comes from the orders and orders_total tables of your database. So if your new business site started with a clean database there should be no values.
Skip
Printable View
Hello,
I have this mod installed that figures out profit:
http://www.zen-cart.com/index.php?ma...roducts_id=278
Any way you can take a look and see if it is possilble to add a profit column to your mod? It'd be great to show Tax collected, Gross Sales, and Gross Profit all on the same page, separated by Month and Year like you have.
Great mod, btw!
Does anyone know if this works with 1.3.9 and PHP 5.3?
I'm sure I'm missing something really obvious as I'm relatively new to Zen Cart. I've installed the files for this addon but their not showing up under the reports menu.
I have successfully installed a couple of shipping modules, COWOA so I'm not quite that green... but green enough apparently.
I did put them in their respective folders in the admin file on my server.
I'm running 1.3.9h
I've spent more than a couple of hours looking for a thread. Thanks for any help,
David
Thank you Skip,
I'm still wrapping my head around the file structure. I haven't renamed my folders, except for my template. So I assumed that the files would go in the admin folder and structure on the server. But because of your post I took a closer look at the actual address of my admin section and realized I wasn't looking at my admin directory but instead my manage directory. Moved the files and of course, they showed up in my admin section.
Thanks,
David
Hi, like the mod so far, however, I have two tax classes for the netherlands, one at 6% and the other at 19%. Both tax classes are installed properly (they work fine when items are sold) however when using your mod I only see a total tax collected. When I click on the "tax" number to get the details I get something like this:
2010/12
: 1,658.50
Only showing the amount but not listing the tax classes. Also, this number is considerable lower than the actual taxes collected (the number I clicked on). I really would love this to work so I can stop paying the tax office 19% on things I charged only 6% for! Can you direct me on where to look for the error? Does this have something to do with the mod? I imagine I have overlooked something...
I am using 1.3.9f
Any help would be greatly appriciated.
Cheers,
jeff
Look at your
table orders_total
How are you storing the %6 tax and the 19% tax is there another class? And if so what is its name.Code:orders_total_id ... orders_id .. title .................... text .......... value ... class ....... sort_order
67 ............... 20050 ...... Sub-Total: ............... $30.00 ........ 30.0000 . ot_subtotal . 1
68 ............... 20050 ...... UPS (1 x 26.4lbs) (Ground) $13.01 ........ 13.0100 . ot_shipping . 2
69 ............... 20050 ...... TAX 4.5%: ............... $1.35 ......... 1.3500 . ot_tax ...... 3
70 ............... 20050 ...... Total: ................... <b>$44.36</b> . 44.3600 . ot_total .... 4
If you look in admin/stats_monthly_sales.php you will find queries getting the class info and you most likely have a class name unknown to this mod.
Skip