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 261 to 280 of 882
28 Dec 2007, 2:12 AM
#261
blindside avatar

blindside

Totally Zenned

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

Sales report 2.0

Hey guys!

Saw the fixes you made. Love it! I've got them in the main module repository now. I'm going to try and push out a new version asap.

Also, for anyone wondering where the hell I've been.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

28 Dec 2007, 7:25 PM
#262
wapnoj avatar

wapnoj

New Zenner

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

Re: Sales report 2.0

This is great. I had an older version and upgraded. seems to work fine on 1.3.7, however I would do a back flip if this could show an attribute breakdown as well as products. I have sizes for clothes. It would be AWESOME to be able to se in a given timeframe the amount of every size that I sold. I have read some references to attributes in the mod but I have not seen them am I missing somthing?

thanks!!!

28 Dec 2007, 7:48 PM
#263
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

That request comes up every few months, but the reason stays the same: you cannot display attributes in a line item basis on a report with multiple products. Here's a little background:

http://www.zen-cart.com/forum/showpost.php?p=285769&postcount=89

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

1 Jan 2008, 3:27 PM
#264
sky1 avatar

sky1

New Zenner

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

Re: Sales report 2.0

When I install a new product, I don't have the **Profit Margin Calculator. **
I have just installed Zen Cart 1.3.7
Am I missing something.

2 Jan 2008, 5:31 PM
#265
wapnoj avatar

wapnoj

New Zenner

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

Re: Sales report 2.0

Yes I understand. thanks, however there must be away to account for individual sizes, colors etc. attributes. I love ZenCart but its getting impossible to account for dailey sales due to the lack of reporting at the attribute level. Does anyone have any suggestions?

I would really appreciate any advice.

BlindSide:

That request comes up every few months, but the reason stays the same: you cannot display attributes in a line item basis on a report with multiple products. Here's a little background:

http://www.zen-cart.com/forum/showpost.php?p=285769&postcount=89

2 Jan 2008, 11:54 PM
#266
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

sky1:

When I install a new product, I don't have the **Profit Margin Calculator. **
I have just installed Zen Cart 1.3.7
Am I missing something.
That's not part of the Sales Report, and I'm pretty sure that's not part of the core either. Is this a 3rd party module you installed? Regardless, this isn't the thread you need.

wapnoj:

Yes I understand. thanks, however there must be away to account for individual sizes, colors etc. attributes. I love ZenCart but its getting impossible to account for dailey sales due to the lack of reporting at the attribute level. Does anyone have any suggestions?

I would really appreciate any advice.
It's been a known problem for some time. Most Dev team effort has focused on the catalog side, and the reporting etc has remained woefully short in the meantime.

However there is light at the end of the tunnel starting in 1.4, which includes inventory tracking at the attribute level. You can read about it in the project roadmap.

Until then you're just going to have to sit tight; I have no plans to write code that will be outdated in the next 12 months or less.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

3 Jan 2008, 5:14 PM
#267
wapnoj avatar

wapnoj

New Zenner

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

Re: Sales report 2.0

Thanks...knowing that there is a light at the end of the tunnel makes all the difference for me. The roadmap looks great. Can't wait......but I will. HAHA

BlindSide:

It's been a known problem for some time. Most Dev team effort has focused on the catalog side, and the reporting etc has remained woefully short in the meantime.

However there is light at the end of the tunnel starting in 1.4, which includes inventory tracking at the attribute level. You can read about it in the project roadmap.

Until then you're just going to have to sit tight; I have no plans to write code that will be outdated in the next 12 months or less.

4 Jan 2008, 2:59 PM
#268
talisman_studios avatar

talisman_studios

New Zenner

Join Date:
Jul 2007
Posts:
42
Plugin Contributions:
0

Re: Sales report 2.0

Alright so I've had a request to do something, I was hoping the sales report modules was going to cover all the monthly financial analysis needs and it actually might but I don't think so. Being hideously out of date with programming doing this myself could be 'interesting' even though it really doesn't strike me as the sort of thing that should be that tough - time consuming maybe. So I'm putting out the feelers now. I wants a report that can produce the following for a given calendar month:

OrderNo
Customer
Date
From Email Address
Address Line 1
Address Line 2/District
Town/City
State/Province/Region/County/Territory/Prefecture/Republic
Postcode
Country
ProductModel
ProductName
ProductPrice
SellPrice
Quantity
Total Earnings

Ideally outputting to csv file when done.

So folks, what do you think? Can this be done in sales report at present? If not would it be easier to add it to the functionality offered or to create something new. I just need to be able to gather this information and would like some pointers from those that might just know better where would be a good place to start. Should I even be trying to do this through the zen cart interface/reports?

5 Jan 2008, 7:26 AM
#269
sky1 avatar

sky1

New Zenner

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

Re: Sales report 2.0

I have just installed "Products Profit/Margin Calculator + Report" witch has given me extra features such as.

Profit Margin CalculatorProducts Cost: Markup Percent : %Gross Margin $: Gross Margin %: %

5 Jan 2008, 11:41 PM
#271
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

sky1 - Just what does any of that have to do with the Sales Report? Please limit your posts to Sales Report-related information

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

8 Jan 2008, 4:51 PM
#272
gezuvor avatar

gezuvor

New Zenner

Join Date:
Apr 2007
Location:
Orange County, CA
Posts:
88
Plugin Contributions:
2

Re: Sales report 2.0

I just wanted to post a big THANK YOU to Frank for this incredible mod. With Kobra's help, I migrated this month from the stone age of osC and this was one of the tools that he recommended for install.

I have been playing with it today and can't believe the detail and flexibility that it provides me. I can finally output some decent data from the 2 years of history I had stored in my old db.

THANK YOU THANK YOU THANK YOU!! (where is the donate button?)

12 Jan 2008, 7:25 PM
#273
lyricwings avatar

lyricwings

Zen Follower

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

Re: Sales report 2.0

I love this mod and I have never had any problems with it.

My only request is that I really need to have both Manufacturers AND Order ID be available on the same report. It seems I can get Order ID included when I display by Order Line Item, and I can get Manufacturer when I display by Product Line Totals. But I can't get them both to display on the same report. Ideally, I'd like the Order ID to display when I go by Product Line Items.

Am I missing something? Maybe there's an option I haven't seen yet?

If not, I would be happy to pay for this modification, if possible.

13 Jan 2008, 3:38 AM
#274
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

gezuvor:

I just wanted to post a big THANK YOU to Frank for this incredible mod. With Kobra's help, I migrated this month from the stone age of osC and this was one of the tools that he recommended for install.

I have been playing with it today and can't believe the detail and flexibility that it provides me. I can finally output some decent data from the 2 years of history I had stored in my old db.

THANK YOU THANK YOU THANK YOU!! (where is the donate button?)
Guess I should add one. If you want, you may send via PayPal to fkoehl {at} gmail {dot} com.

lyricwings:

I love this mod and I have never had any problems with it.

My only request is that I really need to have both Manufacturers AND Order ID be available on the same report. It seems I can get Order ID included when I display by Order Line Item, and I can get Manufacturer when I display by Product Line Totals. But I can't get them both to display on the same report. Ideally, I'd like the Order ID to display when I go by Product Line Items.

Am I missing something? Maybe there's an option I haven't seen yet?

If not, I would be happy to pay for this modification, if possible.
Logically this doesn't make sense. How can you display just one manufacturer for an order when you may have multiple products, each with a potentially different manufacturer?

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

13 Jan 2008, 4:43 AM
#275
lyricwings avatar

lyricwings

Zen Follower

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

Re: Sales report 2.0

---Quote (Originally by lyricwings)---
I love this mod and I have never had any problems with it.

My only request is that I really need to have both Manufacturers AND Order ID be available on the same report. It seems I can get Order ID included when I display by Order Line Item, and I can get Manufacturer when I display by Product Line Totals. But I can't get them both to display on the same report. Ideally, I'd like the Order ID to display when I go by Product Line Items.

Am I missing something? Maybe there's an option I haven't seen yet?

If not, I would be happy to pay for this modification, if possible.

---End Quote---
Logically this doesn't make sense. How can you display just one manufacturer for an order when you may have multiple products, each with a potentially different manufacturer?


Thanks for your response, Blindside.

What you are saying is why I was suggesting that it be added to the option for Product Line -- where just one Product appears per line.

So, the Product Line option would show the Order ID, in addition to giving Product ID, Product Name, Manufacturer, etc.

If there were multiple products in an order, the same Product ID would appear in each product listed in the "Product Line" view.

The situation is that I want to use Sales Report to check against the confirmations that I receive from my manufacturers, when they confirm that they have shipped an item. They simply submit the Order ID to us, so if there was a way for the Order ID to be in the Sales Report, then checking the two would be much easier. Right now we're trying to just try to figure it out by dates and such, which don't always line up if the Manufacturers don't know the date they received the order, or if multiple orders for them came on a specific date.

Does that clarify my question?

Thanks --

13 Jan 2008, 6:10 PM
#276
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

Yeah that makes more sense. You completely lost me by describing your need as "both Manufacturers AND Order ID be available on the same report", as the order ID only appears on the per-order view.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

13 Jan 2008, 10:33 PM
#277
lyricwings avatar

lyricwings

Zen Follower

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

Re: Sales report 2.0

Phew, glad I am making sense.

So - is there any way to do that, that I might be missing?

Like I said, I'd be willing to pay for this customization.

23 Jan 2008, 2:19 PM
#278
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

Basically you'd be expanding the product output view to a unique report line for each order|product combination. So yes it's possible, but would require hacking up the report quite a bit, because the data outputted is ingrained in the class that drives the report.

Depending on your search and output needs, it might be better to make this a separate report, designed specifically to select orders and manufacturers the way you want, and output the data in the format you want.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

27 Jan 2008, 4:00 PM
#279
zapisto avatar

zapisto

Zen Follower

Join Date:
Aug 2005
Posts:
163
Plugin Contributions:
0

Re: Sales report 2.0

BlindSide:

Hey guys!

Saw the fixes you made. Love it! I've got them in the main module repository now. I'm going to try and push out a new version asap.

Also, for anyone wondering where the hell I've been.

Hey BlindSide ,
when the new version will be available ?
thanks

29 Jan 2008, 2:28 AM
#280
blindside avatar

blindside

Totally Zenned

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

Re: Sales report 2.0

I just picked up a new freelance job, and those obviously trump the open source stuff. Sorry. :cry: I'll post when I have something, promise.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com