Yes. The astm_methods column is mapped with a list mapping and renders as badges in the page header. Shops running multiple methods such as Method 1 nitric and citric acid get both badges in the order they appear in the source. Per method hubs use the same column to build filtered landing pages for RFQ intent.

Add or update the shop in the roster sheet with the correct ams_2700_status and audit_date values. SleekRank picks up the updated AMS 2700 badge and the cert renewal page on the next cache refresh without a developer ticket. The page inherits the base template and ASTM method badges automatically.

Yes. The base template includes a LocalBusiness JSON-LD block with placeholders for company name, service area, phone, passivation methods, and review count. SleekRank fills the placeholders from the row data, so every generated city page ships with valid structured data ready for industrial buyer snippets.

Yes. Use the fda_compliant column with values like yes, pending, or no, and add a second URL pattern such as /passivation-services/medical/{slug}/ that draws from the same sheet filtered by FDA shops. Each combination gets its own URL with its own H1 and qualification copy block.

Update the ams_2700_status cell in the source roster to lapsed or pending. The page refreshes on the next cache cycle with the AMS badge demoted, and the shop no longer appears in the AMS 2700 compliant hub. The base record stays live with the updated status and the next audit date visible.

Yes. Add columns for max_part_size, lead_time, and tank_capacity. Map each as a tag or selector in the template and the values render in the relevant template block. OEM buyers comparing passivation shops filter on max part size and lead time first, so surface those fields prominently in the page header.

Yes. The base template can include a Gravity Forms or Fluent Forms block with hidden fields populated from the row data. The shop slug, city, and ASTM method pass through as hidden form values, so the RFQ lands in your CRM tagged with the source page and the buyer intent automatically without per-page config.

The cacheDuration setting in the page group config controls refresh frequency. Most metal finishing directories use 86400 seconds for a daily refresh, which is fast enough for Nadcap and AMS 2700 audit renewals without hitting the Thomasnet portal or Google Sheets API on every visitor request.