def lookup_product(product_name): #Get the Item #items = Item.all(qb=qb_client) item_count = Item.count("Name = '" + product_name + "'", qb=qb_client) if item_count == 1: items = Item.where("Name = '" + product_name + "'", qb=qb_client) return items[0].Id else: logging.error("Product name: [{}] not found. Please add this product to quickbook before this record can be added".format(product_name))