skill / Product & Materials Research

Product Spec Bulk Cleanup

A Claude Code skill that cleans up FF&E schedules — normalizing casing, splitting dimensions, translating materials from Spanish, standardizing categories, and deduplicating rows for consistent, procurement-ready output.

procurement data-lookup
Install ↓ View on GitHub →
New to skills? Read the cheat sheet for architects and designers →

What it does

Type /product-spec-bulk-cleanup in Claude Code and point it at a messy FF&E schedule. The skill normalizes everything — casing, dimensions, units, language, materials vocabulary, currency formatting, and duplicates — so every row is consistent and spec-ready.

Designed for schedules assembled from multiple sources, vendors, and languages.

Install

Claude Desktop:

  1. Open Customize → Browse plugins
  2. Click + → Add marketplace from GitHub
  3. Enter AlpacaLabsLLC/skills-for-architects
  4. Install the Product & Materials Research plugin

Claude Code (terminal):

claude install github:AlpacaLabsLLC/skills-for-architects/05-materials-research

Usage

/product-spec-bulk-cleanup ~/Documents/ffe-schedule.csv

Or point to a Google Sheet:

/product-spec-bulk-cleanup 1FMScYW9guezOWc_m4ClTQxxFIpS6TNRr373R-MJGzgE

The skill reads the schedule, scans for issues, previews changes, and applies fixes.

What it cleans

Casing

eames lounge chair → Eames Lounge Chair, HERMAN MILLER → Herman Miller. Preserves known abbreviations: HAY, USM, DWR, CB2, HBF, OFS.

Categories

Maps free text to a controlled vocabulary. chairs → Seating, mesa → Tables, luminarias → Lighting. Covers 11 canonical categories including Partitions, Acoustic, and Planters.

Dimensions

Splits combined strings into separate W/D/H columns:

BeforeAfter
32 x 24 x 30 inW: 32, D: 24, H: 30, Unit: in
80 × 60 × 75 cmW: 80, D: 60, H: 75, Unit: cm
32"W x 24"D x 30"HW: 32, D: 24, H: 30, Unit: in
Ancho: 80, Prof: 60, Alto: 75 cmW: 80, D: 60, H: 75, Unit: cm

Does not convert units — keeps the manufacturer’s original spec for ordering accuracy.

Language

Translates Spanish material and finish terms to English (common when sourcing from Uruguay, Argentina, or Spain):

Madera → Wood, Cuero → Leather, Acero → Steel, Cromado → Chrome, Nogal → Walnut, Vidrio → Glass

Product names and brands stay as-is (proper nouns). Respects /keep in Spanish if you need the original language.

Materials vocabulary

Standardizes abbreviations: SS → Stainless steel, PC → Powder-coated, Ply → Molded plywood, COM stays COM, HPL stays HPL.

Price & currency

Strips symbols, detects locale formatting (1.234,56 EU vs 1,234.56 US), outputs clean decimals. “Contact for pricing” → empty cell.

Duplicates

Flags rows with identical Product Name + Brand, or identical URL. Presents them for review — never auto-deletes.

Workflow

The skill works in steps:

  1. Load — reads the schedule, reports row/column count
  2. Analyze — scans all rows and produces a cleanup preview with issue counts
  3. Confirm — asks whether to apply all fixes or let you pick selectively
  4. Apply — processes every row through active cleanup rules
  5. Review — shows before/after diff for a sample of changed rows
  6. Save — overwrites original, saves as new file, writes to Google Sheet, or stays in conversation

Pairs with

Use /product-spec-bulk-fetch to extract specs from product URLs, then run this skill to normalize the output. The two skills chain: fetch → cleanup → spec-ready schedule.