Forums / Addon Admin Tools / Sales report 2.0

Sales report 2.0

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

Results 841 to 860 of 882
30 Apr 2023, 2:55 PM
#841
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,139
Plugin Contributions:
56

Sales report 2.0

dennisns7d:

When I click Download Latest (or Download in the v4.0.0 area), I receive reviews_updated-2.0.0.zip.
Note to self: Never do anything before you're coffeed-up.

Should be all better now.

P.S. Thanks for the report!

5 May 2023, 6:18 AM
#842
oldngrey avatar

oldngrey

Zen Follower

Join Date:
Apr 2008
Location:
Qld, Australia
Posts:
433
Plugin Contributions:
0

Re: Sales report 2.0

Zen cart 158a, php 8.2, Sales Report 2 and Sales Report II

Sales report gives the order total as
goods value + order rec tax + shipping - discounts - gift cert

when the shipping included tax the total should be
goods value + goods tax + shipping - discounts - gift cert

In the example below the total should be $35.06

Order ID **** [##############################]**1**[/COLOR] Customer Num Products Goods Value Goods Tax Order Rec. Tax Shipping Discounts Gift Cert. Sold Gift Cert. Used Order Total
8536 McCartney, Paul 1 | -- $32.86 $3.29 $4.35 $11.70 $12.79 | Qty: 2 $0.00 | Qty: 0 $0.00 | Qty: 0 $36.12

OldNGrey
ZC222 PHP 8.4.27
MySQL 11.8.5-MariaDB

8 May 2023, 10:26 PM
#843
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,139
Plugin Contributions:
56

Re: Sales report 2.0

OldNGrey:

Zen cart 158a, php 8.2, Sales Report 2 and Sales Report II

Sales report gives the order total as
goods value + order rec tax + shipping - discounts - gift cert

when the shipping included tax the total should be
goods value + goods tax + shipping - discounts - gift cert

In the example below the total should be $35.06

Order ID [##############################]**1**[/COLOR] |
Customer |
Num Products |
Goods Value |
Goods Tax |
Order Rec. Tax |
Shipping |
Discounts |
Gift Cert. Sold |
Gift Cert. Used |
Order Total |

8536 |
McCartney, Paul |

1
$32.86
$3.29
$4.35
$11.70
$12.79
Qty: 2
$0.00
Qty: 0
$0.00
Qty: 0
$36.12

Would you give me a full example of the order's totals so that I get a "better picture".

10 May 2023, 10:46 PM
#844
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,139
Plugin Contributions:
56

Re: Sales report 2.0

lat9:

Would you give me a full example of the order's totals so that I get a "better picture".
@OldNGrey, is this an issue when the prices "include tax" like they do in AU? I ask because for US-based pricing where the tax isn't included, I'm not seeing an issue when the shipping is taxed.

12 May 2023, 8:20 PM
#845
gsh68 avatar

gsh68

Zen Follower

Join Date:
Mar 2011
Posts:
103
Plugin Contributions:
0

Re: Sales report 2.0

It happens on my setup in UK too - for a domestic sale it adds the VAT from shipping to Order Rec. Tax but then adds the tax inclusive shipping cost to the total.

EG order via admin (tax inclusive pricing @20% VAT)
Sub-Total: £7.50 (net 6.25 - VAT 1.25)
RM First Class (Shipping to GB): £1.44 (net 1.20 - tax 0.24)
VAT 20% (included): £1.49
Total: £8.94

Sales report
Goods value - £6.25
Goods tax - £1.25
Order Rec Tax - £1.49
Shipping - £1.44
Total - 9.18 - 0.24 more than actual order total.

13 May 2023, 3:04 AM
#846
oldngrey avatar

oldngrey

Zen Follower

Join Date:
Apr 2008
Location:
Qld, Australia
Posts:
433
Plugin Contributions:
0

Re: Sales report 2.0

lat9:

@OldNGrey, is this an issue when the prices "include tax" like they do in AU? I ask because for US-based pricing where the tax isn't included, I'm not seeing an issue when the shipping is taxed.
Sorry for the delay in responding I posted a detailed explanation yesterday but it obviously disappeared into the ether.

Yes, the issue is when tax is included in the postage. In Australia all local postage includes tax, all postage for overseas is tax free. All product prices listed include tax, and this remains for an Australian delivery address. the tax is removed for overseas delivery addresses.

I can see the variation by selecting the "Total Validation" option and this is good enough for reconciling other reports.

For me this is now a very low priority for possible future consideration as I now fully understand what is occurring.

The first image is the sales report:
Attachment 20293

The second image is the order details amounts:
Attachment 20294

The third image is the "orders_total" table contents:
Attachment 20295

OldNGrey
ZC222 PHP 8.4.27
MySQL 11.8.5-MariaDB

13 May 2023, 2:27 PM
#847
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,139
Plugin Contributions:
56

Re: Sales report 2.0

@gsh68 and @OldNGrey, thanks for the details. It appears that the report's handling of sites that "display prices with tax" has been incorrect for a while.

One of the underlying issues is that, unlike products, the tax rate associated with an order-total's value (e.g. shipping) is not broken out in the order's recording in the database.

13 May 2023, 10:10 PM
#848
oldngrey avatar

oldngrey

Zen Follower

Join Date:
Apr 2008
Location:
Qld, Australia
Posts:
433
Plugin Contributions:
0

Re: Sales report 2.0

Not Sales Report but the way ZC displays totals is inconsistent.

The order details subtotals may show discounts with or without a minus sign eg coupons.
Coupon value is displayed without a minus sign but subtracted from the total then stored in "orders_total" text field with a minus sign but the "orders-total" value is positive whereas
the payment module fee, to me is correct, as it displays the minus sign on the order, is deducted from the total , and is stored with the minus sign in both fields in "orders_total".

OldNGrey
ZC222 PHP 8.4.27
MySQL 11.8.5-MariaDB

31 Aug 2023, 12:34 AM
#849
planetjune avatar

planetjune

New Zenner

Join Date:
Jul 2008
Posts:
36
Plugin Contributions:
0

Re: Sales report 2.0

I've just installed Sales Report 4.0.0 to a vanilla install of ZC 1.5.8a using PHP 7.3. I've uploaded the files and enabled the plugin from Modules > Plugin Manager. It said "Plugin enabled successfully", but I don't see the entry for Sales Report II in the Reports menu. I can't see what I could have done wrong! Any ideas, please?

31 Aug 2023, 12:41 PM
#850
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,139
Plugin Contributions:
56

Re: Sales report 2.0

That's very weird. If you login to your admin and change the URL in your browser bar to read https://yoursite.com/admin/index.php?cmd=stats_sales_report2, does the report show up?

1 Sep 2023, 2:49 AM
#851
planetjune avatar

planetjune

New Zenner

Join Date:
Jul 2008
Posts:
36
Plugin Contributions:
0

Re: Sales report 2.0

I thought so too! I've just tried your suggestion, and no, it doesn't show up - it redirects me back to my main admin page. So it's clearly not enabled, even though it says it is...

1 Oct 2023, 6:37 PM
#852
jodean avatar

jodean

Totally Zenned

Join Date:
May 2011
Location:
Tennessee
Posts:
511
Plugin Contributions:
0

Re: Sales report 2.0

I have installed the current version twice now and verified that the files are being installed in the correct folders but the sales report does not show up in Admin/Reports. However there is a Sales Report with Graphics. How do I get the installed Sales Report to show up in Admin/Reports?

1 Oct 2023, 7:02 PM
#853
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,139
Plugin Contributions:
56

Re: Sales report 2.0

jodean:

I have installed the current version twice now and verified that the files are being installed in the correct folders but the sales report does not show up in Admin/Reports. However there is a Sales Report with Graphics. How do I get the installed Sales Report to show up in Admin/Reports?
I can't explain how that's not showing up. Any admin log files generated? Have you enabled the plugin via the admin's Modules :: Plugins?

2 Oct 2023, 1:21 PM
#854
jodean avatar

jodean

Totally Zenned

Join Date:
May 2011
Location:
Tennessee
Posts:
511
Plugin Contributions:
0

Re: Sales report 2.0

Yes it was on. So I removed the plugin from the Zencart Plugin folder and reinstalled the plugin and now it works.

2 Oct 2023, 1:46 PM
#855
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,139
Plugin Contributions:
56

Re: Sales report 2.0

jodean:

Yes it was on. So I removed the plugin from the Zencart Plugin folder and reinstalled the plugin and now it works.
Bizarre. I'll need to fuss with that some to see if I can replicate the issue.

2 Oct 2023, 1:58 PM
#856
planetjune avatar

planetjune

New Zenner

Join Date:
Jul 2008
Posts:
36
Plugin Contributions:
0

Re: Sales report 2.0

jodean:

Yes it was on. So I removed the plugin from the Zencart Plugin folder and reinstalled the plugin and now it works.

I've been having the same problem. Do you remember exactly how you made it work, by any chance?

Did you disable and/or uninstall it from the admin Plugin Manager before you deleted it from the zc_plugins folder, or leave it enabled but just physically delete the files and then re-upload them? I've tried all the permutations I can think of but nothing is working for me.

26 Feb 2024, 2:24 PM
#857
planetjune avatar

planetjune

New Zenner

Join Date:
Jul 2008
Posts:
36
Plugin Contributions:
0

Re: Sales report 2.0

Just reporting back: I finally got it to work!

I don't think I did anything differently from my previous attempts this time, but in case this helps anyone else, here's exactly what I did this time:

  • uninstalled the plugin without disabling it first
  • used the plugin manager's cleanup to remove the files
  • downloaded a fresh copy of the plugin and unzipped it
  • uploaded the plugin to the zc_plugins directory
  • installed the plugin from Plugin Manager

And this time it worked as expected - yay!

26 Feb 2024, 5:24 PM
#858
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,139
Plugin Contributions:
56

Re: Sales report 2.0

planetjune:

Just reporting back: I finally got it to work!

I don't think I did anything differently from my previous attempts this time, but in case this helps anyone else, here's exactly what I did this time:

  • uninstalled the plugin without disabling it first
  • used the plugin manager's cleanup to remove the files
  • downloaded a fresh copy of the plugin and unzipped it
  • uploaded the plugin to the zc_plugins directory
  • installed the plugin from Plugin Manager

And this time it worked as expected - yay!
Thanks for reporting back!

13 May 2024, 11:07 AM
#859
siliconbug avatar

siliconbug

Zen Follower

Join Date:
Apr 2009
Posts:
126
Plugin Contributions:
0

Re: Sales report 2.0

ZC v1.5.8a
Sales Report v4.0.0

I install, enable Sales Report, and can visit the Sales Report II configuration page. When I click "Show me the money", it just opens another Sales Report II configuration page. Do I miss any step?

13 May 2024, 12:14 PM
#860
swguy avatar

swguy

Administrator

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

Re: Sales report 2.0

The results are at the bottom below the selection part of the screen.
If you don't want a new window, you can check a box at the bottom ("open results in new window?") and the original window will update in place.

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.