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