Page 1 of 1

Product Sales Breakdown Report

Posted: Tue Oct 05, 2010 12:54 pm
by kbeazer
Hi There,

It seems that there should be a way to get a report like the Product Sales Breakdown that shows Variants of a product in a non-grouped fashion. I just can't seem to find it.

What I am trying to do, is to get the qty of each item's variants over a certain time range. Since variants of items are really different products in a sense, just with variations, it seems that there should be a report that will show you each product variant's qty sold.

Any help is greatly appreciated.

Thanks,
Kevin

Re: Product Sales Breakdown Report

Posted: Tue Oct 05, 2010 1:01 pm
by kbeazer
Hi Again,

If someone would be so kind... a simple sql query would work wonders to basically give me a text file or even result set that had the count of variants sold would help me a lot. I am needing to take an inventory and need to know for a date range, what qty of each size (which is my variant) sold.

Thanks for any help.

Re: Product Sales Breakdown Report

Posted: Wed Oct 06, 2010 10:51 am
by s_ismail
Have a look at this http://wiki.ablecommerce.com/index.php/Custom_Queries, it will help you out to write your own query for your report.

Re: Product Sales Breakdown Report

Posted: Wed Oct 06, 2010 11:39 am
by kbeazer
Thanks.

Has anyone else ever had a need for reports with Variant data included? Is there a way already to do this?

I just can't believe that I would be the only one which makes me think that I am maybe missing something. If not, does anyone have a query to share or way of getting the variants sold for a time range?

Any help is really appreciated.

Thanks.

Re: Product Sales Breakdown Report

Posted: Thu Oct 14, 2010 10:54 am
by plugables
We did something similar in the past. You may contact us if you need help getting this implemented. http://www.plugables.com/ContactUs.aspx