SQOOT Pure — Admin Panel Workflow

Fortress Gold Inc. DBA Sqoot  |  April 12, 2026

📦 Product SKUs
SKUProductWeight
SQ-1OZ1 oz Gold Bar1 oz (31.1g)
SQ-100G100 gm Gold Bar100 gm (3.215 oz)
SQ-1KG1 kg Gold Bar1 kg (32.15 oz)
Customer Price = Live Spot + 3% Markup + $25 Misc
Spot from COMEX via Supabase Edge Function  •  Price confirmed at time of payment
1
Customer Places Order
PENDING PAYMENT
Channels
Chatbase chatbot
Email / Phone
Future: Website portal
Collected Info
Name, Email, Phone
SKU, Quantity
Ship or Vault
Order Number
Format: SQ-YYYYMMDD-XXX
e.g. SQ-20260412-001
▼
2
Payment Received
PAYMENT CONFIRMED
Now
Invoice / Zelle / Wire
(Admin marks as PAID)
Future
Plaid ACH
(Automated)
▼
3
Dillon Gage Order (FizzTrade)
DG ORDER PLACED
Action
Admin places buy on FizzTrade portal
Tracking
DG Order # recorded
Linked to SQOOT Order #
Margin
DG cost vs Customer price
= Gross profit per order
▼   Fulfillment Split   ▼
4a
📦 Ship
SHIPPED → DELIVERED
Carrier
Parcel Pro (insured precious metals)
Tracking
Tracking # recorded
Customer notified (email/SMS)
Statuses
Preparing → Shipped → In Transit → Delivered
4b
🔐 Vault
VAULTED
Customer
Customer # created (SQCUST-XXXX)
if new customer
Inventory
Gold added to single pooled vault
Ownership recorded under customer #
Statuses
Active → Redeemed / Transferred
🗄️ Database Tables (8)
customers
customer_noSQCUST-XXXX
nametext
emailtext
phonetext
addressjsonb
sourcetext
skus
idSQ-1OZ etc
nametext
weight_ozdecimal
weight_gramsdecimal
activeboolean
orders
order_noSQ-YYYYMMDD-XXX
customer_idFK → customers
sku_idFK → skus
spot_pricedecimal
total_pricedecimal
statusworkflow stages
fulfillment_typeship / vault
dg_orders
order_idFK → orders
dg_order_noFizzTrade #
dg_pricedecimal
dg_statusplaced → received
shipments
order_idFK → orders
carrierParcel Pro etc
tracking_notext
statuspreparing → delivered
customer_notifiedboolean
vault_inventory
customer_idFK → customers
order_idFK → orders
sku_idFK → skus
weight_ozdecimal
statusactive / redeemed
expenses
categoryinventory / shipping / …
amountdecimal
vendortext
order_idFK → orders (optional)
revenue
order_idFK → orders
amounttotal revenue
cost_of_goldDG cost
gross_profitrevenue − cost
🖥️ Admin Panel Sections (7)
📊
Dashboard
Spot price, open orders, pending payments, vault total, monthly revenue
📋
Orders
Create, view, filter, update status, link DG order #
👤
Customers
Search, detail view, order history, vault holdings, notes
🔐
Inventory / Vault
Total by SKU, customer holdings, movement log
🏦
Purchases (DG)
FizzTrade log, cost basis, margin calc
📦
Shipments
Active tracking, Parcel Pro, customer notifications
💰
Financials
Revenue by period, expenses, P&L, gross margin