OpenCart 🇺🇦

if(isset($dataArray['fields']['item-price'])) {
	$price = $dataArray['fields']['item-price'];
} else if(isset($dataArray['fields']['price'])) {
	$price = $dataArray['fields']['price'];
} else if(isset($dataArray['fields']['StandardPrice'])) {
	$price = $dataArray['fields']['StandardPrice'];
}   else {
	$price = 0;
}

$category = (isset($dataArray['category'])) ? $dataArray['category'] : "";
$sku = (isset($dataArray['fields']['sku'])) ? $dataArray['fields']['sku'] : "";
if(isset($dataArray['fields']['sku'])) {
	$sku = $dataArray['fields']['sku'];
} else if(isset($dataArray['fields']['SKU'])) {
	$sku = $dataArray['fields']['SKU'];
}

$var = isset($dataArray['optionVar']) ? $dataArray['optionVar'] : '';

$marketplaces = isset($dataArray['marketplace_ids']) ? serialize($dataArray['marketplace_ids']) : serialize(array());

$dataEncoded = json_encode(array('fields' => $dataArray['fields']));

$this->db->query("
	REPLACE INTO `" . DB_PREFIX . "amazon_product`
	SET `product_id` = '" . (int)$product_id . "',
		`sku` = '" . $this->db->escape($sku) . "',
		`category` = '" . $this->db->escape($category) . "',
		`data` = '" . $this->db->escape($dataEncoded) . "',
		`status` = 'saved',
		`insertion_id` = '',
		`price` = '" . $price . "',
		`var` = '" . $this->db->escape($var) . "',
		`marketplaces` = '" . $this->db->escape($marketplaces) . "'");