drdecker Posted August 7, 2010 Posted August 7, 2010 Hi I've been unable to find an add-on for this, but it would seem like a fairly obvious one to have. How can I report on sales of product attributes? Eg, number of white t-shirts sold per month, or number of white medium shirts by month/ year? etc The ultimate aim is to get a picture going back over say 12 months, of the most/ least popular colours and sizes, to try and plan ahead better for getting stock in. Any ideas anyone? Thanks
drdecker Posted August 8, 2010 Author Posted August 8, 2010 Just bumping this query... I'm assuming you can run some sort of query on the 'orders' and 'orders_products_attributes' tables to get this info, but I have little to no SQL knowledge! hence my plea for help! :) Thanks Hi I've been unable to find an add-on for this, but it would seem like a fairly obvious one to have. How can I report on sales of product attributes? Eg, number of white t-shirts sold per month, or number of white medium shirts by month/ year? etc The ultimate aim is to get a picture going back over say 12 months, of the most/ least popular colours and sizes, to try and plan ahead better for getting stock in. Any ideas anyone? Thanks
Recommended Posts
Archived
This topic is now archived and is closed to further replies.