Wheels — Check Part Number

Check wheel part numbers against the generation formula and optionally fix mismatches. Default mode is check-only (dry run).

Part Number Formula (Version 1)

DesignNO + [P+Profile] + [Directional 1st letter] + Dia + WidthCode + Holes
+ PCD1Code + [PCD2Code] + ET + FinishShortName + AppendantShortNames
+ BoltShortName + CBCode + CapNO

Usage: efision -r <region> wheels check-pn [--fix] [filter flags...]

Plus all wheel filter flags.

Examples

Check only (dry run):

efision -r demo wheels check-pn

Efision Wheels Part Number Check
============================================================

Region:  DEMO
Mode:    Check only (dry run)

Checking part numbers... done.

Total checked:    7405
Correct:          7390
Mismatched:       12
Lookup errors:    3

Mismatched Part Numbers:
------------------------------------------------------------------------------------------------------------------------
    #       ID  Brand          Name           Current pNO                  Expected pNO                 Status
------------------------------------------------------------------------------------------------------------------------
    1     1001  INOVIT         Speed          06719Y5V40S4AK               067P3L19Y5V40S4AK            Active
    2     1002  INOVIT         Force          03418M4V-18SMF4AK            034P2R18M4V-18SMF4AK         Active
  ...

INFO Run with --fix to update these part numbers.

Fix mismatches:

efision -r demo wheels check-pn --fix

Filter by brand:

efision -r demo wheels check-pn --brand INOVIT

Filter by model (name or design number):

efision -r demo wheels check-pn --model Torque
efision -r demo wheels check-pn --model 067

Notes

• Only Product.pNO is modified (no other tables changed)
• Updates are wrapped in a database transaction (all-or-nothing)
• Lookup errors indicate missing entries in reference tables. Fix lookup tables first, then re-run.
• --model matches both design name (pdName) and design number (pdNO)