Page 1 of 1

sales of optons/variants

Posted: Sun Feb 03, 2008 6:47 pm
by compunerdy
Is there no report to see how many you have sold at the option/variant level?

Posted: Sun Feb 03, 2008 9:28 pm
by AbleMods
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.

Posted: Mon Feb 04, 2008 1:26 am
by compunerdy
Exactly..they dont show up on sales reports

Posted: Mon Feb 04, 2008 3:50 am
by AbleMods
compunerdy wrote:Exactly..they dont show up on sales reports
The variant purchased shows up on the reports doesn't it?

Posted: Mon Feb 04, 2008 8:38 am
by compunerdy
Nope, All they show is the main product.

Posted: Mon Feb 04, 2008 8:56 am
by Will
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.

Posted: Mon Feb 04, 2008 11:34 am
by AbleMods
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.

Posted: Mon Feb 04, 2008 1:56 pm
by Will
Since our site isn't live yet, I can't say for sure, but it's tracking our test transactions great.

Posted: Mon Feb 04, 2008 9:32 pm
by AbleMods
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?

Re: sales of optons/variants

Posted: Wed Jun 24, 2009 1:48 pm
by mfreeze
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?

Re: sales of optons/variants

Posted: Fri Jun 26, 2009 2:05 pm
by mfreeze
BTW. The Able 5.5 Product Breakdown Report did show the variations so it basically was a report on sales by variation.

Re: sales of optons/variants

Posted: Mon Jun 29, 2009 6:06 am
by kastnerd
This would be nice.