Made-to-order production board for Etsy sellers

The idea

A made-to-order Etsy seller doing 80 units a month runs production off a printed order list and gut feel. Etsy shows orders, not work: no stages, no way to see that three orders share the same variant, and the ship-by date buried per order. Miss a ship-by date and the shop’s star seller badge takes the hit, which sellers guard like a credit rating.

The wedge is per-line-item production cards with two views Etsy will never build: a stage board sorted by ship-by urgency, and a batch view that groups identical variants so the seller stops making one of a thing six times.

Who pays

Sellers doing 50+ made-to-order units a month pay 12 USD/month, priced as an obvious rounding error against protecting star seller status and the late-shipment defect rate. Distribution: the Etsy sellers subreddit, Etsy seller Facebook groups, and YouTube channels teaching Etsy production workflow, where a genuinely useful tool spreads fast.

MVP scope

• Etsy OAuth connect with 15-minute idempotent order sync
• Per-line-item cards with variant, personalisation, and ship-by date
• Kanban board (Queue/Cut/Assemble/Finish/Ship) with urgency colours
• Batch view grouping identical variants with batch-level stage moves
• Auto-archive on shipped status from Etsy
• Skip for v1: multi-shop, Shopify/Amazon channels, shipping label purchase, inventory and materials tracking, team seats

Build MakeQueue, a web app that turns an Etsy shop's open orders into a production board sorted by ship-by date.

Stack: Next.js (App Router), Etsy API v3 with OAuth, Supabase (Postgres + auth), Stripe for billing.

Core flow: the seller connects their shop via Etsy OAuth. A sync job pulls open orders every 15 minutes and creates one production card per line item (not per order), carrying the listing title, variant details, quantity, personalisation text, and the order's ship-by date. Cards land in a Kanban board with columns Queue, Cut, Assemble, Finish, Ship, draggable between stages, always sorted inside each column by ship-by date with colour-coded urgency (red within 2 days, amber within 5). A separate Batch view groups identical listing-plus-variant cards across orders so the seller makes six of the same mug in one session; moving a batch moves every card in it.

Pages: Etsy OAuth connect screen, the board, batch view, order detail drawer with personalisation text prominent, settings for stage names, billing.

Implementation details: store the Etsy receipt and transaction IDs on each card and make sync idempotent, since Etsy webhooks are unreliable and polling will re-see orders. When an order ships on Etsy, auto-archive its cards on next sync.

Pricing: 12 USD/month via Stripe Checkout, 30-day trial, single shop per account.