I would like to be able to store the cost of a product on the DB, this is in addition to the sale price. Is this something I am missing on the setup or does it not exist as standard?
You can create a custom field of the table "product" (commercial edition) via the menu Display>Custom fields so that you can enter additional information for your products.