how this works
overview & definitions
Three states a color can be in:
in stock — hats are available, customers can order normally
restocking — sold out but more are coming, customers can pre-order (up to the restock qty cap)
sold out — no restock planned, customers can only join the waitlist to register interest
Inventory table columns:
in stock — how many hats you physically have right now (raw Firebase number)
pre-orders — how many pending + notified pre-orders exist for that color
public avail. — what customers see on the site (in stock minus pre-orders)
total sold — completed orders for that color
restocking — toggle yes/no to control whether sold-out colors accept pre-orders
restock qty — the cap: how many hats are incoming, limits pre-orders to this number
Pre-order statuses:
pending — customer placed a pre-order, waiting for stock
notified — you tapped "mark notified," a pre-written email opened with their Venmo link. Clock starts (days shown in table).
released — they ghosted, hat goes back to inventory
Order statuses (ship orders):
unpaid → paid → shipped
Inline editing: tap any name, contact, color, method, address, or total cell in either table to edit it. Changes save to Firebase automatically. Color and method fields are dropdowns.
CSV export: includes all real orders (direct + converted pre-orders), with contact, shipped status, and which pre-order it came from.
customer journey: regular order
1. Customer picks a color and delivery method on the site
2. They fill out their info and tap "place order"
3. Confirmation screen shows with a big CTA to send the order email
4. They tap the button, a pre-filled email opens, they hit send
5. For ship orders: Venmo button appears to pay $28–$29.50 (hat + zone-based shipping)
6. Order appears in your admin orders table
customer journey: pre-order
1. Customer picks a sold-out color that's restocking, sees "X spots left"
2. They fill out name, contact, delivery, and address (if shipping)
3. Confirmation screen shows, they send the email
4. Pre-order appears in your admin pre-orders table as pending
5. When all spots fill, new customers see "pre-orders full" and get the waitlist instead
your journey: fulfilling pre-orders
1. Stock arrives → add inventory with the +/−/+10 buttons
2. Go to the pre-orders table
3. Tap mark notified — this opens a pre-filled email to the customer with their Venmo link and order details. Hit send.
4. When they pay, toggle venmo to paid — this auto-converts the pre-order to a real order, deducts 1 from inventory, and removes it from the pre-orders table
5. For ship orders, toggle shipped once you mail it
6. If they ghost after a week, tap release to put the hat back in public inventory
your journey: setting up a restock
1. Toggle restocking to yes for the color
2. Set the restock qty (e.g. 10 incoming)
3. Set the restock ETA below the table (e.g. "mid-August") — this is what customers see
4. Pre-orders will be accepted up to the cap, then auto-lock
5. When stock arrives and pre-orders are fulfilled, toggle restocking back to no
