Units of measure (UOM) are setup in the backend also known as the SQL database.
They are customisable however there is a standard list included by default.
UOM are allocated to tender options in the Admin > Tenders > Options page under the details of the option;
To change or add to the list of UOM that appears in the tender options admin page please use the below scripts;
To create a new UOM:
INSERT INTO tblvalidationentries (
fkidbusinessunit
,cdvalidcode
,sgdisplay
,sgvalue
)
VALUES (
'0'
,'UNITS'
,'Unit_of_measure'
,'Name_of_unit_of_Measure'
)
e.g.
INSERT INTO tblvalidationentries (
fkidbusinessunit
,cdvalidcode
,sgdisplay
,sgvalue
)
VALUES (
'0'
,'UNITS'
,'m'
,'METRE'
)
To update an existing UOM:
1. Check what all of the id's are;
SELECT * from tblValidationEntries
WHERE cdValidCode like 'units%'
2. Find the one you need to update and run the below script
UPDATE tblvalidationentries
SET sgDisplay = 'Unit_of_measure', sgValue = 'Name_of_unit_of_Measure'
WHERE idValidationEntry = idValidationEntry
e,g,
UPDATE tblvalidationentries
SET sgDisplay = 'ea.', sgValue = 'Each'
WHERE idValidationEntry = 4691