- Changed the location field of products to a serial field in accordance with the db model - removed unnecessary if clauses - significantly expanded available functions