Openbravo POS has a built in search function that allows us to search by the product name, barcode, category and price ranges.
The functionality that we need built in is a search by SKU. We store all of the SKUs in the "REFERENCE" field of the "PRODUCTS" table.
Our database that we run is MySQL, the he fix should not remove any existing functionality.
The version of Openbravo POS is 2.30.2, we will need an easy way of patching the existing installations as we have multiple terminals.