Yes. Define a URL pattern like /blacksmiths/{specialty}/{region}/ 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 knife maker Vermont or architectural blacksmith Asheville.

Store accepting_commissions as a boolean column. A selector mapping injects an open or closed badge on each smith page, and the per-specialty hubs can filter on the flag so customers searching for active commissions see only smiths taking work.

Edit the workshop_active column to false and flush the cache. A retired or memorial badge appears via selector mapping, and the per-specialty hubs can hide the smith from active listings while preserving the personal page for historical equity and brand searches.

Yes. Add an apprentice_openings boolean and an apprentice_application_url column. A selector mapping injects the apprentice badge, and a separate page group can publish /blacksmiths/apprenticeships/{region}/ filtered to shops actively taking apprentices.

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 Person or 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 from scratch.

Yes. Store teaching_dates as a JSON array of dates and locations. A list mapping renders the workshop schedule on each smith page, and a calendar hub can aggregate teaching dates across smiths in a region for craft-school students looking to study.

Mark workshop_active to false to keep the page live as a historical record, or delete the row entirely if the smith prefers no public listing. Cache flush propagates the change. For historical figures, a memorial slug can be redirected to a longer biographical page.