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 201 to 220 of 882
30 May 2007, 8:14 PM
#201
blindside avatar

blindside

Totally Zenned

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

Sales report 2.0

Check where you uploaded the files. Like it says in the readme, everything will work without any configuration, as long as you upload to the proper directory.

Make sure you did not nest the admin folders. So, if your admin is still in a folder called "admin," make sure there's not another folder named "admin" under it:

e.g. "[zen catalog]/admin/admin."

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

5 Jun 2007, 4:22 PM
#202
frenchfrog avatar

frenchfrog

New Zenner

Join Date:
Jan 2007
Posts:
65
Plugin Contributions:
0

Re: Sales report 2.0

Hi everyone!

After installing the module, I'm redirected to the admin login when I'm trying to access the sales report.
After this, all the admin is blocked: login page for every request made. the only way to get out of this is to delete the ZenAdminID cookie.
The weird thing is the mod works from my home computer (Apple Mac mini, OSX 10.4) but doesn't from the office ( Mac G5, same OSX version)

Any idea?

5 Jun 2007, 5:08 PM
#203
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

The SR does absolutely nothing with security permissions; it uses the same standard heading info as all other files in the Admin. Are you using any contribs that affect admin security?

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

5 Jun 2007, 6:02 PM
#204
frenchfrog avatar

frenchfrog

New Zenner

Join Date:
Jan 2007
Posts:
65
Plugin Contributions:
0

Re: Sales report 2.0

I run zencart 1.3.7
I did the little changes suggested in the thread (the php missing after teh questionmark and remove the php from the ///// js)

installed MODS

  1. SEO URLs 3.0 beta (set not to rewrite SSL urls, so it should not affect my admin URLs and redirect. I deactivated it, and the problem is still here. I even tried to change the link to SSL when sales reports is called from teh menu: nothing)
  2. Google analytics
  3. edit orders
    3 ) Easy populate 2.75
  4. impoved who's online
  5. backup MySQL
  6. recover carts
  7. pdf order center
  8. image handler
  9. Checkout without account
  10. TY package tracker

One more thing: my zencart is in a subdirectory of an oscomerce:

https://www.thefrenchybee.com runs on oscomerce
, and its bulk orders branch runs on zencart (https://www.thefrenchybee.com/bulk)

Thanks for your help!

5 Jun 2007, 6:49 PM
#205
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

Does the Sales Report appear properly in the "reports" dropdown? If you mouse over the link in the menu, the URL should appear in the lower left of your browser. Does it have a valid link? Nothing like "STATS_SALES_REPORT" in all caps, right?

Do you see the same behavior if you substitute another admin page for the Sales Report (e.g. orders page)?

Is there any crossover--shared admin, products, etc--between your OSC and Zen Cart stores?

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

5 Jun 2007, 9:22 PM
#206
frenchfrog avatar

frenchfrog

New Zenner

Join Date:
Jan 2007
Posts:
65
Plugin Contributions:
0

Re: Sales report 2.0

BlindSide:

Does the Sales Report appear properly in the "reports" dropdown? If you mouse over the link in the menu, the URL should appear in the lower left of your browser. Does it have a valid link? Nothing like "STATS_SALES_REPORT" in all caps, right?

See attached screenshot, everything looks fine

BlindSide:

Do you see the same behavior if you substitute another admin page for the Sales Report (e.g. orders page)?

all other admin pages work fine UNTIL I select the Sales report option, which blocks the entire admin by asking for a login on every page request. If i delete the zenadmin cookie, I can access the backend again

BlindSide:

Is there any crossover--shared admin, products, etc--between your OSC and Zen Cart stores?

The databases are completely separate. Nothing is shared: no file, no table.

I'm clueless.

Thanks for your input!

5 Jun 2007, 11:35 PM
#207
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

Ok, a few things to consider...

When I use my admin, the zenAdminID cookie is not attached to the link for any of the pages, even for the first click after logging in. Is zenAdminID attached to all the links in the nav menu, or just the SR?

That URL is a secure link, and the address root (secure19.prohosting.com) leads me to believe you use a shared SSL certificate. As above, none of the admin links use SSL by default, so there's something else to look at. Did you do anything fancy with the SSL settings in the admin, like set it to use SSL for every page request? Anything special settings for that shared cert?

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

6 Jun 2007, 1:01 AM
#208
frenchfrog avatar

frenchfrog

New Zenner

Join Date:
Jan 2007
Posts:
65
Plugin Contributions:
0

Re: Sales report 2.0

I was playing with the SSL when I took my screenshot, wondering if it could have an effect but it doesn't. I removed the SSL option from the extra box file and the problem is still present. (my oscom has some SSL calls for pages displaying sensitive info, but Zencart doesn't run this way)

And yes, I have a session ID attached to every link when I navigate in admin and it has always been working like this with my ZC. In my Oscom, that's right, there is no session attached to the URL.

Regarding SSL, yes I do use a shared one.
my sessions setting are as follows:

Session Directory none, not filebased
Cookie Domain True
Force Cookie Use False
Check SSL Session ID True
Check User Agent False
Check IP Address False
Prevent Spider Sessions True
Recreate Session True
IP to Host Conversion Status true

I tried to change the check SSL session ID to false, nothing changed: I still have the session ID in my URL, and SR still doesn't work.

I'm also suspecting a session pb. How can we get rid of this session ID in the url?

6 Jun 2007, 1:06 AM
#209
frenchfrog avatar

frenchfrog

New Zenner

Join Date:
Jan 2007
Posts:
65
Plugin Contributions:
0

Re: Sales report 2.0

I just checked from a PC from the office, and I don;t have any sessions ID attached to my URLs, and it works fine.

What can change sessions settings at the computer level????? Even my home Mac works fine...

6 Jun 2007, 4:45 PM
#210
agamic avatar

agamic

New Zenner

Join Date:
Apr 2007
Posts:
24
Plugin Contributions:
0

Re: Sales report 2.0

agamic:

I was wondering whether there was a fix for this as I have just loaded the latest report mod running on 1.3.7 and the tax shows as $1 which is incorrect under the product line items filter but correctly at $2.97 under the orders filter.
Thanks Blindside for a great mod nevertheless.

Hi
I take it that is a no then, no fix that is, as I have been through the whole thread and there is no mention of the tax problem fix. Does anyone have this problem or know of a cure?
Thanks in advance
a

7 Jul 2007, 6:53 AM
#211
x_o avatar

x_o

New Zenner

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

Re: Sales report 2.0

Hi, thanks for the awesome mod.
It worked fine until I started to get this error in Firefox console on line 402:document.search.btn_submit has no properties.
Nothing happening when I click on the button "Show me the money".
Re-installation did not help. I am using Zen 1.3.6 and Sales Report 2.0 plus a lot of other mods. What could it be? Thank you in advance.

10 Jul 2007, 1:19 PM
#212
guenhwyvar avatar

guenhwyvar

New Zenner

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

Re: Sales report 2.0

I installed it on my 1.3.7, everything went smooth. The report have problems with the german localisation (I altered the settings for the date format, but maybe I did something wrong). Anyway, I can switch to english and the date selection works good.

My problem: PayPal sells are ignored in the reports. How I can fix that?

22 Jul 2007, 10:45 PM
#213
lyricwings avatar

lyricwings

Zen Follower

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

Re: Sales report 2.0

This is a great mod!
Is there any way to sort on Manufacturer NAME, not ID, and also have the Manufacturer name show in the report?

I tried the following and it didn't work - now I'm not getting any report at all. Am I missing a step?

  1. In admin/stats_sales_report.php, I edited the line:
    define('DEFAULT_MANUFACTURER', ''); // manufacturers_id from Admin > Catalog > Manufacturers ("mID=##" in the URL)

to
define('DEFAULT_MANUFACTURER', ''); // manufacturers_name from Admin > Catalog > Manufacturers ("mID=##" in the URL)

  1. I also set this line to "true":

define('DISPLAY_MANUFACTURER', true);

Am I missing a step?

Thanks - this is a great mod!

~LW

23 Jul 2007, 2:26 AM
#214
lyricwings avatar

lyricwings

Zen Follower

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

Re: Sales report 2.0

Oops - I spoke too soon!

Honestly, I am not sure exactly what I had done wrong to begin with, but when I saw that this update DID allow the Manufacturer name to display automatically, I re-installed the mod, and now everything works perfectly.

Again, I'm not sure what I did wrong the first time, but now all is well. Sorry for the alarm.

And thanks for this great mod!

~LW

24 Jul 2007, 4:40 PM
#215
lyricwings avatar

lyricwings

Zen Follower

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

Re: Sales report 2.0

This mod is working great! I love it...thank you!

I only have one issue. Whenever I do a report that includes one particular order in the date range, it calculates the total incorrectly, based on quantity. ALL of the other orders are calculated correctly, but it's just this one order that isn't correct.

Base price=$2.50
Quantity=1
Product Total = $8.50

Where did the $8.50 come from? I have looked at the order history, and I can't find anything odd or unusual about it.

The customer did only order 1, and was only charged the correct $2.50.

any ideas why this could be happening, for just this one order?

Thanks!
~LW

13 Aug 2007, 2:51 PM
#216
dogtags avatar

dogtags

Totally Zenned

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

Re: Sales report 2.0

Would be great if you could extract sales data per state.

This would pull out tax-exempt numbers, too

HTH

13 Aug 2007, 6:56 PM
#217
redheads avatar

redheads

Zen Follower

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

Re: Sales report 2.0

I was able to write up an SQL query which gives me the sales by state data - I just need to figure out how to translate it into a zen-cart feature... I would love to see this become reality so my clients can do the searches themselves!

23 Aug 2007, 3:24 PM
#218
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

Take a look at the sales_report class. All the SQL'ing goes on in there. If you can work out the proper SQL for such info, you might be able to work it into the class code.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

1 Sep 2007, 8:55 AM
#219
suffrinmick avatar

suffrinmick

New Zenner

Join Date:
Jun 2005
Posts:
19
Plugin Contributions:
0

Re: Sales report 2.0

Hi - What a really useful tool! Is it possible to include the product category and the shipping costs in the csv output?

Thanks
P

8 Sep 2007, 5:12 PM
#220
hauruapai avatar

hauruapai

New Zenner

Join Date:
Sep 2007
Posts:
36
Plugin Contributions:
0

Re: Sales report 2.0

Hi,

Firstly thank you for this and the info that others have given to fix the little bugs - it is now installed! But .....

I have the latest Zen Cart - clean install, and the report page shows fine. I have installed in the root, so admin is a dir under root and not under catalog. At the mo it is on my WinXPPro with PHP Version 5.2.3

But when I select say the following, which I figure are the widest options:

  1. Gather & Filter Data
    Preset Date Range - This Month
    Search date of... - Order Purchase
    and leave the other 3 set to "doesn't matter

Then leave the rest and click "Show Me The Money" it does not load a page at all - I have even tried the setting to Open in New Window. There is nothing happening! - No error message - no "Processing, please wait" (got that from the view source)

I have made sure that I do have sales and have checked to make sure that all calls to js files are correct by checking them against the Add Product page in admin through a view source - they are the same in each file. Also made sure that the sales_report.js.php, is in it's place in the admin/includes/javascript folder

I have made the changes as outlined in the "Read Me" as well as the changes on how to get the date to UK and adding in the php by the <? lines to get the report to show. (lines lines 693 and 1029)

Have tested in FF where nothing hapens and IE - in IE where nothing happens but it gives js errors in the report page -

line 26
Char 1
Syntax Error

line 665
Char 9
Object Expected

line 874
Char 1
Object Expected

line 967
Char 1
Object Expected

Would appreciate any advise and guidence to be able to get this working