Skip to content

AlpacaLabsLLC/skills-for-architects / skills/product-data-cleanup

product-data-cleanup

Verified

Clean a local FF&E CSV schedule by normalizing casing, dimensions, units, language, materials, and formatting. Use when asked to clean, fix, or standardize product data.

FileKindSize
README.mdmarkdown3.4 KB
SKILL.mdskill md17.0 KB
host-contract.jsonconfig2.0 KB
# /as:product-data-cleanup

FF&E schedule normalizer for Claude Code. Takes a messy furniture schedule — mixed casing, combined dimensions, Spanish material names, inconsistent categories — and cleans it into consistent, procurement-ready data.

[![License: MIT](https://img.shields.io/badge/License-MIT-green.svg)](../../LICENSE)

## Usage

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

Or point to a file:

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

Or paste a markdown table directly in the conversation.

### Input formats

- **Project library** — the nearest `product-library.csv`
- **File path** — `.csv` or `.md`
- **Pasted table** — markdown or tab-separated data

### Output

Previews meaning-preserving fixes and separates proposed factual corrections. Produces an authorized standalone cleaned file, or hands a requested library change to product-library for guarded publication and readback.

## How it fits

This is a **utility** that normalizes data regardless of source:

| Context | How it's used |
|---------|--------------|
| Standalone | Clean up any FF&E schedule |
| After `/as:product-spec-bulk-fetch` | Normalize fetched data |
| After `/as:product-spec-pdf-parser` | Normalize parsed PDF data |
| After `/as:product-research` | Normalize research results |
| On the project library | Clean up the entire library — data from all sources |

## What It Cleans

### Casing

```text
Synthetic formatting input only:
Example Product A | Example Manufacturer | quantity 2 | supplied specification pending
```

### Categories

Maps free text to 22 canonical categories (unified vocabulary shared by all skills):

| Input | → Canonical |
|-------|-------------|
| chairs, silla, seating, stool | Chair |
| mesa, conference table | Table |
| luminaria, pendant, sconce, lighting | Light |
| cabinet, credenza, estante | Storage |
| acoustic panel, baffle | Acoustic |
| biombo, mampara, divider | Partition |

Also: Sofa, Bed, Desk, Shelving, Rug, Mirror, Accessory, Tabletop, Kitchen, Bath, Window, Door, Outdoor Furniture, Textile, Planter, Other.

### Dimensions

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

| Before | W | D | H | Unit |
|--------|---|---|---|------|
| `32 x 24 x 30 in` | 32 | 24 | 30 | in |
| `Ancho: 80, Prof: 60, Alto: 75 cm` | 80 | 60 | 75 | cm |

Source units are preserved by default. Explicitly requested conversions retain the raw source and conversion basis.

### Language

Translates Spanish material and finish terms:

| Spanish | → English |
|---------|-----------|
| Madera → Wood | Cuero → Leather | Acero → Steel |
| Mármol → Marble | Nogal → Walnut | Cromado → Chrome |

Product names and brands stay untouched.

### Materials vocabulary

Standardizes abbreviations: SS → Stainless steel, PC → Powder-coated, COM → COM (Customer's Own Material), etc.

### Price & currency

Strips symbols, detects locale (EU vs US formatting), normalizes to plain decimal.

### Duplicates

Flags identical Product Name + Brand or identical URL — presents for review, never auto-deletes.

## Works with

| Skill | Relationship |
|-------|-------------|
| `/as:product-research` | Normalizes research results after saving |
| `/as:product-spec-bulk-fetch` | Normalizes fetched data |
| `/as:product-spec-pdf-parser` | Normalizes parsed PDF data |
| `/as:product-image-processor` | Run after cleanup for processed images |

## License

MIT
deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall