product-enrich

Name: product-enrich
Author: AlpacaLabsLLC

23installs54forks

How to install product-enrich?

alpacalabsllc/skills-for-architects/product-enrich

$npx -y skills add AlpacaLabsLLC/skills-for-architects --skill product-enrich

Installs into the current project.

Summary

Auto-tag FF&E products with categories, colors, materials, and style tags using AI. Use when the user asks to "enrich", "tag", or "categorize" products, or to fill in missing category, material, or style columns in the schedule.

Files · 1

View on GitHub

SKILL.md

1	# /product-enrich — Product Enrichment
2
3	Takes a product list with basic info (name + brand) and fills in missing metadata — category, subcategory, primary color, material, and style tags — using AI. Works on CSV files, Google Sheets, or pasted data.
4
5	## When to Use
6
7	- After a bulk import where products are missing categories or tags
8	- When a designer clips products quickly without filling in details
9	- To standardize metadata across products from different sources
10	- Before generating an FF&E schedule (enriched data makes better schedules)
11
12	## Step 1: Accept Input
13
14	Accept product data in any format:
15
16	Google Sheet ID:
17	```
18	/product-enrich 1FMScYW9guezOWc_m4ClTQxxFIpS6TNRr373R-MJGzgE
19	```
20
21	CSV file:
22	```
23	/product-enrich ./products.csv
24	```
25
26	Pasted data:
27	```
28	/product-enrich
29	Eames Lounge Chair, Herman Miller
30	Saarinen Tulip Table, Knoll
31	PH 5 Pendant, Louis Poulsen
32	Togo Sofa, Ligne Roset
33	```
34
35	## Step 2: Analyze Each Product
36
37	For each product, infer the following fields:
38
39	### Category
40	Map to the canonical vocabulary (22 terms) defined in `../../schema/product-schema.md`.
41
42	### Subcategory
43	More specific classification within the category:
44	- Chair → Task Chair, Lounge Chair, Dining Chair, Side Chair, Stool, Bench
45	- Table → Dining Table, Coffee Table, Side Table, Console Table, Conference Table
46	- Light → Pendant, Floor Lamp, Table Lamp, Wall Sconce, Ceiling, Task Light, Chandelier
47	- Sofa → Sofa, Sectional, Loveseat, Daybed, Settee
48	- Storage → Credenza, Bookcase, Filing Cabinet, Wardrobe, Sideboard, Dresser
49	- Desk → Writing Desk, Executive Desk, Standing Desk, Workstation
50
51	### Primary Color
52	The dominant color of the product as typically sold:
53	- Use standard color names: Black, White, Gray, Brown, Beige, Navy, Blue, Green, Red, Orange, Yellow, Pink, Purple, Natural, Walnut, Oak, Teak, Chrome, Brass, Copper, Multi
54
55	### Material
56	Primary materials, comma-separated:
57	- Wood (specify type if known: Walnut, Oak, Maple, Teak, Birch, Ash, Beech)
58	- Metal (specify: Steel, Aluminum, Brass, Chrome, Iron, Copper)
59	- Upholstery (specify: Leather, Fabric, Velvet, Bouclé, Mohair, Linen, Wool)
60	- Other: Glass, Marble, Concrete, Ceramic, Plastic, Fiberglass, Rattan, Cane, Acrylic
61
62	### Style Tags
63	2-4 descriptive tags from:
64	- Period/movement: Mid-Century Modern, Art Deco, Bauhaus, Scandinavian, Japanese, Industrial, Contemporary, Traditional, Minimalist, Postmodern, Memphis
65	- Character: Organic, Geometric, Sculptural, Modular, Stackable, Compact, Statement, Classic, Iconic
66	- Context: Residential, Contract, Hospitality, Healthcare, Education, Outdoor
67
68	### Image Analysis
69	If the product data includes an image URL (column AC in the master schema), use Claude vision to verify and refine the enrichment. The image may reveal:
70	- Actual color (not just what the name suggests)
71	- Material details not in the product name
72	- Style characteristics
73
74	## Step 3: Present Preview
75
76	Show a preview of the enrichment before applying:
77
78	```
79	## Product Enrichment Preview
80
81	\| Product \| Brand \| Category \| Subcategory \| Color \| Material \| Style Tags \|
82	\|---------\|-------\|----------\|-------------\|-------\|----------\|------------\|
83	\| Eames Lounge Chair \| Herman Miller \| Chair \| Lounge Chair \| Walnut/Black \| Molded plywood, Leather \| Mid-Century Modern, Iconic, Residential \|
84	\| Saarinen Tulip Table \| Knoll \| Table \| Dining Table \| White \| Marble, Aluminum \| Mid-Century Modern, Sculptural, Organic \|
85	\| PH 5 Pendant \| Louis Poulsen \| Light \| Pendant \| White \| Aluminum \| Scandinavian, Classic, Iconic \|
86	\| Togo Sofa \| Ligne Roset \| Sofa \| Sofa \| Brown \| Fabric \| Contemporary, Organic, Sculptural \|
87
88	4 products enriched. Apply? (y/n)
89	```
90
91	Flag any products where enrichment is uncertain:
92	```
93	⚠ "Custom Reception Desk" — unknown product, category set to Desk but verify
94	```
95
96	## Step 4: Apply
97
98	### To Google Sheet
99	Write enriched fields to the master 33-column schema:
100	- Column A (Category) — enriched category
101	- Column R (Materials) — enriched materials
102	- Column S (Colors/Finishes) — enriched color
103	- Column AD (Tags) — enriched style tags, appended to existing tags
104
105	Do NOT overwrite existing values unless the field is empty or the user explicitly asks to overwrite.
106
107	### To CSV
108	Add new columns if they don't exist: Category, Subcategory, Primary Color, Material, Style Tags. Save as `{original-name}-enriched.csv`.
109
110	### To conversation
111	Output the enriched table in markdown.
112
113	## Step 5: Summary
114
115	```
116	✓ Enriched 4 products
117	Categories: 4 assigned (0 already had values)
118	Colors: 4 assigned
119	Materials: 4 assigned
120	Style tags: 14

People who liked this also viewed

6 picks

Type

product-enrich

23installs54forks

View on GitHub

How to install product-enrich?

alpacalabsllc/skills-for-architects/product-enrich

$npx -y skills add AlpacaLabsLLC/skills-for-architects --skill product-enrich

Installs into the current project.

Summary

Files · 1

View on GitHub

SKILL.md

1	# /product-enrich — Product Enrichment
2
3	Takes a product list with basic info (name + brand) and fills in missing metadata — category, subcategory, primary color, material, and style tags — using AI. Works on CSV files, Google Sheets, or pasted data.
4
5	## When to Use
6
7	- After a bulk import where products are missing categories or tags
8	- When a designer clips products quickly without filling in details
9	- To standardize metadata across products from different sources
10	- Before generating an FF&E schedule (enriched data makes better schedules)
11
12	## Step 1: Accept Input
13
14	Accept product data in any format:
15
16	Google Sheet ID:
17	```
18	/product-enrich 1FMScYW9guezOWc_m4ClTQxxFIpS6TNRr373R-MJGzgE
19	```
20
21	CSV file:
22	```
23	/product-enrich ./products.csv
24	```
25
26	Pasted data:
27	```
28	/product-enrich
29	Eames Lounge Chair, Herman Miller
30	Saarinen Tulip Table, Knoll
31	PH 5 Pendant, Louis Poulsen
32	Togo Sofa, Ligne Roset
33	```
34
35	## Step 2: Analyze Each Product
36
37	For each product, infer the following fields:
38
39	### Category
40	Map to the canonical vocabulary (22 terms) defined in `../../schema/product-schema.md`.
41
42	### Subcategory
43	More specific classification within the category:
44	- Chair → Task Chair, Lounge Chair, Dining Chair, Side Chair, Stool, Bench
45	- Table → Dining Table, Coffee Table, Side Table, Console Table, Conference Table
46	- Light → Pendant, Floor Lamp, Table Lamp, Wall Sconce, Ceiling, Task Light, Chandelier
47	- Sofa → Sofa, Sectional, Loveseat, Daybed, Settee
48	- Storage → Credenza, Bookcase, Filing Cabinet, Wardrobe, Sideboard, Dresser
49	- Desk → Writing Desk, Executive Desk, Standing Desk, Workstation
50
51	### Primary Color
52	The dominant color of the product as typically sold:
53	- Use standard color names: Black, White, Gray, Brown, Beige, Navy, Blue, Green, Red, Orange, Yellow, Pink, Purple, Natural, Walnut, Oak, Teak, Chrome, Brass, Copper, Multi
54
55	### Material
56	Primary materials, comma-separated:
57	- Wood (specify type if known: Walnut, Oak, Maple, Teak, Birch, Ash, Beech)
58	- Metal (specify: Steel, Aluminum, Brass, Chrome, Iron, Copper)
59	- Upholstery (specify: Leather, Fabric, Velvet, Bouclé, Mohair, Linen, Wool)
60	- Other: Glass, Marble, Concrete, Ceramic, Plastic, Fiberglass, Rattan, Cane, Acrylic
61
62	### Style Tags
63	2-4 descriptive tags from:
64	- Period/movement: Mid-Century Modern, Art Deco, Bauhaus, Scandinavian, Japanese, Industrial, Contemporary, Traditional, Minimalist, Postmodern, Memphis
65	- Character: Organic, Geometric, Sculptural, Modular, Stackable, Compact, Statement, Classic, Iconic
66	- Context: Residential, Contract, Hospitality, Healthcare, Education, Outdoor
67
68	### Image Analysis
69	If the product data includes an image URL (column AC in the master schema), use Claude vision to verify and refine the enrichment. The image may reveal:
70	- Actual color (not just what the name suggests)
71	- Material details not in the product name
72	- Style characteristics
73
74	## Step 3: Present Preview
75
76	Show a preview of the enrichment before applying:
77
78	```
79	## Product Enrichment Preview
80
81	\| Product \| Brand \| Category \| Subcategory \| Color \| Material \| Style Tags \|
82	\|---------\|-------\|----------\|-------------\|-------\|----------\|------------\|
83	\| Eames Lounge Chair \| Herman Miller \| Chair \| Lounge Chair \| Walnut/Black \| Molded plywood, Leather \| Mid-Century Modern, Iconic, Residential \|
84	\| Saarinen Tulip Table \| Knoll \| Table \| Dining Table \| White \| Marble, Aluminum \| Mid-Century Modern, Sculptural, Organic \|
85	\| PH 5 Pendant \| Louis Poulsen \| Light \| Pendant \| White \| Aluminum \| Scandinavian, Classic, Iconic \|
86	\| Togo Sofa \| Ligne Roset \| Sofa \| Sofa \| Brown \| Fabric \| Contemporary, Organic, Sculptural \|
87
88	4 products enriched. Apply? (y/n)
89	```
90
91	Flag any products where enrichment is uncertain:
92	```
93	⚠ "Custom Reception Desk" — unknown product, category set to Desk but verify
94	```
95
96	## Step 4: Apply
97
98	### To Google Sheet
99	Write enriched fields to the master 33-column schema:
100	- Column A (Category) — enriched category
101	- Column R (Materials) — enriched materials
102	- Column S (Colors/Finishes) — enriched color
103	- Column AD (Tags) — enriched style tags, appended to existing tags
104
105	Do NOT overwrite existing values unless the field is empty or the user explicitly asks to overwrite.
106
107	### To CSV
108	Add new columns if they don't exist: Category, Subcategory, Primary Color, Material, Style Tags. Save as `{original-name}-enriched.csv`.
109
110	### To conversation
111	Output the enriched table in markdown.
112
113	## Step 5: Summary
114
115	```
116	✓ Enriched 4 products
117	Categories: 4 assigned (0 already had values)
118	Colors: 4 assigned
119	Materials: 4 assigned
120	Style tags: 14

People who liked this also viewed

6 picks

Type