← 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

→