QRZ swapmeet has no public REST feed, so the broker uploads a CSV export or maintains a Google Sheet. SleekRank reads either. For clubs that run consignments through a shared sheet, share read-only and SleekRank pulls on each cache refresh.

Include stock or seller code in the slug. The example icom-ic-7300-stock-2207 uses brand, model, and stock number so multiple identical rigs coexist on the site. The sheet needs a stable identifier column for the slug to be deterministic.

Bands is a column in the row, typically a comma-separated list like HF + 6m + 2m + 70cm. Map it to a selector and the template renders it as a badge row. Buyers filter on bands via query-string filters that read the column directly.

Shipping is destination-specific, so the page renders a shipping calculator block in WordPress rather than a static figure. The block reads rig weight and dimensions from the row via a selector mapping and calls a shipping API client-side.

Accessories is a list column in the row. Map it via a list mapping that injects accessory names into a bullet list in the WordPress template. Each rig can show a different accessory bundle without any per-rig hand editing in the editor.

Yes if the row carries required Product fields. Map slug, name, image, brand, condition, offers price, and offers priceCurrency. The rich results test flags any missing fields so the broker patches the sheet rather than the template.

Yes. Add a status column with values available and sold. Configure the page group to render sold rows with a sold-badge variant via a conditional selector. The URL stays indexed, the schema price clears, and a sold tag appears in the listing.

Add a status column. Filter the page group on status equals available. Rigs awaiting test stay in the sheet but do not render URLs. When the test passes, the next cache refresh creates the page automatically without staff manual intervention.