Context

A manual eBay listing involves: photographing the item, identifying it, writing a description, researching comparable sold prices, and filling out the eBay form. That process takes roughly 10 to 15 minutes per item. There is currently no system to track status, condition, or pricing across the collection.

Factor Detail
Collection size16,000 miniatures
Time per item (manual)10 to 15 minutes (photography, research, description, pricing, upload)
Total estimated hours (manual)approx. 3,200 hours
Existing tracking systemNone

Data flow and status pipeline

Each item follows a status pipeline from capture to live eBay listing. Capture is phone-based. Review, manual entry, and posting are desktop-based. No item posts to eBay without explicit approval.

Capture

Photographer takes 3 photos on phone. Item saved to the database with status: draft. Processing begins immediately.

AI Processing

Gemini Vision reads the ID from the bottom photo. That ID is looked up in a local miniatures database, built prior to launch by aggregating all available public set checklists and fan databases. If found, name, set, rarity, and description are filled from the database. If not found, Gemini generates a description from the photos as a fallback.

Price Lookup

eBay Browse API fetches recent completed sales. The app calculates an average and sets it as the suggested listing price.

Review

Reviewer edits any field inline on desktop. Marks as approved or flags as needs manual entry if the AI could not identify the item.

Manual Entry

Flagged items are queued one at a time. Reviewer fills in the fields, saves, and the next unidentified item loads automatically.

Post to eBay

Approved items are selected in any quantity and posted via the eBay Sell API. Each successful post returns a live listing link.

Three primary screens

Representative layouts. Not final designs.

Screen 1: Mobile Capture
dnddb.opsthatwork.com/capture
Step 2 of 3
Back Photo
LIVE VIEWFINDER
Capture retake front
Screen 2: Desktop Review Queue
dnddb.opsthatwork.com/review
Item Set Price Status Action
IMG
Lich, Undead Unhallowed #12 $8.50 Approved Edit
IMG
Goblin Warrior Harbinger #4 $3.00 Needs Review Review
IMG
Unknown Figure Unidentified -- Manual Entry Enter
IMG
Beholder Giants of Legend #31 $22.00 Approved Edit
Screen 3: eBay Batch Post
dnddb.opsthatwork.com/post
Set: All Condition: All Price: Any Search...
x
IMG
Lich, Undead / Unhallowed #12
$8.50
x
IMG
Beholder / Giants of Legend #31
$22.00
x
IMG
Dire Wolf / Angelfire #8
$5.00
Post selected (3) to eBay
Post results
+Lich, UndeadView on eBay
+BeholderView on eBay
+Dire WolfView on eBay

Where the time goes

Each manual listing involves four distinct tasks. The application automates three of them. Photography takes the same amount of time either way.

Task (per item) Manual With app Hours saved (16k) Labor cost saved
Photography 3-5 min 3-5 min No change --
Identify item + research description 3-5 min 0 min (AI) 800-1,333 hrs $20,000-$33,300
Write listing description 2-3 min 0 min (AI) 533-800 hrs $13,300-$20,000
Research comparable prices 2-3 min 0 min (API) 533-800 hrs $13,300-$20,000
Upload photos + fill eBay form 2-3 min 1-2 min (review + batch) 267-533 hrs $6,700-$13,300
Total per item 12-19 min 4-7 min 2,133-3,200 hrs $53,300-$80,000

Labor cost calculated at $25/hr. Ranges reflect variation in item complexity and condition.

Manual With App
Total hours 3,200 hrs 530 hrs
Labor cost (at $25/hr) $80,000 $13,250
App build + running costs -- ~$496
Total cost $80,000 ~$13,746
Savings ~$66,254

What this costs

Item Detail Cost
App build15 hours at $30/hr$450
Server storage2 months at $10/month$20
Gemini APIAll 16,000 items~$26
eBay APIFree with developer account$0
Total upfront~$496

Break-even at approximately 100 items listed (out of 16,000). Optional data export to external drive available for $50 to $100 if needed later.

Stack and infrastructure