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 301 to 320 of 882
1 Apr 2008, 5:29 PM
#301
milobloom avatar

milobloom

Totally Zenned

Join Date:
Feb 2004
Posts:
1,267
Plugin Contributions:
1

Sales report 2.0

I am having a slight problem

the shipping totals are not adding right if I am looking for specifics.
Like all from a manufacturer. It gives me the shipping for the entire
range and not just the specifics I asked for.

1 Apr 2008, 5:35 PM
#302
kuroi avatar

kuroi

Totally Zenned

Join Date:
Apr 2006
Location:
London, UK
Posts:
10,475
Plugin Contributions:
11

Re: Sales report 2.0

milobloom:

the shipping totals are not adding right if I am looking for specifics. Like all from a manufacturer. It gives me the shipping for the entire range and not just the specifics I asked for.That's correct. Shipping costs are recorded per order, not against individual items in the order. And since there is no explicit record of how the shipping costs were calculated (was it by weight, number of items, flat rate, delivery type, etc?) Sales Order doesn't know how to apportion them either, so it can only report the information it has.

Kuroi Web Design and Development | Twitter

(Questions answered in the forum only - so that any forum member can benefit - not by personal message)

2 Apr 2008, 1:15 AM
#303
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

kitcorsa:

i have been rading through this post for 10 days now on and off and hadn't got to the stage you have listed above. the problem is the downloads section has the OLD 2.0 version not the 2.2 version this is why i was getting the problem i belive.

going to install the new version now and test.
Where's the 2.2 version? I haven't made an official release beyond the "2.0 rev 104" as available in the DL section. If someone's made changes, send them my way, I'll incorporate into my SVN, and upload the new version with a credit.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

2 Apr 2008, 8:11 AM
#304
kuroi avatar

kuroi

Totally Zenned

Join Date:
Apr 2006
Location:
London, UK
Posts:
10,475
Plugin Contributions:
11

Re: Sales report 2.0

BlindSide:

Where's the 2.2 version?In post 239.

Kuroi Web Design and Development | Twitter

(Questions answered in the forum only - so that any forum member can benefit - not by personal message)

13 Apr 2008, 12:17 AM
#305
jazzah avatar

jazzah

Zen Follower

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

Re: Sales report 2.0

Ok basic question from a newbee here! Do you have to have manufacturers? As havent had a need to input that data, will this module work without it? Also do I need to have super sales module? So far we only have the edit order module installed? Thanks

14 Apr 2008, 1:18 PM
#306
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

No, you do not need to use manufacturers. I don't use them in my store, I included the functionality for others.

Thanks for the post number, kuroi. :thumbsup:

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

15 Apr 2008, 10:40 AM
#307
jazzah avatar

jazzah

Zen Follower

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

Re: Sales report 2.0

Is this module easy to install, I would need to pay a freelancer, I just noticed how much some of you are having to change things around and wondered how time consuming it was along with difficulty. Thanks

15 Apr 2008, 1:01 PM
#308
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

This module is completely plug and play, you don't have to change anything around (where do you get that idea from?).

If you follow the install instructions included in the zip, you should have no problem doing this yourself. All the files simply plop into your admin folder. The next time you open the admin, you'll find the Sales Report listed in the "Reports" section.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

19 Apr 2008, 2:28 AM
#309
zerocrew avatar

zerocrew

New Zenner

Join Date:
Mar 2007
Location:
Chandler, Az
Posts:
54
Plugin Contributions:
0

Re: Sales report 2.0

I'd like to start by saying that this module rocks! what i'm trying to do is generate sales reports by category and even by item. is there a way to do this?
example...

Mens shirts sold = 10 @ $10 = $100
mens black sold = 5 @ $10 = $50
mens white sold = 5 @ $10 = $50

Womens shirts sold = 10 @ $10 = $100
womens black sold = 5 @ $10 = $50
womens white sold = 5 @ $10 = $50

21 Apr 2008, 2:48 AM
#310
mipavluk avatar

mipavluk

Zen Follower

Join Date:
Jun 2007
Location:
Posadas, Misiones, Argentina
Posts:
221
Plugin Contributions:
0

Re: Sales report 2.0

Hi there!
I love this mod! but I don't know why is not working for me... :huh:

when I choose only PayPal like Payment Method, only for 1 manufacturer, I receive all payment methods report... why?

I like to know if is possible, have a report with all payment methods but with one more column that said if is: gift certificate, coupon, paypal, etc.

Another problem.... if I choose Output Format, CSV Export, my browser said: to help protect your security bla bla bla... I chose Download File, but the download never start....:(

I have zen cart 1.3.8 and sales report 2.2

thanks in advance!!!!

URL: http://www.littledreamswarehouse.com/shop
Zen Version: 1.3.89h
Zen Template: orange modified

21 Apr 2008, 7:47 PM
#311
vladimir7 avatar

vladimir7

New Zenner

Join Date:
Jan 2008
Posts:
27
Plugin Contributions:
0

Re: Sales report 2.0

Great mod, however I have a question that I can't figure out.
I want to create a report for products sold in a month based by attribute.
For example, a red shirt, would be seperate from a blue shirt.
So if in a month 5 shirts were bought, however 2 were red attribute, 1 blue, and 2 yellow it would show like

2 Red
1 Blue
2 Yellow

instead of just
5 shirts.

Is it possible with this mod? Or is there another mod that this is possible with?

[edit] never mind, I just noticed a couple pages back that it isn't possible.
I guess I will have to write my own reporting tool, or modify this one to do that.

22 Apr 2008, 5:12 PM
#312
zerocrew avatar

zerocrew

New Zenner

Join Date:
Mar 2007
Location:
Chandler, Az
Posts:
54
Plugin Contributions:
0

Re: Sales report 2.0

I'm asking the same question....
hopefully someone can answer us.

22 Apr 2008, 5:25 PM
#313
kuroi avatar

kuroi

Totally Zenned

Join Date:
Apr 2006
Location:
London, UK
Posts:
10,475
Plugin Contributions:
11

Re: Sales report 2.0

zerocrew:

I'm asking the same question....
hopefully someone can answer us.
With over 300 posts in this forum, it would be helpful if you would be more specific about which question you believe to be unanswered.

Kuroi Web Design and Development | Twitter

(Questions answered in the forum only - so that any forum member can benefit - not by personal message)

23 Apr 2008, 5:35 PM
#315
vladimir7 avatar

vladimir7

New Zenner

Join Date:
Jan 2008
Posts:
27
Plugin Contributions:
0

Re: Sales report 2.0

I may work on a Report mod that calculates total based off attribute, so stay tuned.

It won't be anywhere near as fancy or customizable as this sales report, but basically it would output like this

Product		Attribute   Amount Sold    Total
Shirt  $24
	Red  2     $16   
	Green 1   $8
Pants $60
       Black  2  $40
       Orange 1 $20

ugg formatting screwed up... but you get the idea

24 Apr 2008, 3:25 AM
#316
psr_racing avatar

psr_racing

New Zenner

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

Re: Sales report 2.0

I'm having a small problem with version 2.2. The report is generating incorrect order totals. It is adding the product cost (ex tax) to the shipping cost (inc tax) and giving a total figure that doest match the order.
All I'm looking for with this add-on is to be able to obtain a total $ value of all orders between two dates. I need the order totals (including shipping and tax ie what the customer pays) for all orders so I have a 'total income'. Showing tax would also be a bonus but not essential as I can just divide the total by 11 (Aus GST 10%).

24 Apr 2008, 1:30 PM
#317
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

Vladimir7:

I may work on a Report mod that calculates total based off attribute, so stay tuned.

It won't be anywhere near as fancy or customizable as this sales report, but basically it would output like this

Product Attribute Amount Sold Total
Shirt $24
Red 2 $16
Green 1 $8
Pants $60
Black 2 $40
Orange 1 $20

> 
> ugg formatting screwed up... but you get the idea
Like I've said before, the first version of the Sales Report attempted this, and I took it out when I took over the project because it simply didn't work well.  But I'm looking forward to seeing what solution you might come up with.

A few things you'll want to keep in mind:
- Attributes currently have no associated quantity, so you'll need to do your own counting.
- How will you handle text attributes?  Remember that they are often completely different values (hence no counting).
- You'll probably want to ignore file upload and read-only attributes, but only if they do not have a currency value associated with them.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

24 Apr 2008, 6:49 PM
#318
zerocrew avatar

zerocrew

New Zenner

Join Date:
Mar 2007
Location:
Chandler, Az
Posts:
54
Plugin Contributions:
0

Re: Sales report 2.0

Vladimir7:

I may work on a Report mod that calculates total based off attribute, so stay tuned.

It won't be anywhere near as fancy or customizable as this sales report, but basically it would output like this

Product Attribute Amount Sold Total
Shirt $24
Red 2 $16
Green 1 $8
Pants $60
Black 2 $40
Orange 1 $20

:clap:  all i have to say is if you can do this it would F!@$$# rock!
thanks for trying man.
9 May 2008, 9:30 PM
#319
skippermcnally avatar

skippermcnally

New Zenner

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

Re: Sales report 2.0

Hi there,

I haven't read through this entire thread, but I was experiencing an issue with rev 104 where, when I filtered by manufacturer, it would still show a date with orders, where that manufacturer had no orders, as having orders on the report. The product totals were zero, but the tax and discounts were still there, throwing off numbers. Additionally, I did not want to see any orders for the time period if that manufacturer had no orders.

So, I changed the query that retrieves the order numbers to consider the manufacturer filter and it appears to have resolved the issue. This is a code snippet starting at line 164:

      // build the SQL query of order numbers within the current timeframe
      $sql = "SELECT DISTINCT o.orders_id from " . TABLE_ORDERS . " o \n";
      if ($this->date_target == 'status') {
	  	if ($this->manufacturer) {
			$sql .= "INNER JOIN " . TABLE_ORDERS_PRODUCTS . " op on o.orders_id = op.orders_id \n";
			$sql .= "INNER JOIN " . TABLE_PRODUCTS . " p on p.products_id = op.products_id and p.manufacturers_id = " . $this->manufacturer . " \n";
		}
        $sql .= "LEFT JOIN " . TABLE_ORDERS_STATUS_HISTORY . " osh ON o.orders_id = osh.orders_id \n";
        $sql .= "WHERE osh.date_added >= '" . date("Y-m-d H:i:s", $sd) . "' AND osh.date_added < '" . date("Y-m-d H:i:s", $ed) . "' \n";
        $sql .= "AND osh.orders_status_id = '" . $this->date_status . "' \n";
      }
      else {
	  	if ($this->manufacturer) {
			$sql .= "INNER JOIN " . TABLE_ORDERS_PRODUCTS . " op on o.orders_id = op.orders_id \n";
			$sql .= "INNER JOIN " . TABLE_PRODUCTS . " p on p.products_id = op.products_id and p.manufacturers_id = " . $this->manufacturer . " \n";
		}
        $sql .= "WHERE o.date_purchased >= '" . date("Y-m-d H:i:s", $sd) . "' AND o.date_purchased < '" . date("Y-m-d H:i:s", $ed) . "' \n";
      }

Hope this helps someone else in the same predicament. Thanks for the great report! :bigups:

1 Jun 2008, 2:56 PM
#320
tianxin avatar

tianxin

New Zenner

Join Date:
Sep 2005
Posts:
30
Plugin Contributions:
0

Re: Sales report 2.0

sorry but where is the link to sales report 2.2 ?
i see the downloads section is version 2.0.

thanks