Getting popular products by category

[dave_reach]

Is there a simple way using the AbleCommerce API to return the top selling products from a specified category? I have a category called Bundles, and I need to list the Top Bundles.

Any ideas?

Thanks,
Dave.

[m_plugables]

You may have to write some custom database related code for this purpose. You can use this
http://wiki.ablecommerce.com/index.php/ ... uilder_API as refarnce that how to write your database related custom code

[sacards.com]

i thought this would be an easy modification to the current featuredgrid control ?

[m_plugables]

In fact ProductDataSource class have no functions that finds the popular products for some specific category. Yes you can use the current Featured Products grid control because it has most of the things like the layout etc. You just need to write some custom function in the control which returns the popular products for your criteria and then use this function instead of ProductDataSource.GetPopularProducts()

[dave_reach]

That is what i'll do - i've already written a myriad of custom database code to select a variety of different things, i'm just struggling to work out how to order by sales - although I havn't really had a proper look yet - that is this morning's job!

Thanks,
Dave

[dave_reach]

For anyone who is interested this is how I achieved this, although it has altered since my original request. The client now wishes to set Bundles as an option on the product, so I created a Template Field to hold this information.

Code: Select all

SELECT TOP 3 ac_Products.ProductId, ac_ProductTemplateFields.ProductId FROM ac_ProductTemplateFields
INNER JOIN ac_Products ON (ac_Products.ProductId = ac_ProductTemplateFields.ProductId)
WHERE (ac_ProductTemplateFields.InputFieldId = 2 AND ac_ProductTemplateFields.InputValue = 1)
ORDER BY (SELECT SUM(Quantity) FROM ac_OrderItems WHERE ac_OrderItems.ProductId = ac_Products.ProductId) DESC

[m_plugables]

Thanks for sharing your experience dave