How to date range for Best Products Purchased report?

[Guest]

I would like to be able to put in a date range or an order number range for the Best Products Purchased report, rather than just having it keep adding from the beginning of time. Has anyone done this before and, if so, what would I need to do to accomplish this?

 

Thanks! :)

[Aodhan]

I would like to be able to put in a date range or an order number range for the Best Products Purchased report, rather than just having it keep adding from the beginning of time.  Has anyone done this before and, if so, what would I need to do to accomplish this?

 

Thanks! :)

 

You would need to change the stats_products_purchased page. Instead of pulling data straight from the products database as it currently does, you would need to pull from the orders_products table, and create a looping count structure to get total purchases for each product.

 

A query that pulls orders after a certain date (Say one month before today), counts all the purchases, and joins the products and products_description table is what you will need. I can't do the SQL statement off the top of my head, or I'd give you some samples.

 

Aodhan

[Guest]

Thank you! However, I am brand new to this and don't have a clue how to go about doing what you just described. Would you be able to help me out with the scripting?

 

Tammy