Csv To Sif

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

Converts the nearest project's product-library.csv into a SIF output file for dealer and procurement systems such as Hedberg, CAP, CET, Cyncly Worksheet, ProjectMatrix, Studio Webware, and Design Manager.

When to Use

• Sending a specification to a dealer for quoting
• Importing product data into a dealer management system
• Sharing a standardized product list with procurement
• Converting an FF&E schedule into a format dealers expect

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

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

| SF | Specification File | No | Project reference (header, once per file) |

| ST | Specification Title | No | Display title (header, once per file) |

| PN | Product Number | Yes | SKU or model number. Marks the start of a new record. |

| PD | Product Description | Yes | Product name and description |

| MC | Manufacturer Code | Yes | 3-5 character code (HMI, KNL, STC) |

| MN | Manufacturer Name | No | Full manufacturer name |

| QT | Quantity | Yes | Integer quantity |

| NT | Quantity (alt) | No | Some systems use NT instead of QT |

| GC | Category / Group Code | No | Product category |

| G0 | Vendor / Group ID | No | Vendor or dealer identifier |

Pricing fields

| Code | Name | Description |

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

| PL | List Price | Unit list price (numeric, no currency symbol) |

| P1 | Price Tier 1 | Primary price (some systems use P1 instead of PL) |

| P2 | Price Tier 2 | Alternate price tier |

| P4 | Price Tier 4 | Alternate price tier |

| P5 | Price Tier 5 | Alternate price tier |

| I1 | Unit List Price (Cyncly) | Used by Cyncly Worksheet |

| I2 | Purchase Price (Cyncly) | Used by 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 name, area code, or project tag |

| ON | Option Number | Must pair with OD |

| OD | Option Description | Finish, fabric, color selection |

| AN | Attribute Number | Must pair with AD |

| AD | Attribute Description | Dimension, weight, or other attribute |

| WT | Weight | Product weight |

| VO | Volume | Product volume |

| PRC | Product Category (Cyncly) | Category for Cyncly Worksheet |

Link fields

| Code | Name | Description |

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

| ProductURL | Product Page URL | Link to manufacturer product page |

| ImageURL | Product Image URL | Link to product image |

| PV | Picture Path | Windows bitmap or TIF file path |

Alternate manufacturer codes (by system)

| System | Code | Purpose |

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

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

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

| Cyncly Worksheet | MN | Full manufacturer name |

| CET / Configura | EC | Manufacturer code (alt) |

File structure example

SF=Project Alpha - FF&E Specification
ST=FF&E Schedule — March 2026
PN=670
PD=Eames Lounge Chair and Ottoman
MC=HMI
MN=Herman Miller
GC=Seating
QT=3
PL=5695.00
WT=92
TG=Executive Lounge
OD=Santos Palisander / Black MCL Leather
AN=DIM
AD=32.75W x 32.5D x 33.5H in
ProductURL=https://www.hermanmiller.com/products/seating/lounge-seating/eames-lounge-chair-and-ottoman/
ImageURL=https://www.hermanmiller.com/content/dam/hmicom/page_assets/products/eames_lounge_chair_and_ottoman/mh_prd_ovw_eames_lounge_chair_and_ottoman.jpg

PN=164-500
PD=Saarinen Round Dining Table 54"
MC=KNL
MN=Knoll
GC=Tables
QT=1
PL=4750.00
TG=Dining Area
OD=Arabescato Marble Top / White Base
AN=DIM
AD=54dia x 28.5H in

Rules

• Each line is one field: CODE=VALUE
• Lines terminated by CRLF
• Blank line between records
• PN starts a new record — must come first in each record
• ON/OD and AN/AD pairs must stay together
• No embedded line breaks within a field value
• Empty values use CODE= with nothing after the equals sign

Step 1: Accept Input

Read ../../schema/product-schema.md and ../../schema/csv-conventions.md. Default to the nearest ancestor containing PROJECT.md and validate its product-library.csv with python3 "${CLAUDE_PLUGIN_ROOT}/skills/master-schedule/scripts/csv-library.py" validate product --project <project-root> before conversion. This skill is read-only with respect to the CSV; its structured output remains SIF.

CSV file:

/as:csv-to-sif ./product-data-import.csv

Pasted CSV:

/as:csv-to-sif
Product,Brand,SKU,Qty,Price,Finish,Room
Eames Lounge Chair,Herman Miller,670,3,5695,Walnut/Black Leather,Executive Lounge
Saarinen Table 54,Knoll,164-500,1,4750,Arabescato/White,Dining

Step 2: Choose Target System

Ask which dealer system the SIF file is for (affects which field codes to use):

Target system:
1. Standard (Hedberg, CAP, ProjectMatrix) — default
2. CET / Configura (SPEC)
3. Cyncly Worksheet (CAPSIF)
4. Design Manager

Default to Standard if not specified. The main differences:

• Standard: MC for manufacturer, PL for price, QT for quantity
• CET: EC for manufacturer, standard pricing
• Cyncly: MG/MN for manufacturer, I1/I2 for pricing, PRC for category
• Design Manager: Standard + DXSC, DXBD, DXLC, DXLN extensions

Step 3: Map Columns

Auto-detect column mappings from header names:

| CSV Column (common names) | SIF Field |

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

| Product Name, Name, Description, Product | PD |

| SKU, Model, Part Number, Product Number | PN |

| Brand, Manufacturer | MC + MN |

| Qty, Quantity, Count | QT |

| Price, List Price, Unit Price | PL |

| Finish, Color, Configuration | OD |

| Room, Location, Area, Tag, Side Mark | TG |

| Category | GC |

| Weight | WT |

| Discount, Discount % | S- |

| URL, Product URL, Link | ProductURL |

| Image, Image URL | ImageURL |

| W, D, H (dimensions) | AD (with AN=DIM) |

If using the master 33-column schema (defined in ../../schema/product-schema.md):

See ../../schema/sif-crosswalk.md for the full column-to-SIF mapping. Key fields:

| Column | SIF Field |

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

| A (Category) | GC |

| B (Brand) | MC + MN |

| E (Product Name) | PD |

| I (SKU) | PN |

| J (Link) | ProductURL |

| L-P (W, D, H, Seat H, Unit) | AD (with AN=DIM) |

| Q (Weight) | WT |

| R (Materials) | AD (with AN=MAT) |

| S (Colors/Finishes) | OD (with ON=FIN) |

| T (Selected Color/Finish) | OD (primary, replaces S if present) |

| U (List Price) | PL |

| AC (Image URL) | ImageURL |

| AD (Tags) | TG |

If the mapping is ambiguous, ask the user to confirm.

Manufacturer code lookup

Convert full brand names to standard 3-5 character codes:

| Brand | MC Code | Brand | MC Code |

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

| Herman Miller | HMI | Blu Dot | BLU |

| MillerKnoll | MKN | Design Within Reach | DWR |

| Knoll | KNL | Fritz Hansen | FRH |

| Steelcase | STC | Vitra | VIT |

| Haworth | HAW | Arper | ARP |

| Teknion | TEK | Muuto | MUU |

| Humanscale | HUM | HAY | HAY |

| Kimball | KIM | Flos | FLS |

| National | NAT | Louis Poulsen | LPO |

| OFS | OFS | Artemide | ART |

| HBF | HBF | Restoration Hardware | RHB |

| Bernhardt | BRN | West Elm | WEL |

| Geiger | GEI | CB2 | CB2 |

For unknown brands, use first 3-5 characters uppercased. Flag for the user to verify.

Step 4: Preview

Show a preview of the first 3 records before generating the file:

## SIF Preview (first 3 of 12 records)

Record 1:
  PN=670
  PD=Eames Lounge Chair and Ottoman
  MC=HMI
  MN=Herman Miller
  GC=Seating
  QT=3
  PL=5695.00
  WT=92
  TG=Executive Lounge
  OD=Santos Palisander / Black MCL Leather
  AN=DIM
  AD=32.75W x 32.5D x 33.5H in

...

12 records total. Generate SIF file? (y/n)

Step 5: Generate SIF File

Write the .sif file with CRLF line endings:

# Output path: same directory as input, or specified path
{input-dir}/{input-name}.sif

Step 6: Summary

✓ Generated product-data-import.sif
  Target: Standard (Hedberg/CAP/ProjectMatrix)
  12 records · 8 fields per record avg
  Manufacturers: HMI (5), KNL (3), STC (2), BLU (2)
  Total list value: $47,830.00
  Saved to: ./product-data-import.sif

Pairs With

• /as:product-data-import — generate a schedule first, then convert to SIF
• /as:sif-to-csv — round-trip: CSV → SIF → send to dealer → receive updated SIF → back to CSV
• /as:product-data-cleanup — clean up the CSV before converting