1.  [Home](/)
2.  / [Skills](/skills/)
3.  / Product Data Cleanup

Skill Claude Desktop · Claude Code

# /product-data-cleanup

Normalize messy product data into spec-ready data

[Install ↓](#install) [View on GitHub →](https://github.com/AlpacaLabsLLC/skills-for-architects/tree/main/skills/product-data-cleanup) [New to skills? →](/articles/claude-code-cheat-sheet) [All skills →](/skills)

[Procurement](/skills?tag=procurement) [Data Lookup](/skills?tag=data-lookup)

## What it does

Type `/as:product-data-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 **Architecture Studio**

**Claude Code (terminal):**

```
claude plugin marketplace add AlpacaLabsLLC/skills-for-architects
claude plugin install as@skills-for-architects
```

Or symlink just this skill:

```
git clone https://github.com/AlpacaLabsLLC/skills-for-architects.git
ln -s $(pwd)/skills-for-architects/skills/product-data-cleanup ~/.claude/skills/product-data-cleanup
```

## Usage

```
/as:product-data-cleanup ~/Documents/product-data-import.csv
```

Or run it with no argument to clean the current project’s product library:

```
/as:product-data-cleanup
```

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:

Before

After

`32 x 24 x 30 in`

W: 32, D: 24, H: 30, Unit: in

`80 × 60 × 75 cm`

W: 80, D: 60, H: 75, Unit: cm

`32"W x 24"D x 30"H`

W: 32, D: 24, H: 30, Unit: in

`Ancho: 80, Prof: 60, Alto: 75 cm`

W: 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 for multilingual product schedules:

`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** — replaces the original atomically, saves as a new file, or stays in conversation

## Pairs with

Use [`/as:product-spec-bulk-fetch`](/skills/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**.

## Related skills

[01

### /csv-to-sif

Convert FF&E product lists to SIF format for dealer procurement systems

→](/skills/csv-to-sif) [02

### /product-image-processor

Download, resize, and remove backgrounds from product images at scale

→](/skills/product-image-processor) [03

### /product-enrich

Auto-tag FF&E products with categories, colors, materials, and style tags

→](/skills/product-enrich)

[← All skills](/skills) [Product Spec PDF Parser →](/skills/product-spec-pdf-parser)