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

Price A and B on a logarithmic scale, 100 times apart1101001,000AB
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

Back to top ▲