Monthly Sales and Tax Summary Report [support thread]

barco57:

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

Hi Skip - thanks for a great add-on! I wanted to ask, is it possible to add in a the Payment Fee into the report? We use PayPal and it would be great to get an idea of their fees. I see them on the order page, but did not know if I started poking around, if it was even possible to modify your add-on to include that and before I started, want to consult with you.
Let me know your thoughts when you can and if you have the time. I am already grateful for this contribution and do not wish to burden you. Thank you. Joe

PayPal has a stored value that can be use. As You can see barco57 posted.

If you have the time your welcome to add and improve the report.

It is always nice to see that people are willing to give back to the community.

in my report where it displays "Gift Vouchers" amount, it is actually showing my shipping insurance. how do i change the text to read "shipping insurance"?

thanks

ams30gts:

in my report where it displays "Gift Vouchers" amount, it is actually showing my shipping insurance. how do i change the text to read "shipping insurance"?

thanks

Edit file admin/includes/languages/english/stats_monthly_sales.php
around line 47 you will find:

define('TABLE_HEADING_OTHER', 'Gift<br> Vouchers');  // could be any other extra class value

Change to:

define('TABLE_HEADING_OTHER', 'Shipping<br>Insurance'); 

Skip

skipwater:

Edit file admin/includes/languages/english/stats_monthly_sales.php
around line 47 you will find:

define('TABLE_HEADING_OTHER', 'Gift<br> Vouchers'); // could be any other extra class value

> 
> Change to:
> ```
define('TABLE_HEADING_OTHER', 'Shipping<br>Insurance'); 

Skip

thanks worked perfect

don't know what i could have done wrong. i copied everything over to the corresponding directory, and when i load reports/monthly sales it gives me a 404 Not Found error. :I

mooomers:

don't know what i could have done wrong. i copied everything over to the corresponding directory, and when i load reports/monthly sales it gives me a 404 Not Found error. :I
Double check where you copied the files to and that you copied all the files. The file not found is one or two things. a. The file is not where it belongs. b. The file was never copied to where it belongs.

Skip

weird.. i double checked and tripple checked on my ftp server and the files are there in the corresponding directories. this is driving me crazy. i must be missing something somewhere!

mooomers:

weird.. i double checked and tripple checked on my ftp server and the files are there in the corresponding directories. this is driving me crazy. i must be missing something somewhere!

What is the file name the url is calling that is giving you the 404 error?

Skip

Hi Skip,
the link is
http://www.yabycosmetics.com/admin/stats_monthly_sales.php

The first thing you need to do is rename your admin and install the new patch http://www.zen-cart.com/forum/showthread.php?t=130161.
You also should subscribe to the Zen Cart Release Announcements so you can keep up with patches.

As for the 404 that is the correct file name.

But at this time I think it is more important that you up date your site first. and then get back to this.

Skip

i changed the permission to 644 and now it all seems good!

i'm now trying to figure out the admin security patch situation. Thanks for letting me know abt this!

i do have a question about the report though, some columns addup and some don't seem to..

using this one line as an example:

Month	Year	Gross Income	Product sales	Nontaxed sales	Taxed sales	Taxes collected	Shipping & Handling	Tax on shipping	Gift Vouchers

Jul	2007	  1394.07	     1278	     827.35  	  450.65	      49.58           138.83	              1.3	     73.64

product sale + taxes and shipping - discounts doesn't add up to the gross. am i missing something?

thx.

mooomers:

i do have a question about the report though, some columns addup and some don't seem to..

using this one line as an example:

Month Year Gross Income Product sales Nontaxed sales Taxed sales Taxes collected Shipping & Handling Tax on shipping Gift Vouchers

Jul 2007 1394.07 1278 827.35 450.65 49.58 138.83 1.3 73.64

> 
> product sale + taxes and shipping - discounts doesn't add up to the gross.  am i missing something?
> 
> 
> thx.

Now you want me to be a accountant:(

Belive it or not that infomation is correct:

gross income = 1394.07
product sold = 1278.00
-------------------------------
difference = 116.07

non tax items = 827.35
tax items = 450.65
------------------------------
total = 1278.00 same as product sold 

Taxes collected = 49.58
shipping = 138.83
ship taxes = 1.30	
----------------------------------
tax ship total = 189.71

So we have a difference in gross monies and product sales

tax ship total = 189.71
difference = 116.07
--------------------------
Gift Vouchers 73.64

You now have a balance of $0.00

Don't make be do that again:no:

Skip

oh duh i posted an example that worked out!! but thank you for showing me the calculations anyway!!

so some of the lines come out with a difference of a dollar and some, like this year's ytd is already off by about $75.

i'm just very confused why some rows don't add up.

I uploaded all the files.....includes to the includes file .

Uploaded Stats_monthly_sales php to admin file.

I do not have a box at the bottom of admin reports to run the report.

What did I miss ?

https://www.centraltrailer.com

Thanks,
Martin

You have this file
admin/includes/boxes/extra_boxes/stats_monthly_sales_reports_dhtml.php ?

Did you rename your admin?

Skip

That file is in the includes file as you listed.

My admin is cart.

Any other ideas ?

Martin

Martin Smith:

That file is in the includes file as you listed.

My admin is cart.

Any other ideas ?

Martin

OK your zen cart store root is centraltrailer.com/cart but that is not your admin folder.

The file should be centraltrailer.com/cart/admin/includes/boxes/extra_boxes/stats_monthly_sales_reports_dhtml.php.

But you should have renamed your admin folder per- new patch http://www.zen-cart.com/forum/showthread.php?t=130161.

If so the path would be what ever you changed admin too.
centraltrailer.com/cart/??????/includes/boxes/extra_boxes/stats_monthly_sales_reports_dhtml.php

Skip