Forums / Addon Admin Tools / Sales report 2.0

Sales report 2.0

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

Results 161 to 180 of 882
19 Mar 2007, 6:36 PM
#161
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Sales report 2.0

Yes, the Sales Report works with all versions of Zen Cart 1.3.x.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

19 Mar 2007, 6:39 PM
#162
clubaddict avatar

clubaddict

New Zenner

Join Date:
Mar 2007
Location:
Belfast, United Kingdom
Posts:
6
Plugin Contributions:
0

Re: Sales report 2.0

excellent, thanks for the reply BS

19 Mar 2007, 9:27 PM
#163
clubaddict avatar

clubaddict

New Zenner

Join Date:
Mar 2007
Location:
Belfast, United Kingdom
Posts:
6
Plugin Contributions:
0

Re: Sales report 2.0

quick question.... is there anyway that instead of having this report on manufacturers, to have it report on record label/record artist instead?

20 Mar 2007, 1:54 AM
#164
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: Sales report 2.0

It's not a drag-n-drop kind of feature, it would require customizing the report, both the class file (does the searching/calculations) and the admin page (search and report output).

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

20 Mar 2007, 1:11 PM
#165
fullup avatar

fullup

New Zenner

Join Date:
Feb 2007
Posts:
9
Plugin Contributions:
0

Re: Sales report 2.0

Doesn't work with either Firefox of Safari.

Thank you

20 Mar 2007, 2:37 PM
#166
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: Sales report 2.0

Make sure that the JavaScript file, sales_report.js.php, is in it's place in the admin/includes/javascript folder. For that matter, I would check the entire file upload.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

21 Mar 2007, 4:57 AM
#167
fullup avatar

fullup

New Zenner

Join Date:
Feb 2007
Posts:
9
Plugin Contributions:
0

Re: Sales report 2.0

OK, I reloaded it again. Triple checked the locations. Now I have this error:

Parse error: syntax error, unexpected $end in /Library/WebServer/Documents/tc/admin/stats_sales_report.php on line 1187

Thanks for the help.

22 Mar 2007, 1:56 PM
#168
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: Sales report 2.0

What version of PHP are you running? Windows or Linux?

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

23 Mar 2007, 5:44 AM
#169
fullup avatar

fullup

New Zenner

Join Date:
Feb 2007
Posts:
9
Plugin Contributions:
0

Re: Sales report 2.0

PHP Version 5.1.2
running on Mac OS X

23 Mar 2007, 1:32 PM
#170
linuxw00t avatar

linuxw00t

New Zenner

Join Date:
Feb 2007
Posts:
4
Plugin Contributions:
0

Re: Sales report 2.0

I'd kind of like to know why mine isn't working. I've uploaded everything correctly.

Zen Cart 1.3.7

**PHP Version 4.3.11
**

**Server OS: ** Linux 2.4.21-47.0.1.ELsmp

**Database: ** MySQL 4.0.27-max-log
**
HTTP Server: ** Apache

26 Mar 2007, 2:35 AM
#171
stevietheman avatar

stevietheman

New Zenner

Join Date:
Mar 2007
Location:
Louisville, Kentucky, USA
Posts:
34
Plugin Contributions:
0

Re: Sales report 2.0

FullUp:

OK, I reloaded it again. Triple checked the locations. Now I have this error:

Parse error: syntax error, unexpected $end in /Library/WebServer/Documents/tc/admin/stats_sales_report.php on line 1187

Thanks for the help.

Here's the fix for this error...

On both lines 693 and 1029, change "<?" to "<?php".

Some PHP servers are configured such that they will choke if "<?" is used instead of "<?php" to begin PHP script.

Enjoy your sales report. :D

Steve Magruder, Freelance Web Programmer
WebCommons :: Web Programming Services

26 Mar 2007, 3:24 AM
#172
stevietheman avatar

stevietheman

New Zenner

Join Date:
Mar 2007
Location:
Louisville, Kentucky, USA
Posts:
34
Plugin Contributions:
0

Re: Sales report 2.0

Also, the "Show me the money!" button not doing anything can be fixed by going into sales_report.js.php and doing the following replaces:

  1. Replace all "<?php////////////" with "////////////".
  2. Replace all "///////////////?>" with "///////////////"

Steve Magruder, Freelance Web Programmer
WebCommons :: Web Programming Services

26 Mar 2007, 4:14 AM
#173
stevietheman avatar

stevietheman

New Zenner

Join Date:
Mar 2007
Location:
Louisville, Kentucky, USA
Posts:
34
Plugin Contributions:
0

Re: Sales report 2.0

Ajeh:

Go to the Tools ... Install SQL Patches ...

ALTER TABLE admin_activity_log CHANGE page_parameters page_parameters TINYTEXT NULL DEFAULT NULL;


In my case, I was seeing the same error, but tinytext wasn't large enough, so instead I did the *alter table* like so...

```php
ALTER TABLE admin_activity_log CHANGE page_parameters page_parameters TEXT NULL DEFAULT NULL; 

Perhaps TEXT is too big, but I was lazy and just wanted it to work without too many steps. :D

Steve Magruder, Freelance Web Programmer
WebCommons :: Web Programming Services

26 Mar 2007, 1:25 PM
#174
fullup avatar

fullup

New Zenner

Join Date:
Feb 2007
Posts:
9
Plugin Contributions:
0

Re: Sales report 2.0

Hey Steve,

Thanks a bunch. Your changes fixed everything.

Jim

stats_sales_report.php
On both lines 693 and 1029, change "<?" to "<?php".

sales_report.js.php

  1. Replace all "<?php////////////" with "////////////".
  2. Replace all "///////////////?>" with "///////////////"
26 Mar 2007, 3:36 PM
#175
stevietheman avatar

stevietheman

New Zenner

Join Date:
Mar 2007
Location:
Louisville, Kentucky, USA
Posts:
34
Plugin Contributions:
0

Re: Sales report 2.0

FullUp:

Hey Steve,

Thanks a bunch. Your changes fixed everything.

Jim

stats_sales_report.php
On both lines 693 and 1029, change "<?" to "<?php".

sales_report.js.php

  1. Replace all "<?php////////////" with "////////////".
  2. Replace all "///////////////?>" with "///////////////"

My pleasure. It was just a result of my minor struggle to get it working for myself, and I figured I would help spare everyone else the pain.

It looks like a great mod. I can't wait to make some use out of it. Thanks BlindSide!

Steve Magruder, Freelance Web Programmer
WebCommons :: Web Programming Services

29 Mar 2007, 2:26 AM
#176
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: Sales report 2.0

Huh, well my apologies to everyone on that one. The goal of the odd tags and comment slashes was to make the description appear when viewing the code but leave it out when the file was included at page load. I'll take it out for the next release.

Did that solution work for you, linuxw00t?

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

29 Mar 2007, 3:03 AM
#177
fullup avatar

fullup

New Zenner

Join Date:
Feb 2007
Posts:
9
Plugin Contributions:
0

Re: Sales report 2.0

BlindSide, your report is awesome and we all appreciate your sharing it and the time you spend keeping it up to date. Zen-cart is a great community.

Thank you!!!

Jim

30 Mar 2007, 12:27 AM
#178
mikeyg avatar

mikeyg

Totally Zenned

Join Date:
May 2005
Posts:
515
Plugin Contributions:
0

Re: Sales report 2.0

Blind side

Just got this working having changed the admin log to text as above (Steve's fix - Thank you)

I have noticed that if I customise my date selection my start date is UK format (d-m-y) but the end is in US (m-d-Y) format. So If I choose 1st Jan to 2nd Jan I in fact get a report that finishes on 1st Feb.

Where can I fix this to be UK (d-m-y) format for everything.

I have changed the language file to get the reports showing the correct date format, it appears to be just this end date selection box which interprets the selection in the wrong way.

Thanks

MG

31 Mar 2007, 2:13 AM
#179
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: Sales report 2.0

FullUp:

BlindSide, your report is awesome and we all appreciate your sharing it and the time you spend keeping it up to date. Zen-cart is a great community.

Thank you!!!

Jim
Your welcome. Glad you like it! :D
MikeyG:

Blind side

Just got this working having changed the admin log to text as above (Steve's fix - Thank you)

I have noticed that if I customise my date selection my start date is UK format (d-m-y) but the end is in US (m-d-Y) format. So If I choose 1st Jan to 2nd Jan I in fact get a report that finishes on 1st Feb.

Where can I fix this to be UK (d-m-y) format for everything.

I have changed the language file to get the reports showing the correct date format, it appears to be just this end date selection box which interprets the selection in the wrong way.

Thanks

MG
This problem has been reported in the past. Currently, there is no way to change the date format accepted in the date search boxes. You must either enter the date manually in US m-d-y format or use the JavaScript calendar dropdown to set it for you automatically. An oversight on my part that I'll correct in a future release, my apologies.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

31 Mar 2007, 1:30 PM
#180
arrse avatar

arrse

New Zenner

Join Date:
Nov 2006
Posts:
42
Plugin Contributions:
0

Re: Sales report 2.0

Blindside,
I'd also like to offer you my thanks for a module that is now something I use on almost a daily basis (an addict ... moi!). I know you receive a lot of features requests but if you don't mind I'd like to offer a few of my own:

  1. Multiple selection for Payment Method, Manufacturer and Current Order Status.

  2. An option to show orders by discount code or code(s) used.

  3. Finally I'd echo my support for a UK date format!!

Thanks for all the continued work.