Generate Daily Product Rankings Based On Sales Data
Use this template
100% fully customizable
Includes 7-day free trial
Live chat, email support
Setup services available
Keep your best-selling products front and center with daily sales-based rankings. This template crunches your sales numbers every 24 hours, gives each product a numbered rank, and shuffles your collection order to showcase what's hot right now.
Frequently asked questions:
What is a template?
Templates are pre-made workflows by our team of experts. Instead of building a workflow from scratch, these have all the steps needed to complete the task.
Can I personalize a template?
Yes! Every step can be customized to meet your exact requirements. Additionally, you can even add more steps and make it more sophisticated.
Can MESA handle the setup for me?
Yes, check out our Expert Workflow Setup. We'll collaborate with you to craft the perfect workflow so you're up and running with confidence.
Other workflow requirements:
How this template works:
Trigger daily ranking
The workflow starts automatically every day at midnight to refresh sales data.
Define ranking inputs
Sets dynamic variables like how many days of sales to review, how many products to rank, and which collection to update.
Query best-selling products
Runs a SQL query to calculate the top-selling products by quantity sold.
Fetch current collection products
Retrieves all products currently in the selected collection so their ranking can be reset.
Loop through current collection
This step goes through each product in the existing collection.
Reset product rank to zero
Clears any previous ranking by setting the best_sellers_index metafield to 0.
Loop through new top-sellers
Begins a new loop over the freshly ranked best-selling products.
Get product info
Looks up each product from the top sellers to prepare it for re-ranking.
Assign new best-seller rank
Updates the product's metafield to reflect its current best-seller index.
Sort products in best sellers collection
Uses a custom script to reorder the collection based on updated rankings.
Generate Daily Product Rankings Based On Sales Data
100% customizable. No code required.
Rated 4.8 out of 5 stars on the Shopify App Store
Use this templateLoved by 3k+ businesses worldwide
Fully supported by automation experts.
Get help from our team of experts and industry partners, who are dedicated to ensuring your MESA experience is smooth, efficient, and tailored to your exact business needs.
