Clee's Internal Tools
Your tools,
one place.
Semi-automated tools for inventory, campaign planning, and data work. Click any card to open the tool.
Active Tools
Freebie Item Scorer
Score every ready-stock item 0–10 for freebie suitability. Connects live to Metabase. Filter by manufacturer, series, stock range, and COGS.
Excel Splitter
Split any Excel or CSV into N equal parts or by row count. All output files keep the original header. Works offline, no upload needed.
Critical Revaluation
Compare over/underperforming items against price change history. Identify candidates for price adjustments using live sales velocity data.
Band Matrix
Ready stock only, split into the six price bands. Velocity up, persistence across — heatmap plus per-item scatter. Drop the Metabase xlsx export to refresh.
New Sale DB
Surface items that qualify for a sale — new arrivals (last 100 days) and recently restocked stock. Ignore reviewed items, filter by type, and export for further work.
Reactivate
Items flagged for reactivation from Metabase. Filter by name, stock, and discount price. Exports a clean list with item page links ready to act on.
Error Checker
Two-in-one dashboard for pricing errors. Sale Price Error flags bad discount margins and extreme discounts. Normal Price Error catches Boncos and Gorengan items.
Fast Mover Alert
Items selling too fast for their stock — the full danger-zone list (≤21 days of cover). Urgency A/B/C × value HIGH/MID/LOW, ranked by revenue at risk. Same data SparkleBot posts daily.
Oripa Banner Builder
Auto-compose an Oripa (gacha pack) from live inventory. Set token price & pull count, curate a prize pool, and the builder assigns rarities (Gutter → Final Chase) so all SOP rules pass — including GP ≥ 35% and the 120–150% multiplier.
Marketplace Price Calculator