boutique-ops

v1.0.0 MIT retail updated 2026-09-27

Compute inventory turn from a product CSV (sku, cost, retail, units sold, period days) — units per 30 days per item plus margin, flagging slow movers selling under 1 unit per 30 days as needing a markdown. Use when deciding which retail items to discount or stop stocking.

$ skillbank install boutique-ops@1.0.0
# pins exactly 1.0.0 · README + changelog included

Boutique Ops

Overview

Shelf space is rent. This skill reads your inventory (SKU, cost, retail, units sold over some number of days) and computes each item's turn rate — units sold per 30 days — plus its margin. Anything moving under 1 unit per 30 days is flagged as a slow mover that needs a markdown, so you can act before dead stock eats your cash flow. Useful for monthly buying reviews: reorder the fast movers, mark down the slow ones, stop restocking the zeros.

Installation

1. Copy the boutique-ops/ directory anywhere convenient. 2. Make the script executable (Unix):


   chmod +x scripts/turn.py

No pip install needed — standard library only. All data stays local — nothing is uploaded.

Configuration

Input file: an inventory CSV passed with --csv (a starter is bundled at samples/inventory.csv):


sku,cost,retail,units_sold,period_days
DOG-TOY-101,4.50,12.99,18,30
LEASH-BLK-202,9.00,24.99,2,30

| Column | Required | Description | |--------------|----------|-----------------------------------------------| | sku | yes | Item identifier (must not be empty). | | cost | yes | Unit cost in dollars. | | retail | yes | Selling price in dollars (must be > 0). | | units_sold | yes | Units sold during the period. | | period_days| yes | Length of the sales period in days (> 0). |

All values must be non-negative numbers; the report normalizes everything to units per 30 days so rows with different period lengths compare fairly.

Inputs

| Command | Arguments | Returns | |--------------------------|--------------|----------------------------------------------------------------------| | turn.py --csv <file> | Inventory CSV | Turn rate per item, margin %, slow-mover flags, flagged SKU list. |

Slow movers are listed first, then fastest sellers. Bad input (missing file, wrong columns, zero/negative period days, non-numeric values) exits nonzero with a plain-English error — never a traceback.

Worked example


$ ./scripts/turn.py --csv samples/inventory.csv
SKU                      Retail     /30d   Margin  Flag
--------------------------------------------------------------
TREAT-BAG-303          $   8.99     0.50    64.4%  SLOW MOVER — markdown
SWEATER-M-404          $  29.99    25.00    63.3%
DOG-TOY-101            $  12.99    18.00    65.4%
LEASH-BLK-202          $  24.99     2.00    64.0%
BOWL-SS-505            $  16.99     2.00    60.3%
--------------------------------------------------------------

5 items analyzed, 1 slow mover(s) (< 1 unit per 30 days).
Flagged SKUs: TREAT-BAG-303

TREAT-BAG-303 sold half a unit per 30 days — mark it down or bundle it with the fast-moving SWEATER-M-404.

Version history

Changelog

1.0.0 — 2026-09-27

  • Initial release. Inventory turn-rate calculator (scripts/turn.py) with slow-mover markdown flags.

← back to catalog