implemented create for sqlgateway, handled case when available stocks < number being sold