Margin
High-volume SKU below store average margin
Impact · R$ 4.2k–6.8k / mo
Example report
This report uses fictional demo data to show the StoreOpps format — not results from a real client store.
Demonstrative data: operational files match StoreOpps sample CSVs. Identical metrics across stores usually mean the same example files were uploaded — not a data leak between stores.
Complete example report
Fictional example dataNorth Baby Store (demo)
Diagnosis generated on 8/25/2026, 9:00:00 AM — Brasília time
Storefront: Storefront reading updated todayOperations: Operational data completeCross insights: Cross insights available
Operational period: Sep 1, 2025 — Jun 25, 2026
Storefront reading captured on 8/25/2026, 9:00:00 AM
- Cross-data findings indicate relationships between the data, but do not prove causation.
- Storefront and CSV compatibility is uncertain — confirm store and files before trusting cross-insights.
Executive summary
A combined reading of public storefront signals and operational files for this store.
Three priorities to remember
- Safe Infant Seat — Highlight with low margin · Stockout + highlight (High priority)
- Premium Stroller — Highlight with low margin (High priority)
- High Chair — Winner with low exposure (High priority)
Next 7 days
- Swap the highlight or renegotiate cost/price.
- Remove the highlight or replenish stock immediately.
Cross opportunities
Where storefront and operations agree — or conflict.
Storefront + operationsHigh priorityHigh confidence
Highlight with low margin — 2 products affected
A storefront highlight has weak operational margin.
Swap the highlight or renegotiate cost/price.
Premium Stroller
SKU001 · Matched by SKU · High confidence
Safe Infant Seat
SKU002 · Matched by SKU · High confidence
Also flagged for: Stockout + highlight
Storefront + operationsHigh priorityHigh confidence
Winner with low exposure — 2 products affected
A strong operational performer appears rarely in the sampled storefront.
Increase home/collection emphasis without sacrificing margin.
High Chair
SKU007 · Matched by SKU · High confidence
Travel Crib
SKU005 · Matched by SKU · High confidence
Storefront + operationsHigh priorityHigh confidence
Stockout + highlight — 1 product affected
An at-risk or unavailable item is still highlighted.
Remove the highlight or replenish stock immediately.
Safe Infant Seat
SKU002 · Matched by SKU · High confidence
Also flagged for: Highlight with low margin
Storefront + operationsHigh priorityHigh confidence
Idle stock + high exposure — 1 product affected
Idle inventory remains highly exposed — the storefront is not converting.
Review price/offer or remove the highlight.
Baby Hygiene Kit
SKU003 · Matched by SKU · High confidence
Evidence is limited beyond what the public storefront allows us to observe.
Storefront + operationsMedium priorityHigh confidence
Idle stock + low exposure — 1 product affected
An idle SKU also has little storefront presence.
Run a campaign or collection to move inventory.
Bib Pack
SKU006 · Matched by SKU · High confidence
Unified action plan
Consolidated priorities from storefront, operations, and cross insights.
Next 7 days
- Storefront + operationsCalculatedHigh priorityHigh confidence
Swap the highlight or renegotiate cost/price.
A storefront highlight has weak operational margin.
- SKU001 — Premium Stroller
- SKU002 — Safe Infant SeatAlso flagged for: Remove the highlight or replenish stock immediately.
- SKU017 — Stage Car Seat
- SKU025 — Rocking ChairAlso flagged for: Remove the highlight or replenish stock immediately.
- SKU029 — Compact Stroller
- Storefront + operationsCalculatedHigh priorityHigh confidence
Remove the highlight or replenish stock immediately.
An at-risk or unavailable item is still highlighted.
- SKU007 — High Chair
Next 30 days
- Storefront + operationsHigh priorityHigh confidence
Increase home/collection emphasis without sacrificing margin.
A strong operational performer appears rarely in the sampled storefront.
- SKU007 — High Chair
- SKU005 — Travel Crib
- CalculatedHigh priorityHigh confidence
Prioritize liquidation or purchase cuts for idle SKUs.
5 SKUs hold stock far above observed sell-through.
- SKU003 — Baby Hygiene KitAlso flagged for: Review price/offer or remove the highlight.
- SKU006 — Bib PackAlso flagged for: Run a campaign or collection to move inventory.
- SKU009 — Hooded Towel
- SKU024 — Soft Teether
- SKU030 — Cloth Diaper PackAlso flagged for: Decide whether to promote, discount or delist each SKU.
- Storefront + operationsHigh priorityHigh confidence
Review price/offer or remove the highlight.
Idle inventory remains highly exposed — the storefront is not converting.
- Storefront + operationsMedium priorityHigh confidence
Run a campaign or collection to move inventory.
An idle SKU also has little storefront presence.
- CalculatedMedium priorityMedium confidence
Decide whether to promote, discount or delist each SKU.
1 product in the catalog had no observed orders in the period.
Storefront reading
Observed on the site8 products observed · high quality
- Premium Stroller
- Safe Infant Seat · highlighted
- Baby Hygiene Kit · highlighted
- Maternity Backpack
- Travel Crib
- Bib Pack
Demo report
Fictional example dataFull example with fictional data
Same format you get after uploading complete CSVs. All numbers are fictional.
Fictional data · simulated period · download the sample CSVs to reproduce this report.
Download the CSVs used in this example
Same operation in every language — only headers and product names are localized.
Products
Catalog, stock, and reference pricing.
Orders
Revenue, repeat purchase (via Customer ID), and sell-through.
Customers
Optional customer registry — separate from customers inferred from orders.
Costs
Priority unit cost for margin.
Templates are empty headers. Examples reproduce this demo report.
Header
Inferred- Store
- North Baby Store (demo)
- Segment
- Baby and maternity
- Period
- 2025-09-01 → 2026-06-25
- Operational analysis completed
- 8/25/2026, 9:00:00 AM
- Origin
- Demo data
- Currency
- BRL
Full coverage
All required data groups were found. · High
Executive summary
Index methodology for this score
This store’s operational index: 85/100.
This index comes from your connected operational CSV data for this store — not from the public storefront reading.
Formula: starts at 55 and adds bonuses for healthy margin, repeat purchase, absence of stockout risk, absence of excess stock, and good data coverage; then clamps between 35 and 95.
Applied to this report: base 55 + healthy margin 12 + repeat 10 + no stockout risk 0 + no excess stock 0 + coverage 8.
Signals used: margin 46.8%, repeat rate 70.9%, SKUs at stockout risk 3, excess-stock SKUs 5, CSV coverage 100%.
Directional operational index to prioritize investigation — not a financial audit or forecast.
317 orders · R$423,098 revenue · 100% coverage
Prior-period comparison unlocks on Pro after the next analysis for the same store.
Recommended priority: High revenue with below-average margin
Key indicators
- Revenue
- R$423,098
- Orders
- 317
- Products
- 30
- Customers
- 134
- Average order value
- R$1,335
- Items per order
- 3.34
- Average discount
- 4.3%
- Gross margin
- 46.8%
- Gross profit
- R$197,873
- Inventory value
- R$194,905
- Units in stock
- 2,436
- Repeat rate
- 70.9%
- Analyzed period
- 2025-09-01 → 2026-06-25
Opportunity radar
High revenue with below-average margin
HighNext 7 days6 products with high volume sit below the store average margin.
Affected revenue: R$190,875
Group margin: 41.4% · Store average: 46.8%
Potential impact (+3 p.p.): R$5,726
Formula: affected revenue × 3 percentage points.
Start with
- • SKU001 — Premium Stroller
- • SKU017 — Stage Car Seat
- • SKU002 — Safe Infant Seat
Action: Review price, cost and discount on the top SKUs listed.
Confidence: High · Effort: Medium · Success metric: Gross margin of this group over the next 30 days. · Review in: Next 7 days
Idle inventory with immobilized capital
HighNext 30 days5 SKUs hold stock far above observed sell-through.
Potentially immobilized capital: R$46,530
Stock (units): 1,360
Units sold in period: 191
Recovery scenarios (not guarantees)
Recovering 30% of value: R$13,959
Recovering 50% of value: R$23,265
Scenarios depend on price, discount and liquidation strategy.
Start with
- • SKU003 — Baby Hygiene Kit
- • SKU006 — Bib Pack
- • SKU009 — Hooded Towel
Action: Prioritize liquidation or purchase cuts for idle SKUs.
Confidence: High · Effort: Medium · Success metric: Immobilized inventory value over the next 30 days. · Review in: Next 30 days
Stockout risk
HighNext 7 days3 SKUs are at or below reorder point.
Current stock: 9
Reorder point: 12
Impact not safely estimated with current data.
Start with
- • SKU002 — Safe Infant Seat
- • SKU007 — High Chair
- • SKU025 — Rocking Chair
Action: Replenish the listed SKUs before demand is lost.
Confidence: High · Effort: Low · Success metric: Stockouts avoided over the next 7 days. · Review in: Next 7 days
Products without sales in the period
MediumNext 30 days1 product in the catalog had no observed orders in the period.
Stock (units): 210
Impact not safely estimated with current data.
Start with
- • SKU030 — Cloth Diaper Pack
Action: Decide whether to promote, discount or delist each SKU.
Confidence: Medium · Effort: Medium · Success metric: Units sold from this group over the next 30 days. · Review in: Next 30 days
Winning products
- Trail Stroller (SKU010)R$69,586 · 49.3%
- Premium Stroller (SKU001)R$40,084 · 42.7%
- Stage Car Seat (SKU017)R$37,445 · 42.3%
- Safe Infant Seat (SKU002)R$31,708 · 36.3%
- Rocking Chair (SKU025)R$28,497 · 43.2%
- Compact Stroller (SKU029)R$26,899 · 45.3%
- Travel Crib (SKU005)R$26,243 · 38.6%
- High Chair (SKU007)R$21,395 · 46.3%
High revenue, low margin
- Premium Stroller (SKU001)R$40,084 · 42.7%
- Stage Car Seat (SKU017)R$37,445 · 42.3%
- Safe Infant Seat (SKU002)R$31,708 · 36.3%
- Rocking Chair (SKU025)R$28,497 · 43.2%
- Compact Stroller (SKU029)R$26,899 · 45.3%
- Travel Crib (SKU005)R$26,243 · 38.6%
Excess stock
- Baby Hygiene Kit (SKU003)240 units · R$22,800
- Bib Pack (SKU006)320 units · R$5,760
- Hooded Towel (SKU009)190 units · R$5,320
- Soft Teether (SKU024)400 units · R$3,200
- Cloth Diaper Pack (SKU030)210 units · R$9,450
Margin intelligence
- Average margin
- 46.8%
- Estimated gross profit
- R$197,873
Inventory intelligence
- Stock (units)
- 2,436
- Inventory financial value
- R$194,905
- Potentially immobilized capital
- R$46,530
Customer intelligence
- Customers
- 134
- Repeat purchase rate
- 70.9%
- Top 20% revenue share
- 46.2%
RFM segmentation
Recency, frequency and monetary value — anonymous ids only.
Champions
10 customers · 7.5% of base · 17.6% of revenue
Loyal
2 customers · 1.5% of base · 1.3% of revenue
Potential
13 customers · 9.7% of base · 3.3% of revenue
Promising
26 customers · 19.4% of base · 23.8% of revenue
Need attention
39 customers · 29.1% of base · 35.1% of revenue
At risk
1 customer · 0.7% of base · 2% of revenue
Hibernating
13 customers · 9.7% of base · 10.2% of revenue
Lost
30 customers · 22.4% of base · 6.8% of revenue
Methodology and limitations
Formulas used in this report:
Unit cost source: costs file when valid; otherwise products catalog. Zero is valid; missing is not treated as zero.
- • Net revenue ~= gross value - line discount.
- • Margin uses the costs file when valid; otherwise unit cost from the products file. Conflicts favor the costs file.
- • Repeat rate = customers with 2+ distinct orders / customers with >=1 order.
- • RFM scores customers on recency, frequency and monetary value (anonymous ids).
- • Coverage = share of capability groups available (revenue, products, customers, inventory, margin, repeat, discounts).
- ✓ Revenue
- ✓ Products
- ✓ Customers
- ✓ Inventory
- ✓ Margin
- ✓ Repeat purchase
- ✓ Discount impact