Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Attribute report


drdecker

Recommended Posts

Posted

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

Posted

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...