Forums / Addon Admin Tools / Sales report 2.0

Sales report 2.0

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

Results 381 to 400 of 882
19 Oct 2009, 6:52 PM
#381
erinl avatar

erinl

New Zenner

Join Date:
May 2007
Posts:
62
Plugin Contributions:
0

Sales report 2.0

Hello,

I have just installed sales report 2.0. I have tried to change the settings in my profiles admin to select the admin profiles and save the changes. The changes never seem to save so it is always unselected. I get the error message that I don't have permission to use sales reports.

Any help would be greatly appreciated.

Erin
https://www.momandbabyboutique.com

19 Oct 2009, 6:58 PM
#382
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

Pardon my dumbness, but I don't understand.
You're in zencart admin, how do you change profiles admin? what are admin profiles?

I just may need more step by step to understand. You try to generate a report saying "Reports -> Sales Report", and it says you don't have permission?

Are you using the 'Reports Defaults' button? How?

19 Oct 2009, 7:11 PM
#383
dinki avatar

dinki

Zen Follower

Join Date:
Oct 2006
Posts:
206
Plugin Contributions:
0

Re: Sales report 2.0

dinki:

Can someone tell me how I can get my Paypal fees to show up in the report in place of another field that I don't use? I'm thinking I could get rid of the gift certificates field. I know the fee information is stored in the database, I just don't know where and how to incorporate it.

Please please please? Tax season will be upon us before we know it! This would make life so much easier on those of us who use Paypal AND file taxes.

Visit my Decal website: DecalDepot.net

20 Oct 2009, 2:47 AM
#384
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

I've done some work to capture paypal transactions into SO as they occur. Another approach is to find the transactions after the fact during report generation. These were both posted in the SO support thread.

20 Oct 2009, 1:11 PM
#385
dinki avatar

dinki

Zen Follower

Join Date:
Oct 2006
Posts:
206
Plugin Contributions:
0

Re: Sales report 2.0

Thanks for the information, but please excuse my ignorance when I ask what 'SO' is?

Visit my Decal website: DecalDepot.net

20 Oct 2009, 1:25 PM
#386
erinl avatar

erinl

New Zenner

Join Date:
May 2007
Posts:
62
Plugin Contributions:
0

Re: Sales report 2.0

carlvt88:

Pardon my dumbness, but I don't understand.
You're in zencart admin, how do you change profiles admin? what are admin profiles?

I have installed the "Admin Profiles" mod so that my staff can update the site without access to all of the admin. Frankly - zencart admin can be very confusing so I try to keep it simple and only give them the basics.

carlvt88:

I just may need more step by step to understand. You try to generate a report saying "Reports -> Sales Report", and it says you don't have permission?

I go to "Reports -> Sales Report and I receive the error message "Sorry, your security clearance does not allow you to access this resource.
Please contact your site administrator if you believe this to be incorrect.
Sorry for any inconvenience."

carlvt88:

Are you using the 'Reports Defaults' button? How?

I'm not sure what you are asking.

Thanks for responding.

Erin
https://www.momandbabyboutique.com

20 Oct 2009, 1:39 PM
#387
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

Thanks Erin - makes more sense to me now. I'm unfamiliar with the admin profiles module so I can't help much here, and it sounds like that may be the source of the problem. Of course if it's the interaction between the two modules, might need someone who uses both to weigh in here.

I might load up admin profiles, but probably not until November as I'm in busy season now.

20 Oct 2009, 1:46 PM
#388
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

Sorry Dinki - it was a rushed response. SO is the super orders module, written by the same author, there's a lot of overlap between the modules.

Here's a post on post-processing data, and here's one on capturing the data up front.

I can probably help more as time allows, but not until November.

21 Oct 2009, 2:48 AM
#389
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

Dinki, send me a PM. I may have generated the paypal report you're looking for, you're welcome to see if it works.

23 Oct 2009, 1:27 AM
#390
erinl avatar

erinl

New Zenner

Join Date:
May 2007
Posts:
62
Plugin Contributions:
0

Re: Sales report 2.0

Anyone? I'm still can't get this to work. I haven't been separating my store sales from my on-line sales and I need to know that info now.

Thanks,
Erin
https://www.momandbabyboutique.com

erinl:

Hello,

I have just installed sales report 2.0. I have tried to change the settings in my profiles admin to select the admin profiles and save the changes. The changes never seem to save so it is always unselected. I get the error message that I don't have permission to use sales reports.

Any help would be greatly appreciated.

Erin
www.momandbabyboutique.com

23 Oct 2009, 1:57 AM
#391
redheads avatar

redheads

Zen Follower

Join Date:
May 2006
Posts:
119
Plugin Contributions:
0

Re: Sales report 2.0

I would try uninstalling the admin profiles, OR before I do that I might try assigning myself a new profile with all permissions and try logging in from there to run the reports.

23 Oct 2009, 2:45 AM
#392
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

Again, disclaimers that I'm really unfamiliar with this module, bla bla bla,

I tried loading this module, so your description makes a little more sense. First problem - you say you go to Tools->Admin settings, click on the Preferences logo to edit preferences for a user, select some items, click save, then when you go back to look at that user's preferences again, the changes aren't there? If so, it sounds like you're not writing to the database.

I was able to reproduce your problem. The error message said your security clearance does not allow you to access this resource
In the profile screen (the one with lots of boxes), do you see "stats sales reports" under the Third Party Mods section? At first I didn't, but running though the code would aparently add this module to the internal table of pages, so that the next time through this checkbox appeared. Then, checking the box would enable that capability.

If you can't get that box to appear by letting the module add it by itself, you could manually add it through the SQL patches, but probably better to let the module manage it.

23 Oct 2009, 2:58 AM
#393
tino_schlegel avatar

tino_schlegel

Totally Zenned

Join Date:
Nov 2007
Location:
Melbourne, Australia
Posts:
532
Plugin Contributions:
0

Re: Sales report 2.0

sweetikins:

Hello :-)

I am in need of help with my sales report, it is giving me an error and i cant figure out how to fix it. Here is what it says:

Parse error: syntax error, unexpected $end in C:\wamp\www\Test Zen\admin\stats_sales_report.php on line 1229

Now line 1229 is the following

I originally got the unexpected $end in C:\wamp\www\Test Zen\admin\stats_sales_report.php on line 1187

Had the same problem on a Windows machine.

Its because of the php parser. To fix this problem, you have to replace 2 occurences of <? in

In Line 693 and 1029

Replace

<?

with

<?php
23 Oct 2009, 12:25 PM
#394
dinki avatar

dinki

Zen Follower

Join Date:
Oct 2006
Posts:
206
Plugin Contributions:
0

Re: Sales report 2.0

dinki:

Please please please? Tax season will be upon us before we know it! This would make life so much easier on those of us who use Paypal AND file taxes.

I figured out a way to get my total Paypal charges for the year by doing:

SELECT SUM(mc_fee)  FROM `paypal` WHERE date_added <= 20100101 AND date_added >= 20090101;

This is done as a query directly on the database. This suits my needs just fine. Thought I'd share for those who may stumble across this.

Visit my Decal website: DecalDepot.net

27 Oct 2009, 7:36 PM
#395
gearheadniko avatar

gearheadniko

New Zenner

Join Date:
Oct 2009
Posts:
63
Plugin Contributions:
0

Re: Sales report 2.0

BlindSide:

Well it's been a long time in the making, but hopefully the wait was worth it! Sales Report 2.0 is here, so go get it!

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=83

You can drop the files right into the admin and right over top of the existing files. Still no overwrites. :thumbsup:

Take it for a spin, and let me know what you think, and if you find any problems. I've been using it for the past few months as I built and tweaked it, so there should be no major issues.

Enjoy, and thanks for your patience.
I have installed Sales Report as directed, but "Sales Report" does not appear under "Reports" any clues, Thanks

28 Oct 2009, 1:16 PM
#396
gearheadniko avatar

gearheadniko

New Zenner

Join Date:
Oct 2009
Posts:
63
Plugin Contributions:
0

Re: Sales report 2.0

I have uploaded Sales Report, but there is no indication it is there or working, There is NO "Sales Report" under "Reports" in Admin. Does anyone have any clue as to what my problem is?

8 Nov 2009, 1:55 PM
#397
noruga avatar

noruga

New Zenner

Join Date:
May 2009
Posts:
31
Plugin Contributions:
0

Re: Sales report 2.0

I am having the same problem. "Sales report" does not appear under "Reports".

8 Nov 2009, 3:32 PM
#398
nagelkruid avatar

nagelkruid

Zen Follower

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

Re: Sales report 2.0

dinki:

I figured out a way to get my total Paypal charges for the year by doing:

SELECT SUM(mc_fee) FROM paypal WHERE date_added <= 20100101 AND date_added >= 20090101;


Hi,
I needed this functionality too, so i have a new version that will show paypal stuff in the report. paypal columns will only be in order view, not in product view as they wont make sense in there.

There is no check yet to see if the paypal table is present so if you don't use paypal, it makes no sense to use the paypal report.

In this zip, i have included conner's latest version with date fixes for the original blindside version and also the paypal report which elaborates on conner's version. Both versions will run next to each other so you will have 2 report options added under reports, Sales Report & Sales Report PayPal.

Please, if anyone can run this in their shop and tell me the results, good or bad, i will be happy to hear.

p.s. also added an option to exclude a "current status" so if you don't want orders to show up that are currently assigned to "cancelled" or something similar. that should be possible.
p.s.s added dutch language files as i am dutch :P

:oops:file limits don't allow me to post the zip here so please get it from [here](http://www.xs4all.nl/%7Evee/sales_report_2.3.0rc1_for_zc.zip).

Cheers,
Jeroen
22 Nov 2009, 8:43 PM
#399
avf avatar

avf

New Zenner

Join Date:
May 2008
Posts:
87
Plugin Contributions:
0

Re: Sales report 2.0

have been using this mod as the only one to really let me know how sales are happening on my site. greatone ! Thanks.

i would like to remove the time limit for grouping as is now for daily, monthly yearly to "all time"

As my site is more than a year old I want to see which products i am selling an how much without the yearly grouping just all time.
Any help would be highly appreciated
Thanks
AVF

1 Dec 2009, 9:35 PM
#400
solarsmith avatar

solarsmith

New Zenner

Join Date:
Dec 2009
Posts:
2
Plugin Contributions:
0

Re: Sales report 2.0

:lamo:

Help! No matter what time frame I select, the Sales Report shows NO sales for that time period.

My host is HostMonster, which says my Zen Cart is the latest version, my browser is Firefox, I have cookies on, and use a Mac iBook G4.

Anybody have a similar problem? For a while I was getting shot back to the LogIn page whenever I dared to ask for a sales report. Now at least it's "better". But no sales showing in time frames when I know I've had mucho sales.

avf, sorry to post this as a reply to you, but I'm new to this forum and I couldn't find a simple "post message" button anywhere.

solarsmith