Converts SIF (Standard Interchange Format) files from dealer/procurement systems to readable CSV or Google Sheets. Maps codes to headers, expands options/attributes, calculates pricing/totals for quote review/import.
npx claudepluginhub alpacalabsllc/skills-for-architects --plugin 06-materials-researchThis skill is limited to using the following tools:
Converts a SIF (Standard Interchange Format) file from a dealer or procurement system into a clean, human-readable CSV or Google Sheet. Translates field codes to column headers, expands options and attributes, calculates pricing, and computes totals.
Converts CSV, Excel, or Google Sheets FF&E product lists to SIF format for import into dealer and procurement systems like Hedberg, CAP, CET, and Cyncly. Useful for quoting specs, data import, and standardized sharing.
Transforms product data from CSV, Excel, Shopify exports into Saleor config.yml format. Use for bulk imports, migrations, or converting external sources.
Parse, transform, clean, and analyze CSV files: auto-detect formats, filter/sort/merge/pivot, generate stats/outliers, with Python (pandas) and JavaScript examples.
Share bugs, ideas, or general feedback.
Converts a SIF (Standard Interchange Format) file from a dealer or procurement system into a clean, human-readable CSV or Google Sheet. Translates field codes to column headers, expands options and attributes, calculates pricing, and computes totals.
SIF is a text-based key-value format. Each line is CODE=VALUE, terminated by CRLF. Products are separated by records starting with PN=.
| Code | Name | Description |
|---|---|---|
SF | Specification File | Project reference (header) |
ST | Specification Title | Display title (header) |
PN | Product Number | SKU — starts a new record |
PD | Product Description | Product name |
MC | Manufacturer Code | 3-5 char code |
MN | Manufacturer Name | Full name |
QT | Quantity | Integer |
NT | Quantity (alt) | Some systems use NT instead of QT |
GC | Category / Group Code | Product category |
G0 | Vendor / Group ID | Vendor identifier |
| Code | Name | Description |
|---|---|---|
PL | List Price | Unit list price |
P1-P5 | Price Tiers | Alternate price tiers |
I1 | Unit List Price (Cyncly) | Cyncly Worksheet |
I2 | Purchase Price (Cyncly) | Cyncly Worksheet |
S- / S% | Sell Discount % | Sell = PL - (PL × S- × 0.01) |
P% / B% | Purchase/Buy % | Cost = PL × (P% × 0.01) |
| Code | Name | Description |
|---|---|---|
TG | Side Mark / Tag | Room, area, or project tag |
ON / OD | Option | Number + description pair |
AN / AD | Attribute | Number + description pair |
WT | Weight | Product weight |
VO | Volume | Product volume |
PRC | Product Category (Cyncly) | Cyncly category |
| Code | Name | Description |
|---|---|---|
ProductURL | Product Page URL | Link to product page |
ImageURL | Product Image URL | Link to product image |
PV | Picture Path | Local file path |
| System | Code | Purpose |
|---|---|---|
| Standard | MC | 3-5 char manufacturer code |
| Cyncly | MG | Manufacturer code (replaces MC) |
| CET | EC | Manufacturer code (alt) |
SIF file:
/sif-to-csv ~/Documents/project/dealer-quote.sif
Pasted SIF content:
/sif-to-csv
SF=Project Alpha
ST=Dealer Quote - March 2026
PN=670
PD=Eames Lounge Chair and Ottoman
MC=HMI
QT=3
PL=5695.00
S-=42
TG=Executive Lounge
OD=Santos Palisander / Black MCL Leather
Read the file and parse each record:
SF and STPN= boundariesPL - (PL × S- × 0.01) if discount presentPL × (P% × 0.01) if purchase % presentPL × QTSell Price × QT| MC | Brand | MC | Brand |
|---|---|---|---|
| HMI | Herman Miller | BLU | Blu Dot |
| MKN | MillerKnoll | DWR | Design Within Reach |
| KNL | Knoll | FRH | Fritz Hansen |
| STC | Steelcase | VIT | Vitra |
| HAW | Haworth | ARP | Arper |
| TEK | Teknion | FLS | Flos |
| HUM | Humanscale | LPO | Louis Poulsen |
| KIM | Kimball | ART | Artemide |
| OFS | OFS | HBF | HBF |
| GEI | Geiger | BRN | Bernhardt |
For unknown codes, keep as-is and flag.
ON/OD pairs → concatenate into "Options" column, separated by |AN/AD pairs → concatenate into "Attributes" column, separated by |AN=DIM, parse dimension string back into W/D/H if possible## SIF Import: Project Alpha — Dealer Quote March 2026
3 records parsed from dealer-quote.sif
| # | SKU | Product | Brand | Qty | List $ | Disc % | Sell $ | Ext Sell | Options | Tag |
|---|-----|---------|-------|-----|--------|--------|--------|----------|---------|-----|
| 1 | 670 | Eames Lounge Chair | Herman Miller | 3 | $5,695 | 42% | $3,303 | $9,909 | Palisander/Black | Exec Lounge |
| 2 | 164-500 | Saarinen Table 54" | Knoll | 1 | $4,750 | 38% | $2,945 | $2,945 | Arabescato/White | Dining |
| 3 | 462-CG | Gesture Chair | Steelcase | 8 | $1,189 | 45% | $654 | $5,232 | Cogent/Licorice | Open Office |
**Totals:**
- List: $22,147 · Sell: $18,086 · Savings: $4,061 (18.3%)
Ask the user for output format:
Save as {input-name}-parsed.csv:
Item #, SKU, Product, Brand, Qty, List Price, Discount %, Sell Price, Ext List, Ext Sell, Category, Weight, Options, Attributes, Tag, Product URL, Image URL, MC Code
Write to the 33-column schema (defined in ../../schema/product-schema.md, CRUD patterns in ../../schema/sheet-conventions.md):
See ../../schema/sif-crosswalk.md for the full column-to-SIF mapping. Key fields:
Output the table in conversation.
✓ Parsed dealer-quote.sif
Specification: Project Alpha — Dealer Quote March 2026
3 records · 12 units
Total list: $22,147 · Total sell: $18,086 (18.3% avg discount)
Manufacturers: HMI (1), KNL (1), STC (1)
Saved to: ~/Documents/project/dealer-quote-parsed.csv
/csv-to-sif — round-trip: create SIF, send to dealer, parse their quote back/product-data-cleanup — normalize the parsed data/product-data-import — reformulate dealer data into a formatted schedule/product-enrich — add categories and tags to imported products