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 81 to 100 of 882
25 Oct 2006, 12:42 AM
#81
blindside avatar

blindside

Totally Zenned

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

Sales report 2.0

If you are searching based on date assigned status, make sure that the assigned status is only assigned once. If it appears more than once, and both dates fit your search criteria, then it will be listed twice. I deal with this issue on a routine basis in my own company.

I would add code to prevent this, but how can the report know which date is the correct one when it appears twice? Further, what if only one date appears on the report, then you run it at a later date to pick up the second? Now you've got the order recorded twice on your books, not good.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

25 Oct 2006, 12:47 AM
#82
missjane avatar

missjane

New Zenner

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

Re: Sales report 2.0

Ah, you got it! That's exactly what my problem was. I went in and removed the duplicate statuses and now it's great! Thank you SO much!

Jane

25 Oct 2006, 4:38 PM
#83
alyxsmom avatar

alyxsmom

New Zenner

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

Re: Sales report 2.0

I just installed the update and am thrilled to get the manufacturer filter. Thank you.

That said...

When running the report by manufacturer and product line items for 1 day and 1 manufacturer (to get a feel for it), I'm finding that the one item that sold for that manufacturer yesterday at a selling price of $1.50 is reporting as $1500.00 in the total column. There are 1000 items in stock, so obviously it is multiplying the purchase price by the quantity in stock rather than the purchased quantity of 1.

While I'm sure my designer/manufacturer would love to get paid $1500.00 for her single $1.50 item... I however do not wish to pay her that ;)

What do I need to change to make this pull from the proper qty field?

29 Oct 2006, 7:47 PM
#84
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

The report does not do any calculation of the sort you are describing. It doesn't look at the in-stock quantity, only calculates from actual ordered products.

You could run some more reports to try and deduce where the issue is originating. For instance, change it from "Product Line Items" to "Order Line Items," leaving all the other criteria the same. Check the orders that appear and make sure you're not missing orders that have sold quantity of your product, and that someone did not, in fact, actually order 1000 of them.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

31 Oct 2006, 4:08 AM
#85
alyxsmom avatar

alyxsmom

New Zenner

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

Re: Sales report 2.0

Thanks for the response.

I promise you, noone has ordered 1000 of any single product on my site (it's all digital downloads - there would be no point in ordering 1000).

I have run this report in every possible configuration I can think of - including running the report as you describe. The totals come out perfectly in every report - **except when run by manufacturer. **

Since there are no calculations being done here, perhaps the decimal point is off somewhere in the 'by single manufacturer report'?

31 Oct 2006, 4:11 PM
#86
gwkg avatar

gwkg

New Zenner

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

Re: Sales report 2.0

I am seeing the following page when clicking reports > sales reports

**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.**

Can someone point me in the right direction to correct this?

Thanks

1 Nov 2006, 4:56 PM
#87
hrm avatar

hrm

New Zenner

Join Date:
Oct 2005
Posts:
95
Plugin Contributions:
0

Re: Sales report 2.0

Any idea if attributes will be accounted for anytime soon? In the older version of Sales Report, the attribs were at least listed next to the Product Name. That was really helpful. Is it possible for me to set the new SR to show this info or is it coming in a future release?

Thanks. I really do love this contrib and lots of the new features. I just really need that one.

Heather
Results! Why, man, I have gotten a lot of results.
I know several thousand things that won't work.
----Thomas Edison

2 Nov 2006, 3:07 AM
#88
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

alyxsmom:

Thanks for the response.

I promise you, noone has ordered 1000 of any single product on my site (it's all digital downloads - there would be no point in ordering 1000).

I have run this report in every possible configuration I can think of - including running the report as you describe. The totals come out perfectly in every report - **except when run by manufacturer. **

Since there are no calculations being done here, perhaps the decimal point is off somewhere in the 'by single manufacturer report'?
But I didn't actually touch the calculations to add this filter, so I don't see how the proverbial decimal point is off. Still, I'll try some further debugging.
gwkg:

I am seeing the following page when clicking reports > sales reports

**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.**

Can someone point me in the right direction to correct this?
The Sales Report does not have any features like that, it sounds like your store has an admin security module installed. If you're not the one responsible for setting it up (it sounds like you're not), I suggest you contact whoever did.
hrm:

Any idea if attributes will be accounted for anytime soon? In the older version of Sales Report, the attribs were at least listed next to the Product Name. That was really helpful. Is it possible for me to set the new SR to show this info or is it coming in a future release?
I currently have no plans to display attributes as you described. In fact, I removed that display delibrately, as it simply didn't work well. Attributes differ from order to order, and therefore make it impossible to display products in total on a single line. Text attributes look even worse, as they stretch the columns out and push onto multiple lines.

As I said earlier in the thread, this is not the primary purpose of a sales report, and you should ask yourself exactly what information you're seeking. With SR, you should be looking for dollars and cents (or pounds, or yen, or rupees...). You simply cannot calculate sales totals and display product attribute details in the same report nicely.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

2 Nov 2006, 5:38 PM
#89
hrm avatar

hrm

New Zenner

Join Date:
Oct 2005
Posts:
95
Plugin Contributions:
0

Re: Sales report 2.0

Sorry if I opened a can of worms with the attributes question.

My dilemma is that my client pays me comissions based on downloads but not for other product sales. Many products are available both ways and more downloads are being added all the time. This makes reporting and calculating my pay difficult.

In the old version of Sales Report, the attributes were at least listed so we could tell at a glance whether ANY downloads of that product were sold.

Does anyone know of another module out there that might accomplish what I need? Maybe something for inventory management?

Thanks for your help.

Heather
Results! Why, man, I have gotten a lot of results.
I know several thousand things that won't work.
----Thomas Edison

2 Nov 2006, 10:31 PM
#90
thedailyscrap avatar

thedailyscrap

New Zenner

Join Date:
Apr 2005
Posts:
47
Plugin Contributions:
0

Re: Sales report 2.0

alyxsmom:

I just installed the update and am thrilled to get the manufacturer filter. Thank you.

That said...

When running the report by manufacturer and product line items for 1 day and 1 manufacturer (to get a feel for it), I'm finding that the one item that sold for that manufacturer yesterday at a selling price of $1.50 is reporting as $1500.00 in the total column. There are 1000 items in stock, so obviously it is multiplying the purchase price by the quantity in stock rather than the purchased quantity of 1.

While I'm sure my designer/manufacturer would love to get paid $1500.00 for her single $1.50 item... I however do not wish to pay her that ;)

What do I need to change to make this pull from the proper qty field?

Hi Alyxsmom did you deduce the problem here? I too am having the same issues. I'm sure my manufacturers would love the $73,000 the report says oppose to The true $73.00 earned. LOL.

Zen Cart 1.3.7
Server: Linux
PHP Version 4.4.2

4 Nov 2006, 3:56 AM
#91
bkempf avatar

bkempf

New Zenner

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

Re: Sales report 2.0

I'm having the same trouble...what I am wondering now...is there a way to get the old sales report back...it seemed to work better for the digital scrapbooking industry...I can't find the old download anywhere and will it work on the new version of the cart?

4 Nov 2006, 11:45 PM
#92
alyxsmom avatar

alyxsmom

New Zenner

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

Re: Sales report 2.0

Um, nope, I still have no answer for this LOL! I wish I did... that and how to get the discounts/coupon codes to actually deduct out properly...

5 Nov 2006, 11:23 PM
#93
thedailyscrap avatar

thedailyscrap

New Zenner

Join Date:
Apr 2005
Posts:
47
Plugin Contributions:
0

Re: Sales report 2.0

alyxsmom:

Um, nope, I still have no answer for this LOL! I wish I did... that and how to get the discounts/coupon codes to actually deduct out properly...

I'm trying to get ahold of Jason L. on getting a report wrote up but I haven't got a reply from him in a few weeks...hope all is ok with him and his family. Will let you girls know when I hear from him. :)

Kristi

Zen Cart 1.3.7
Server: Linux
PHP Version 4.4.2

6 Nov 2006, 3:24 PM
#94
bkempf avatar

bkempf

New Zenner

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

Re: Sales report 2.0

I still would like to know if there is a way to install the old report in the new addition of the cart...thank you for your help

7 Nov 2006, 2:44 PM
#95
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

To everyone seeing manufacturer issues: I am looking into the problem further, and recruited some additional dev team muscle to try and track it down. The problem I have is that I do not use manufacturers, and this problem seems to occur on stores where they are used heavily. So replicating the issue is difficult, since I would need to build a large amount of associated data. I will post when I have more information, just sit tight. :smile:

bkempf:

is there a way to get the old sales report back...it seemed to work better for the digital scrapbooking industry...I can't find the old download anywhere and will it work on the new version of the cart?
The old SR is out of date with the latest versions, and I am no longer supporting it, hence its removal. Aside from the manufacturer issue, what else are you missing?

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

7 Nov 2006, 3:04 PM
#96
digidiva_kathy avatar

digidiva_kathy

Zen Follower

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

Re: Sales report 2.0

Ladies, I'm not sure what problem you're having, but I have installed the new version and it's working fine for me. I'm not getting any errors. Perhaps it's because I don't track stock, though...I just noticed that part of the equation. Why don't you guys just turn off stock tracking in your carts? If you only sell downloads, you don't need it.

Alyxsmom, I never knew the coupons to deduct out properly. If there is a discount on an order, I have to go look at the order to see which item it was applied to, particularly if it was only applicable to one designer's item. I've never known of a different way to do this...am I missing something?

7 Nov 2006, 3:20 PM
#97
bkempf avatar

bkempf

New Zenner

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

Re: Sales report 2.0

our biggest problem...is that the coupons used don't show up as coupons used...they show as a sale. We used to be able to go under paypal ipn and it would take all the coupons off...

7 Nov 2006, 3:33 PM
#98
bkempf avatar

bkempf

New Zenner

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

Re: Sales report 2.0

I"m going to get Tamara to come and explain this better as she is the one that does the report/sales list for me...
how do you turn off stock tracking?

7 Nov 2006, 4:31 PM
#99
digidiva_kathy avatar

digidiva_kathy

Zen Follower

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

Re: Sales report 2.0

Admin>Configuration>Stock...change check stock level and subtract stock to false, Allow Checkout to true and turn off the Show Sold Out Image in place of Add to Cart.

7 Nov 2006, 5:50 PM
#100
bkempf avatar

bkempf

New Zenner

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

Re: Sales report 2.0

ok, did that Kathy, will look at the report and see what difference that made..thank you...
The coupon codes weren't "figured" in the old report...you still had to go in and see which one was discounted...but when you went into paypal ipn it took all the zero balances off...this new one was leaving in coupon codes that the dt was using to get kits...not sure I understand why...