AlpacaLabsLLC/skills-for-architects / skills/product-data-cleanup
product-data-cleanup
VerifiedClean 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.
| File | Kind | Size |
|---|---|---|
| README.md | markdown | 3.4 KB |
| SKILL.md | skill md | 17.0 KB |
| host-contract.json | config | 2.0 KB |
README.md
View on GitHub# /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)
## 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
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| 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: 119k | Updated | Claude CodeCodex | Verified | Install |
| 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: 119k | Updated | Claude CodeCodex | Verified | Install |
| 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: 118k | Updated | Claude CodeCodex | Verified | Install |
| 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: 118k | Updated | Claude CodeCodex | Verified | Install |