UOM mix-up check
Compare the same item's price from two sources. About 10×, 100× or 1000× apart almost always means one was loaded in the wrong UOM.
Try an example
Convert from
$1.25 vs $125.00
How it's calculated
- Flags a ratio within 5% of 10, 100 or 1000.
Worked examples
$1.25 vs $125.00
- Likely UOM mix-up: 100× apart
- B ÷ A: × 100
- B corrected: $1.25
$450.00 vs $0.46
- Likely UOM mix-up: 1000× apart
- B ÷ A: × 0.001
- A corrected: $0.45
$10.00 vs $12.00
- No UOM mix-up pattern: OK
- B ÷ A: × 1.2
