sku-canonicalization-buddy

Internal SKU canonicalization policy. Apply it exactly; the rules are company-specific and override general intuition.

Nebula Gadgets Inc. SKU Canonicalization Policy

Welcome to the Nebula Gadgets Inc. Inventory Management System. Over the years, our regional distributors have submitted inventory logs using highly inconsistent naming conventions, abbreviations, and typos. This policy serves to map these messy real-world variants to our strict internal canonical SKU codes.

Canonical Codes

All incoming messy strings must be mapped to one of the following 5 canonical SKU codes:

1. NGI-WIDGET-X1: The Quantum Widget.
2. NGI-SPROCKET-B: The Hyper Sprocket.
3. NGI-GIZMO-99: The Plasma Gizmo.
4. NGI-DOOHICKEY-Z: The Grav Doohickey.
5. NGI-THINGAMABOB-Q: The Aether Thingamabob.

Mapping Guidelines

Look for key substrings and abbreviations to determine the correct canonical SKU:

• Quantum Widget variants: Look for q-widget, quantumwidg, qw-x1, quant-widget, q_widg.
• Hyper Sprocket variants: Look for hypsprocket, sprocket model b, hyper-sproc, h-sprocket, hyp-sprckt.
• Plasma Gizmo variants: Look for plasmagiz, plsm-gzm, gizmo99, plasma_gizmo, plsm-gz.
• Grav Doohickey variants: Look for gravdoohickey, doohickey-z, grav-doo, g-doohickey.
• Aether Thingamabob variants: Look for aetherthing, thingamabob-q, aether-tbob, athr-thingamabob.

Ignore extra tags related to condition (e.g., USED, REFURB, NEW), color (blk), or generational markers (MK1) unless they conflict with the primary product identifier.