Create A Best Sellers Collection Over A Specific Time Period

One of the things Shopify allows you to do out of the box is sort a collection by Best Selling, but that is going to look at all time best sellers. Many times you want to look at best sellers over a specific time period, like the last 6 months for example.

That’s what this workflow allows you to do.

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:

Workflow #1: Save Order Data To Data by MESA

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 #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:

How do I use this demo file?

  1. Add MESA from the Shopify App Store. Enjoy a 7-day free trial to start.
  2. Import this download to My Workflows. Navigate to your automations then follow the prompt to import a workflow. Upload the downloaded ZIP file from this demo.
  3. That's it! Personalize any step if you want. You got this.
  4. Questions? Shoot me an email: [email protected]
We literally wrote the book on Shopify automation

Learn how to make Shopify work easier with your business processes.

Get the playbook - Free!

shopify automation playbook PDF