sales of optons/variants

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

sales of optons/variants

Post by compunerdy » Sun Feb 03, 2008 6:47 pm

Is there no report to see how many you have sold at the option/variant level?

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

Post by AbleMods » Sun Feb 03, 2008 9:28 pm

You know, I hadn't thought about it that way.

You mean something like this?

SKU 12345
Variant 12345-01 5 sold $27.50
Variant 12345-02 2 sold $12.25
Variant 12345-03 6 sold $40.00

Probably wouldn't be that hard to do as long as the original product with the variants still exists. Once a variant is stored as an order, the concept of variants is lost I believe - at that point it's just another SKU being purchased.
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

Post by compunerdy » Mon Feb 04, 2008 1:26 am

Exactly..they dont show up on sales reports

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

Post by AbleMods » Mon Feb 04, 2008 3:50 am

compunerdy wrote:Exactly..they dont show up on sales reports
The variant purchased shows up on the reports doesn't it?
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

Post by compunerdy » Mon Feb 04, 2008 8:38 am

Nope, All they show is the main product.

Will
Captain (CAPT)
Captain (CAPT)
Posts: 263
Joined: Fri Oct 05, 2007 8:02 am

Post by Will » Mon Feb 04, 2008 8:56 am

We're using Google Analytics to track the product sales. It does it by absolute SKU, so you get sales of each variant. Plus, our sales and marketing people can customize and download excel versions directly. :)

It works great so far. Downside is it relies on javascript, so non-js folk don't register.

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

Post by AbleMods » Mon Feb 04, 2008 11:34 am

hmm i was wondering how well that worked in real-life, haven't taken the time to set it up. I've only been tracking goals.
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

Will
Captain (CAPT)
Captain (CAPT)
Posts: 263
Joined: Fri Oct 05, 2007 8:02 am

Post by Will » Mon Feb 04, 2008 1:56 pm

Since our site isn't live yet, I can't say for sure, but it's tracking our test transactions great.

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

Post by AbleMods » Mon Feb 04, 2008 9:32 pm

I'd ticket that to Able - reports shouldn't be showing the main SKU for variant sales, should be showing the variant.

You'd never know that the red shirts were selling great and the green ones haven't sold at all. You'd only know x amount of shirts were sold right?
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
mfreeze
Commodore (COMO)
Commodore (COMO)
Posts: 421
Joined: Mon Jan 24, 2005 2:07 pm
Location: Washington, NJ
Contact:

Re: sales of optons/variants

Post by mfreeze » Wed Jun 24, 2009 1:48 pm

Has anybody addressed this yet? I checked in 7.03 and neither the daily or monthly sales report breaks down the sales by variant.

The Order Items table does contain a row for OptionList and variant name. I checked and these are not available in either the SalesSummary or OrderSummary classes so the existing reports couldn't be modified to show a breakdown by option or variant.

I would think that every Able merchant would require a report that breaks down sales by option/variant. Without this how would you calculate necessary inventory levels or the need to even carry certain variations?
Mary E Freeze

Freeze Frame Graphics
Web Hosting and Design, ASP and CFMX Development

http://www.ffgraphics.com

User avatar
mfreeze
Commodore (COMO)
Commodore (COMO)
Posts: 421
Joined: Mon Jan 24, 2005 2:07 pm
Location: Washington, NJ
Contact:

Re: sales of optons/variants

Post by mfreeze » Fri Jun 26, 2009 2:05 pm

BTW. The Able 5.5 Product Breakdown Report did show the variations so it basically was a report on sales by variation.
Mary E Freeze

Freeze Frame Graphics
Web Hosting and Design, ASP and CFMX Development

http://www.ffgraphics.com

kastnerd
Commodore (COMO)
Commodore (COMO)
Posts: 474
Joined: Wed Oct 22, 2008 9:17 am

Re: sales of optons/variants

Post by kastnerd » Mon Jun 29, 2009 6:06 am

This would be nice.

Post Reply