How do I create a weekly markdown dashboard for my boutique?

A Monday markdown dashboard is a simple Google Sheet that takes about 20 minutes to review each week. Set up columns for SKU or style name, category, current discount tier, units sold this week, current on-hand quantity, updated weeks of supply, weeks remaining in the season, and an action flag.

The action flag is a basic formula: if weeks of supply is greater than weeks remaining, it reads 'move down.' Otherwise it reads 'hold.' Add conditional formatting so red highlights items that need to drop a tier and green highlights items that are fine. This turns your dashboard into an instant visual decision tool.

The key benefit is replacing reactive, emotion-driven discounting with a consistent data ritual. Instead of panicking on a slow Saturday and slashing prices, you open the sheet Monday morning, move red items to the next tier, leave green items alone, and go about your week. Toolio's research specifically recommends weekly sell-through reporting over monthly post-mortems for this reason.