Sif To CSV

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

Harness note: use /as:<skill> on Claude Code and $<skill> on Codex. Resolve <skill-root> as the directory containing this loaded SKILL.md and <plugin-root> as the plugin root that contains skills/, and use equivalent native tools when host tool names differ.

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

Pricing fields

Product detail fields

Link fields

Alternate manufacturer codes

Step 1: Accept Input

SIF file:

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

Pasted SIF content:

/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

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

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:

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

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 "<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: ./product-library.csv

Pairs With

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