Bestselling Results¶
Menu Location: Products > Online Store > Bestselling Results
Overview¶
Bestselling Results controls how the "Bestselling" sort option works in your online shop. It is not a sales report, it is the configuration tool for a rank score the system calculates for every product based on how many unique customers have recently ordered it. Recent weeks can be weighted more heavily so that recent buying behavior counts for more than older weeks.
Primary Functions:
- View each product's current Bestselling Rank Score
- See a week-by-week breakdown of how a product's score was calculated
- Configure how many weeks back the score looks
- Set a weight for each week back (recent weeks can count for more)
- Manually trigger a score recalculation
Page Layout¶
Product List¶
A table of the top 100 products with a nonzero Bestselling Rank Score, sorted highest score first, showing:
- Name - links to the product's edit page
- Bestselling Rank Score - click it to open the Score Details breakdown for that product
Settings Panel¶
- Weeks back - "How many weeks (including the current week) into the past do you want the system to look at?" Default shown on the page is 5.
- Weighted Values - one input per week back (labeled "Current Week," "1 week back," "2 weeks back," etc.), each defaulting to 5. Set a higher number for recent weeks and a lower one for older weeks, or set them all the same for equal weighting.
- Save Settings - saves the weeks-back and weight values without recalculating scores
- Save & Update Scores - saves settings and recalculates scores immediately
- Update Scores (button at top of page) - recalculates scores without changing settings
Score Details Modal¶
Clicking a product's score opens "Score Details for [product name]," a table with one row per week:
- Week - the date range for that week
- *Count - the number of unique customers who purchased at least one of this product that week
- x Weight - the weight configured for that week
- = Score - Count multiplied by Weight
A totals row at the bottom shows the combined Count and Score across all weeks.
How Scoring Works¶
For each week back, the system counts how many unique customers ordered the product that week (cancelled orders are excluded), multiplies that count by the weight configured for that week, and adds the result to the product's total Bestselling Rank Score. "Weeks" here are the store's weekly order cycles, not fixed calendar weeks.
Scores recalculate automatically once every 24 hours. You can also force an immediate recalculation at any time with the Update Scores or Save & Update Scores button.
The resulting score is what customers see reflected when they sort the shop by "Bestselling," and it also drives the "Bestsellers" category view and the "View More" link shown under bestselling products on product pages.
Common Use Cases¶
Use Case 1: Look Further Back (or Not as Far)¶
Goal: Widen or narrow the window the score considers.
Steps:
- Change the "weeks back" value in the Settings Panel
- Click Save & Update Scores
Result: Scores are recalculated using the new number of weeks.
Use Case 2: Favor Recent Purchases More Heavily¶
Goal: Make the score respond faster to recent sales instead of treating all weeks equally.
Steps:
- Set a higher weight for "Current Week" and progressively lower weights for older weeks
- Click Save & Update Scores
Result: Products that sold well recently rank higher, even if an older week had similar volume.
Use Case 3: Force an Immediate Refresh¶
Goal: Get updated scores right after a promotion or big sales day instead of waiting for the daily automatic update.
Steps:
- Click Update Scores at the top of the page
Result: All product scores are recalculated immediately using the current settings.
Use Case 4: Understand Why a Product Ranks Where It Does¶
Goal: See the week-by-week math behind a specific product's score.
Steps:
- Find the product in the list
- Click its Bestselling Rank Score
- Review the Count, Weight, and Score for each week in the modal
Result: A clear breakdown of how that product's total score was built.
Troubleshooting¶
List Is Empty or a Product Isn't Showing a Score¶
Check:
- Has "Update Scores" ever been run? Scores start at 0 and only populate after a calculation
- Did the product actually have orders in the configured window?
- Were the orders cancelled? Cancelled orders don't count toward the score
Solutions:
- Click Update Scores
- Increase "weeks back" to widen the window
- Check the product's order history directly if it still seems wrong
Scores Don't Change After Clicking Update Scores¶
Check:
- Did you save the weeks-back and weight changes first? Use Save & Update Scores to do both at once
- Is a weight set to 0? That zeroes out that week's contribution
Solutions:
- Re-enter and save the settings, then update scores again
- Review each week's weight value in the Settings Panel
Related Pages¶
- Featured Products Sort - a separate ordering used to control which products show as "featured," independent of the Bestselling score
- Menu Inventory - review and manage stock levels for products
- Order Contents Dump - detailed order-by-order product data
- Product Quantities Over Time - quantity trends for specific products
- Store - store category setup, display order, and images
Quick Reference Card¶
| Task | Action/Location |
|---|---|
| See a product's current score | Product List table |
| Understand how a score was built | Click the score to open the details modal |
| Change how far back scoring looks | Settings Panel > weeks-back field |
| Make recent sales count for more | Settings Panel > Weighted Values |
| Recalculate right now | "Update Scores" button |
| Save settings and recalculate together | "Save & Update Scores" button |
FAQs¶
Is this a sales report?¶
No. It's the configuration screen for the score behind the shop's "Bestselling" sort option. It shows a rank score, not revenue or unit totals, though the underlying calculation is based on how many distinct customers bought a product.
How often do scores update on their own?¶
Once every 24 hours. You don't need to do anything for that to happen, but you can force an update sooner with the "Update Scores" button.
What counts toward a product's score?¶
For each week in the configured window, the number of unique customers who ordered that product, multiplied by that week's weight. Cancelled orders are not counted.
What does "weeks back" mean if my store doesn't run on a calendar week?¶
It refers to the store's own weekly order/delivery cycles, not fixed Sunday-to-Saturday calendar weeks.
Where do customers actually see this ranking?¶
When a customer sorts the shop by "Bestselling," views the "Bestsellers" category, or sees a "View More" link on a product page pointing to the bestselling-sorted view.
End of Documentation
For additional help, contact your system administrator or Kiva Logic support.