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: