Product Sales Breakdown Report

[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

[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.

[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.

[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.

[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