sif-to-csv

# /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. ## When to Use - Received a SIF file from a dealer and need to review it as a spreadsheet - 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 ## 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 ~/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 ``` ## 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 | # | 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%) ``` ## 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: - 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" ### Markdown Output the table in conversation. ## 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: ~/Documents/project/dealer-quote-parsed.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