Yes. Define a URL pattern like /coppersmiths/{specialty}/{metro}/ and SleekRank renders a page per combination from the sheet. Each combination gets its own H1, list of smiths, and meta tags, which is what ranks for queries like custom copper gutters Boston.

Store current_lead_time_weeks as a number column and update it weekly from the shop. A tag mapping injects the lead time on the page, and the per-specialty hubs can sort by lead time so homeowners with tight timelines see shorter-lead shops first.

Edit the accepting_orders column to false and flush the cache. A closed-for-orders badge appears via selector mapping, and the per-specialty hubs can hide the smith from active listings while keeping the personal page indexed for historical equity and brand searches.

Yes. Store gallery_urls as a JSON array of image URLs in the sheet. A list mapping renders the portfolio on each smith page, and a per-style hub can filter on portfolio tags like Federal Revival or Mission to surface stylistically matching shops for design searches.

Each generated URL is a real WordPress page with full HTML and ships in the auto-generated XML sitemap. The base template is auto-noindexed. Google treats each smith URL as a distinct page with its own canonical, Open Graph, and LocalBusiness schema.

Yes. SleekRank uses an existing WordPress page as the template, so Bricks, Elementor, Gutenberg, Oxygen, and classic themes all render through the mapping layer without rewriting the directory design.

Yes. Add a commission_minimum column with the dollar floor for custom orders. A tag mapping injects the figure on the page, and a budget filter on the metro hub helps homeowners narrow to shops within their range before reaching out for a quote.

Delete the row from the sheet and flush the cache. The smith URL stops resolving and returns 404, the specialty and metro hubs update to omit them, and the sitemap regenerates. For historical figures, redirect the slug to a memorial page rather than 404.