Yes. Add a serial_dated_year column populated by the dealer's authentication process. The Product JSON-LD includes the year as a manufactureDate field, and the base page renders the year prominently above the fold. For Rolex specifically, the serial-dated year is often more important than the reference because dial variants and case material variations are reference-specific to a date range.

Add a dial_variant column with values like Mk1, Mk2, blue, black, salmon, tropical. The base page renders the dial variant as a prominent badge and the Product JSON-LD includes it in the model field. A buyer searching for a Mk2 Submariner dial or a blue dial Daytona lands directly on the right variant rather than browsing through generic reference pages.

Yes. Consignment pieces appear in the inventory feed with a consignment flag. The base page conditionally renders a consignment badge that some buyers prefer to see. The pricing field still applies and the URL is no different in structure from outright-purchase pieces, so the dealer presents a consistent buying experience across all inventory tiers.

Yes. Store macro shot URLs by category - dial_macros, case_macros, movement_macros - in separate comma-separated columns. List mappings split each column and render distinct gallery sections under labeled headings. Collectors evaluating a six-figure piece pore over macro shots, and structured galleries reduce the prep work for the photography team per listing.

Store service history as structured JSON in a single column - year, location, type, link to receipt PDF if available. A selector mapping with a small inline template renders the entries as a chronological list. Buyers see the actual service timeline rather than a generic recently serviced claim, which validates the asking price at the collector tier.

Track has_box, has_papers, has_warranty_card_signed, has_warranty_card_blank, has_extract_of_archives, has_original_receipt, has_link_set, has_certificate. The base page renders the full set checklist visually so a buyer scanning the listing knows immediately whether the piece qualifies as full set or partial set under collector definitions.

Yes. The default related filter matches on category, but adding a brand or reference_family field and a custom related filter in sleek-rank.php lets you surface other Submariner references on a Submariner page, or other 5711 dial variants on a 5711 page. Reference-family related grids match how collectors browse within a single configuration line.

The row drops from the inventory and the URL returns 404 on the next cache refresh. For high-value pieces with inbound links from watch publications or collector blogs, set a 410 with a redirect to a nearest-equivalent reference via a small custom plugin to preserve link equity. The sitemap regenerates without the listing automatically across the entire 10,000-row corpus.