When the Lot Sheet Falls Apart at 200 Items
The auction house intake process has a breaking point. It usually happens somewhere around the 200-consignment mark, when you've got three consignors dropping off goods the same morning, bins are being reshuffled because the "A" row got pushed back to make room for a pallet of returned appliances, and the guy doing condition grading is working off a clipboard that already has coffee on it.
At that scale, paper-based intake breaks. Not theoretically — actually breaks. Lot numbers get skipped. A "New – Open Box" item gets listed as "Used" because the grader was in a hurry and checked the wrong box. Someone writes "B7" on a sticky note that falls off. Three weeks later, when the buyer calls to say the item description doesn't match what showed up, you're digging through photographed clipboard pages trying to reconstruct what happened. That's not an operations problem. That's a documentation problem.
This template eliminates it by turning intake into a structured, field-constrained data entry flow — with an automated image fetch layer bolted on top that does the one job nobody wants to do manually.
The Bin Address System and Why the Condition Taxonomy Earns Its Complexity
The Bin Letter / Bin Number combination field structure deserves more attention than it gets. The template uses two discrete choice fields — letter (A through K, plus WA for a special zone) and number (1–20) — rather than a single free-text "bin location" field. That's a deliberate design decision. When bin location is free text, you get "B7", "b-7", "Bin B, #7", "B Section Row 7", and eventually something that can't be parsed at all. Two constrained dropdowns produce exactly one output format, which means a warehouse scan report filtered by bin address actually works without data cleaning first.
The Condition field is the other one worth unpacking. Nine options: New Factory Sealed, Like New, New – Scratch and Dent, New – Damaged Box, New – No Box, New – Open Box, Refurbished, Used, As-Is. Most amateur setups use three to five. The difference matters at resale time. A buyer who paid for "New – Open Box" and receives something that should have been "New – Damaged Box" — cracked corner panel, dented frame — is a dispute. Nine granular conditions give your graders the vocabulary to be precise, which in turn gives your listings the accuracy that builds repeat bidder trust.
MSRP alongside Start Bid is the third critical pairing. Knowing that a lot has an MSRP of $340 CAD but is opening at $25 tells you something about consignor expectations and floor pricing strategy in a single glance. When you're reviewing 80 lots the morning before auction day, that comparative context is not a nice-to-have.
The Google Custom Search Script in Practice
The GOP (Grab Online Photos) script — a JavaScript action that fires against the Google Custom Search API — queries the item's Title field and pulls back up to 10 image URLs, dropping them into the Online Image 1–10 fields with paired "Keep?" boolean toggles. The cleanup image URL logic (stripping comma-appended suffixes before .jpg) handles a common artifact from certain CDN image paths that would otherwise load broken.
The practical workflow: a staffer enters the Title field during intake, hits the GOP action, and gets a results set of online reference images in seconds. They flip through them, set "Keep Image?" to true for the ones that accurately represent the item's appearance, and move on. Manual upload slots (Image 1–10) remain available for items where the search returns nothing useful — obscure branded goods, custom fabrications, local resellers without online presence.
This is not a replacement for proper item photography. It's a triage tool for lots where sending a photographer over isn't cost-justified. For a lot opening at $5, pulling a manufacturer reference image that shows the product's original retail appearance is often enough. For a lot with an MSRP over $200, you photograph it yourself and use the manual image fields.
The Consignor field — coded as EL10, Aldo1, Bt15, Gt4 — tracks which consignor brought the item. Combined with a report filtered by consignor code and lot number range, you can generate a payout summary per consignor without manual cross-referencing after the auction closes.