Click a variable above to insert it at cursor position.
—
Pricing Rules
Rules are evaluated in order — first match wins. The formula's result has the mail cost subtracted,
is rounded down to X.X9, then clamped to the price floor.
Dashboard
Lifetime P&L from imported eBay Transactions.
Monthly Trend
Loading…
Month
Revenue
Net Cash
Units
Platform Fees
Expenses
Net After Exp.
No data yet.
Lots
Register and manage card lot purchases.
Lot Registry
Loading…
Per-Lot P&L
Financial performance by lot. Edit lots via Inventory → Lots.
P&L Table
Loading…
Expenses
Business expenses outside of eBay fees (shipping materials, subscriptions, etc.).
Listed in DB but gone from eBay ( — likely sold, pending attribution):
Quantity mismatch ():
Card Name
Set
#
Finish
Cond
Total
Unlisted
Listed
Sold
Price
SKU
Lots
Last Synced
Click Sync to build listings from inventory.
Workbench
? How to use
Workbench — Sections Overview
1 · Migration Coverage
Shows which lots have been ingested into the DB.
2 · Duplicate Variants — Inventory Store
Scans the inventory DB for card variants
(scryfall_id + finish + condition) that have more than one custom label.
This happens when the same card was imported from multiple lots or sources.
Use the results to decide which records to merge in the Inventory view before syncing to eBay.
3 · Duplicate Variants — Active Listings Report
Parses your latest eBay Active Listings CSV and resolves each MTG listing to a Scryfall card.
Flags variants where eBay has multiple separate listing items for the same card.
These are candidates for qty consolidation (Phase 2).
Requires a fresh Active Listings report in ebay_reports_dir.
4 · SKU Alignment & Consolidation
Aligns all eBay Custom Labels to ZTCG- format,
consolidates duplicate listings per variant into one, and sets correct quantities.
Produces a Revise CSV and an End CSV for redundant duplicates.
Steps:
Ensure your latest Active Listings report is in ebay_reports_dir.
Click Analyze — review stats (to revise / to end / unmatched).
If price conflicts appear (>20% spread), review each row and adjust the Final Price if needed.
Click Download CSVs — two files download automatically.
Upload ztcg_sku_alignment_revise.csv to eBay via Seller Hub → File Exchange first.
After the Revise upload completes, upload ztcg_consolidation_end.csv to end duplicates.
Wait 5–10 min and check File Exchange results for row-level errors.
Migration Coverage
▼
Lot ID
Game
Purchase
Cost
ManaBox
TCGAutomate
Manual
Loading…
Duplicate Variants — Inventory Store
▼
Finds card variants (scryfall_id + finish + condition) with multiple listed custom labels in the inventory store.
These need to be consolidated into a single eBay listing.
Card Name
Set
Finish
Cond
Listings
Total Qty
SKUs
Lots
Click Scan Inventory to detect duplicates.
Duplicate Variants — Active Listings Report
▼
Parses the most recent eBay active listings report, resolves each MTG listing to a
Scryfall card, and flags variants with multiple live listing items.
Card Name
Finish
Cond
Listings
Total Qty
Duplicate Listing Items
Click Resolve & Scan to analyse the active listings report.
SKU Alignment & Consolidation
▼
Aligns all eBay custom labels to ZTCG- format
and consolidates duplicate listings per variant. Generates a Revise CSV
(SKU + qty + price) and an End CSV for redundant duplicates.
—to revise
—to end
—already aligned
—unmatched
—skipped
Verify merges before downloading — uncheck any group that should NOT be consolidated.
Each group below maps multiple eBay listings to one ZTCG- SKU. Confirm the titles are truly the same card variant.
Price conflicts (>20% spread) show an editable Final Price field.
Card / SKU
Set
#
Qty
Lowest
Highest
Spread
Final Price
Matching…
Import Cards Review
Card
Set
#
Finish
Cond
Qty
✓
Select a card
Scan
No scan
Scryfall
No image
Printings
Select a card to search
App Settings
Paths, listing defaults, and eBay business policies.
Display Settings
Font size
Theme
Paths
AI Integration
Used for Claude Vision card identification (hybrid matching fallback). Get a key at console.anthropic.com.
Image Hosting (Google Cloud Storage)
When set, card images are uploaded to GCS and public URLs are embedded in the listing CSV. Leave blank to use local serving (localhost URLs, not suitable for eBay).
eBay Listing Defaults
Store Categories
Scryfall Card Database
Checking…
Fix Unmatched SKU Groups
Assign each unmatched SKU prefix to a lot. Matched entries will be saved to lots_map.json and existing sales will be re-mapped.
SKU Group
Sales
Assign to Lot
Add Lot
Lot ID *
Game *
Total Cost (CAD) *
Source
Purchase Date
Listed Date
GST (CAD)
QST (CAD)
Notes
Fix Card Identity
Search Scryfall to assign the correct printing.
Type a name to search…
Merge with existing record?
Add Card Manually
Import Cards
Import a ManaBox CSV export. Cards land as unlisted after condition review.
No file selected
Auto-detected from filename
Import a TCGAutomate eBay File Exchange CSV. Scryfall identity resolved from card name + collector number.
No file selected
Auto-detected from filename
Scan a folder of card photos. Uses Tesseract OCR + Claude Vision to identify cards.