SNH_Bestseller

Magento Bestsellers for configurable (actually all) product types (originally SNH_Addorderqty)

Rationale

Magento doesn't support a bestsellers collection by default so this needs to be coded. Some efforts have been made before - but they seem to capture only simple products and simple products (as a child of a configurable product).

A question was asked at stackexchange to develop a method to work around this: http://magento.stackexchange.com/questions/105698/magento-getting-store-bestsellers-configurable-products-only-from-current-stor

Goals of this extension

[DONE] Return a list of configurable bestsellers (or at least the real parent)
[DONE] with sales order qty summed per store view (store) (so sales made in other stores are exclude)
[DONE] with sales order qty summed per category (optional; only include product belonging to category X - applies to parent products only because simple products may not be a member of the category)
[DONE] with an optional command to lag limit the sales qty over time (like last month only, or last 60 days)
[DONE] option to set header title
[TODO] add a default magento compatible template file that works for everyone (my own is themed)
[TODO] create option to inject distinct variable like distinct=brand where the brand column in the result is used to olny list the first bestseller appearance per brand (to prevent 1 popular brand from hogging bestsellers - so in other words, show the bestsellers, but then the 1 bestseller per brand)
and if someone feels enthusiastic: create a temp table and cronjob to log the results to speed up things (optional optional)

Help needed

in perfecting the code
testing this on multiple installations
adding the items under [TODO]

Usage

You may need to code your own phtml file - but it then may rely on this model. Example code below: {{block type="bestseller/bestseller" header="My Popular products" daysback=60 limit=8 category=6 template="catalog/product/bestsellerlist.phtml"}}

Where

type="bestseller/bestseller" calls the block code and method
header="My Popular products" injects the header (empty = "Bestsellers")
daysback=60 calculates bestsellers and looking back 60 days (empty = 60)
limit=8 returns the 8 best selling products (empty = 3)
category=6 returns best selling products that are a member of category (empty = root category)
template="catalog/product/bestsellerlist.phtml" your own coded template file doing magic with the resulting collection

In the template you can retrieve the collection like $_productCollection = $this->getCollection(); and the header or other variables like so $_header = $this->getHeader() ?: "Bestseller";. By looping over the products a list is made foreach ($_productCollection as $_product). Best is to copy the list or category list template depending on your needs. Some coding is required.

References