boutique-ops
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.