POP SPOT
Command Dashboard
Funko sales & stock performance · all channels · all stores ·
Sales Performance
Net Funko sales · selected channels & filtersStock Position
Inventory snapshot · all propertiesTotal Sales and Quantity per Channel
Sales (bars · left axis) and Quantity (line · right axis)
Top Brands by Sales
Brands ranked by selected metric (Funko Pop!, Bitty Pop!, Loungefly, etc.)
Total Sales per Store
All stores ranked by selected metric
Sales Mix by Channel
Funko share by channel · click slice to focus
Funko % of Total Sales · by Channel
Penetration: Funko ÷ total company sales for that channel
Top Stores · Funko Share
Stores with highest Funko penetration
Stock by Property
Available units by IP / category
Stock by Series
Available units by product line
🏆 Top 10 Performers
Best performers · toggle each chart between Value & QtyTop 10 Characters by Sales
Best-performing items by selected metric
Top 10 IPs by Sales
Best-performing IPs / properties by selected metric
Top 10 Lines by Sales
Best-performing product lines by selected metric
Top 10 Items — Wholesale
Top-selling SKUs through wholesale order sources
Channel × Sub-channel Cross-Tab
Product Catalog
· SKUs · click any card to see per-store stock and sales.
Store Performance
Per-store stock and sales analysis — click a row for SKU breakdown.
Transfer Engine
Move dead / slow-moving stock to where it's actually selling — you set the criteria.
How it works · you set the criteria
1. You define "dead stock"
Set Days on shelf, Max recent sales, and Min SOH at the FROM store. Anything matching becomes a FROM candidate. Toggle warehouses and consignment in/out.
Set Days on shelf, Max recent sales, and Min SOH at the FROM store. Anything matching becomes a FROM candidate. Toggle warehouses and consignment in/out.
2. You define "demand"
TO = stores selling above your threshold AND nearly out, OR new arrivals (≤ N days on shelf, low SOH) that haven't started selling yet.
TO = stores selling above your threshold AND nearly out, OR new arrivals (≤ N days on shelf, low SOH) that haven't started selling yet.
3. Smart matching
For each demand store, cover ~2 months of recent sales. Pull from warehouses first, then oldest-on-shelf, then highest SOH. Moves already in flight are skipped.
For each demand store, cover ~2 months of recent sales. Pull from warehouses first, then oldest-on-shelf, then highest SOH. Moves already in flight are skipped.
4. You choose the ranking
Sort by Revenue Lift (default), Age-Weighted, or Velocity. Priority is a 0–100 score (100 = the top move under the chosen ranking); Revenue Lift stays in EGP. Min priority cuts the tail, and you can click any column header to re-sort.
Sort by Revenue Lift (default), Age-Weighted, or Velocity. Priority is a 0–100 score (100 = the top move under the chosen ranking); Revenue Lift stays in EGP. Min priority cuts the tail, and you can click any column header to re-sort.
🚚 Live Transfers 0
Pending & recently-issued transfers from the live system. The recommender below skips moves that are already in flight.
Recommendations 0
Algorithmic suggestions. In-flight transfers above are excluded.
Reports
One-click exports. All CSV files open in Excel / Google Sheets.
Master Data
Full Sheet
All items · photos · catalog + per-store Stock/Sales/Sales Period + company & retail totals — mirrors the master sheet
Master Inventory
Full Export
Every SKU · every store · SOH + sales
Overstock Report
Risk
Stock that isn't moving · value at risk
OOS Best Sellers
Lost Sales
Top sellers with zero stock somewhere
Store P&L Summary
Per-Store
Revenue · stock value · turnover by store
License Performance
By IP
Revenue / SOH / unit count by license
Transfer Plan
Action
Full ranked transfer recommendations
⏳ Online & Pre-Order
Pipeline
Pre-order pipeline + online channels
📦 Warehouse Stock
Push Plan
All warehouse stock · push-to-store priorities
🤝 Consignment
3rd-Party
Hamleys + Hedeya stock per SKU
Channel Breakdown
Admin · Data Upload
Upload the 5 source Excel files. Each upload overwrites the matching table in Supabase.
1 · Supabase Admin Key
Required to write data. From Supabase → Settings → API Keys → service_role key.No key entered — uploads will fail until you save a key above.
⚠ Security: The service_role key bypasses RLS. Only paste it here on a private machine — never commit this HTML with the key inside. The key is stored in
sessionStorage and cleared when you close the tab.
2 · Upload the 5 files
Drop or pick each.xlsx, validate, then upload. Recommended order: Products → Stock → Transfers → History → Sales Orders.
ℹ How uploads work: Each file replaces only its own table (full delete + re-insert) — there is no cross-table cascade. You can upload any subset; the dashboard reflects whatever is currently in Supabase. For a complete refresh, upload all five. The two large files (Transfers ~88k and Sales ~83k rows) insert in 500-row batches, so they take a little while — watch the per-card progress bar.
①
Master Data
→ products table
pending
Drop .xlsx here
or click to choose
or click to choose
—
—
—
Expects sheet Zazome Report (file
New_Items_List.xlsx) with columns:
sku, barcode, item_name, product_type, price, sale_price_activate, sale_price, online_price, brand, line, classification_code, category2, ip, license, character, item_url, main_photo, photo1…photo9
—
②
Stock Data
→ stock_by_store table
pending
Drop .xlsx here
or click to choose
or click to choose
—
—
—
Expects sheet Zazome Report (file
General_-_Items_Store_List_sheet.xlsx) with columns:
sku, item_name, barcode, price, category, store_code, store_name, soh, committed, available, last_updated, open_orders, row_id, page_number
—
③
Transfer Data
→ transfers table
pending
Drop .xlsx here
or click to choose
or click to choose
—
—
—
Expects sheet Zazome Report (file
Transfer_Orders_Listbb.xlsx) with columns:
order_number, order_status, date_created, user_name, from_store_code, from_store_name, to_store_code, to_store_name, item_code, item_name, item_description, category, quantity_ordered, quantity_issued, quantity_received, quantity_delta, comment, comment_issue, comment_receive, date_issued, date_received, row_id, page_number
—
④
Stock History
→ history table
pending
Drop .xlsx here
or click to choose
or click to choose
—
—
—
Expects sheet Historical_Stock (file
The sheet's
Transform_Stock_History_Funko_portal_V6.xlsx) with columns:
unique, sku, store_code, location, release_date, current_status, history, days_ofs, company_status
The sheet's
unique column maps to unique_key; trailing empty columns are ignored.
—
⑤
Sales Orders
→ sales_orders table
pending
Drop .xlsx here
or click to choose
or click to choose
—
—
—
Expects sheet Zazome Report (file
Period filters read
Sales_Transactions_-_Items.xlsx) with the full 45-column layout, including:
customer_code, store_code, store_name, transaction_number, trx_date, transaction_date, item_code, item_name, quantity_sold, full_price, price, total_sales, total_sales_ex, recall_type, order_number, order_source_name, row_id, page_number (… and the rest).
Period filters read
transaction_date. Sales value uses total_sales_ex (ex-VAT line total); returns (quantity_sold < 0) subtract.
—