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 401 to 420 of 882
2 Dec 2009, 3:58 PM
#401
carlvt88 avatar

carlvt88

Zen Follower

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

Sales report 2.0

Reply is appropriate for sales-reports issues.

No answers, just questions here:

Do you use a preset or a custom date range?

When you say 'Show me the money', do you get a response that says "-- NO ORDERS IN TIMEFRAME --", or just blank below the column headers?

Do you have other add-ins installed?

If you can do Customers->Orders and see the orders, but when you do Reports->Sales Report and don't see the orders, my guess would be an installation issue, either a corrupt file or an extra .bak file hanging around.

13 Dec 2009, 1:05 AM
#402
txfrightmare avatar

txfrightmare

New Zenner

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

Re: Sales report 2.0

I need a report that gives me the following info all in one report:

Cust name
Product name
Product Quantity
Product Attribute

Will this report do that?

14 Dec 2009, 5:48 PM
#403
carlvt88 avatar

carlvt88

Zen Follower

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

Re: Sales report 2.0

No, doesn't have the attribute capability.

It aggregates orders first by timeframe (e.g. day, week, month). If you want, you can list individual orders per timeframe (sort by order attributes such as the order number ,customer name, or quantity of items per order), or you can list by products (sort by product attributes such as product name, model number, number of a particular product ordered in the timeframe)

19 Dec 2009, 6:14 PM
#404
gearheadniko avatar

gearheadniko

New Zenner

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

Re: Sales report 2.0

Thanks to all the great help I have Sales Report working fine. The only issue I see is that the product price selected is the current price of the product. For instance I sold on one of my products at $64.95 in Nov. The same product is on sale now at $61.70 and that is what the sales report shows for the sale in Nov. Anyone have any clues or ideas. Whoever is responsible for this report is doing a great job, wish I could figure a way to seperate my 2 different taxes (In Canada EH!)

21 Dec 2009, 7:12 AM
#405
nagelkruid avatar

nagelkruid

Zen Follower

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

Re: Sales report 2.0

gearheadniko:

Thanks to all the great help I have Sales Report working fine. The only issue I see is that the product price selected is the current price of the product. For instance I sold on one of my products at $64.95 in Nov. The same product is on sale now at $61.70 and that is what the sales report shows for the sale in Nov. Anyone have any clues or ideas. Whoever is responsible for this report is doing a great job, wish I could figure a way to seperate my 2 different taxes (In Canada EH!)

Yes you are right, the report does not take the actual price used in the order, it recalculates the price from each order. Don't understand why either, but it is true it will calculate with current prices and changing that will require some programming.

You could add tax columns if you like, you will have to change the class file and add the columns to it. This should be fairly easier than rewriting the above, you can look at the code i wrote (link few posts back) for adding paypal columns and apply the same logic for the tax columns you want to add.

Jeroen

22 Dec 2009, 5:15 PM
#406
gearheadniko avatar

gearheadniko

New Zenner

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

Re: Sales report 2.0

:clap:nagelkruid YOU ROCK!!!:clap:

I installed your sales report mod, nice! I appreciate the advise on the tax columns but I don't have the knowledge to do this type of work. If you are interested I would be glad to make a contribution.
Thanks again for the mod.:clap:

30 Dec 2009, 11:24 AM
#407
nagelkruid avatar

nagelkruid

Zen Follower

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

Re: Sales report 2.0

gearheadniko:

:clap:nagelkruid YOU ROCK!!!:clap:

I installed your sales report mod, nice! I appreciate the advise on the tax columns but I don't have the knowledge to do this type of work. If you are interested I would be glad to make a contribution.
Thanks again for the mod.:clap:
:smile: cheers.
I am always interested but i just don't have the time right now, sorry.

1 Feb 2010, 3:00 AM
#408
leilanddale avatar

leilanddale

New Zenner

Join Date:
Jan 2010
Posts:
69
Plugin Contributions:
0

Re: Sales report 2.0

Hi I'm using the following add on:

V4 Book Mulitilanguage Product Type for V1.3.8

http://www.jphuk.co.uk/zc/index.php?main_page=document_general_info&cPath=54&products_id=490

Books are the only products on my store, so they all use this "template". It adds extra tables ect. one is Author Name.

Is there a way that I will be able to select sort by Author name as a sort option?

Any help would be appreciated!

Thanks a million!

4 Feb 2010, 6:13 PM
#409
helpme avatar

helpme

Totally Zenned

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

Re: Sales report 2.0

never mind :)

9 Feb 2010, 3:51 PM
#410
zepher avatar

zepher

New Zenner

Join Date:
Jan 2010
Posts:
28
Plugin Contributions:
0

Re: Sales report 2.0

Is there anyway to get the sales report to show product attributes? Would be a good addition to Sales Report 3.0... I saw that the old zen-cart sales reports included attributes, but the new one doesn't.... Sort of a step backwards, anyway if you are looking to include another feature consider allowing the stats to be shown by attribute. Thanks! :yes:

23 Feb 2010, 6:01 AM
#411
suksuk avatar

suksuk

New Zenner

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

Re: Sales report 2.0

Hello!

I installed version 2.2.0 and can see that I can group orders by month, but I would also like to further separate them by customer ID. Is this possible?

If not, does anyone know if there is a similar contribution that can do this, i.e. "view orders by customer per month"?

Thanks!

edit: I see that I can already display by "Order ID" - is it possible to group the results together that are by the same customer? I have a bit of PHP/MySQL experience so am prepared to do some hacking if needed - just need to be pointed in the right direction!

23 Feb 2010, 3:32 PM
#412
zepher avatar

zepher

New Zenner

Join Date:
Jan 2010
Posts:
28
Plugin Contributions:
0

Re: Sales report 2.0

Seems like the stock sales report system is a bit lacking and I'd be intereted in a 3rd party sales report system that can display product attributes, but I'd also like to be able to generate sales reports based more criteria than is included in the stock sales report. Any thoughts? Good luck with your customization, wish I could help. Seem like a weak link in the system. :oops:

:cry:

zepher:

Is there anyway to get the sales report to show product attributes? Would be a good addition to Sales Report 3.0... I saw that the old zen-cart sales reports included attributes, but the new one doesn't.... Sort of a step backwards, anyway if you are looking to include another feature consider allowing the stats to be shown by attribute. Thanks! :yes:

26 Feb 2010, 4:32 PM
#413
joepixel avatar

joepixel

New Zenner

Join Date:
May 2008
Location:
orlando, florida
Posts:
28
Plugin Contributions:
0

Re: Sales report 2.0

k4satin:

Any response on this? I already have a cost field in my db from 'cash on hand' calculator. Would love to have a column added to sales report with the cost field! It doesn't seem like it would be hard to do.

I'm wondering if this has ever been added too. This would be an awesome addition. Any word on adding a way to measure cost in this report? The sales report is a great mod! Thanks so much for offering it to us!

26 Feb 2010, 4:34 PM
#414
joepixel avatar

joepixel

New Zenner

Join Date:
May 2008
Location:
orlando, florida
Posts:
28
Plugin Contributions:
0

Re: Sales report 2.0

IronTank:

Hi,

I don't know if I'm asking this in the correct topic. If not, I apologize and please direct me to the right topic. :oops:
I had asked the same question in another topic regarding a similar report module, but thought I'd try here also. :blush:

I want to keep track of the product cost( the price I pay for) and the price I sell it for, so that I can keep track of Revenue. So, in addition to the sales reports, I was wondering if this module have revenue reports.

I had thought this is what the NET and GROSS prices are for while adding the products, but after some research it turns out they are for taxing products.

I'm thinking maybe the Product Cost has to be added while I'm adding the products... so this might be the wrong topic. But, maybe this module could include a feature where I could put in a product's cost(price I paid for).

Sorry if I'm asking, and this is already available in ZC. I'm new to ZC's system :blush:

Thanks much in advance!
ITF :bigups:

It looks like quite a few folks would love to have this addtion. Anyone working on adding this?

3 Mar 2010, 5:58 PM
#415
wolfderby avatar

wolfderby

Zen Follower

Join Date:
Dec 2008
Location:
Pittsburgh, PA
Posts:
241
Plugin Contributions:
0

Re: Sales report 2.0

wickedklown:

sorry to slam this forum over and over. but the questions are just flying right now....

as i dig into the new sales report, i notice that order which have been set to canceled, or refunded, are still showing up in the report as a sale. but we cant account for that money since it was refunded. sometimes we give store credit, but that is set under another status.

but in any event, how would i setup super orders, to not calculate that order as a sale, since it was refunded. i use the refunded button and return the money to reflect in the total shows customer still owes whole balance again then i look at the report and its still being calculated in the total.

so how do i set it up, maybe im running super orders wrong, and its not understanding that it was a canceled order. im sure some of you guys are pros with this, so just fill me in... please..

also, what exactly do that COMPLETED and CANCELED buttons do on the bottom of the order? im using those too, but they dont see to do anything, at least that i can tell.

wickedklown:

well im looking into your report now.
and im not sure if i found errors, or what

but for some reason, i have a guy that orderd 1 item, at 55.67 total w/ shipping.

for some reason, when i pull up his order with the sales report, its showing 5428.89 with 108 products in his order. whats up with that? im filtering by manufacture, and +product line for display. on last month.
ALSO- along with that- when i display by +Order Line, it shows me all the orders from that timeframe, but its only calculating items from the selected manufacture, correct? and only the goods value?

when i change it to show (dont matter) for the manufacture, it displays correct for his order. and i see no problems.

im also noticing that its calculating shipping costs for some that didnt order those manufacture items. why is that? dont calc the goods value (i assume becuase its not the selected manufacture) but it is calculating its shipping total. and for those orders that do have the selected manufacture its calcuating the goods value and not the shipping.. am i missing somthing?

why is it working like that?

any help would be great

I'm pretty sure that since it's not the core functionality of zen-cart to cancel re-stock refund or return an order, it's going to be pretty hard for the sales report add-on to incorporate the functions of another add-on.

Perhaps if we can figure out how to include a commented out if statement in the code that people can uncomment if they have the super orders add-on installed, that will no include figures from refunded products/orders?

Also in the mean time I just deleted the row for the order from the orders table in my database directly.

23 Mar 2010, 9:44 PM
#416
wolfderby avatar

wolfderby

Zen Follower

Join Date:
Dec 2008
Location:
Pittsburgh, PA
Posts:
241
Plugin Contributions:
0

Re: Sales report 2.0

If you'd like to remove "cancelled" orders from the sales report data (marked "cancelled" through a manually created order status, under admin > localization > order status > "insert")...

Go into your stats_sales_report.php file (in your admin folder) and around line 49 you'll find this line of code

    $orders_status = $db->Execute("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . "
                                   where language_id = '" . (int)$_SESSION['languages_id'] . "'
                                   order by orders_status_id asc");

you'll want to change it to:

$orders_status = $db->Execute("SELECT orders_status_id, orders_status_name FROM " . TABLE_ORDERS_STATUS . "
                                   WHERE language_id = '" . (int)$_SESSION['languages_id'] . "' AND NOT (orders_status_id = 5)
                                   ORDER BY orders_status_id asc");

(note: my cancelled order status was the 5th possible status under order status, if your status has a different id number you'll have to change the orders_status_id to the appropriate number)

for other information regarding cancelled orders check here:
http://www.zen-cart.com/forum/showthread.php?t=151168

7 Apr 2010, 7:08 AM
#417
redheads avatar

redheads

Zen Follower

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

Re: Sales report 2.0

wolfderby:

Go into your stats_sales_report.php file (in your admin folder) and around line 49 you'll find this line of code

Oh... I was soooo excited to see this option, :clap: and I have replaced the line as suggested (my cancelled status was 4), yet the report does not exclude those items in status 4. :dontgetit

Interestingly enough, when I run the report to include only cancelled items I get correct numbers, so I know I have my status correct, and I am sure I am editing the correct file since I thought maybe I had put my code in the wrong line so I put it in the instance of that text higher up on the page and it removed status '4' from my drop-box of choices. I fixed that but am not sure what to try next. :lookaroun

Any suggestions would be appreciated! :bigups:

7 Apr 2010, 7:21 AM
#418
redheads avatar

redheads

Zen Follower

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

Re: Sales report 2.0

Oh, the version I am using is:
SALES REPORT 2.2.0RC1
on the Zen Cart 1.3.8p3 build

22 Apr 2010, 12:08 PM
#419
beinart avatar

beinart

New Zenner

Join Date:
Sep 2009
Posts:
11
Plugin Contributions:
0

Re: Sales report 2.0

Will this add-on allow me to find out how many orders I have received of a particular item over a chosen time period? I'm very new to all of this!

22 Apr 2010, 12:20 PM
#420
carlvt88 avatar

carlvt88

Zen Follower

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

Re: Sales report 2.0

Yes it does. You can specify a date range (choose date of purchase, or another date such as date shipped / rejected / status changed). Then within that date range (grouped by day / week / month / year), you can summarize, or list sales per part number, or sales per order.

I've done some customization on my own to add check boxes so I can list only particular items. Works for me because I only have about twelve part numbers.

You can also export the report to a csv file.