Lot Cost Scanner
live show + pull-station cost logging · per-show exportLabel setup
Set the exact dimensions to match your printer/blank stock. Currently set to 1.75" × 0.75", essentially identical to a genuine off-the-shelf Zebra part — their 1.88"×0.75" roll (10024086-1 / 10024379) — not a custom-cut order.
Layout: cost code top-left, QR below it bottom-left, your logo top-right, optional retail price bottom-right in plain numbers. Cost code cipher is MARYXSPIKE → 1234567890, encoded by whole dollar. Two extra obfuscation rules: when a digit repeats the one right before it, it's written as B instead of repeating the letter (e.g. $100 → 1,0,0 → M, E, then B for the second 0 → MEB); and 0 is randomly written as either E or Z each time, so the same price won't always print the same code.
Just the QR, sized to fill the label — no cost code, logo, or retail price. Starting at 0.5" square to test against your camera before committing to bulk labels; nudge the size above and re-print a test tag if scans aren't landing reliably. Works from either a sheet of small adhesive stickers or a Zebra roll — whichever you'd rather test with first.
Prints a photo-sheet grid on regular paper/label sheets — good for a home/office printer.
Each tag prints as its own label, one after another, sized to the roll — no grid, no wasted stock. At 1.75" × 0.75", order Zebra's genuine 1.88"×0.75" die-cut rolls (essentially this exact footprint, works on the common desktop models: ZD420/ZD421, GK420d, GC420d) — this isn't a custom-cut size. Before printing, set the label width/height above to match your actual roll stock, and set that same size in the printer driver's label/stock settings (Windows: printer Preferences → Stock/Media Size) so the printer knows where each label starts — otherwise it'll drift out of registration after a few labels. Keep logos simple/high-contrast; thermal printers render B&W, not grayscale photos.
Search all SKUs
Searches everything — active, archived, and one-offs — by name or code. Print straight from here, restore something to the main list, or permanently delete (real delete, not archive, for actual mistakes like duplicates).
Named SKUs
For anything worth calling by name instead of just a price point — your core high-volume items (add all ~50 here once, by name, for cleaner scan feedback and analytics) as well as one-off higher-value or unique lots. Cost, retail, and qty stay editable any time; bump quantity to bulk-print a batch that just came in.
Same rule as tiers: editing a SKU's cost here only changes tags printed after that point — already-printed tags and already-logged shows keep their original cost.
Cost tiers
Reusable tags for common cost points, spanning whatever inventory happens to match that price — not tied to one specific item, so no name here by design. Print once, laminate, keep in a bin at the pull station. Set quantity per tier to bulk-print for a group of identical-cost items that just arrived.
Adjusting a tier's cost only affects tags you print from this point forward — a tag already printed keeps whatever cost is encoded in its QR, and a lot already logged at a past show keeps the cost it was scanned at. Past figures never shift under you. Always shown lowest to highest.
SKU list — backup & restore
Your tiers and Named SKUs now live in the shared database — every signed-in teammate sees the same list, on any computer, automatically. These buttons are just for backup: export a snapshot to a file occasionally, or restore from one if something ever needs recovering (loading a file adds those SKUs into the database, it doesn't replace what's already there).
Preview below shows how tags will render. To actually print, hit the Print button on the specific tier or SKU row above, set to the quantity you want.
Live show capture
Camera stays on and reads whatever's in view continuously, but nothing gets logged until you trigger it — foot pedal or the on-screen button. That way holding up a few items before deciding which one to actually run never mis-logs a lot. Quantity defaults to 1; punch a number on the keypad before triggering to log that many units under the one lot — the first digit replaces the default, further digits build a two-digit number. It resets to 1 right after each lot is logged, and also on its own after about 10 seconds of no activity in case you typed a number then changed your mind.
Show code only matters for eBay — it's whatever letter/word you're already embedding in eBay listing titles for this show, and it's what keeps reconciliation from ever matching the wrong show's lot (eBay reuses lot numbers across shows). Leave it blank for Whatnot/TikTok.
Add a missed lot
For a lot that sold but never got scanned during the show (or a show that's already ended). Either point the camera at the item's tag until it shows "In view" above, or just type/pick the SKU directly below — then set the show/category/lot number here and add it, independent of whatever the live "next lot" counter is currently on.
Fix a logged lot
Pick a show to see everything logged for it — category, lot number, SKU, cost, and qty are all editable right here. Rows flagged ⚠ were auto-logged as a duplicate of the previous lot because the pedal fired with nothing recognizable in view; check the item was actually the same and clear the flag, or fix the SKU/cost if it wasn't.
SKU list
Named SKUs and what they cost. This list is read-only.
| SKU name | Code | Category | Cost |
|---|
Giveaway cost list
Whatnot's sold-lot export lists giveaways as separate rows, outside your normal lot sequence — so they don't get scanned live. Instead, keep a small lookup table of title → unit cost here, export it, and match it against the giveaway rows in the export by title when you reconcile a show. TikTok and eBay Live have no giveaway mechanic currently, so this only applies to Whatnot for now.
Post-show entry
After a show: upload the sales export, then work down the sold lots in order. Scan each tagged item (or type its code, e.g. T20 or C003), type a number with an x to set the quantity: 5x on its own repeats the item above with a new quantity, or put it in front of an item (5x T20). A number without the x is a search (so 1928 finds the 1928 notes). Press Enter on an empty box to repeat the row above, or - to skip a row. Tick rows to apply one entry to many at once. Nothing is saved to the database until you hit Save.
| Category | Lot | Sale | SKU | Qty | Cost |
|---|
Reconcile a sales export
Upload the sold-lot export from Whatnot, TikTok Shop, or eBay after a show — the format is detected automatically from the file. Whatnot: reads category and lot number out of the product name, using the original item price as-is. TikTok: reads the lot number from the "Item" column and skips $0 (unsold) rows. eBay: reads the lot number and show code out of the item title (e.g. "#405 - - Y - AUCTION LOT..."), only matches rows whose code matches the selected show's code (eBay reuses lot numbers across shows, so this is required, not optional), and uses sale price regardless of payment status since eBay buyers can pay weeks later. Nothing is written until you review the preview and hit Apply.
Matched — will update sale price
| Category | Lot | SKU | Cost | Sale Price |
|---|
Not matched — needs a look
Rows from the export naming a lot number that doesn't exist in this show's log — check for typos, a wrong show selected, or a lot scanned under the wrong category.
| Category | Lot | Sale Price |
|---|
Giveaways not matched to your list
Titles found in the export that don't match anything in the Giveaways tab, by normalized title — their cost isn't counted in the total above until you add them there and re-run this. Applying now will still save the total as computed from what did match.
| Title (as it appears in the export) | Count |
|---|
Show log
Export this after the show and merge it with the platform's sales report by lot number (and category, where the platform splits sequences) to get sale price, fees, and margin per lot. Giveaway rows in that same export match against your Giveaways list by title, separately from this cost log.