Cartridge Best Selling products

[Josh B]

We are currently batting around the idea of how to show best selling products on one of the sites we are building. Thought I would throw out the couple directions we have thought of and see if anyone else has a better idea.

Option 1:

Cron job that runs nightly going through all of the new orders looking at SKUs and quantity. 

Store it in a BestSelling table that would consist of product id & total sold number.

Create a template tag that would display the products

Option 1.1:

Cron job that runs nightly going through all of the new orders looking at SKUs and quantity. 

Cached object instead of a database table

Create a template tag that would display the products

Option 2:

Add a field on the product or product variation that gets incremented every time that product is purchased.

Create a template tag that would display the products

Option 3:

Create a template tag that would do all of the look ups, cache it and do the products 

[Stephen McDonald]

Hey Josh, 

Option 2 has actually always existed in Cartridge since day 1, it's just that nothing actually makes use of the recorded data.

Have a look at the ProductAction model and ProductActionManager:

https://github.com/stephenmcd/cartridge/blob/master/cartridge/shop/models.py#L665

https://github.com/stephenmcd/cartridge/blob/master/cartridge/shop/managers.py#L166

They allow for things like variation.product.added_to_cart() and variation.product.purchased(), which each increment values on their respective fields. These are already being called in the relevant spots:

https://github.com/stephenmcd/cartridge/blob/master/cartridge/shop/models.py#L558

https://github.com/stephenmcd/cartridge/blob/master/cartridge/shop/models.py#L496

So theoretically the data is all there. Would love to see something done with it, and have that provided in Cartridge by default, as this was always the intention.

--
You received this message because you are subscribed to the Google Groups "Mezzanine Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mezzanine-use...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--
Stephen McDonald
http://jupo.org

[Stephen McDonald]

Sorry my comment was slightly off - a value doesn't get incremented, a record gets created. That way it has a timestamp, so time-series reports could be created from the data stored.

[Josh B]

Awesome, looked into it and started writing something. In your eyes should this be a manager to return the list or just a template tag?

Josh

[Stephen McDonald]

I guess both would be useful, with the template tag making use of the manager.