📋 Advanced Unit Normalization Features
⚖️ Weight Equivalents
All treated as "ton":
ton
tons
tonne
tonnes
tn
t
📐 Area Equivalents
All treated as "square foot":
sq ft
SF
sq. ft.
sqft
square feet
sq foot
📏 Length Equivalents
All treated as "linear foot":
Linear Feet
lf
linear ft
lin feet
l.f.
lin. ft.
📦 Volume Equivalents
All treated as "cubic yard":
Cubic Yard
Cubic Yards
cu yd
cyd
cubic yd
cu. yd.
📁 Required CSV Format
Columns can have any of these names:
Name Column: name, product, item, productname
Supplier Column: supplier, vendor, manufacturer
Category Column: category, type, group
Unit Column: unit, uom, measurement
Cost Column: cost, price, unitcost
Supplier Column: supplier, vendor, manufacturer
Category Column: category, type, group
Unit Column: unit, uom, measurement
Cost Column: cost, price, unitcost
Example Comparison Results:
"Steel Beam", "Supplier A", "Construction", "ton", 1250.00
"Steel Beam", "Supplier A", "Construction", "tons", 1250.00
→ Result: Identical (tons normalized to ton)
"Flooring", "Supplier B", "Materials", "sq ft", 5.99
"Flooring", "Supplier B", "Materials", "SF", 5.99
→ Result: Identical (SF normalized to square foot)
"Steel Beam", "Supplier A", "Construction", "ton", 1250.00
"Steel Beam", "Supplier A", "Construction", "tons", 1250.00
→ Result: Identical (tons normalized to ton)
"Flooring", "Supplier B", "Materials", "sq ft", 5.99
"Flooring", "Supplier B", "Materials", "SF", 5.99
→ Result: Identical (SF normalized to square foot)