csv-to-sif
Export a project's FF&E product-library CSV as dealer-system SIF. Use to produce a .sif schedule; use sif-to-csv for the reverse direction.
AlpacaLabsLLC · AI review on file
Installation
Read the source and dependencies before running a command. Copying does not install or execute anything.
npx skills add AlpacaLabsLLC/skills-for-architects --skill csv-to-sifAbout this skill
name: csv-to-sif description: Export a project's FF&E product-library CSV as dealer-system SIF. Use to produce a .sif schedule; use sif-to-csv for the reverse direction. allowed-tools:
- Read
- Write
- Edit
- Bash
- Glob
- Grep
- AskUserQuestion
/as:csv-to-sif — CSV to SIF Converter
Harness note: use
/as:<skill>on Claude Code and$<skill>on Codex. Resolve<skill-root>as the directory containing this loadedSKILL.mdand<plugin-root>as the plugin root that containsskills/, and use equivalent native tools when host tool names differ.
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
PNstarts a new record — must come first in each recordON/ODandAN/ADpairs 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 "<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 manufact