git:20260720.55a5936 to git:20260726.e702451

19 added, 44 removed. Audit A to A.

---

name: sif-to-csv

- description: Convert a SIF (Standard Interchange Format) file to a clean, readable CSV or Google Sheet. Use when the user shares a .sif file or asks to "convert SIF to CSV", open a dealer file, or make a SIF readable. For the reverse direction use /csv-to-sif.

+ description: Parse a SIF (Standard Interchange Format) input into a readable preview and optionally append canonical product rows to the project's CSV library. Use when asked to convert or inspect SIF dealer data. For the reverse direction use /as:csv-to-sif.

allowed-tools:

- Read

- Write

- Edit

- Bash

- Glob

- Grep

- AskUserQuestion

- - mcp__google-sheets__get_sheet_data

- - mcp__google-sheets__update_cells

- - mcp__google-sheets__list_sheets

---

- # /sif-to-csv — SIF to CSV Converter

+ # /as:sif-to-csv — SIF to CSV Converter

- 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 a SIF input from a dealer or procurement system into a human-readable preview and canonical product rows. Translates field codes, expands options and attributes, calculates pricing, and computes totals.

## When to Use

- - Received a SIF file from a dealer and need to review it as a spreadsheet

+ - Received a SIF file from a dealer and need to review it as CSV data

- Importing dealer pricing back into your FF&E schedule

- Comparing a dealer quote (SIF) against your original specification

- - Loading dealer data into the master Google Sheet

+ - Loading dealer data into the project's `product-library.csv`

## SIF Format Reference

SIF is a text-based key-value format. Each line is `CODE=VALUE`, terminated by CRLF. Products are separated by records starting with `PN=`.

### Core fields

| 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 |

### Pricing fields

| 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) |

### Product detail fields

| 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 |

### Link fields

| 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 |

### Alternate manufacturer codes

| System | Code | Purpose |

|--------|------|---------|

| Standard | `MC` | 3-5 char manufacturer code |

| Cyncly | `MG` | Manufacturer code (replaces MC) |

| CET | `EC` | Manufacturer code (alt) |

## Step 1: Accept Input

**SIF file:**

```

- /sif-to-csv ./dealer-quote.sif

+ /as:sif-to-csv ./dealer-quote.sif

```

**Pasted SIF content:**

```

- /sif-to-csv

+ /as: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

```

## Step 2: Parse SIF

Read the file and parse each record:

1. **Header fields**: Extract `SF` and `ST`

2. **Records**: Split on `PN=` boundaries

3. **For each record**, extract all fields

4. **Detect manufacturer code variant**: look for MC, MG, or EC — normalize to brand name

5. **Detect price variant**: look for PL, P1, I1 — use whichever is present

6. **Detect quantity variant**: look for QT or NT

7. **Calculate derived values**:

- Sell Price: `PL - (PL × S- × 0.01)` if discount present

- Net Price: `PL × (P% × 0.01)` if purchase % present

- Extended List: `PL × QT`

- Extended Sell: `Sell Price × QT`

### Manufacturer code expansion

| 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.

### Options and attributes

- Multiple `ON`/`OD` pairs → concatenate into "Options" column, separated by ` | `

- Multiple `AN`/`AD` pairs → concatenate into "Attributes" column, separated by ` | `

- If `AN=DIM`, parse dimension string back into W/D/H if possible

## Step 3: Present Preview

```

## SIF Import: Project Alpha — Dealer Quote March 2026

3 records parsed from dealer-quote.sif

|---|-----|---------|-------|-----|--------|--------|--------|----------|---------|-----|

| 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%)

```

## Step 4: Output

- Ask the user for output format:

- ### CSV file

- 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

- ```

- ### Google Sheet (master schema)

- 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:

+ Show the parsed table in Markdown. For persistence, write only to the nearest project-root `product-library.csv`. Read `../../schema/product-schema.md`, `../../schema/csv-conventions.md`, and `../../schema/sif-crosswalk.md`. Map by these named fields:

- - Column J (Link) ← ProductURL

- - Column E (Product Name) ← PD

- - Column I (SKU) ← PN

- - Column B (Brand) ← MC expanded

- - Column A (Category) ← GC or PRC

- - Column L-P (Dims) ← parsed from AD where AN=DIM

- - Column Q (Weight) ← WT

- - Column U (List Price) ← PL/P1/I1

- - Column V (Sale Price) ← calculated sell price

- - Column T (Selected Finish) ← OD

- - Column AC (Image URL) ← ImageURL

- - Column AD (Tags) ← TG

- - Column AE (Notes) ← "From SIF: {ST}. Discount: {S-}%. Qty: {QT} · Ext: ${ext_sell}"

- - Column AF (Status) ← "quoted"

- - Column AG (Source) ← "sif-to-csv"

+ - `Link` ← ProductURL; `Product Name` ← PD; `SKU` ← PN; `Brand` ← expanded MC

+ - `Category` ← GC or PRC; dimensions ← AD where AN=DIM; `Weight` ← WT

+ - `List Price` ← PL/P1/I1; `Sale Price` ← calculated sell price; `Selected Color/Finish` ← OD

+ - `Image URL` ← ImageURL; `Tags` ← TG; `Status` ← `quoted`; `Source` ← `sif-to-csv`

+ - `Notes` ← `From SIF: {ST}. Discount: {S-}%. Qty: {QT} · Ext: ${ext_sell}`

- ### Markdown

- Output the table in conversation.

+ Preview the complete batch's row mappings, totals, warnings, and target path, then use the single confirmation gate. After approval, serialize all complete rows as one JSON array and invoke `python3 "${CLAUDE_PLUGIN_ROOT}/skills/master-schedule/scripts/csv-library.py" append product --project <project-root> --row-json <batch.json>` exactly once. The helper validates the complete batch and library before one atomic replacement; never loop per row.

## Step 5: Summary

```

✓ 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: ./dealer-quote-parsed.csv

+ Saved to: ./product-library.csv

```

## Pairs With

- - `/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

+ - `/as:csv-to-sif` — round-trip: create SIF, send to dealer, parse their quote back

+ - `/as:product-data-cleanup` — normalize the parsed data

+ - `/as:product-data-import` — reformulate dealer data into a formatted schedule

+ - `/as:product-enrich` — add categories and tags to imported products