finish coding and testing update_and_retrieve_stock_from_odb