Report to show sales by country..maybe even by state.

Post feature requests to this forum and a pre-configured poll will automatically be created for you.
Post Reply

How important is this enhancement to you?

It's a critical enhancement that I must have.
0
No votes
It's an important enhancement but others are more critical.
1
25%
I'd like to have it but it's not that important.
3
75%
I'd never use this feature.
0
No votes
 
Total votes: 4

User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Report to show sales by country..maybe even by state.

Post by compunerdy » Fri Sep 12, 2008 2:24 pm

Would be handy to know.

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: Report to show sales by country..maybe even by state.

Post by AbleMods » Fri Sep 12, 2008 10:23 pm

Like this? Totals have been altered to protect the innocent.
Sales by Country-State.pdf
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Re: Report to show sales by country..maybe even by state.

Post by compunerdy » Sat Sep 13, 2008 12:06 am

Me likey :mrgreen:

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: Report to show sales by country..maybe even by state.

Post by AbleMods » Sat Sep 13, 2008 12:58 pm

For you and the community...

viewtopic.php?f=47&t=8210
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: Report to show sales by country..maybe even by state.

Post by AbleMods » Sun Sep 14, 2008 8:48 am

One for sale that does it by country

http://www.ablemods.com/Top-X-Sales-by- ... 24C12.aspx
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: Report to show sales by country..maybe even by state.

Post by AbleMods » Sun Sep 14, 2008 2:42 pm

Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Re: Report to show sales by country..maybe even by state.

Post by compunerdy » Sun Sep 14, 2008 3:32 pm

Very cool Joe...I purchased the ones for countrys.

If I change it to show more than 12 is there no way to make those visible? Can the box be made larger or a scroll bar be added? Also would be cool if the states and countrys where combined into one with a tab to switch between the two.

Just some ideas..very cool reports and very easy to install.

User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Re: Report to show sales by country..maybe even by state.

Post by compunerdy » Sun Sep 14, 2008 4:03 pm

I just thought of some other cool ideas..

orders instead of $ per country/states

average order amount per country/states

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: Report to show sales by country..maybe even by state.

Post by AbleMods » Sun Sep 14, 2008 5:04 pm

Thanks!

Remember that these dashboard modules get "hit" every single time the dashboard is refreshed. Multiply that by the number of people using your admin side and its alot of extra bandwidth and database hits. Complex stuff is better left for actual ASPX pages.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: Report to show sales by country..maybe even by state.

Post by AbleMods » Sun Sep 14, 2008 5:11 pm

compunerdy wrote:Very cool Joe...I purchased the ones for countrys.

If I change it to show more than 12 is there no way to make those visible? Can the box be made larger or a scroll bar be added? Also would be cool if the states and countrys where combined into one with a tab to switch between the two.

Just some ideas..very cool reports and very easy to install.
The reason for the limitation is the chart sits within a fixed width - the dashboard is divided into two halves. So if you have more than 12 and increase the height of the chart, the chart itself distorts and looks awful.

You can use that control on a regular page, so if you need it bigger just make a new store-side page and copy the control to ~/ConLib/Custom/. Then edit the copy and adjust the height/width values to suit your need.

I like how they work too - having different little plugins like this makes it awfully easy to come up with a really customized dashboard experience. I just have to be somewhat careful for performance reasons - some people spend all day in their Admin-side and that dashboard page takes alot of hits.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Re: Report to show sales by country..maybe even by state.

Post by compunerdy » Sun Sep 14, 2008 5:29 pm

Well from my experience I set both the states and the countrys to show yearly and I see no delay at all. You have a idea how many orders I do but I would rather not post that on a public forum.

User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Re: Report to show sales by country..maybe even by state.

Post by compunerdy » Mon Sep 15, 2008 12:31 am

I went ahead and just changed the height and it didnt warp how the chart looks at all.

Post Reply