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 141 to 160 of 882
17 Feb 2007, 3:01 AM
#141
candywrap avatar

candywrap

New Zenner

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

Sales report 2.0

Does anyone have this mod working on 1.3.7?
I have installed it on my fresh install of 1.3.7, but no "Sales Report" comes up under "Reports" in the Admin.

17 Feb 2007, 3:17 AM
#142
candywrap avatar

candywrap

New Zenner

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

Re: Sales report 2.0

candywrap:

Does anyone have this mod working on 1.3.7?
I have installed it on my fresh install of 1.3.7, but no "Sales Report" comes up under "Reports" in the Admin.

Doh! Never mind. Forgot I re-named my admin folder for security reasons.:blush:

21 Feb 2007, 7:21 PM
#143
fullup avatar

fullup

New Zenner

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

Re: Sales report 2.0

I just installed Sales Report (rev 104) on a fresh copy of Zen-cart 1.3.7. When I click on Sales Report from the admin/reports/ menu I get a blank screen. Any thoughts or help would be appreciated.

23 Feb 2007, 1:41 AM
#144
mikeyg avatar

mikeyg

Totally Zenned

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

Re: Sales report 2.0

BlindSide.

I have just installed Sales report an on running a report get the foll0wing error.

1406 Data too long for column 'page_parameters' at row 1
in:
[insert into fmadmin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (now(), '1', 'stats_sales_report.php', 'date_preset=yesterday&start_date=&end_date=&date_target=status&date_status=2&payment_method=&current_status=&manufacturer=&timeframe=day&timeframe_sort=asc&detail_level=product&li_sort_a=model&li_sort_order_a=asc&li_sort_b=name&li_sort_order_b=asc&output_format=print&', '192.168.30.21')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any thoughts

Thanks

Mikey G

23 Feb 2007, 5:49 AM
#145
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Sales report 2.0

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

ALTER TABLE admin_activity_log CHANGE page_parameters page_parameters TINYTEXT NULL DEFAULT NULL; 

Does this correct the problem?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

23 Feb 2007, 10:40 AM
#146
mikeyg avatar

mikeyg

Totally Zenned

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

Re: Sales report 2.0

Ajeh,

Unfortunately not still getting the error.

Regards

MG

23 Feb 2007, 2:14 PM
#147
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Sales report 2.0

Check your database table via phpMyAdmin ...

How many tables do you see?

On the table:
admin_activity_log

did it update the field?

Check that your admin and catalog are both using the same server, database, username, password in the files:
/includes/configure.php
/admin/includes/configure.php

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

23 Feb 2007, 11:35 PM
#148
mikeyg avatar

mikeyg

Totally Zenned

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

Re: Sales report 2.0

Ajeh

It appears to have recorded this activity in the log and certainly that field data type when you look at the table structure appears to say tinytext.

If I have understood this right then it appears to have run okay

Cheers

MG

24 Feb 2007, 2:35 AM
#149
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Sales report 2.0

If I go to the Tools ... Install SQL Patches and enter:

insert into fmadmin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (now(), '1', 'stats_sales_report.php', 'date_preset=yesterday&start_date=&end_date=&date_ target=status&date_status=2&payment_method=&curren t_status=&manufacturer=&timeframe=day&timeframe_so rt=asc&detail_level=product&li_sort_a=model&li_sor t_order_a=asc&li_sort_b=name&li_sort_order_b=asc&o utput_format=print&', '192.168.30.21');

I cannot reproduce the error ...

NOTE: I did adjust mine for the table name as mine is admin_activity_log and not fmadmin_activity_log

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

25 Feb 2007, 11:49 PM
#150
sn0ut avatar

sn0ut

New Zenner

Join Date:
Oct 2005
Location:
UK - London
Posts:
56
Plugin Contributions:
3

Re: Sales report 2.0

Mikey G

I sometimes get this same error on my test machine using mysql 5.24 but not on my domain which runs mysql 5.27. What version of db are you running?

27 Feb 2007, 1:55 AM
#151
davestrand avatar

davestrand

New Zenner

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

Re: Sales report 2.0

Hello,

Thanks for this awesome Sales Report system. I'm only having one problem when I try to export my CSV files. I keep getting consistent and unsightly errors in my sheet. It's probably something simple, hopefully someone can help.

Here are my settings.

Custom Date Range
Order Purchased
+Product Line Items
CSV Export
Column Titles in First Row

And I keep getting this error every few Rows..

<b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/.cara/davestra/strandland.com/digitalstore/admin/includes/classes/sales_report.php</b> on line <b>908</b><br />

or this one...

<b>Warning</b>: array_multisort() [<a href='function.array-multisort?zenAdminID=4baf46482870f18dcf2411f16f568494'>function.array-multisort</a>]: Argument #1 is expected to be an array or a sort flag in <b>/home/.cara/davestra/strandland.com/digitalstore/admin/includes/classes/sales_report.php</b> on line <b>915</b><br />

or this one...

<b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/.cara/davestra/strandland.com/digitalstore/admin/includes/classes/sales_report.php</b> on line <b>908</b><br />

Sorry, I'm new to this stuff, so I dunno what it means.

THanks,
-Dave

Here's my store if you need that...
http://www.strandland.com/digitalstore

5 Mar 2007, 2:49 PM
#152
linuxw00t avatar

linuxw00t

New Zenner

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

Re: Sales report 2.0

I am having trouble using this sales report tool. I am trying to use it and it doesn't generate any reports. I have double checked to make sure everything is in its proper location. So I am not sure what I am doing wrong...

7 Mar 2007, 12:39 PM
#153
dogtags avatar

dogtags

Totally Zenned

Join Date:
Nov 2003
Posts:
876
Plugin Contributions:
1

Re: Sales report 2.0

Might need to add a filter:

State

to pull out sales data on a per-state basis.

Any suggestions on how to do this?

Many thanks :smile:

15 Mar 2007, 4:38 PM
#154
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

**@davestrand:**What version fo PHP are you using? Your errors typically happen when an older version of PHP is being used. You need to be running at least 4.2.2.

@linuxw00t: That tells me nothing, so it's pretty hard for me to help you. Does the search come up at all? When you submit a search, does the screen refresh, or just hang? Does a new page come up totally blank? Give me details about exactly what behavior you are experiencing.

@DogTags: Off-hand I'd say that a per state filter would require some serious adjustments to the report, as that kind of filtering happens in the core of the data mining process. You'll need to know what's happening in the sales_report class.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

16 Mar 2007, 12:30 PM
#155
fullup avatar

fullup

New Zenner

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

Re: Sales report 2.0

Blindside, like @linuxw00t: the search screen appears and then does nothing when you click Show me the money! No screen refresh. It just hangs.

Zen version 1.3.7
Sales Report 2.0

16 Mar 2007, 2:28 PM
#156
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

Does the progress indicator on your browser move at all (it should)? What browser and version are you using?

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

16 Mar 2007, 11:04 PM
#157
linuxw00t avatar

linuxw00t

New Zenner

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

Re: Sales report 2.0

I try using it using the different options and then I click the 'show me the money' button and it doesn't do anything its just as if I made a button just to click. The browser progress doesn't do anything. Just like if I said 'click here' and you tried to click it. I have the correct software and everything is in its proper place.

17 Mar 2007, 1:12 PM
#158
fullup avatar

fullup

New Zenner

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

Re: Sales report 2.0

I'm using Firefox 2.0 and Safari. No, the progress bar does not move or even show for that matter.

Thanks for the help.

J

19 Mar 2007, 1:36 PM
#159
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

Sounds like Safari doesn't like the JavaScript being used with the submit button. Can you try it with Firefox to confirm?

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

19 Mar 2007, 6:06 PM
#160
clubaddict avatar

clubaddict

New Zenner

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

Re: Sales report 2.0

does this work with the latest 1.3.7?