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 701 to 720 of 882
16 Sep 2017, 9:02 PM
#701
kavlito avatar

kavlito

New Zenner

Join Date:
Sep 2009
Posts:
40
Plugin Contributions:
0

Sales report 2.0

bseller:

I just installed SALES REPORT Version 2.3.2. I have the same problem with Goods Value subtracting sales tax. Isn't this a basic bug that can be fixed?

I am curious if your changes are working properly and if you ever received feedback?

I appreciate your help.

While I see that this question has got no response to it, it did work for me. Thanks.

23 Sep 2017, 8:33 PM
#702
rayzermatic avatar

rayzermatic

New Zenner

Join Date:
Sep 2011
Posts:
11
Plugin Contributions:
0

Re: Sales report 2.0

Hi,

Can the "order date" be added to the report listing easily? Maybe between ID and Customer.

18 Oct 2017, 6:54 PM
#703
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.2.0 of the "Sales Report" to the plugins for review; I'll post back here once it's available.

This version contains the following changes/bugfixes:

[CHANGE] Updated class selector for use under PHP 7.0 and later
[BUGFIX] Column-count "off" for CSV output when taxes are included.
[BUGFIX] Manufacturer filter was not being honored
[CHANGE] Applied PSR-2 styling to the various modules.
[BUGFIX] Correct year display for "Last Year" selection.

20 Oct 2017, 3:57 PM
#704
deno avatar

deno

New Zenner

Join Date:
Mar 2009
Posts:
76
Plugin Contributions:
0

Re: Sales report 2.0

Hi

My customer has asked if I can produce a CSV report that has the following data:

Product Ordered
Number Of Products
Price of each product
Price of postage
Destination country of order

Is Sales Report capable of doing this?

Thanks

Dene

20 Oct 2017, 4:34 PM
#705
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

Deno:

Hi

My customer has asked if I can produce a CSV report that has the following data:

Product Ordered
Number Of Products
Price of each product
Price of postage
Destination country of order

Is Sales Report capable of doing this?

Thanks

Dene
With custom modification, yes. It's not something that the plugin does out-of-the-box.

20 Oct 2017, 6:55 PM
#706
deno avatar

deno

New Zenner

Join Date:
Mar 2009
Posts:
76
Plugin Contributions:
0

Re: Sales report 2.0

lat9:

With custom modification, yes. It's not something that the plugin does out-of-the-box.

That sounds good. Is there any documentation I could get that would guide me in that direction?

Thanks

Dene

20 Oct 2017, 7:06 PM
#707
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

Deno:

That sounds good. Is there any documentation I could get that would guide me in that direction?

Thanks

Dene
Unfortunately, the plugin's documentation is sparse at best. You'll be looking to make changes to the plugin's class-file (/admin/includes/classes/sales_report.php) to add the columns that your customer desires.

20 Oct 2017, 7:10 PM
#708
deno avatar

deno

New Zenner

Join Date:
Mar 2009
Posts:
76
Plugin Contributions:
0

Re: Sales report 2.0

Thanks for the heads up, i'll check it out...

Dene

21 Oct 2017, 8:22 AM
#709
deno avatar

deno

New Zenner

Join Date:
Mar 2009
Posts:
76
Plugin Contributions:
0

Re: Sales report 2.0

Deno:

Thanks for the heads up, i'll check it out...

Dene

Is there anyone on here that can help me put this together as it's above my head?

I'll like it customizing to prepare a report like above. If this is possible please let me know how much it would cost.

Thanks

Dene

28 Oct 2017, 5:11 PM
#710
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.2.0 of the "Sales Report" to the plugins for review; I'll post back here once it's available.

This version contains the following changes/bugfixes:

[CHANGE] Updated class selector for use under PHP 7.0 and later
[BUGFIX] Column-count "off" for CSV output when taxes are included.
[BUGFIX] Manufacturer filter was not being honored
[CHANGE] Applied PSR-2 styling to the various modules.
[BUGFIX] Correct year display for "Last Year" selection.
v3.2.0 is now available for download.

10 Nov 2017, 12:00 PM
#711
congerman avatar

congerman

Zen Follower

Join Date:
Oct 2008
Posts:
392
Plugin Contributions:
0

Re: Sales report 2.0

Just installed this mod but when I go to the report link I get a white page with the words "Illegal Access" at the top left of the screen. Zen vrs 1.5.5c

10 Nov 2017, 1:05 PM
#712
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

Congerman:

Just installed this mod but when I go to the report link I get a white page with the words "Illegal Access" at the top left of the screen. Zen vrs 1.5.5c
That "Illegal Access" usually means that the plugin was being used outside of the Zen Cart environment (the IS_ADMIN_FLAG definition is used for the determination). The only place in the Sales Report's distribution that the message is used is in /YOUR_ADMIN/includes/functions/extra_functions/stats_sales_report.php.

Unfortunately, the plugin has historically included multiple files of the same name, i.e. stats_sales_report.php. Make sure that you didn't "finger-check" and copy that extra_functions version of the file to the /YOUR_ADMIN directory.

10 Nov 2017, 1:15 PM
#713
congerman avatar

congerman

Zen Follower

Join Date:
Oct 2008
Posts:
392
Plugin Contributions:
0

Re: Sales report 2.0

lat9:

That "Illegal Access" usually means that the plugin was being used outside of the Zen Cart environment (the IS_ADMIN_FLAG definition is used for the determination). The only place in the Sales Report's distribution that the message is used is in /YOUR_ADMIN/includes/functions/extra_functions/stats_sales_report.php.

Unfortunately, the plugin has historically included multiple files of the same name, i.e. stats_sales_report.php. Make sure that you didn't "finger-check" and copy that extra_functions version of the file to the /YOUR_ADMIN directory.

All I did was put all the files, in the supplied structure, into my admin folder. Not sure what you mean by "finger-check" are you saying that I should put all the files except the extra functions one?

10 Nov 2017, 1:51 PM
#714
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

Congerman:

All I did was put all the files, in the supplied structure, into my admin folder. Not sure what you mean by "finger-check" are you saying that I should put all the files except the extra functions one?
Nope, that extra-functions one is what adds the link to the report itself. What happens if you edit that /extra_functions/sales_report.php, changing

<?php
/**
 * SALES REPORT 3.1
 *
 * @author     Frank Koehl (PM: BlindSide)
 * @author     Conor Kerr <[email protected]>
 * @updated by stellarweb to work with version 1.5.0 02-29-12 
 * @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');
}

if (function_exists('zen_register_admin_page')) {
    if (!zen_page_key_exists('stats_sales_report')) {
        // Add Monthly Report link to Reports menu
        zen_register_admin_page('stats_sales_report', 'BOX_REPORTS_SALES_REPORT','FILENAME_STATS_SALES_REPORT', '', 'reports', 'Y', 17);
    }
}
?>

to

<?php
/**
 * SALES REPORT 3.1
 *
 * @author     Frank Koehl (PM: BlindSide)
 * @author     Conor Kerr <[email protected]>
 * @updated by stellarweb to work with version 1.5.0 02-29-12 
 * @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')) {
    [B]trigger_error[/B]('Illegal Access'[B], E_USER_WARNING[/B]);
}

if (function_exists('zen_register_admin_page')) {
    if (!zen_page_key_exists('stats_sales_report')) {
        // Add Monthly Report link to Reports menu
        zen_register_admin_page('stats_sales_report', 'BOX_REPORTS_SALES_REPORT','FILENAME_STATS_SALES_REPORT', '', 'reports', 'Y', 17);
    }
}
?>

Is a debug-log generated after that change or do you still see the "Illegal access" message? If a debug-log is created, please post it back.

10 Nov 2017, 2:07 PM
#715
congerman avatar

congerman

Zen Follower

Join Date:
Oct 2008
Posts:
392
Plugin Contributions:
0

Re: Sales report 2.0

Interesting. I made the change and as dreamweaver was uploading, part of the text kept saying "sales report gives illegal access error. I then went to admin and the report is there ( not fully tested it yet so do not know if working as should be) an error log was created but it is 1723 lines long I am just replacing my admin folder details on it. Would you still like it posted here or PM'd

10 Nov 2017, 2:15 PM
#716
lat9 avatar

lat9

Administrator

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

Re: Sales report 2.0

Congerman:

Interesting. I made the change and as dreamweaver was uploading, part of the text kept saying "sales report gives illegal access error. I then went to admin and the report is there ( not fully tested it yet so do not know if working as should be) an error log was created but it is 1723 lines long I am just replacing my admin folder details on it. Would you still like it posted here or PM'd
PM sent.

10 Nov 2017, 9:21 PM
#717
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,900
Plugin Contributions:
22

Re: Sales report 2.0

Congerman:

I made the change and as dreamweaver was uploading...Paraphrasing Elmer Fudd, be vewwy, vewwy careful when using dreamweaver for file editing, etc. Unless you are vewwy, vewwy careful, it will add code that will munge things up in a hurry.

I often tell customers that want to use programs like that to open Word, type Hello World!, save it as html, then open it in notepad. You'll be amazed.

Stick to the simple editors. If you've just got to have some bells and whistles, try Ultra-Edit. Like Dreamweaver, it's commercial but it does not add extraneous code.

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

10 Nov 2017, 9:41 PM
#718
design75 avatar

design75

Totally Zenned

Join Date:
Dec 2009
Location:
Amersfoort, The Netherlands
Posts:
2,862
Plugin Contributions:
5

Re: Sales report 2.0

Or use Notepad++ as a simple txt editor with some whistles, it is free. Or if you want a full IDE editor use something like NetBeans, which is also free> dbltoe:

Paraphrasing Elmer Fudd, be vewwy, vewwy careful when using dreamweaver for file editing, etc. Unless you are vewwy, vewwy careful, it will add code that will munge things up in a hurry.

I often tell customers that want to use programs like that to open Word, type Hello World!, save it as html, then open it in notepad. You'll be amazed.

Stick to the simple editors. If you've just got to have some bells and whistles, try Ultra-Edit. Like Dreamweaver, it's commercial but it does not add extraneous code.

10 Nov 2017, 9:59 PM
#719
congerman avatar

congerman

Zen Follower

Join Date:
Oct 2008
Posts:
392
Plugin Contributions:
0

Re: Sales report 2.0

dbltoe:

Paraphrasing Elmer Fudd, be vewwy, vewwy careful when using dreamweaver for file editing, etc. Unless you are vewwy, vewwy careful, it will add code that will munge things up in a hurry.

I often tell customers that want to use programs like that to open Word, type Hello World!, save it as html, then open it in notepad. You'll be amazed.

Stick to the simple editors. If you've just got to have some bells and whistles, try Ultra-Edit. Like Dreamweaver, it's commercial but it does not add extraneous code.

I have been using dreamweaver for 17 years and never had an issue with it. Have you been using free, copied, cut down versions?

10 Nov 2017, 10:20 PM
#720
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,900
Plugin Contributions:
22

Re: Sales report 2.0

Bout the same here. Have thru 2015 version but, the minute I had problems with it computing PHP and XHTML correctly, I dropped it like a hot potato for Ultra-Edit. Doesn't mean it is better than Dreamweaver, JetBeans, etc. It just fits my needs. I would probably not have Dreamweaver were it not in a bundle.

For those the "just gotta", take a look at http://tinyurl.com/y8a3ngrg for some info that just could make a difference in your outcome. Hopefully, it's current.

An old thread but maybe helpful at http://tinyurl.com/yczpfkzr

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com