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 481 to 500 of 882
20 Jan 2011, 9:30 PM
#481
parsie avatar

parsie

New Zenner

Join Date:
Jan 2011
Posts:
2
Plugin Contributions:
0

Sales report 2.0

Hi I have a question the tool is really cool, but instead of manufacturers (wich are set for product general) I need to display sales for Record Artist. Does anyone know how and where to reprogramm this setting? It´s basically the same but ...

thanks for your help.

Kind regards Patrick

21 Jan 2011, 8:57 PM
#482
darkangel avatar

darkangel

Totally Zenned

Join Date:
Oct 2007
Location:
Emporia, Kansas
Posts:
1,729
Plugin Contributions:
0

Re: Sales report 2.0

ok, updated my files and decided to try the rollover edits in .js but when I go to the report...what exactly am I to see as a rollover-----

or does my pea brain not register the wording right and it does not mean rollover like in button rollover?

also...is there a way to get both the order number and product name in the report...sometimes I need to alert the customer of a new update to their product purchased and this would make it simpler in searching it up.

24 Jan 2011, 9:03 PM
#483
carlvt88 avatar

carlvt88

Zen Follower

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

Re: Sales report 2.0

I'm not sure about rollover - are you referring to the rowover that's in the installation README.txt file?

        if (object.className == 'dataTableRow') object.className = 'dataTableRowOver';

If so, the intent is to change the 'className' of text when the mouse is over the row. This changes the color as defined in the css style sheet.

admin/includes/stylesheet.css:```
.dataTableRow{
background-color:#f2f1ee;
}
.dataTableRowOver{
background-color:#ffffff;
cursor:pointer;
cursor:hand;
}


All you'll see is the color changes for the row you're over.

The report doesn't include the all products in all orders option - I believe that would quickly become too big and clumsy, where there are other reports for this.

But, I did put a mod in that you can limit the report to a specific product ID. So, if you know the product ID's number, you can generate a report of all orders or customers that contain this product.
24 Jan 2011, 9:21 PM
#484
carlvt88 avatar

carlvt88

Zen Follower

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

Re: Sales report 2.0

[dope-slap to self] - if I had looked up 5 lines in the readme file, I would have seen the title: ROLLOVER

25 Jan 2011, 12:47 AM
#485
darkangel avatar

darkangel

Totally Zenned

Join Date:
Oct 2007
Location:
Emporia, Kansas
Posts:
1,729
Plugin Contributions:
0

Re: Sales report 2.0

carlvt88:

[dope-slap to self] - if I had looked up 5 lines in the readme file, I would have seen the title: ROLLOVER

well I had to go back to the readme myself just to make sure I saw Rollover...lol

ok I never thought of looking it up by product idbut just looking at the controls right now:

I see where you can choose product line items>product id>then product id, product name, manufacturer, model no.,base price,quantity,fees or product total but nothing about order id (number)

then in order line items i get to see order id and then cnan choose cust last name, # products, goods value, shippping, discounts, gc's, order total

but not in the same screen do I get to see the product id and cust name together...so means I need to run it twice to get the info I would need.

or did I get that wrong --would not surprise me at all if I did.

All in all it is a great pakage to use so I am still happy.

27 Jan 2011, 6:39 AM
#486
weber avatar

weber

Zen Follower

Join Date:
Nov 2005
Posts:
157
Plugin Contributions:
0

Re: Sales report 2.0

I just install the version 2.3.2

after installed, the addon not function at all. at firefox i can see two errors

Error: syntax error
Source File: XXXXXX/admin/stats_sales_report.php
Line: 443, Column: 6
Source Code:
} else {

Error: populate_search is not defined
Source File: XXXXXX/admin/stats_sales_report.php
Line: 1

what's wrong? i have zen cart 1.39h

31 Jan 2011, 9:44 AM
#487
supersnow avatar

supersnow

Zen Follower

Join Date:
Apr 2007
Location:
California, USA
Posts:
233
Plugin Contributions:
0

Re: Sales report 2.0

I love this module and I use it all the time. I recently put on a the dual pricing module and I would love to be able to filter my reports to just the retail customers and to just our wholesale customer orders.

I like the new filter that you can filter for categories etc. It would be great to be able to filter with the dual pricing module too!

Can anyone help with how do add this. Thanks!

Thanks
Supersnow

31 Jan 2011, 3:22 PM
#488
carlvt88 avatar

carlvt88

Zen Follower

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

Re: Sales report 2.0

@DarkAngel: You're looking at the sort options for the product line items. The option I was pointing to is in the top box - used for 'gather & filter data'. Check the box that says 'Only include specific Product ID's...' and a box appears where you can specify the ID / IDs that you want to include in the report. Note: AddIn version 2.3.0 or greater required.

@weber, Is it possible you missed updating the file in admin/includes/languages? Did this addon work before the upgrade? What version was working prior to 2.3.2 failing?

31 Jan 2011, 3:43 PM
#489
carlvt88 avatar

carlvt88

Zen Follower

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

Re: Sales report 2.0

@supersnow, There is a filter for customerID and productID, but not Category. You can use the current module to filter for a comma separated list of customers, and this list can be saved in the defaults file, but it doesn't sound like a clean solution.

I've added a category pulldown for my own use, but I'm not familiar with the dual pricing addin, so I don't know if that would work in this case.

31 Jan 2011, 6:23 PM
#490
supersnow avatar

supersnow

Zen Follower

Join Date:
Apr 2007
Location:
California, USA
Posts:
233
Plugin Contributions:
0

Re: Sales report 2.0

carlvt88:

@supersnow, There is a filter for customerID and productID, but not Category. You can use the current module to filter for a comma separated list of customers, and this list can be saved in the defaults file, but it doesn't sound like a clean solution.

I've added a category pulldown for my own use, but I'm not familiar with the dual pricing addin, so I don't know if that would work in this case.
You are right it is only a product id filter and not categories - my bad. It was very late when I did my post.

But since the dual pricing adds to the customer table I was hoping that I could add a filter that would us a pull down for their "Wholesale pricing level" which in my case is either 0 for retail and 1 for wholesale. Any ideas?

Thanks
Supersnow

31 Jan 2011, 6:44 PM
#491
carlvt88 avatar

carlvt88

Zen Follower

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

Re: Sales report 2.0

Are you good with programming? If you can play with this, you could try replacing all instances of customers_id with customers_whole in admin/includes/classes/sales_report.php. Then put a 0 or a 1 in the 'Customers ID' filter.

I don't have that plugin and haven't tried the above code at all, but this is a 2 min swag at an approach. Let me know if this works and if you want to run with it from here.

31 Jan 2011, 6:56 PM
#492
carlvt88 avatar

carlvt88

Zen Follower

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

Re: Sales report 2.0

I believe the report gets the selling prices from the orders and not the products, so this should work without mods. But, the 'discount' might not be what you're looking for.

It would also need some cleanup around customer_id and customer_whole - you may want to add the wholesale selector instead of hijacking the customer_id field.

This is intended to be just a starting point. I believe it would be a reasonable bit of work, and wouldn't belong in the released addin since it'd use several SQL fields that don't typically exist in standard cart installations.

31 Jan 2011, 7:19 PM
#493
supersnow avatar

supersnow

Zen Follower

Join Date:
Apr 2007
Location:
California, USA
Posts:
233
Plugin Contributions:
0

Re: Sales report 2.0

carlvt88:

Are you good with programming? If you can play with this, you could try replacing all instances of customers_id with customers_whole in admin/includes/classes/sales_report.php. Then put a 0 or a 1 in the 'Customers ID' filter.

I don't have that plugin and haven't tried the above code at all, but this is a 2 min swag at an approach. Let me know if this works and if you want to run with it from here.

Unfortuanlty this doesn't work as the customers_whole is not in the orders table it is in the customers table. So I need to work out how to get the customers_whole to be added to the orders table then I would think your solution would work.

Any ideas?

Thanks
Supersnow

6 Apr 2011, 10:23 AM
#494
gunnel avatar

gunnel

New Zenner

Join Date:
Jan 2011
Location:
Sweden
Posts:
12
Plugin Contributions:
0

Re: Sales report 2.0

Hi
I just installed this mod and tried to get a report. Everything looks nice in Admin but when pushing the button "Show me the money" I don´t se a report. It doesn´t matter if I checked the checkbox "Open results in new window" or not. Nothing happens, no error message, not anything. I use v1.3.9f and Swedish in Admin, but I put all the language files in that map to.
Please help!:unsure:

6 Apr 2011, 2:12 PM
#495
carlvt88 avatar

carlvt88

Zen Follower

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

Re: Sales report 2.0

Does nothing, like a dead button? Or do you get a blank page? Could this be an installation issue perhaps? Have you made any modifications?
Have you tried a different browser (opera, firefox, etc.)?
I've never tested with multiple languages, but I don't see immediately where that would be an issue. I can check that out this evening (my development system is at home).

6 Apr 2011, 8:18 PM
#496
darkangel avatar

darkangel

Totally Zenned

Join Date:
Oct 2007
Location:
Emporia, Kansas
Posts:
1,729
Plugin Contributions:
0

Re: Sales report 2.0

Gunnel:

Hi
I just installed this mod and tried to get a report. Everything looks nice in Admin but when pushing the button "Show me the money" I don´t se a report. It doesn´t matter if I checked the checkbox "Open results in new window" or not. Nothing happens, no error message, not anything. I use v1.3.9f and Swedish in Admin, but I put all the language files in that map to.
Please help!:unsure:

while others come in to see if they can help---go to your server and visually check---reup each and every file.

sometimes when uploading the files they get a minor corruption and even though they are there they are not complete

21 Apr 2011, 6:48 PM
#497
spiritcraft avatar

spiritcraft

New Zenner

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

Re: Sales report 2.0

v1.39h with a bunch of mods... It worked right out of the box. Nice mod, thanks. I will monitor to see if categories are added to search criteria sometime.

Thanks again.

15 Jun 2011, 2:02 PM
#498
alfawebz avatar

alfawebz

New Zenner

Join Date:
Apr 2011
Posts:
2
Plugin Contributions:
0

Re: Sales report 2.0

Installation simple, reports run great. The only problem I have is that I cant get a report with the Customer info and the Products purchased. Is this someting that is only available seperately. Or i guess I am missing something. please help, Thanks!

20 Jun 2011, 2:02 PM
#499
carlvt88 avatar

carlvt88

Zen Follower

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

Re: Sales report 2.0

You can list all the orders or all the products for a particular customer, but there isn't the option to repeat this for all customers (that is, for each customer, show all their orders or products). Without digging too deeply, I believe this would be either a big processing time hit, or a big rewrite.

18 Jul 2011, 1:10 PM
#500
lndlyb4 avatar

lndlyb4

New Zenner

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

Re: Sales report 2.0

Hi, I had a little trouble finding an answer to this by searching this forum, so I thought I would post the answer to my own question. I'm sure it's in an obvious place, but just in case it's not. I get so much help from these forums, so I like to do my part when I can. My problem was that I couldn't find how to search by date range when I installed the Sale Report. I opened zc_admin/includes/languages/english/stats_sales_report.php and changed the default setting for DEFAULT_DATE_SEARCH_TYPE from 'preset' to 'custom'. This automatically displays the date range start and end dates. I hope this is clear enough the way I've written it.