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:

shopify metafield

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

shopify collection

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

workflow steps: save shopify order to database

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:

workflow: Set metafield and collection sort order

Questions about this workflow? Contact our partner:

Kalen Jordan

MESA Service Partner

What you should do next

Whenever you’re ready…follow these 4 simple steps to get started:

  1. Add MESA to your Shopify store. The best way to get started is by adding the MESA app from the Shopify App store. Every plan includes the first 7-days free so you can be assured your workflow is running properly.
  2. Import this workflow. Download this .ZIP file then import it into your MESA workflows.
  3. Questions? Contact Kalen Jordan. MESA Service Partners can help personalize workflows or make any automations your business requires.
  4. If you know another merchant who’d enjoy reading this, share it with them via LinkedIn, YouTube, Twitter, or Facebook.

Automate anything and get more from your apps.
For free.

Start free trial
background: abstract lines

Automate everything with MESA

Make any workflow and get more from your existing apps.

Try MESA for free, 7-day trial included.