Forums / Addon Admin Tools / Sales report 2.0

Sales report 2.0

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

Results 801 to 820 of 882
10 Feb 2021, 5:08 PM
#801
lat9 avatar

lat9

Administrator

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

Sales report 2.0

greg_beyer:

Hello, I'm seeking an example of the report it can create. In particular, does it capture product category as well as product name, sales count order date, and price in the report?

I found a discussion of category inclusion back in 2017, but don't know if it was implemented.

Thanks
The report provides the option of a CSV export but I does not include any category-related information since that information isn't saved as part of an order.

14 Mar 2021, 1:19 AM
#802
drm1963 avatar

drm1963

New Zenner

Join Date:
Feb 2018
Location:
Tennessee
Posts:
48
Plugin Contributions:
0

Re: Sales report 2.0

in Sales Report - Version: v3.4.0 is there a way to add the customer's email address to the generated report.

The Sales Report - Version: v3.4.0 work great and typically we export as .csv files but being able to add an email address could help with other functions that we use the file for.

14 Mar 2021, 12:46 PM
#803
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

drm1963:

in Sales Report - Version: v3.4.0 is there a way to add the customer's email address to the generated report.

The Sales Report - Version: v3.4.0 work great and typically we export as .csv files but being able to add an email address could help with other functions that we use the file for.
That'll make that report's output a tad 'busy', but I've noted the request on the plugin's GitHub repository: https://github.com/lat9/sales_report/issues/26

12 May 2021, 1:43 PM
#804
strelitzia avatar

strelitzia

Totally Zenned

Join Date:
Nov 2005
Location:
France
Posts:
588
Plugin Contributions:
1

Re: Sales report 2.0

I'm experiencing issues with this module not reporting correctly.
Module version 3.4
Zen Cart 1.5.7c

I ran a report for year to date with 'Displayed information' set to Product Line Items
The report doesn't show all the attributes that are related to products sold.
For example, product A only shows attribute a, and yet I can see from the orders history that product A also sold with attribute c in the last week.

I did a print_r($products); at line 455 of admin/includes/classes/sales_report.php and when I look up an order that is in this array output, it only ever shows the last item from any given order. running the query ```
SELECT op.* FROM orders_products op WHERE op.orders_id = 120918

If indeed it is only taking account of the last item in each order, it would explain why I have so many items missing from the report.

NOTE: This problem isn't limited to YTD reports. I tested it on single day and single month reports too.

Zen Cart developer since 2009 — Zen Cart Solutions
Ecommerce development, integrations & automation — Junction Solutions

12 May 2021, 3:14 PM
#805
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

It sounds like you're expecting that the product-line-items display one line for each products-specific option-combination purchased, e.g. one line that sums the "Shirt" product in Small/Red, another in Large/Black.

FWIW, this report's never worked that way and I'm not sure how much effort's required to make that change.

12 May 2021, 6:52 PM
#806
strelitzia avatar

strelitzia

Totally Zenned

Join Date:
Nov 2005
Location:
France
Posts:
588
Plugin Contributions:
1

Re: Sales report 2.0

Thanks for the info. I wasn't aware it couldn't do this out of the box.

Zen Cart developer since 2009 — Zen Cart Solutions
Ecommerce development, integrations & automation — Junction Solutions

12 May 2021, 7:01 PM
#807
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

The Sales Report is currently housed on GitHub: https://github.com/lat9/sales_report/

If you feel strongly that the feature you require should be included, I'll be more than happy to receive a PR.

3 Aug 2021, 12:27 PM
#808
jimmie avatar

jimmie

Totally Zenned

Join Date:
Jan 2013
Location:
New Port Richey, Florida
Posts:
971
Plugin Contributions:
0

Re: Sales report 2.0

is there away to put a default store status to omit, ( instead of doesnt matter)
my accountant doesnt understand our processing

3 Aug 2021, 3:29 PM
#809
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

jimmie:

is there away to put a default store status to omit, ( instead of doesnt matter)
my accountant doesnt understand our processing
There's a way, but it will require a store-specific edit of /admin/stats_sales_report.php. Find the following section (starting on line 235 of the current version):

$payment_method = (isset($_GET['payment_method']) && array_key_exists($_GET['payment_method'], $payment_key)) ? $_GET['payment_method'] : '0';
$payment_method_omit = (isset($_GET['payment_method_omit']) && array_key_exists($_GET['payment_method_omit'], $payment_key)) ? $_GET['payment_method_omit'] : '0';
$current_status = (isset($_GET['current_status']) && array_key_exists((int)$_GET['current_status'], $status_key)) ? (int)$_GET['current_status'] : 0;
$excluded_status = (isset($_GET['excluded_status']) && array_key_exists((int)$_GET['excluded_status'], $status_key)) ? (int)$_GET['excluded_status'] : 0;
$manufacturer = (isset($_GET['manufacturer']) && in_array((int)$_GET['manufacturer'], $manufacturer_key)) ? (int)$_GET['manufacturer'] : 0;
$detail_level = (isset($_GET['detail_level']) && in_array($_GET['detail_level'], $detail_types)) ? $_GET['detail_level'] : 'order';

... and update the excluded_status default to identify your site's default status:

$payment_method = (isset($_GET['payment_method']) && array_key_exists($_GET['payment_method'], $payment_key)) ? $_GET['payment_method'] : '0';
$payment_method_omit = (isset($_GET['payment_method_omit']) && array_key_exists($_GET['payment_method_omit'], $payment_key)) ? $_GET['payment_method_omit'] : '0';
$current_status = (isset($_GET['current_status']) && array_key_exists((int)$_GET['current_status'], $status_key)) ? (int)$_GET['current_status'] : 0;
$excluded_status = (isset($_GET['excluded_status']) && array_key_exists((int)$_GET['excluded_status'], $status_key)) ? (int)$_GET['excluded_status'] : [B]0[/B];
$manufacturer = (isset($_GET['manufacturer']) && in_array((int)$_GET['manufacturer'], $manufacturer_key)) ? (int)$_GET['manufacturer'] : 0;
$detail_level = (isset($_GET['detail_level']) && in_array($_GET['detail_level'], $detail_types)) ? $_GET['detail_level'] : 'order';
22 Sep 2021, 12:52 PM
#810
dave224 avatar

dave224

Zen Follower

Join Date:
Jun 2012
Posts:
481
Plugin Contributions:
0

Re: Sales report 2.0

Just a nit... there's a missing ">" to close the td tag in line 1098 of admin/stats_sales_report.php version 3.4.0

<td class="lineItemHeadingContent right"<?php echo TABLE_HEADING_PRODUCT_TOTAL . show_arrow('grand'); ?></td>

Thank you for keeping this add-on up-to-date!
Dave
zc157c, php 7.3,

22 Sep 2021, 1:37 PM
#811
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

Dave224:

Just a nit... there's a missing ">" to close the td tag in line 1098 of admin/stats_sales_report.php version 3.4.0

<td class="lineItemHeadingContent right"<?php echo TABLE_HEADING_PRODUCT_TOTAL . show_arrow('grand'); ?></td> ``` > Thank you for keeping this add-on up-to-date! > Dave > zc157c, php 7.3, Thanks for the report; GitHub issue created: <https://github.com/lat9/sales_report/issues/27>
7 Jan 2022, 1:11 PM
#812
persion avatar

persion

New Zenner

Join Date:
Apr 2012
Posts:
5
Plugin Contributions:
0

Re: Sales report 2.0

It's a great plugin, but our online shop has many currency, the report all in USD. Can it be improved? Thank you.

7 Jan 2022, 3:03 PM
#813
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

persion:

It's a great plugin, but our online shop has many currency, the report all in USD. Can it be improved? Thank you.
FWIW, I've created a tracking issue (https://github.com/lat9/sales_report/issues/28) in the report's GitHub repository. I'm not going to promise anything, as that's going to be a fairly large change.

9 Jan 2022, 3:54 AM
#814
oldngrey avatar

oldngrey

Zen Follower

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

Re: Sales report 2.0

Be careful what you wish for.
I let the customer list prices in multiple currencies, but charge in AUD and let the credit card company handle conversion rates.
Zen Cart Order Details displays order details in the display currency that the customer has chosen but for overseas sales not in AUD I have no idea of the value of the goods or the shipping in AUD. These values in AUD are required for custom declarations etc.
To see the values in AUD I use the Sales Report

For accounting purposes all sales calculations are in AUD and these are derived directly from the Sales Report

environment Pre-prod: Zen Cart 157c; Apache 2.4.41; PHP 7.4.3; MySQL 8.0.22; Linux 5.4.0

OldNGrey
ZC222 PHP 8.4.27
MySQL 11.8.5-MariaDB

9 Feb 2022, 5:00 PM
#815
swguy avatar

swguy

Administrator

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

Re: Sales report 2.0

I'm considering adding a zone column for a client that needs a per state breakdown. Any thoughts on this?

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.

9 Feb 2022, 10:08 PM
#816
oldngrey avatar

oldngrey

Zen Follower

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

Re: Sales report 2.0

If it was a toggle eg zone was not shown unless selected would be good, but that may make formatting more complicated. If displaying zone, the country or country code should also be displayed.

In the Sales Report I can presently only identify international sales from the tax amount which in my case is always zero. So in this case the destination country would be useful on the report (as an option).

I am assuming that zone in the report would be destination zone. Customer location zone, billing zone and destination (shipping) zone can all be different on the same order.
I have Australian customers who send items to overseas addresses. In this scenario the sale is tax exempt.
If the same customer sends the next order to an Australian destination, tax applies to the sale (goods and shipping).

OldNGrey
ZC222 PHP 8.4.27
MySQL 11.8.5-MariaDB

10 Feb 2022, 12:03 PM
#817
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

swguy:

I'm considering adding a zone column for a client that needs a per state breakdown. Any thoughts on this?

OldNGrey:

If it was a toggle eg zone was not shown unless selected would be good, but that may make formatting more complicated. If displaying zone, the country or country code should also be displayed.

In the Sales Report I can presently only identify international sales from the tax amount which in my case is always zero. So in this case the destination country would be useful on the report (as an option).

I am assuming that zone in the report would be destination zone. Customer location zone, billing zone and destination (shipping) zone can all be different on the same order.
I have Australian customers who send items to overseas addresses. In this scenario the sale is tax exempt.
If the same customer sends the next order to an Australian destination, tax applies to the sale (goods and shipping).
As @OldNGrey said, adding another column (even an optional one) could be 'challenging'. Would it suffice to have the country/state (zone) breakdown only provided in the "Timeframe Statistics" view?

10 Feb 2022, 12:51 PM
#818
swguy avatar

swguy

Administrator

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

Re: Sales report 2.0

I think it makes more sense to put it on order line items. But I'll submit a PR and let you make the call. You could even opt to only show it on the CSV.

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.

26 Feb 2022, 11:57 AM
#820
helenewallis avatar

helenewallis

Totally Zenned

Join Date:
Jun 2016
Location:
Suffolk VA
Posts:
625
Plugin Contributions:
0

Re: Sales report 2.0

swguy:

I'm considering adding a zone column for a client that needs a per state breakdown. Any thoughts on this?

I was just going to ask for that myself. We're over the threshold on sales tax collection now in multiple states, and it's getting to be a pain to handle that manually.