SKU format rules and prefix conventions for ConductScience products.
All SKUs are being migrated from supplier-derived prefixes to category-coded opaque format.
See: docs/plans/2026-02-26-business-rules-design.md
Old format (DEPRECATED): {SUPPLIER_PREFIX}-{NUMBER} (e.g., RBP-0001)
New format: CS-{CAT}-{NNNNN} (e.g., CS-PMP-00001)
CS-{CAT}-{NNNNN}
-)| Code | Category | Examples |
|---|---|---|
PMP |
Pumps | Peristaltic, syringe, filling |
WQ |
Water Quality | pH meters, test strips, analyzers |
BIO |
Biotech/Life Science | PCR, histology, staining |
MIC |
Microscopy | Microscopes, lenses, cameras |
MAZ |
Behavioral/Maze | Mazes, tracking, behavioral |
IMG |
Imaging/NMR | NMR analyzers, seed analyzers |
MFL |
Microfluidics | Chips, pumps, controllers |
SRG |
Surgical/Stereotaxic | Frames, instruments |
GEN |
General Lab | Anything not fitting above |
Variant formats:
CS-BDL-{CAT}-{NNNNN}CS-SUB-{CAT}-{NNNNN}These prefixes are being replaced. The sku_migration table maps old → new.
| Old Prefix | Supplier | New Category |
|---|---|---|
RBP |
Rongbai Pump | PMP |
LHB |
Lohand Bio | WQ |
BB |
Biobase | BIO / GEN |
WH |
WenHao Microfluidic | MFL |
RF |
Roundfin | BIO |
MX |
MicroscopeX | MIC |
PI |
Pretty Industries | GEN |
SB |
Servicebio | BIO |
SN |
Sinobio/BioSino | BIO |
ME |
MazeEngineers | MAZ |
CS |
ConductScience (branded) | varies |
NM |
Niumag | IMG |
CS-PMP-00001), never a supplier-derived prefix. Old prefixes like RBP, LHB, SB are banned from new assignments.PMP category code.sku_migration table in conductops.db maps new_sku → old_sku → supplier → woo_product_id. This is the source of truth for tracing SKU lineage.| Field | Purpose | Example |
|---|---|---|
| CS SKU | Customer-facing identifier (WooCommerce _sku) |
CS-PMP-00001 |
| Old CS SKU | Previous internal SKU (in sku_migration table) |
RBP-0001 |
| Supplier SKU | Original supplier model number | RB-BT100S |
All three are tracked. Rosetta and sku_migration map between them.
sku_migration table with supplier name and old SKU (if migrating)supplier_sku in manifest{sku:path} parameter type in FastAPI.