Forums / Addon Admin Tools / Sales report 2.0

Sales report 2.0

Started by blindside on 29 Aug 2006, 2:41 AM · Views: 248,185

Results 461 to 480 of 882
8 Oct 2010, 4:55 PM
#461
solosolera avatar

solosolera

New Zenner

Join Date:
Oct 2010
Posts:
2
Plugin Contributions:
0

Sales report 2.0

Hi all,

I’m new using zencart and just I installed "Sales Report 2.3.0" but I think that “Goods Value” is off thus the reason why my totals are also off. Maybe this has been answered but can’t seem to find where or I’m misinterpreting the meaning of “Goods Value”. From what I can tell “Goods Value” is the sub-total of “goods sold” – taxes and I think it should be just the value of goods sold. Is there a reason why you would subtract the sales tax from the orders sub-total to get the value of “Goods Value” and not just report the orders sub-total?

Any help on this matter would be greatly appreciated since I like this report...

zc 1.3.9f

Thanks ahead of time..

12 Oct 2010, 4:44 PM
#462
dml73 avatar

dml73

Zen Follower

Join Date:
Oct 2007
Posts:
416
Plugin Contributions:
0

Re: Sales report 2.0

I installed and played around with this module, it definately is great! However, just to make sure, am I correct that I cannot get a csv file with both the customer (eg name and shipping address) data AND the product data (eg product model number and price)? :blink:

14 Oct 2010, 5:19 PM
#463
solosolera avatar

solosolera

New Zenner

Join Date:
Oct 2010
Posts:
2
Plugin Contributions:
0

Re: Sales report 2.0

solosolera:

Hi all,

I’m new using zencart and just I installed "Sales Report 2.3.0" but I think that “Goods Value” is off thus the reason why my totals are also off. Maybe this has been answered but can’t seem to find where or I’m misinterpreting the meaning of “Goods Value”. From what I can tell “Goods Value” is the sub-total of “goods sold” – taxes and I think it should be just the value of goods sold. Is there a reason why you would subtract the sales tax from the orders sub-total to get the value of “Goods Value” and not just report the orders sub-total?

Any help on this matter would be greatly appreciated since I like this report...

zc 1.3.9f

Thanks ahead of time..

I really like this report but I have found what I believe is another problem with this report.

Besides the “Goods Value” being the (order value – taxes) the report TOTAL is missing the taxes so there seems to be a tax issue in this report. Also the taxes that are subtracted from the “goods value” are taxes before any discount (I have a group discount).

As it stands now the report’s GOODS VALUE = (order subtotal – taxes (before discount)) and the TOTAL = (order subtotal – discount + shipping) no taxes.

I believe that the GOODS VALUE should be the orders sub-total only and the reports TOTAL should be the orders total (order subtotal – discount + taxes (after discount) + shipping).

Again maybe I’m misinterpreting how this report works so here is an example...

ORDER:

Sub-Total: $69.95

Group Discount: -$3.50

FL State and Local Tax (6.5%): $4.32

United Parcel Service (1 x 5.00lbs) (2nd Day Air): $11.93

Total: $82.70

This report shows:

**Goods Value = 65.40 (should be 69.95)

Total = 78.38 (should be 82.70)**

After several days of trying to figure out how ZC and this report work (I have very little clue) I made some changes to get that results I think the report should give me. Can anyone that knows how this report works and has PHP experience tell me if the changes I made are correct or if they will adversely affect the report in a manner that I’m not aware.

Changes to: admin\includes\classes\sales_report.php

I CHANGED :

$product_price_exc_tax = ($product_price_inc_tax - $product_tax);

TO:

$product_price_exc_tax = ($product_price_inc_tax);

I’m obviously screwing with some rules here by changing “$product_price_exc_tax” to equal “$product_price_inc_tax“ but the value used to get the “GOODS VALUE” seems to be "product_price_exc_tax”. So please advice on the consequences of this change.

AND BELOW:

// (goods + tax + shipping + gc_sold) - (discount + gc_used)

I ADDED:

$order_goods_tax = zen_calculate_tax(($order_goods - ($order_discount + $order_gc_used)), $tax) ;

To get the taxes after any discount.

Now the report gives me what I believe are the correct values for my scenario:

**GOODS VALUE = 69.95

TOTAL = 82.70**

Can anyone knowledgeable please let me know what they think or if maybe there is some tax setting in ZC that I’m not setting thus getting the results I was getting.

Thanks…

24 Oct 2010, 5:44 AM
#464
dave3009 avatar

dave3009

New Zenner

Join Date:
Nov 2009
Posts:
19
Plugin Contributions:
0

Re: Sales report 2.0

Hi

I searched the thread and could only find one reference to this question, and didn't see any solution. Hopefully someone can help. I was hoping to be able to include 'company name' in the +order line report. I can add the required column but lack the talent to actually populate the information from the database.

Any help would be greatly appreciated.

TIA

Dave

26 Oct 2010, 5:28 PM
#465
wearethecure avatar

wearethecure

New Zenner

Join Date:
May 2009
Posts:
4
Plugin Contributions:
0

Re: Sales report 2.0

Hi dave3009,

Have you found the answer to your question? Because I have the same problem. I can get reports of total sales for a day, week or month but I cannot get a report that shows each individual sales, the name of the person, their address and what they ordered. Then I would love to export that to an excel sheet so I could print up shipping labels. So if you have discovered the answer or anyone else has the answer I would love to know

Gary

26 Oct 2010, 5:33 PM
#466
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

have you looked at the Super Orders add-in? It has a feature for batch-status-update and batch-form-print that I use to print invoices / packing slips for orders that haven't been shipped. I then update those orders to the 'shipped' status. It lines up with window envelopes too.

14 Nov 2010, 11:59 PM
#467
swguy avatar

swguy

Administrator

Join Date:
Feb 2006
Location:
Tampa Bay, Florida
Posts:
10,754
Plugin Contributions:
56

Re: Sales report 2.0

Posted version 2.3.1.

  • Added "today" as a selection
  • fixed a bug where defaults didn't work when some of the lists were empty (such as manufacturer).

That Software Guy. My Store: Zen Cart Support
Available for hire - See my ad in Services
Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
Do you benefit from Zen Cart? Then please support the project.

1 Dec 2010, 5:34 PM
#468
icemanchai avatar

icemanchai

New Zenner

Join Date:
Jun 2006
Posts:
76
Plugin Contributions:
0

Re: Sales report 2.0

Titles, drop menu and radio options of "Sort products by..." and "Then sort by..." are totally disappeared when using with non-english languages even have translated language files.

What can I do to make them display? Please help.

Thank you.

3 Dec 2010, 6:52 AM
#469
icemanchai avatar

icemanchai

New Zenner

Join Date:
Jun 2006
Posts:
76
Plugin Contributions:
0

Re: Sales report 2.0

I solved the problem of showing "Sort products by" and "Then sort by" by inputting the correct date format in

define('DEFAULT_START_DATE' &

define('DEFAULT_END_DATE'

in language files.

3 Dec 2010, 12:30 PM
#470
dw08gm avatar

dw08gm

Totally Zenned

Join Date:
Sep 2008
Location:
DownUnder, overlooking South Pole.
Posts:
1,022
Plugin Contributions:
2

Re: Sales report 2.0

Using 139h with SuperOrders, I applied the optional rollover edits to admin/includes/general.js, as per the following snippet, but cannot see what it does.

Did I add the code rightly?

What am I supposed to see happen?

function rowOverEffect(object) {
  if (object.className == 'dataTableRow') object.className = 'dataTableRowOver';
// start Sales_report
	if (object.className == 'totalRow') object.className = 'totalRowOver';
	if (object.className == 'lineItemRow') object.className = 'lineItemRowOver';
// end Sales_report
// start Super Orders
	if (object.className == 'paymentRow') object.className = 'paymentRowOver';
	if (object.className == 'purchaseOrderRow') object.className = 'purchaseOrderRowOver';
	if (object.className == 'refundRow') object.className = 'refundRowOver';
// end Super Orders
}

function rowOutEffect(object) {
  if (object.className == 'dataTableRowOver') object.className = 'dataTableRow';
// start Sales_report
	if (object.className == 'totalRowOver') object.className = 'totalRow';
	if (object.className == 'lineItemRowOver') object.className = 'lineItemRow';
// end Sales_report
// start Super Orders
	if (object.className == 'paymentRowOver') object.className = 'paymentRow';
	if (object.className == 'purchaseOrderRowOver') object.className = 'purchaseOrderRow';
	if (object.className == 'refundRowOver') object.className = 'refundRow';
// end Super Orders
}

Thanks in advance

16 Dec 2010, 4:58 PM
#471
carol2848 avatar

carol2848

New Zenner

Join Date:
Nov 2007
Posts:
78
Plugin Contributions:
0

Re: Sales report 2.0

I went into the admin-inc-lang-eng-stats_sales_report.php file to change some of my column headings on the Sales Report. Now NONE of the headings even show up on the report when I print. Reuploaded backup of the file, but still no headings printing, so the problem is coming from somewhere else. Is there somewhere else I can check or fix?
I seem to have problems with my new FileZilla. I don't know how this happened. Appreciate any help. Thanks.

17 Dec 2010, 4:15 AM
#472
carol2848 avatar

carol2848

New Zenner

Join Date:
Nov 2007
Posts:
78
Plugin Contributions:
0

Re: Sales report 2.0

Please ignore last message! Problem due to new computer/printer. Problem solved. :clap:

18 Dec 2010, 4:48 PM
#473
boomer_az avatar

boomer_az

New Zenner

Join Date:
Nov 2010
Posts:
19
Plugin Contributions:
0

Re: Sales report 2.0

I just installed Version 2.3.1 and after requesting report it defaults to the admin login screen despite turning on/off the new window option.

Using ver 1.3.9h

Thanks

20 Dec 2010, 12:40 AM
#474
caroleas avatar

caroleas

Totally Zenned

Join Date:
Feb 2009
Posts:
896
Plugin Contributions:
0

Re: Sales report 2.0

I just wanted to say a big thank you for that mod. It installed so easily and works like a charm.

20 Dec 2010, 6:33 PM
#475
dw08gm avatar

dw08gm

Totally Zenned

Join Date:
Sep 2008
Location:
DownUnder, overlooking South Pole.
Posts:
1,022
Plugin Contributions:
2

Re: Sales report 2.0

From #471 above, and since having just installed Super Orders 3:

Or do I do this in admin/includes/general.js:

function rowOverEffect(object) {
  if (object.className == 'dataTableRow') object.className = 'dataTableRowOver';
}

function rowOutEffect(object) {
  if (object.className == 'dataTableRowOver') object.className = 'dataTableRow';
}

// BEGIN Super Orders3 edit
function rowOverEffect(object) {
	if (object.className == 'dataTableRow') object.className = 'dataTableRowOver';
	if (object.className == 'paymentRow') object.className = 'paymentRowOver';
	if (object.className == 'purchaseOrderRow') object.className = 'purchaseOrderRowOver';
	if (object.className == 'refundRow') object.className = 'refundRowOver';
}

function rowOutEffect(object) {
    if (object.className == 'dataTableRowOver') object.className = 'dataTableRow';
	if (object.className == 'paymentRowOver') object.className = 'paymentRow';
	if (object.className == 'purchaseOrderRowOver') object.className = 'purchaseOrderRow';
	if (object.className == 'refundRowOver') object.className = 'refundRow';
}
// end Super Orders3

// start Sales_report2
function rowOverEffect(object) {
	if (object.className == 'totalRow') object.className = 'totalRowOver';
	if (object.className == 'lineItemRow') object.className = 'lineItemRowOver';
}
// end Sales_report2

// start Sales_report
function rowOutEffect(object) {
	if (object.className == 'totalRowOver') object.className = 'totalRow';
	if (object.className == 'lineItemRowOver') object.className = 'lineItemRow';
}
// end Sales_report

Thanks

21 Dec 2010, 1:54 PM
#476
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

Not a javascript pro, but I'd think the first example is more straightforward - overloading a function with the same parameters - does that even compile?

All this is for is to make the report a little more functional - highlights the line your mouse is over by specifying a different background color via the CSS sheets

21 Dec 2010, 5:10 PM
#477
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Sales report 2.0

carlvt88:

Not a javascript pro, but I'd think the first example is more straightforward - overloading a function with the same parameters - does that even compile?

All this is for is to make the report a little more functional - highlights the line your mouse is over by specifying a different background color via the CSS sheetsI agree especially since this file did not change at all in the new Super Orders v3.0 release.. If the previously posted proposed changes work no reason they won't continue to work with Super Orders v3.0 and the lates version of the Sales Report..

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

22 Dec 2010, 3:07 AM
#478
caroleas avatar

caroleas

Totally Zenned

Join Date:
Feb 2009
Posts:
896
Plugin Contributions:
0

Re: Sales report 2.0

Quick question. The Sales Report works fine, but since i installed it, i do not receive the invoices anymore. I only see the paypal message. Is there something i missed?

28 Dec 2010, 3:02 PM
#479
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

Can you say a little more? I'm not sure what you mean. What invoices? SalesReport doesn't send invoices. What paypal message? Is this an email?

28 Dec 2010, 3:05 PM
#480
caroleas avatar

caroleas

Totally Zenned

Join Date:
Feb 2009
Posts:
896
Plugin Contributions:
0

Re: Sales report 2.0

I am refering to the copy of the invoice sent to the customer. Usually, i would receive them, but then, suddenly, i didn't. Strangely, as mysteriously as it started, it also stopped. I get those again now. So i am not sure it is related to the Sales Report 2.0 anymore. Just odd coincidence.