← All projects
PRJ-15
Jan 2026 · a high-mix architectural lighting manufacturer in Montreal
90 CRI LED Board Transition
Data Migration · Product Standardization
Data & SQL
Executed the automation data migration from 80 CRI to 90 CRI boards across all 472 products — staged SQL updates, chip-data validation, and BOM correction with the BOM team.
STANDARDIZATION
80 + 90 CRI→90 CRI
PRODUCTS COVERED
—→472
Problem
The company offered both 80 CRI and 90 CRI boards, which multiplied part numbers, data, rules and stock.
Approach
- Mass-updated the SQL board-to-fixture assignment tables in stages as each board passed mechanical and electrical testing
- Retired the 80 CRI boards, added the 90 CRI boards and linked each board's chip data
- Validated with test ordering codes against the new chip coefficients and checked driver currents
- Flagged wrongly entered chip data, incorrect board callouts in shop-drawing notes and BOM entries with old part numbers, and worked with the BOM team to correct them
Outcome
Across all 472 products, one CRI to maintain: lower LED board inventory, simpler stores picking and customer ordering, fewer automation rules and data, fewer board part numbers for BOM, and purchasing of 90 CRI boards only.
Next · PRJ-16
Product Automation Template