OpenCart 🇺🇦

$skuArray = array();

foreach ($skus as $sku) {
	$skuArray[] = "'" . $this->db->escape($sku) . "'";
}

if ($this->openbay->addonLoad('openstock')) {
	$rows = $this->db->query("
		SELECT apl.amazon_sku, IF(por.product_id IS NULL, p.quantity, por.stock) AS 'quantity'
		FROM " . DB_PREFIX . "amazonus_product_link apl
		JOIN " . DB_PREFIX . "product p ON apl.product_id = p.product_id
		LEFT JOIN " . DB_PREFIX . "product_option_relation por ON apl.product_id = por.product_id AND apl.var = por.var
		WHERE apl.amazon_sku IN (" . implode(',', $skuArray) . ")
	")->rows;
} else {
	$rows = $this->db->query("
		SELECT apl.amazon_sku, p.quantity
		FROM " . DB_PREFIX . "amazonus_product_link apl
		JOIN " . DB_PREFIX . "product p ON apl.product_id = p.product_id
		WHERE apl.amazon_sku IN (" . implode(',', $skuArray) . ")
	")->rows;
}

$return = array();

foreach ($rows as $row) {
	$return[$row['amazon_sku']] = $row['quantity'];
}

$this->openbay->amazonus->updateQuantities($return);