Loading…
Dashboard
Year-to-date · 2026 · Leumas Live
2026 Net Profit / Loss
—
Loading...
Monthly Performance — 2026
Expenses
Sales
Earnings
Operations P&L (Monthly) — 2026
· cards you bought to hold are counted on the Master Dashboard, not here
| Month | Expenses | Investment | eBay Sales | Off-eBay | Total Sales | Earnings | Profit | Margin | Orders | Units |
|---|
Promoted Listings — 2026
| Month | Ad Spend | eBay Sales | Ad % of eBay | Ad Transactions |
|---|
Master Dashboard
Inventory + Investments · all channels
Business Net Worth
—
Listed inventory + investments + earnings − expenses
eBay Inventory
Top Lots by Earnings
| # | Type | Invested | Earnings | P/L |
|---|
Investments
Top Singles by P/L
| Card | Paid | Earned | P/L |
|---|
Expense Breakdown
| Category | 2025 | 2026 | Total | Share |
|---|
Market Value — Coming with eBay & TCGPlayer API
Card values from TCGplayer and eBay sold listings — what your cards are worth now, not what you listed them at. Updated daily.
TCGPlayer Planned
eBay Sold Listings Planned
PSA Pop Report Planned
Historical
Multi-year financials
Year over Year
All-time combined · one final number
Year Over Year Performance
Expenses
Sales
Earnings
Year-by-Year Breakdown
| Year | Card Expenses | Biz Expenses | Total Expenses | Sales | Earnings | P/L | Margin |
|---|---|---|---|---|---|---|---|
Month-by-Month
| Month | Expenses | Sales | Earnings | P/L | Margin |
|---|---|---|---|---|---|
All-Time Net Result
—
Total earnings minus all expenses across all years
Snapshot
Real-time business view · YTD 2026
Inventory Value by Price Band —
| Band | Listings | Total Quantity | Value | Avg / Card |
|---|
Where these come from: Avg daily deposit — what eBay actually paid you over the last 90 days, after fees and refunds, divided by 90. Operating P/L — what you kept from eBay this year, minus what you spent running the business. Cash P/L — the same, but also minus what you spent buying cards. The gap between those two is what you put into inventory this year. Activity YTD — every sale you've made this year, on every platform.
Inventory
Loading your cards...
Never synced
Listings
Pricing Tool
Manual Listing
Listings
| Img | SKU | Title | Lot | Qty | Price | TCGP MKT | MP MKT | Sold | Listed | Status | Actions |
|---|
Playable Sets
Top-25 competitive Pokémon decks — your stock vs market · decks and prices refresh automatically every day
Card Matching
TCG cards that need a catalog match
Cards waiting for a catalog match
| Title | Qty | Price | Match |
|---|
Existing Duplicates
Listings that are really the same card — merge them so your counts are right.
Existing duplicates
The same card listed more than once. Merging keeps one listing, adds the quantities together, and ends the extras on eBay — nothing runs without your confirmation. If two rows are actually different cards, use Deny to hide the group (or Card Matching if the card is matched wrong).
Reconcile from an import
Leumas is your master inventory, and your import is the truth. Upload your current inventory export (from whatever tool you use) and Leumas will show every card whose count disagrees, then — only for the cards you approve — set each one to your file's count. This heals an over-count and makes a re-import a no-op instead of adding again. Matched by card (not by SKU), so the changing SKUs don't matter. Preview-first; it revises live eBay listings, so nothing happens until you approve each card.
Reads your file locally; compares to Leumas. No change until you review & approve.
eBay Mismatches
Where eBay's counts don't match yours — review and fix them in bulk
eBay vs Leumas
Leumas is the source of truth. Syncs no longer overwrite your data — they just report what eBay shows. These
are the listings where eBay and Leumas disagree on quantity or price. Tick the ones to fix and
Push selected to eBay — Leumas's number is written to each live listing (ReviseItem), then the flag clears.
This fires real eBay writes and is confirm-gated; nothing changes until you push.
Lots
Your lot listings — set completion, set lots, and custom bulk lots
Dashboard
Set Lots
Set Lots
Track set completion across your TCGs — pick a game, series & set
Pick a series and set above to load the master-set completion grid.
This page only counts what you own — it never changes your listings.
This page only counts what you own — it never changes your listings.
Combine Scanner
Find existing eBay listings that look like the same card and could be combined
Scans active eBay listings and clusters them by extracted card # + matching set name.
Only listings with BOTH a detectable card number AND a detected set name are eligible.
Listings with grading prefixes (PSA, BGS, SGC, CGC) or "signed/auto" markers are skipped.
Each proposed cluster shows the listings — you pick which one is parent, check the box to include, then click Queue Selected.
Queueing pushes to the same approval queue used elsewhere — nothing combines on eBay until you click Push.
No scan run yet
Click "Scan Active Listings" to find combine candidates among your existing eBay inventory.
Orders
Every sale, on every platform — one page
All orders
TCGplayer orders
Orders
Every sale in one place — eBay and everywhere else
Never synced
Orders
| Rec# | Date (PST) | Title | SKU | Qty | Earnings | Shipping | Total | Buyer / Platform | Lot |
|---|
Combine Recovery
Reunite orphaned grandchildren · verify combine integrity
How this page works
Each row is an archived combine whose children were never absorbed into an active parent. For each row you can:
Absorb — splice this archived combine's children into a selected active combine (recommended when you find the right target).
Un-archive — restore as a standalone active combine (use if the eBay listing for this SKU still exists and just got incorrectly archived).
Dismiss — hide from view this session only (no DB write). Use for rows you've decided to leave alone.
Every absorb / un-archive is logged to combine_recovery_audit; click Undo Last to reverse the most recent action.
—
Reset
Not loaded yet
Click Refresh to load archived combines and compute candidate matches.
Combine & Fix Duplicates
Merge duplicate listings of the same card into one. Leumas keeps track of which box each copy lives in.
Combine Flow
New Uploads – Exact Matches — same-title duplicates, safe to approve. Similar — near-matches to review. Approve the ones you want, then Push to eBay — the kept listing's quantity goes up and the extras end.
Already listed the same card more than once? Open the Existing Duplicates tab — it finds every duplicate across your live listings so you can merge each into one.
Existing (0)
New Uploads – Exact Matches (0)
Similar — Review (0)
Existing Duplicates
New Imports (0)
Queue (0)
Manual Combine
Denied (0)
Lot Backfill (0)
Combined Groups — 0 parent SKUs
Exact title matches — 0 waiting
| Parent SKU + Title | Child SKU + Title | New Qty | Lot | Action |
|---|
Similar Titles — Manual Review — 0 pending · —
| Existing Parent | New Listing | Match Score | Lot | Action |
|---|
Approval Queue — 0 waiting to push
Approved combines waiting for the next Push to eBay. If one gets stuck, remove it here
or point it at a different parent — the rest of the queue is untouched.
| Parent SKU | Child SKU | Title | Action |
|---|
New Imports — Unmatched Cards — 0 pending
| SKU | Title | Price | Qty | Lot | Status | Action |
|---|
Pick a lot to tag listings as they're created
Manual Combine — pick one listing to keep, then add the ones to merge into it
KEEP THIS LISTING (the parent)
MERGE THESE INTO IT (tick as many as you need)
Pick the listing to keep, then tick the ones to merge into it
Denied Combines — these will never be re-suggested
| Card A | Card B | Action |
|---|
Assign cards to lots — …
Match the photo, pick a lot, Assign. Skip just hides a card from this list (nothing is written — bring them back with Review skipped). Every assign is logged in the Audit Trail below and revertible.
Lot Backfill — what this does
Fills in missing lot assignments everywhere at once — on combines, inventory rows, and past orders — so the Lots tab attributes profit to the right physical box going forward.
Safety: it only ever fills blanks, never overwrites an existing lot. Every write is logged under one batch and any batch reverts with one click (Audit Trail below).
SKU convention: new lots use SKUs starting with "Box ". Anything else is legacy and can be assigned to the old lot with the one-click below.
Quick Actions
Phase A — Auto-pass
For every unmapped combine child, fill from existing data: (a)
orders.assigned_child_sku → orders.lot_id pair, then (b) live ST.inv.lot_id where the child sku still exists in inventory. Free wins, no patterns required.
Click "Preview" to scan…
Non-Box → Lot 'old'
Pattern
^(?!Box ).+ → lot old. Sweeps every SKU not prefixed with "Box " (B1-/B2- shorthand, COMBINED-, SV/SWSH set SKUs, CDP-, etc.) into the legacy bucket. Single batch, fully revertable.
Click "Preview" to scan…
SKU Rule Engine — 0 rules
Type a regex pattern + pick a lot. Live match preview before commit. Each Apply runs across all three tables under one batch_id. Stored rules persist between sessions — re-running an already-applied rule is a no-op for rows already tagged.
Match preview will appear here
| Pattern | Lot | Last Applied | Writes | Action |
|---|
SKU Bucket Browser — 0 buckets unmapped
Buckets are auto-extracted from currently-unmapped SKUs across combines + inventory + orders. Click a bucket's Apply button to create a rule for that prefix and run it immediately. Buckets only show "Box "-prefixed SKUs — use the Non-Box one-click above for legacy formats.
| Bucket | Inv | Children | Orders | Total | Assign to lot | Action |
|---|
Audit Log — 0 batches
Showing most recent ~1000 rows of audit history (PostgREST cap). Each row = one Apply click. Revert undoes exactly that batch's writes (clears the lot_id back to null wherever this batch had filled it). Manual edits made after a batch are preserved — revert only touches values this batch wrote.
| When | Source / Pattern | Lot | Writes | Status | Action |
|---|
Refunds
Orders refunded or cancelled after the sale was recorded, on every platform you sell on
Pick List
Orders to pull and ship — check each card off as you box it
Pending Orders
| Order | Item | Pull SKU | Buyer | Date (PST) | Price |
|---|
Card Lots
A lot is one batch of cards you bought — track what you paid and what it has earned back
Your Lots
Monthly Report
Profit month by month · cards bought to hold are counted on the Master Dashboard
All Months Summary — Operations P&L
| Month | Expenses | Investment | Sales | Earnings | Profit | MoM | Margin | Orders | Units | Listed $ | Sell-Thru | Multi-Card% |
|---|
Expense Ledger
Business expenses · all channels
Expenses
| Item | Category | Type | Date | Cost | Docs | Repeat |
|---|
Filtered Total:
$0.00
Investments
Singles & Sealed · by year
Combined — Singles + Sealed
Singles
Sealed Product
Investment P/L by Year
| Year | Type | Invested | Sales | Earnings | Unsold Value | P/L | ROI |
|---|
Singles
Individual card investments
Singles
| Card | Purchased | Paid | Copies | MKT | Value Now | If-Sold Gain | Sold Date | Sales | Earnings | P/L | Status | Actions |
|---|
Sealed Product
Sealed product investments
Sealed Items
| Item | Copies | Invested | MKT | Value Now | If-Sold Gain | Sold | Sales | Earnings | P/L | Status | Actions |
|---|
CARD SEARCH
Search by card name, set, SKU — inventory + orders + combine groups
Start typing to search
Results across inventory, orders, and combine groups
Widget Lab
Build your own pages from widgets — Orders, Pick List, KPIs, Inventory on one grid. Saved pages appear under "My Pages".
Hopper
Upload card images — we match them automatically
1 Configure
2 Upload
3 Review
Setup
Saved title / description / images / policies — edit via Configurations
Catalog we match your scans against
Sorting a tray by set? Say which, and the matcher can only answer from it.
Scanning a reverse holo or 1st edition tray? Say which printing and every card that has one binds to it.
Sifting — send cheap cards to bulk lots instead of inventory
Scanning a bulk box? Cards worth less than your cut-off never reach your inventory — Leumas puts them straight into a bulk lot you are building, tells you which box to drop each one in, and starts a new box when one fills up. You still own them and they are still counted; they are just not listed anywhere.
Anything worth less than this goes to a bulk lot. Anything worth this or more goes to your inventory as normal.
The kind of lot you are building. Leumas fills the current box, then opens the next one.
If we cannot price a card, keeping it is the safe answer — you can always sift it later, but pulling one back out of a 300-card box is a job.
Recorded on every bulk card so the cost of the box you bought still follows the cards into the lot.
Make a new kind of bulk lot
“No duplicates” means each lot gets at most one of any card — so eight copies of one common land in eight different boxes. That is what makes a lot worth listing.
Listing defaults
Default for every card (editable per card later)
Default starting price
Auto-increments if it ends in a number
Scheduling (optional — stagger listings)
All listings go live immediately.
Listing Templates
Naming format, description, images, platform policies & categories — used when you scan cards in AND when you retitle existing listings. A Hopper batch you already started keeps the title format it began with.
Configuration profile
Title generator
Variables — click to add to the title; AA forces that variable uppercase
Structure — drag to reorder (or use ); × to remove
Preview
Description & images
Platform & business policies
Store categories — blanks use your default policies automatically; assign a policy only where a category should differ
Map a store category to its payment / shipping / return policies. When a card is filed under a category, those policies apply automatically.
Filing rules — put a card into a store category automatically when it matches your conditions
Example: Set starts with “SV” → file it under Scarlet & Violet Series. Rules are checked top to bottom and the first one that matches wins; a card that matches no rule keeps the category from your configuration. Applied when the Hopper identifies a card — you can still change the category on any card before you send it. A rule can also read the card’s catalogue details — card name, card number, language, year, and per game the player, team, colours, HP, ink and more (the “From the catalogue” group in the field list); with Filing rules outside the Hopper on, a card listed from Inventory or an import that has no store category of its own is filed by the same rules.
Cropping — zoom regions shown on every card during review
Pick a card game and draw the regions you want to inspect on every card of it — edges, centering, the collector number, the holo pattern. Each region becomes a zoom tile on the review screen, beside your scan. Each game keeps its own set. Display only — cropping never changes matching, pricing, or your listing photos.
Hopper KPIs
Who worked which batches, and how much
Per person
Loading…
Scan Batches
Drop big batches, work the matching & pricing as you have time
Your batches
Not-found report — every card the matcher couldn't identify, with the likely cause
Loading…
Scanners — scan straight into Leumas Live, no exporting or uploading
Loading…
Match Accuracy
Auto-match accuracy & manual corrections by TCG — all tenants (admin)
Accuracy by TCG
Loading…
Inconsistency reports (beta)
Loading…
Team Access
Let someone work in your account — you choose exactly what they can see or change
eBay Tools
Promoted Listings ads and markdown sales — you review every change before it goes live.
eBay Ads
Discounts & Offers
Business Policies
Customize
Make it yours — brand, colors, text size. Live preview; nothing changes for anyone else.
Account and billing
Your plan, starting over from zero, and closing your account.
Start over
Clears what Leumas Live holds for you so you can start fresh: the cards that are not listed anywhere, extra copies above what your marketplaces list, and your combines. Cards that are live on a marketplace stay, with their links, so every sync keeps working with nothing to import. Nothing changes on any marketplace: your listings on eBay, TCGplayer, ManaPool, CardTrader and your web store stay exactly as they are. Your account, orders, finances, settings and connections stay too. You will see exactly what goes, and type your email, before anything is deleted.
Delete my account
Permanently removes your Leumas Live account: inventory, orders, combines, scans, settings and the marketplace sign-ins stored here. Your live listings on eBay, ManaPool, CardTrader and TCGplayer stay live on those marketplaces and Leumas stops managing them. You will see exactly what goes, and type your email, before anything is deleted.
Sidebar & toolbar
Choose which features show in your sidebar and their tabs — add any feature to any section, reorder, or hide what you don't use.
Brand
Your name + logo replace the in-app wordmark. (The browser-tab name stays "Leumas Live".)
Colors & Text
Brand-accent, sidebar, and background. (Profit/loss reds & greens stay fixed so P&L always reads right.)
Changes preview live as you edit. Save makes them stick across devices.
Feature Store
Turn optional features on or off for your account.
eBay listing defaults
Cards brought in from TCGplayer or ManaPool don't come with an eBay description or photos. Set a default here and they list without you touching each one — any card that already has its own description or photos keeps them.
These fill in per card: {title} {set_name} {number} {rarity} {condition} {game}
Good for a store banner or a grading-scale card. They're added after the card's own photo. Cards with no photo of their own list with their catalog picture automatically.
Applies to eBay listings made from the app and to bulk-list files.
Manual Listing
Add an item to inventory — eBay-ready (photos, policies, description). Added to inventory, not auto-listed.
Add Item to Inventory
Sealed product, sleeves, accessories, or any item not from CardUploader.
Click to add a photo
eBay listing details
Only needed if you will list this on eBay. Policies are pre-filled from your saved eBay profile — change them here to override for this item only. Nothing is sent to eBay now; the card is added to inventory and you list it when you are ready.
Card game singles are 183454, card sleeves 183461, sports card singles 261328 — or enter any eBay category number.
Recently Added (Manual)
No manual entries yet
Import Data
Bring your cards and sales in from spreadsheet files — eBay, CardUploader, TCGplayer, and more
Optional. Every card in this import drops into the chosen lot, so combines built right away inherit it. A saved SKU→lot rule still wins.
Import options
Imported cards land unlisted; list them from Inventory when you're ready.
CardUploader Export
Export from carduploader.com. Cards added to inventory. Assign lot after import. Multiple files supported — drop or pick several at once.
Raw Cards
Click or drop raw CSV(s)
Graded Slabs
Click or drop slab CSV(s)
Captures grader, grade & cert #. Excluded from combines.
Reads:
*Title CustomLabel *StartPrice *Quantity · slabs also read grade + Certification NumberCard Dealer Pro Export
Export from carddealerpro.com (eBay Bulk Upload format). Cards added to inventory. Multiple files supported — same parser as CardUploader with the CDP metadata prefix stripped.
Click or drop CSV(s)
Reads:
*Title CustomLabel *StartPrice *Quantity · skips Info,Version=... lineTCG Automate Export
Export from TCG Automate (eBay Bulk Upload format). Cards added to inventory. Multiple files supported — same parser as CardUploader.
Click or drop CSV(s)
Reads:
*Title CustomLabel *StartPrice *QuantityTCGplayer Inventory → eBay
Upload your TCGplayer MyPricing export to cross-list your TCGplayer stock to eBay. Cards bind automatically (no matcher), pull a product image, and price with your eBay markup. Staged in New Imports — review before listing. One file.
Click or drop your MyPricing CSV
Reads:
TCGplayer Id Product Line Total Quantity TCG Market PriceTCGplayer Scan & Identify
Just scanned a pile with TCGplayer's Scan & Identify? Upload its CSV to bring those cards into Leumas. Each row binds to its card automatically from the file's own TCGplayer Id (no matcher), pulls a product image and prices with your markup. Staged in New Imports — review before listing. This never changes what you have listed on TCGplayer, and the count comes from Add to Quantity. One file.
Click or drop your Scan & Identify CSV
Reads:
Product ID TCGplayer Id Product Line Printing Add to Quantity TCG Market PriceCardbot - TCGplayer (Kiosk)
Scanned a stack with your CardBot? Upload its export for TCGplayer CSV to bring those cards into Leumas. Each row binds to its card automatically from the file's own TCGplayer Id (no matcher), pulls a product image and prices with your markup. Staged in New Imports — review before listing. This never changes what you have listed on TCGplayer, and the count comes from Add to Quantity. One file.
Click or drop your CardBot CSV
Reads:
TCGplayer Id Product Line Condition Add to Quantity TCG Market PriceMigrate Inventory (CardUploader)
Switching from CardUploader (or a similar platform)? Upload your full inventory export. Each Catalog SKU is matched to its eBay listing as the combine parent; User SKUs become child SKUs (not on eBay) and appear in the Existing tab. Quantities, prices & TCGplayer bindings from this file become the source of truth. One file.
Click or drop your inventory CSV
Reads:
Catalog SKU User SKU Title TCGplayer SKU Price Qty · no eBay listings revised/endedCardCatalyst Export
Switching from CardCatalyst? Upload the itemized in-stock export. Each row is one physical copy — quantities come from counting the rows, so nothing is guessed. Cards bind to the catalog from the file's own TCGPlayer ID, titles and prices fill in automatically, and Bin + Position become the card's box SKU. Staged in New Imports as unlisted on-hand stock — review before listing. One file.
Click or drop your CardCatalyst CSV
Reads:
Bin Position Card Name Condition Printing TCGPlayer ID · quantity = count of itemized rows · no listings touchedSortSwift Inventory
Moving over from SortSwift? Upload your inventory export. Every card binds straight to the catalog from the file's own SKU Id — the exact per-condition TCGplayer SKU — so nothing is matched on the card's name and nothing is guessed. Your Remarks bin labels become each card's box SKU, and each box becomes a lot carrying its cost. Staged in New Imports as unlisted on-hand stock — review before listing. One file.
Your sales do not come from this file. Import those with the Leumas TCGplayer extension instead — it pulls TCGplayer's real fees and net per order, which this export does not contain.
Click or drop your SortSwift inventory CSV
Reads:
SKU Id Name Quantity Your Price Remarks Cost · binds on SKU Id, never on the title · no listings touchedTCGTracking Export
Switching from TCGTracking? Upload either inventory export — the per-location file or the aggregate one; the importer tells them apart automatically. Cards you already track here are recognised, not duplicated — if your eBay (or any platform) is already connected, those cards keep their existing quantity and simply gain their box location, so nothing doubles. Anything genuinely new is staged as unlisted on-hand stock. Your location labels (A-1-A…) become each card's box SKU, so every slot stays findable on the pick list. Reserved copies (pending TCGTracking orders) are skipped and counted. One file, either version.
Click or drop your TCGTracking CSV
Reads:
Product Name Condition Finish Location(s) TCGPlayer SKU ID Quantity Reserved My Price · no listings touchedRestore SKU mapping
Does your pull sheet show codes like CS-XXXXXX instead of your own SKUs? Upload the same CardUploader inventory export here. This restores only which of your SKUs each card belongs to, so pull sheets name the right box. It does not change quantities, prices, listings or anything on eBay, and it will not add cards back into your inventory. Safe to run more than once.
Click or drop your inventory CSV
Reads:
Catalog SKU / Cat SKU (or Custom Label) + User SKU · either column order works, with or without a header row · columns are detected and shown before anything is saved · no inventory, listing or eBay changesHistorical Sales (any platform)
Import past sales from eBay, TCGplayer, Cash, Discord, Mercari, or anywhere else. Download CSV template
Click or drop Sales CSV
Cols:
Date Platform Item Name Quantity Sold Price Fees Net Buyer SKU Lot Cost Basis Marketplace Order ID Item ID Item URLHistorical Expenses
Import past expenses (supplies, shipping costs, fees, subscriptions, etc.). Download CSV template
Click or drop Expenses CSV
Cols:
Date Type Amount Description NotesTCGplayer Order History
Import past TCGplayer orders for your records. On TCGplayer go to Orders → Export Shipping and drop that CSV here. This records order history only — it does not change inventory. Re-importing is safe (deduped by order #).
TCGplayer's export carries the order's date, buyer and value — it does not contain the individual cards, which TCGplayer only puts on the packing slips.
Importing here first is safe: if you later upload that order's packing-slip PDF on the TCG Orders page, it takes the order over — matches the cards, adjusts your stock and updates the eBay listing.
Click or drop your TCGplayer Orders CSV
Reads:
Order # Order Date FirstName LastName Value Of Products Shipping Fee Paid Item Count — and Product Set Condition Quantity Price if your file has them
Recent Imports (last 10)
| Time | Type | Rows | Status | Files |
|---|---|---|---|---|
| Loading... | ||||
Import Log
| Time | Type | Records | Status | Notes |
|---|---|---|---|---|
| No imports yet | ||||
API Status
Connected services · sync status
eBay Developer API
Listings sync, order fulfillment, finances, combine push · per-tenant OAuth
Connected
eBay Sync Controls
Last sync: Never — click Test Connection first
TCGPlayer API
Real-time card market prices for Singles & Sealed investments
Supabase Database
leumas-live · cxyjpfdpmvcfjpqbaigp · East US
Connected
Domain — inventory.leumascc.com
DNS setup pending · will point here after Netlify deploy
Domain — leumascardcraze.com
Brand domain · parked for future storefront
When eBay API connects — what happens automatically:
→Your eBay listings sync to database
→New orders appear in real time
→Pick list activates for every order
→eBay fees tracked exactly via Finances API
→Combine push: parent qty updated on eBay
→April 30–today orders backfilled automatically
→Parent hits zero → unpulled children flagged
→Weekly eBay store fee auto-import to ledger
Diagnostics
Read-only audits across inventory and combines data. Run any anytime.
Note: All buttons here are READ-ONLY. They scan local state and report findings — no database writes, no eBay calls. Cleanup scripts (which DO write) remain console-paste-only by design.
Fire every read-only card in sequence (~30s end-to-end). Each card's verdict renders inline; scroll to review.
Admin-only operational audits below. New users won't see this block.
Self-Loop Audit
Scans combines for any parent_sku that appears in its own child_skus, and pending approvals for parentSku===childSku. Verifies the v2.9.88 chokepoint is holding the line. Expected: 0 findings.
Year-Boundary Patterns Audit
Hard deadline: Dec 31, 2026. Scans local state for any field/value that still references "2026" — `totals2026`, `months2026`, `ord2026`, etc. Documents the pattern surface for the eventual refactor session. Past Dec 31 these become silent misclassification bugs.
Combine Integrity Audit
Scans combines table for structural anomalies: duplicate parent_skus (two combine rows pointing to the same parent), empty child_skus arrays (combine with no children), non-string elements in child_skus, and parent_skus with no matching inv row (orphan parents). Expected: 0 across all four categories.
Combine Qty Integrity
For every active combine where all kids have an inv row (no phantoms), compares parent
inventory.quantity against the sum of child quantities. Flags mismatches. Phantom-containing combines are skipped — you can't honestly sum kids that no longer exist locally. Same sweep also available on Combine Recovery page; mirrored here for general diagnostics use.eBay Webhook Subscription
Registers your eBay account to push real-time notifications to the
ebay-webhook Edge Function — sales, listing created/revised/closed, auction checkout. Without this, the app only learns of new sales via the periodic syncOrders poll; with it, sales appear within seconds via Supabase Realtime. One-time setup; idempotent if you click again. Per ef-security-audit notes: never been called → 0 events received in DB ever.
TCG Diagnostics
Sync · Catalog · Reconciliation · Projection
TCG Sync Health
Queries
tcg_eligible_inventory for drift between local and TCGplayer. Shows decrement candidates (sold on eBay since last push), increment candidates (restocked / new combine pulls), ghost listings (cards on TCG you don't have anymore), and total cards diverged. If decrements or ghosts are non-zero, the next CSV export will reconcile them.TCG Projection Refresh
Reloads
tcg_orders + tcg_order_lines and re-projects them into ST.ord as synthetic off-eBay rows so dashboards reflect any commits since boot AND any lot_id changes on the matched inventory. Idempotent — safe to click repeatedly. Cancelled/refunded/voided parents are excluded from the projection.TCG Catalog Freshness
Queries
tcg_catalog for the newest updated_at across all rows, plus per-game freshness, plus running count of tcg_order_lines with match_status='no_match'. Color bands: ≤7d green / 8-30d yellow / >30d red. New TCG sets release roughly monthly — refresh the catalog if it's been a while, especially before high-volume sales.TCG Reconciliation
Shows the count of inventory rows where
tcg_listed_qty > 0 (what local thinks is live on TCG), sum of cards listed, pending drift to reconcile on next CSV push, and last successful export from tcg_sync_log. Mentally diff the "Cards on TCG" number against your TCG seller dashboard's count — if they disagree materially, you have ghost listings TCG didn't reconcile.Lot Attribution Coverage
Snapshot of Lot Backfill progress — how many
combines.child_lot_map entries are populated, how many inventory rows have a lot_id, how many orders are attributed. Click Check to compute against current in-memory ST. Mirrors the KPI strip on the Lot Backfill tab; surfaced here so you can monitor progress without leaving Diagnostics.Webhook Events Delivered
Queries the
webhook_events table to confirm the subscription above is actually pushing. Shows total events ever, last 24h count, last event timestamp, and per-event-type breakdown. If you just registered, give eBay a few minutes — they don't backfill, only push events that fire AFTER subscription is active.
Data Health
SKU drift · combine recording · audit batches
Dup-SKU Drift Monitor
Counts SKUs shared by 2+ active inventory rows. Post the 2026-05-25 cleanup (930 rows renamed under batch
8d9c4cbf-…) this should sit at 0. Any drift indicates future imports / manual edits re-introducing duplicates. Re-run after CSV imports to confirm cleanliness.Combine Recording Health
For every active combine whose parent has a live inv row, compares
child_skus.length against parent quantity. Surfaces the 4,047-style backlog from the v2.16.33 audit (68% under-recorded). Companion to Combine Qty Integrity: that one checks sum-of-child-quantities; this one checks count-of-recorded-locations.Malformed Combine Children
Counts
child_skus elements with structural problems: trailing dash (the "Box 11 - M1 -" class from v2.16.31), leading/trailing whitespace, empty strings, non-string types, double-dash. Each becomes a manual fix candidate. Per v2.16.31's note, the app renders these as-is — auto-cleanup is a separate workflow.Historical-Overlap SKU Tracker
Counts the SKU collision categories intentionally skipped in the 2026-05-25 dup-SKU cleanup: 1 active + N historical (functionally fine — single live SKU) and all-historical (audit noise only). Plus surfaces any new active-vs-active collisions that might appear later. Lets you decide later if/when to clean up historical overlap.
Recent Audit Batches
Merges the most recent batches across three audit tables:
lot_backfill_audit, tcg_collision_cleanup_audit, dup_sku_rename_audit. Shows table, batch_id (first 8 chars), row count, reverted count, source/reason. Surfaces dup_sku_rename_audit which has no other UI today.ST Length Sanity
For every boot-loaded ST array (
ST.lots, ST.ord, ST.inv, ST.ebayTx, etc.), compares in-memory length against DB COUNT(*). Smoking gun = ST length stuck at 1000 while DB has more (PostgREST default cap signature). Caught the v2.16.52 silent truncation bugs; will catch the next one too. ST.ord + ST.inv legitimately exceed DB count (synthetics + carduploader staging).Multi-Listed Cards Scanner
Scans inventory for
(tcgplayer_id, condition) groups with 2+ active rows. This was the trigger for the 2026-05-25 Umbreon over-sell — pre-v2.16.14 the CSV dedupe summed wrong on these and inflated TCG state. v2.16.14 fixed the math, but multi-listing remains operationally fragile (hard to allocate when TCG sells one). Run before any TCG CSV push; consolidate flagged groups via the Combine Listings page first.TCG State Readback (drift detector)
Compares TCG's actual listed inventory against our local
tcg_listed_qty model. Upload a fresh TCGplayer MyPricing CSV export (Pricing → Generate Pricing Custom Export → download). We parse the Total Quantity column, aggregate by (tcgplayer_id, condition), and surface every drift bucket. This is the only path to detect TCG state corruption. Run after every kill-switch + push cycle to confirm TCG agrees with us.
Force-Drain CSV: uses TCG's exported Total Quantity per row to compute negative deltas. Drains TCG to 0 even when our local
tcg_listed_qty under-counted (e.g., post-kill-switch stragglers from pre-v2.16.14 dedupe drift). Generate, upload to TCG, then re-run Drift Check to verify.
Affiliate
Your link, the people who signed up through it, and what you have earned.
Admin
Cross-tenant operational view · admins only
TCG Catalog
TCGplayer reference data · upload monthly Pricing Custom Export CSVs
Upload one CSV per game (TCGplayer · My Account · Pricing · Generate Pricing Custom Export). Re-uploading replaces existing rows on conflict — safe to refresh anytime.
Matching is now automatic — new inventory binds to the catalog on its own; anything ambiguous waits for a one-click review under Card Matching.
Match to Catalog
Matching now runs automatically — no button to press
Inventory now binds to the TCG catalog automatically. The moment cards land in your inventory (after listing/approval or manual entry) the safe matcher runs on your rows, and a nightly job re-checks everything as catalog data and prices change. Safe, unambiguous matches bind silently; the rare ambiguous card is held for a one-click Confirm / Reject under Card Matching. Nothing here needs your attention unless you want it.
Sync to TCGplayer
Send your prices and quantities to TCGplayer — you preview every change first
How this works
Sends every card that's new or has changed to TCGplayer, in the file format TCGplayer expects. Prices — and which cards qualify — come from your Pricing Tool rules. After a push, the next one only sends what changed since.
Recent TCGplayer activity
Everything Leumas sent to TCGplayer or read from it — automatic and manual pushes, store readbacks, order pulls, shipped close-outs, and the checks that were held.
TCG Orders
Bring in your TCGplayer orders and take the sold cards out of your inventory
Preview, then commit. Upload your Shipping CSV and Packing Slips PDF, then run the preview to see how each line matched. Nothing changes until you commit, and only orders marked ok do. A Commit ALL (incl. held) button appears when some are held — it records the held orders as history and leaves their stock alone. Safe to run again: anything already committed is skipped.
Importing past, already-shipped orders? Use Import data → "TCGplayer Order History" instead — it records order history directly, no packing slip and no live inventory needed.
1. Shipping CSV
No file selected
2. Packing Slips PDF
No file selected
TCGplayer Direct sales
TCGplayer Direct is the TCGplayer program where TCGplayer sells your cards to the buyer and you mail the cards to TCGplayer instead of to the buyer. When the Leumas TCG Sync extension is paired on a PC with Chrome running and a TCGplayer seller tab open, each Direct sale comes off your stock automatically within about 5 minutes, and your other marketplaces are lowered the same way as for any other sale. Every one is listed below with a button to put it back.
Once a week TCGplayer gives you a Reimbursement Invoice: a CSV file under Direct in your TCGplayer seller portal. Upload it here. It confirms the sales Leumas already took off (they are never taken twice) and takes off any it missed, for example while that PC was off. You see every card first, nothing changes until you press Take off stock, and the same invoice is never counted twice. Not in TCGplayer Direct? You can ignore this.
Shipping
Every order ready to pack — print labels, buy postage, mark them shipped
SHIPPING WORKFLOW. After committing TCG orders on the TCG Orders page, they land here as
pending. Click 4×6 Label per row to print a pick/pack slip (works on thermal printers — Rollo/Munbyn/DYMO 4XL). Pull the cards using the SKU + LOT chips on the label. Attach the TCG-supplied shipping label and ship. Click Mark Shipped to drop the row from the queue. Filter switches between Pending (default), Shipped (history), and All.
Card Shows
Take cards to a show, sell on the floor, and square everything up when you're back.
What's New
Roadmap, recent updates, and your feedback.
Roadmap
Recent Adds / Fixes
Suggestions & Issues
Aging Inventory
Active eBay listings by time on market — refresh the stale ones with End & Relist
AUTO END & RELIST
Every night, Leumas ends and relists your OLDEST active eBay listings (past your age threshold), optionally
dropping the price — a fresh listing without lifting a finger. Price-adjusted cards are locked from the
auto-pricer (🔒) so the discount sticks; cards already 🔒 locked relist at their current price.
⚠ Before you turn this on: eBay can see repeated end-and-relist churn — heavy use may flag your account
or affect search placement. Each relist starts a NEW listing, so its watchers, views, and sale history are
lost — and it counts against your monthly free-listing (zero insertion fee) allowance; past that, eBay
charges an insertion fee per relist (check your allowance in Seller Hub). This is optional and entirely
your call — it runs only while you leave it on.
"Cards with watchers" uses your last-synced watcher counts — run 👁 Sync watchers on the Aging page to refresh them; a card whose count was never synced is treated as having no watchers.
Recent activity (last 3 nights)
Inventory Audit
Cycle counting — walk your physical inventory on a schedule so every card gets checked at least once per cycle
Audit setup
Confirmed / Mismatch only records what you saw — it never changes your inventory count and never touches eBay or TCGplayer. A mismatch is filed below for you to resolve through Inventory or Combine Listings when you're ready.
Record a mismatch
This records the variance only — it does not change your inventory count or touch eBay/TCGplayer. Resolve it through Inventory / Combine Listings when you're ready.
Charts
The same numbers as your other reports, drawn as charts
Monthly Sales · Earnings · Expenses
Cumulative P/L Trend
Cards Out / Sales
Cards out the door per platform + daily sales & earnings · since Jun 1, 2026 (owner only)
10-Day Experiment
Cards listed and sold during the listing experiment, by game and market value (owner only)
Money
Everything you sold and everything you kept — one page
Profit
Master
Snapshot
Monthly
Year over year
Historical
Profit
What you kept, by platform, after fees and card costs
Profit by channel
| Channel | Revenue | Fees + Shipping | COGS | True Net | Cost basis |
|---|---|---|---|---|---|
Selling Stats
What sold between any two dates, on every platform
Revenue
Tax Summary
Your year, laid out the way Schedule C asks for it
Not tax advice. This puts your sales, card and lot purchases, and logged expenses on the closest Schedule C lines — for a sole proprietor or single-member LLC. It can't see write-offs you haven't tracked here, like vehicle, home office or depreciation, personal-use splits, or inventory timing. Check with your tax pro before you file.
Income & Cost of Goods Sold
| Schedule C line | Amount |
|---|
Part II — Expenses
| Schedule C line | Fed by | Amount |
|---|---|---|
Line 31 — Net profit (or loss)
Line 1 gross receipts − Line 4 COGS − Line 28 total expenses
Break-Even
How much you need to sell to cover your costs
Your numbers
Community Comps
Real sold prices across the Leumas community, every platform — last 30 days plus all-time. Anonymized, minimum 3 sellers per card. Updated once a day.
Bulk Exchange
Move bulk lots member-to-member. Transact out-of-band via PayPal Goods & Services — Leumas is not a party to the sale.
Storage map
Your areas, shelves, boxes, rows and stacks as a picture you can click into, with the cards that live in each one
Buylist
What you pay for cards, published as a page or a widget your own website shows — and the other buyers' prices you keep beside yours
Store categories
Your eBay store categories, WooCommerce categories and Shopify collections, and one set of rules that files each card on every platform — by game, set, rarity, printing, price, words in the title, or the card's catalogue details. Each platform stands alone unless you sync it with eBay
Messages
Messages from Sam about your account, and your replies.
Seller messages
Drafts waiting for you, replies from sellers, and the templates
Help & Guides
Ask Leumas beta
Explains the app and can look up your own cards and orders. It never changes anything.
Answers can be wrong — check the "?" guide for the screen. Questions and answers are saved; the Leumas Live owner can read them to improve the guides.
ADD LOT
ASSIGN SKUs TO LOT
ASSIGN ORDER TO LOT
Links sale revenue to selected lot for P/L tracking.
PUT THIS BOX IN A LOT
A lot is the purchase these cards came from — it is what the Lots page uses to work out profit. This changes the cards in this box, not the sale.
RECORD SALE
Manual sale record. In Leumas Live with eBay API, this will push a real-time quantity update to eBay.
SUGGESTION
REPORT AN ISSUE
ADD ROADMAP ITEM
ADD UPDATE
NEW POLL
Launching a new poll closes the current one (its votes are kept).
COST BREAKDOWN —
Each purchase entry behind the combined Paid figure.
Customize your inventory table
Untick a column to hide it, use the arrows to put them in your order. The same goes for the filter controls below. Columns tied to a marketplace only appear once that marketplace is connected.
NEW CARD SHOW
RECORD SALE
TRADE
Cards received (you can add several)
| Card name | Card # | Value ($) |
|---|
Gives away 1 unit of the card above (its eBay listing is decremented or ended). Each received card becomes a sellable line. Cash received books as card-show income; cash paid books as a New Purchase cost.
PULL IN INVESTMENTS
Liquidating? Pull held investments onto the floor. Selling one books to the investment tab (decrements qty-on-hand) — it does NOT touch the card-show P/L; the "Investment Sold" tile is a visual aid only.
NEW PURCHASE
Does not touch eBay. Counts as a New Purchase (lowers show P/L + books to your Expense Ledger → monthly/yearly P&L). If it sells, it books to Orders. Export "New Cards" after the show to scan in.
Are these new copies?
0 card(s) in this file (0 copies) are already in your inventory. Leumas cannot tell whether you just scanned more copies of cards you already own, or whether this is the same stock counted again — so it is asking you rather than guessing.
If this file is only telling Leumas where cards you already have are sitting (a bin or box list), choose Same cards — just update where they are: their location changes and their quantity stays as it is. 0 of these cards have the same count in the file as in Leumas.
| Card | You have | In file | Would be |
|---|
The other choices list or change nothing on eBay, TCGplayer or any other marketplace by themselves — they only adjust what Leumas holds. "The file's count is my total" asks first and names every listing it will change. "Same cards" saves where they sit and changes no quantity; "Add" puts the copies on the card you already have (its box); "Keep as a separate box" gives them their own row under the box in this file. "Decide later" keeps these cards; your next import will ask about them again.
BULK PURCHASE
Rate is per-card (decimal). Total = Count × Rate. Tier abbreviations (C / UC / RH / H / IR…) come later.
| Name | Count | Rate | Total |
|---|
Grand Total: $0.00
SHOW EXPENSE
Books to your Expense Ledger (tagged to this show) → flows into monthly/yearly P&L.
CONSIGNMENT
RECORD SALE
BIND TO CATALOG
Click a result to bind it to every copy of this item and set its market value.
ADD PRODUCT
Click a result to match it (sets market value + product id). Then enter what you paid and how many copies you're holding.
MATCH TO CATALOG
Pick the exact card + set + condition — binds this listing's identity.
NEW BATCH
A batch freezes your next orders into numbered slots — slot 1 is tray slot 1, and the numbers
never change while you pack. New orders wait for the next batch.
Takes your oldest unshipped orders first, skipping anything already in an open batch.
If fewer are waiting than you asked for, the batch is created with what's there and says so.
REMATCH INVENTORY
ADD EXPENSE
DOCUMENTS
Drop files here, or paste a screenshot with Ctrl‑V
Photos, PDFs, emails (.eml / .msg), spreadsheets — up to 25 MB each
CATEGORIES & TYPES
Drag a type into a bucket, or pick one from the dropdown on the chip. Any type can sit in any bucket, and moving it re-files every expense that uses it — nothing is rewritten in your ledger. Removing a bucket keeps its types; they return to Uncategorized.
RETARGET PARENT
AUTO-MATCH PARENTS
QUEUE HEALTH AUDIT
EDIT LISTING
0 / 80
$
First photo is the gallery image. Removing a photo only applies when you Save — nothing is removed without you.
Loading store categories from eBay...
More: shipping · package · quantity · Best Offer · item specifics
Open a listing to load its specifics…
Editing specifics replaces the listing's ENTIRE specifics set — all rows below are sent.
Photos — add / remove
BULK FIELDS
Every filled field below is applied to ALL listings. Blank = leave that field unchanged.
BULK EDIT TITLES
$ BULK EDIT PRICES
Quick actions (applies to all visible rows, doesn't save until you click Save):
Set all to $
·
Multiply all by
·
Decrease all by
%
·
LIST SELECTED CARDS
EDIT PRICING
Help improve card matching?
Leumas Live can get better at identifying cards — including sports and games with no catalog — by learning from
confirmed matches. If you opt in, we may use your card photos, titles, and the matches you confirm (never your
prices, costs, sales, or any personal or account information) to improve the shared matcher and catalog for everyone.
• It's completely optional — the app works exactly the same either way.
• Only cards you match or correct are used, and only after you opt in.
• Your prices, costs, orders, and account details are never used.
• Only cards you match or correct are used, and only after you opt in.
• Your prices, costs, orders, and account details are never used.
TRACK PLATFORM