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 761 to 780 of 882
22 Oct 2019, 12:11 PM
#761
lat9 avatar

lat9

Administrator

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

Sales report 2.0

Lordzoabar:

Not sure if I'm just missing something with it, or if the module doesn't support it at all, but I'm trying to get a report listing our top selling products over the course of the past 2 years. As it is, I can go to the Reports->Products Purchased page and it will give me a list of what we've sold, from most to least,ever since we opened, but I'm needing to be able to generate a list for a specific time period, and of a specific selection of product. If this doesn't, is there anything that does?

We're on 1.5.5.
The current version (3.3.1) of the Sales Report supports Zen Carts 1.5.5 and later. Choosing settings like below will yield a timeframe-specific search displaying the products purchased in descending order of quantity:

Displayed information: Products Line Items
Sort products by: Quantity (desc)
Then sort by: Products ID (desc)

22 Oct 2019, 2:46 PM
#762
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.3.2 of the Sales Report, and it is now available for download.

 This release contains changes associated with the following GitHub issues:

#16: Correct PHP notices during products-purchased CSV output.
#17: (Interoperation) Don't load extra-functions until an admin is logged in.

https://www.zen-cart.com/downloads.php?do=file&id=9

23 Oct 2019, 11:51 AM
#763
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.3.2 of the Sales Report, and it is now available for download.

 This release contains changes associated with the following GitHub issues:

#16: Correct PHP notices during products-purchased CSV output.
#17: (Interoperation) Don't load extra-functions until an admin is logged in.

https://www.zen-cart.com/downloads.php?do=file&id=9
Now available for download.

31 Oct 2019, 5:50 PM
#764
creyesx6 avatar

creyesx6

Inactive

Join Date:
Dec 2010
Location:
U.S. State of Texas
Posts:
76
Plugin Contributions:
0

Re: Sales report 2.0

lat9:

Now available for download: https://www.zen-cart.com/downloads.php?do=file&id=9

Thanks for the work. I am looking forward to seeing how it works.

Question. I have installed the plugin to my Admin folder without an issue and since this is the first install, I had no overrides. However, after logging in to Admin and Reports I do not see any sales report option as if it was never installed. Again, I verified that all files transferred over.

I am using v 1.5.5f and I installed the most recent version from github for 1.5.5 and later. I am currently using the Westminster template and have not installed any other report plugins. I am using php 7.2. Not sure if it helps or not but the website is pfcind.com. If you need any other information, please let me know.

Thank you.

31 Oct 2019, 6:35 PM
#765
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

creyesx6:

Thanks for the work. I am looking forward to seeing how it works.

Question. I have installed the plugin to my Admin folder without an issue and since this is the first install, I had no overrides. However, after logging in to Admin and Reports I do not see any sales report option as if it was never installed. Again, I verified that all files transferred over.

I am using v 1.5.5f and I installed the most recent version from github for 1.5.5 and later. I am currently using the Westminster template and have not installed any other report plugins. I am using php 7.2. Not sure if it helps or not but the website is pfcind.com. If you need any other information, please let me know.

Thank you.
The plugin, in and of itself, has no overrides! Since it's an admin-only contribution, your store's current template doesn't matter.

Have you looked at the admin's "Reports" dropdown? That's where the "Sales Report" will show up if it's correctly installed.

Make sure that (a) you installed all the files to your site's admin sub-directory and (b) that the file /admin/includes/extra_datafiles/sales_report_filenames.php is present (where /admin is the pseudonym for your 'secret' admin directory).

31 Oct 2019, 6:43 PM
#766
creyesx6 avatar

creyesx6

Inactive

Join Date:
Dec 2010
Location:
U.S. State of Texas
Posts:
76
Plugin Contributions:
0

Re: Sales report 2.0

Thanks for the response.
I checked the Admin Reports menu and have the following: Customer-Orders-Total, Customers Referral, Products Low Stock, Products Purchased, Products Viewed, Search Log. As I understand it, I should see a "Sales Report" option as well. I checked and confirmed that my admin directory does include [myadmin]/includes/extra_datafiles/sales_report_filenames.php. I am going to check each and every file used from GitHub to be sure they each transferred one by one. But I am fairly confident I will find that they have all transferred. I will report the results. Thanks for getting back to me :smile:

31 Oct 2019, 6:51 PM
#767
creyesx6 avatar

creyesx6

Inactive

Join Date:
Dec 2010
Location:
U.S. State of Texas
Posts:
76
Plugin Contributions:
0

Re: Sales report 2.0

I checked and confirmed that 6 files plus Image files were transferred over. If there are more than 6 files to be transferred over, then I am missing files.

31 Oct 2019, 7:08 PM
#768
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

What happens if you change your browser's address bar (when you're logged into the admin) to read pfcind.com/admin-dir-name/stats_sales_report.php and press Enter? Does the sales-report display?

31 Oct 2019, 7:14 PM
#769
creyesx6 avatar

creyesx6

Inactive

Join Date:
Dec 2010
Location:
U.S. State of Texas
Posts:
76
Plugin Contributions:
0

Re: Sales report 2.0

lat9:

What happens if you change your browser's address bar (when you're logged into the admin) to read pfcind.com/admin-dir-name/stats_sales_report.php and press Enter? Does the sales-report display?

Yes it absolutely does. I can see Preset Date Range with options, etc....... For some reason, it's just not displaying in the menu. Sounds like a mysql issue?

31 Oct 2019, 7:40 PM
#770
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

creyesx6:

Yes it absolutely does. I can see Preset Date Range with options, etc....... For some reason, it's just not displaying in the menu. Sounds like a mysql issue?
That's weird, since the admin-page registration should have been performed by the plugin's /admin/includes/functions/extra_functions file.

If you inspect your database via your webhost's phpMyAdmin and view the admin_pages table, do you see a page_key named stats_sales_report?

1 Nov 2019, 1:54 PM
#771
creyesx6 avatar

creyesx6

Inactive

Join Date:
Dec 2010
Location:
U.S. State of Texas
Posts:
76
Plugin Contributions:
0

Re: Sales report 2.0

lat9:

That's weird, since the admin-page registration should have been performed by the plugin's /admin/includes/functions/extra_functions file.

If you inspect your database via your webhost's phpMyAdmin and view the admin_pages table, do you see a page_key named stats_sales_report?

I just checked and no, it is not there. If I add will it resolve? Can you advise the parameters for this entry? Thanks again for your help.

1 Nov 2019, 2:00 PM
#772
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

creyesx6:

I just checked and no, it is not there. If I add will it resolve? Can you advise the parameters for this entry? Thanks again for your help.
That's exactly what the file /YOUR_ADMIN/includes/functions/extra_functions/stats_sales_report.php does. Are you sure you copied that file to your admin's sub-directory?

1 Nov 2019, 2:05 PM
#773
creyesx6 avatar

creyesx6

Inactive

Join Date:
Dec 2010
Location:
U.S. State of Texas
Posts:
76
Plugin Contributions:
0

Re: Sales report 2.0

lat9:

That's exactly what the file /YOUR_ADMIN/includes/functions/extra_functions/stats_sales_report.php does. Are you sure you copied that file to your admin's sub-directory?

Yes, it is absolutely there.
Here is the contents of that file. I copied this over from my server.

<?php /** * SALES REPORT 3.3.2 * * @author Frank Koehl (PM: BlindSide) * @author Conor Kerr <[email protected]> * @updated by stellarweb to work with version 1.5.0 02-29-12 * @updated by lat9, supporting zc1.5.5/1/5.6, 2019-06-20 * @copyright Portions Copyright 2003-2006 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license <http://www.gnu.org/copyleft/gpl.html> GNU Public License V2.0 */ if (!defined('IS_ADMIN_FLAG')) { die('Illegal Access'); } // ----- // Bail if an admin isn't logged in, e.g. if a currency-cron is running. // if (empty($_SESSION['admin_id'])) { return; } // ----- // If the report's page-key entry doesn't net exist, add it. // if (!zen_page_key_exists('stats_sales_report')) { zen_register_admin_page('stats_sales_report', 'BOX_REPORTS_SALES_REPORT', 'FILENAME_STATS_SALES_REPORT', '', 'reports', 'Y'); }
1 Nov 2019, 3:26 PM
#774
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

This makes no sense. Are you sure that the file is in the /admin/includes/functions/extra_functions subdirectory?

Are you receiving any myDEBUG-adm-*.log files in your store's /logs subdirectory? Remember that those files will include references to your site's admin directory name, so if you choose to post some be sure to xxx-out that and use the "CODE" tags (the big **# **in the menu-bar when you're writing your post) to enclose that log-file content.

1 Nov 2019, 3:42 PM
#775
creyesx6 avatar

creyesx6

Inactive

Join Date:
Dec 2010
Location:
U.S. State of Texas
Posts:
76
Plugin Contributions:
0

Re: Sales report 2.0

lat9:

This makes no sense. Are you sure that the file is in the /admin/includes/functions/extra_functions subdirectory?

Are you receiving any myDEBUG-adm-*.log files in your store's /logs subdirectory? Remember that those files will include references to your site's admin directory name, so if you choose to post some be sure to xxx-out that and use the "CODE" tags (the big **# **in the menu-bar when you're writing your post) to enclose that log-file content.

Yes, the file is located in the subdirectory as mentioned above. I checked the logs file under public_html/logs and I do not have any errors since it was installed yesterday. I installed a total of 6 files for the plugin from Github and I checked those against my server and they match with the exact same directory names (after I changed to my custom admin directory). I am not aware of any other location of where the error logs may be. I do check for error logs as I run into issues but none in this case. After pulling up the sales report via url provided I did find that the screen view did not work and when downloading the file, I had to change the extension to a .csv to view, but there were no headings, not sure if there was supposed to be any. Not sure if this additional info helps or not.

1 Nov 2019, 3:59 PM
#776
creyesx6 avatar

creyesx6

Inactive

Join Date:
Dec 2010
Location:
U.S. State of Texas
Posts:
76
Plugin Contributions:
0

Re: Sales report 2.0

I did find an error but this was prior to the install of this plugin. It is as follows:

#[28-Oct-2019 09:06:12 US/Central] Request URI: /[myadmin]/categories.php?cPath=10&pID=796&page=3, IP address: 24.173.44.158

[28-Oct-2019 09:06:12 US/Central] PHP Warning:  Creating default object from empty value in /home/xxx/public_html/[myadmin]/categories.php on line 1010
1 Nov 2019, 8:33 PM
#777
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

@creyesx6, thanks for "sticking with me" on this. After inspection, the issue is that the plugin's menu-bar addition occurs when the 'extra_functions' load ... which is prior to the admin's session initialization.

Unfortunately, that extra_functions processing is checking to see if an admin session is currently active (which it won't be based on the load-point of the processing).

I'll be updating the Sales Report plugin to remove that "is an admin active?" check to allow the menu-bar registration to complete successfully.

1 Nov 2019, 9:02 PM
#778
creyesx6 avatar

creyesx6

Inactive

Join Date:
Dec 2010
Location:
U.S. State of Texas
Posts:
76
Plugin Contributions:
0

Re: Sales report 2.0

Awesome! Thanks so much for your help and resolution. Looking forward to putting it to good use!!

2 Nov 2019, 11:29 AM
#779
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

GitHub issue created: https://github.com/lat9/sales_report/issues/18

I'll wait a bit for a new release, just in case other gremlins come to the surface!

25 Nov 2019, 11:00 PM
#780
speak394 avatar

speak394

New Zenner

Join Date:
Mar 2018
Location:
Alabama
Posts:
61
Plugin Contributions:
0

Re: Sales report 2.0

Using Zen 1.54
PHP 5.6

Will this sales report work with my set up.

I need a report to show me which products have sold the most in specific time periods.