I want to publish the six most popular selling items on my home page.
I have created an Item Search which looks at all the transactions over the last 14 days and counts the number of Sales Order transactions for each product (no the quantity of items sold).
On the results tab I clicked Run Unrestricted and set maximum results to 6. When I run the search manually I get the six most popular selling items and the number of transactions, a total and a "more..." message.
If I use this search for a Published Saved Search, it publishes all the items found not just the top six thus ignoring the "Set maximum results = 6"
Is there any way to make this work?
I there is a way to run a search and only get six results is there any way to publish those six items on to the home page without putting them into a subcategory?
I want to make the "most popular items" the results if a dynamic search so that it is constantly changing with the seasons. It makes the home page more interesting and less static. I also think that the results if the search is highly relevant and will boost sales.