OpenCart 🇺🇦

/**
* Gets the product info from an ID and sends to ebay update method.
*/
$this->log('ebaySaleStockReduce() - Is stock update needed (Item ID: '.$product_id.',SKU: '.$sku.')');

if(!empty($product_id)) {
	if($sku == null) {
		$query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "product` WHERE `product_id` = '".(int)$product_id."' LIMIT 1");
		$this->log('ebaySaleStockReduce() - Send item ID: "'.$product_id.'", Stock: "'.$query->row['quantity'].'" to decideEbayStockAction()');
		$this->decideEbayStockAction($product_id, $query->row['quantity'], $query->row['subtract']);
	}else{
		$query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "product_option_relation` WHERE `product_id` = '".(int)$product_id."' AND `var` = '".$sku."' LIMIT 1");
		$this->log('ebaySaleStockReduce() - Send item ID: '.$product_id.', VAR: '.$sku.', passing '.$query->row['stock'].' to decideEbayStockAction()');
		$this->decideEbayStockAction($product_id, $query->row['stock'], $query->row['subtract'], $sku);
	}
}