Create A Best Sellers Collection Over A Specific Time Period

While Shopify allows you to sort collections by all-time best sellers, this workflow enables you to focus on top-selling products over a specific time period, such as the last 6 months. Keep your store relevant and responsive to current trends by showcasing the best performers from recent sales. Enhance your merchandising strategy and drive more sales by highlighting products that are currently in demand.

Watch the demo

We’re going to first create a metafield to store the best selling index on each product:

And then we’ll also want to have a collection set up that pulls in all products with a non zero best seller index:

Next, we’ve got a couple of workflows to install:

Preview workflow 1: Save order data to database

This one is simply going to save each order line item to our database – we’ll use that in the next step to query best sellers

Preview workflow 2: Set metafield and collection sort order

This one will run on a daily schedule and query all the best sellers, and set the best selling index (i.e. 1, 2, 3, …) and also set the collection sort order: