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 821 to 840 of 882
22 Mar 2022, 3:47 PM
#821
helenewallis avatar

helenewallis

Totally Zenned

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

Sales report 2.0

Unfortunately, this does not appear to be working correctly with 1.5.7d. With earlier Zencart versions, the report lists each instance separately when more than one product attribute is chosen. In other words, we have various sizes of some products, which are called out in attributes. With our current 1.5.5 version, each one of those is listed properly when the report is run for product totals. In the 1.5.7d version that I'm getting ready to put online, only the first instance of each product number is called out. The totals are correct, but it's not possible to see, for example, how many we sold of one size versus another. This is a major problem for us, since we use this report to enter data in our accounting software, and to manage our inventory levels there.

28 Mar 2022, 2:22 PM
#822
helenewallis avatar

helenewallis

Totally Zenned

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

Re: Sales report 2.0

Is anyone currently maintaining this report? We would really like to continue using it, but it no longer handles products with attributes correctly. It sums up all the order amounts for a given product on a single line, rather than listing the total of each attribute separately. That makes it useless for us, and I'll have to figure out some other way to create a similar report if it can't be fixed.

I do see that someone fixed the problem with the sales tax not being included in the total. That was only a minor irritation, though I'm glad it has been corrected. Not being able to see individual attribute sales definitely is a major problem.

28 Mar 2022, 3:55 PM
#823
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

HeleneWallis:

Is anyone currently maintaining this report? We would really like to continue using it, but it no longer handles products with attributes correctly. It sums up all the order amounts for a given product on a single line, rather than listing the total of each attribute separately. That makes it useless for us, and I'll have to figure out some other way to create a similar report if it can't be fixed.

I do see that someone fixed the problem with the sales tax not being included in the total. That was only a minor irritation, though I'm glad it has been corrected. Not being able to see individual attribute sales definitely is a major problem.
Yes, I am. It's just that I'm in the middle of a couple of fairly complicated upgrades ... and paid customers come first.

28 Mar 2022, 11:07 PM
#824
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

HeleneWallis:

Is anyone currently maintaining this report? We would really like to continue using it, but it no longer handles products with attributes correctly. It sums up all the order amounts for a given product on a single line, rather than listing the total of each attribute separately. That makes it useless for us, and I'll have to figure out some other way to create a similar report if it can't be fixed.

I do see that someone fixed the problem with the sales tax not being included in the total. That was only a minor irritation, though I'm glad it has been corrected. Not being able to see individual attribute sales definitely is a major problem.
Helene, what version of the report gave the correct results? That would definitely help me narrow in on the source of the issue.

30 Mar 2022, 7:08 PM
#825
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

swguy:

PR https://github.com/lat9/sales_report/pull/29
I've just submitted v3.5.0 of the "Sales Report", which now includes the shipping country/state in the CSV output (thanks, @swguy).

31 Mar 2022, 12:10 PM
#826
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

lat9:

I've just submitted v3.5.0 of the "Sales Report", which now includes the shipping country/state in the CSV output (thanks, @swguy).
Now available for download: https://www.zen-cart.com/downloads.php?do=file&id=9

17 Jul 2022, 12:19 PM
#827
helenewallis avatar

helenewallis

Totally Zenned

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

Re: Sales report 2.0

lat9:

Helene, what version of the report gave the correct results? That would definitely help me narrow in on the source of the issue.

Very sorry, Cindy, I got pulled off into other things and never saw your question. It was version 3.1, the original version, I believe.

Also, I just noticed that each execution of the report is opening a new instance of it. For someone who refers to it repeatedly every day, that is a REAL nuisance, lol.

17 Jul 2022, 3:18 PM
#828
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

I've just submitted v3.5.1 of Sales Report for the Zen Cart moderators' review; I'll post back here when it's available for download at https://www.zen-cart.com/downloads.php?do=file&id=9.

This release contains changes associated with the following GitHub issues:

#31: Attributed products' sales are incorrectly aggregated.
#32: Duplicate constant TABLE_HEADING_MODEL with different contents

Early adopters can download directly from GitHub: https://github.com/lat9/sales_report/releases/tag/v3.5.1

17 Jul 2022, 3:20 PM
#829
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

HeleneWallis:

Very sorry, Cindy, I got pulled off into other things and never saw your question. It was version 3.1, the original version, I believe.

Also, I just noticed that each execution of the report is opening a new instance of it. For someone who refers to it repeatedly every day, that is a REAL nuisance, lol.
Corrected in v3.5.1, see above. For the new-window opening, just untick that "Open in a new window" checkbox just above the "Show me the money" button. Your selection will be remembered for the current admin session.

17 Jul 2022, 5:12 PM
#830
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

Please note: I've just submitted v3.5.1a which replaces v3.5.1 since that release was missing the actual change for issue #31.:censored:

19 Jul 2022, 1:40 PM
#831
helenewallis avatar

helenewallis

Totally Zenned

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

Re: Sales report 2.0

lat9:

Corrected in v3.5.1, see above. For the new-window opening, just untick that "Open in a new window" checkbox just above the "Show me the money" button. Your selection will be remembered for the current admin session.

Duh. Thank you. I had unticked that when I first began using the plugin, and didn't notice that it had been restored in the new version.

19 Jul 2022, 2:26 PM
#832
helenewallis avatar

helenewallis

Totally Zenned

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

Re: Sales report 2.0

lat9:

I've just submitted v3.5.1 of Sales Report for the Zen Cart moderators' review; I'll post back here when it's available for download at https://www.zen-cart.com/downloads.php?do=file&id=9.

This release contains changes associated with the following GitHub issues:

#31: Attributed products' sales are incorrectly aggregated.
#32: Duplicate constant TABLE_HEADING_MODEL with different contents

Early adopters can download directly from GitHub: https://github.com/lat9/sales_report/releases/tag/v3.5.1

Thanks much, appears to be working great. My only other (and trivial) gripe is that the line padding was changed to 8px, which is enough to push the printed report onto two pages sometimes. I changed it to 2px, which is still a bit more than previous, but not enough to force our printed sales reports onto two pages.

This is one of the most useful plugins in all of Zencart, and it's a great relief to have it working properly for us.

19 Jul 2022, 3:02 PM
#833
helenewallis avatar

helenewallis

Totally Zenned

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

Re: Sales report 2.0

Oops, I may have spoken too soon. The report I printed to test the display was correct, but now that I've looked at several other days, one of our products with attributes is still summing up the quantities for all the items in that product number, and printing just one line. I did notice one thing. It was displaying the product description for the second attribute in the list, rather than the first one. It was also the only one of our products with attributes that didn't have a heading line such as 'Please make a selection." I added that, and now the display is showing the first attribute description, but still with the total for all of the products in the list. All the other products with attributes appear to be displayed correctly. Unfortunately, this is one of those products that we sell every single day, and almost every day has multiple attribute totals. So I'm having to go back to the sales report by order to figure out manually which orders had which attributes.

19 Jul 2022, 5:13 PM
#834
helenewallis avatar

helenewallis

Totally Zenned

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

Re: Sales report 2.0

Regarding the above, the product whose attributes are not being picked up correctly is the last one in the product list that has attributes. Not the absolute last product, but the last one with attributes that need to be summed and reported separately. I don't know if that's the problem with it, but I've seen other situations where the last record in a dataset didn't get included properly.

15 Aug 2022, 4:51 PM
#835
helenewallis avatar

helenewallis

Totally Zenned

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

Re: Sales report 2.0

I've gone back and looked at this report again, and it is not reporting any products with attributes correctly. I thought it was, because I was seeing several product variants in our sales reports. But when I looked more closely, I realized that it's only showing the first one in each case. The quantities are correct but they're all being assigned to the first variant in each product that has variants.

I have been entering the daily sales in our bookkeeping software, and coping with the issues by looking at the individual sales, where necessary, to get the right totals for each product variant. But someone else is taking over the job now, to free me up for other things, and he is not going to put up with having to dig the information out from multiple sources. So this really needs to be fixed. Can anyone figure this out? The report used to display correctly.

15 Aug 2022, 5:25 PM
#836
dennisns7d avatar

dennisns7d

New Zenner

Join Date:
Jan 2010
Posts:
55
Plugin Contributions:
0

Re: Sales report 2.0

Which version are you using? Make sure that you are using v3.5.1a, not v3.5.1.

15 Aug 2022, 7:30 PM
#837
helenewallis avatar

helenewallis

Totally Zenned

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

Re: Sales report 2.0

I was using 3.5.1a, but have reloaded it and everything seems to be okay now. It's possible that something was written over when we upgraded the website, because I had thought it was working and was then informed that it wasn't. Thanks!

23 Mar 2023, 10:34 AM
#838
swguy avatar

swguy

Administrator

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

Re: Sales report 2.0

Zen Cart 1.5.8 update:

Looks like we'll need to change calls to zen_db_output to use zen_output_string_protected instead in ./YOUR_ADMIN/includes/classes/sales_report.php. I have submitted a PR to Github.

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.

30 Apr 2023, 12:33 PM
#839
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

Sales Report, v4.0.0 is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=9.

This version has been released as a Zen Cart encapsulated plugin, so you use zc158's admin's Modules :: Plugin Manager to perform the install/un-install process.

This version contains changes associated with the following GitHub issues:

#35: Now distributed as a Zen Cart encapsulated plugin, for zc158 and later.
#26: Add customers_email_address as an optional column for "Orders Line-Items" reports.
#36: Using the Zen Cart admin_html_head.php to load required CSS/JS files, each now as their own file.
#37: Correct 'matrix' display, was using products id, not uprid, so attributed-products weren't properly displayed.
#38, #39: Various refactorings and performance improvements.
#40: Adding "Last 12 Months" as a preset date selection.
#41: Use "datepicker" instead of "spiffyCal" for custom-date selection.
#42: Change DISPLAY_EMPTY_TIMEFRAMES constant interpretation; true now displays the timeframes (was false in previous versions of the report).
#43: Enable additional order-total discounts and surcharges via site-specific customization.

30 Apr 2023, 2:20 PM
#840
dennisns7d avatar

dennisns7d

New Zenner

Join Date:
Jan 2010
Posts:
55
Plugin Contributions:
0

Re: Sales report 2.0

When I click Download Latest (or Download in the v4.0.0 area), I receive reviews_updated-2.0.0.zip.