Duplicate handling rules
Per-table rules for what happens when an incoming row collides with an existing one. Parts upsert; customers merge by email; quotes keep every revision; suppliers stay hands-off.
Duplicate handling rules is a reusable Oak Flats Muffler Men UI primitive with documented states, accessibility expectations, theme behavior, and implementation evidence.
Duplicate handling rules: Per-table rules for what happens when an incoming row collides with an existing one. Parts upsert; customers merge by email; quotes keep every revision; suppliers stay hands-off.
Duplicate handling rules
- part_number
When the same SKU is already in the parts catalog, update the existing row with the incoming RRP and stock.
- email_norm
If a customer email matches, merge with prefer-most-recent for phone and suburb.
- customer_idvehicle_id
Quotes for the same customer + vehicle should be kept as separate revisions.
- supplier_slug
Suppliers are managed manually — skip incoming rows that match an existing slug.