All Drafts

On Day 8 of Every Month, the System Rewards the Nutritionists Who Recommended the Store the Most, on Its Own

A nutritionist program that runs itself: each professional has their own profile, code and booking calendar, and every month the system counts valid uses, assigns prizes by TIER and builds the gifts in the ERP with stock worth moving.

Daniel Flores Osses
Daniel Flores Osses
Nov 18, 2026 · 6 min read

In the Chilean eCommerce business I built this for (a retail store and a wholesale one, with two warehouses of their own), around three hundred nutritionists recommend products to their patients with their own discount code. Rewarding them was manual work: checking who had sold the most, hunting for gifts that were in stock, putting together each order and chasing addresses over chat.

I rebuilt it so the program runs itself. The rules are written down before the month starts, the system does the math, and the person in charge of the program steps into a prize at a single point: approving it.


Every professional manages their own account

A nutritionist applies through a form on the online store. An administrator checks their degree in the Health Superintendency's registry of practitioners and approves them with one click. From there, everything is automatic:

  • Their discount code on the store, their account and their contact in the ERP are created, with their shipping address.
  • They get an email that walks them through a step-by-step setup: their details, their code and what counts as a use, how the prizes work, their public profile, whether they want to join the WhatsApp group, and the program's terms.
  • Their public profile includes appointment booking: the patient books and gets the notice by email.
  • If they change their shipping address in their profile, the change is made in the ERP too. Nobody copies it by hand.

No automatic process runs without the terms accepted. Anyone who hasn't accepted them still adds up uses but doesn't win, and the prizes screen flags them so someone can let them know.


What counts as a use

The whole program rests on one definition: the valid use. Count it wrong and you reward wrong. An order counts if it meets all of this:

  • It's paid and has the code applied.
  • It wasn't voided or fully refunded.
  • It isn't a self-purchase: it doesn't match the nutritionist's tax ID, email, phone or address.
  • It's the only one from that customer in the month: a patient who buys four times adds one use, not four.
This month's orders with a nutritionist's codePaid, with the codecountsSame customer, second orderalready countedBought with their own tax IDself-purchaseFully refundeddoesn't countPaid, another customercountsValid uses this month2 of 5
Only one use per customer per month counts, with no self-purchases or fully refunded orders.

If an order is refunded after the count, it's deducted the following month. A closed month is never touched.


TIERS with fixed thresholds

The first design ranked nutritionists by number of uses and handed out TIERS by position. I switched it to fixed thresholds: that way each one knows which goal to chase, and stock can be estimated before the month ends.

  • TIER1: 20 valid uses or more.
  • TIER2: 15 to 19.
  • TIER3: 10 to 14.

Everyone who reaches a threshold gets that TIER's prize; they don't compete with each other. Thresholds can be adjusted in the settings. On top of that there's an extra prize for whoever had the most uses that month.

Valid uses in the closed month101520Nutritionist A24TIER1Nutritionist B24TIER1Nutritionist C17TIER2Nutritionist D12TIER3Nutritionist E8no prizeTie for first place with 24 usesBoth get the extra prize, on top of their TIER
Each threshold reached unlocks its TIER; the star is the extra prize for whoever had the most uses.

Two rules settle the edge cases:

  • A tie for first place: everyone tied gets the extra prize, and the system checks there's enough stock for all of them.
  • Nobody reached the minimum: the extra prize isn't lost; it rolls over to the next month.

Gifts come from the stock worth moving

Choosing gifts was the slowest part. Now the person in charge sets up the month on a single screen: the products for each TIER, the extra prize, and an equivalent backup prize in case stock runs short. They search by name or by SKU (each product's internal code) and add each one as a chip with its quantity.

Next to it, suggestions show up from the system that flags what will expire before it sells. They're products with free stock in both warehouses that meet any of these conditions:

  • they expire in 120 days or less;
  • they arrived at zero cost;
  • they're flagged as "expires with stock", "slow mover" or "excess stock".
This month's prizesTIER1 · 20 or moreProtein 2 kgShakerTIER2 · 15 to 19Creatine 300 gTIER3 · 10 to 14ShakerExtra prizeProtein + creatine packBackupProtein 1 kgCollagen 300 gSuggestions from the stock control systemCollagen 300 gexpires in 95 days+ AddBars x12arrived at zero cost+ AddOmega 3slow mover+ AddNeeded for the estimated winnerscompared with free stock in both warehousesenough
Suggestions come from the stock control system; they're added with one click and the system checks stock in the ERP.

A product that was going to sit in the warehouse ends up in the hands of a professional who recommends it. While the month is being set up, the system estimates how many winners there will be, works out the units needed for each SKU and compares them with real stock in the ERP.


Why day 8 and not day 1

The count runs on day 8, not day 1. That week leaves room for end-of-month orders to be voided or refunded before counting; counting on day 1 would reward orders that later don't exist. On day 8, an automatic process:

  1. Freezes the previous month's count, with its orders and each nutritionist's TIER.
  2. Creates a prize for every winner who accepted the terms.
  3. Sends them the "You won a prize!" email, with 5 days to confirm their shipping address. If they don't, the address on file is used.

Once the address is confirmed, or the deadline passes, the system builds the quote in the ERP: the winner's contact with their shipping address, each product at retail price with a 100% discount, and the tags "Nutritionist Prize", the TIER and "Extra prize" when it applies. That way every prize has a value attached and the program can be measured.

Before creating it, it checks stock again. If the extra prize is short, it uses the backup and lets the person in charge know. If a TIER product is short, the quote is created anyway and a notice goes out to sort it.

Day 8: the month is frozencounts uses, assigns TIERS and the extra prize“You won a prize!” email5 days to confirm the shipping addressQuote in the ERPat retail price with a 100% discountGifts to approvean administrator reviews and approves itConfirmed in the ERPthe system detects it: AuthorizedShippedemail with the tracking numberautomatica person decides
Of the six steps, a person steps in for one. The system handles the rest and logs it.

A single human approval

The quote shows up in the "Gifts to approve" inbox. An administrator reviews and approves it, and whoever authorizes spending confirms it in the ERP. From there the system carries on by itself:

  • If the quote is confirmed in the ERP, the prize moves to "Authorized"; if it's cancelled, to "Rejected".
  • When the shipment has a tracking number, the nutritionist gets an email with it.
  • After 48 hours without authorization a reminder goes out; at 96, the notice escalates to administration and management.

The nutritionist sees their prize's status in their profile, without amounts. And running the process twice duplicates nothing: each prize leaves its mark on the quote, and the system looks for it in the ERP before creating another.


The WhatsApp group, without connecting to WhatsApp

The nutritionists' group is voluntary and gets two graphics a month, which the system builds with the product's real photo from its catalog record:

  • on the 15th, "This will be the prize for whoever uses their code the most this month", with the extra prize;
  • on the last business day, the prizes for each TIER.

AI only generates the background, with no products, no text and no one's data. The person in charge reviews the graphic, downloads it and posts it to the group. The system reminds them when to do it, but it never writes on WhatsApp for anyone.


What the business gains

Rules known before the month starts and math nobody does by hand. The nutritionist knows which goal to chase, the person in charge goes from building orders to approving them, and the gifts come from the stock most worth moving. Every prize is measured at retail price and at cost, alongside the sales and new customers each code brought in, just like in the system where every discount code is held to account.

The winner isn't whoever remembers to ask. It's whoever meets the rule.

If your ambassador or professional program is still rewarded by hand, start with an AI diagnosis for your company.

Contact me