Product Sync.<br>
Opencart products: 252<br>
Input products: 100<br>
<hr>NEW: 102201899<br>
<hr>NEW: 102201999<br>
<hr>NEW: 102202099<br>
<hr>NEW: 102202199<br>
<hr>NEW: 102202299<br>
<hr>NEW: 102202399<br>
<hr>NEW: 102202499<br>
<hr>NEW: 102202599<br>
<hr>NEW: 102202699<br>
<hr>NEW: 102202799<br>
<hr>NEW: 102202899<br>
<hr>NEW: 102202999<br>
<hr>NEW: 102203099<br>
<hr>NEW: 102203199<br>
<hr>NEW: 102203299<br>
<hr>NEW: 102203399<br>
<hr>NEW: 102203499<br>
<hr>NEW: 102203599<br>
<hr>NEW: 102203699<br>
<hr>NEW: 102203799<br>
<hr>NEW: 102203899<br>
<hr>NEW: 102203999<br>
<hr>NEW: 102204099<br>
<hr>NEW: 102204199<br>
<hr>NEW: 102204299<br>
<hr>NEW: 102204399<br>
<hr>NEW: 102204499<br>
<hr>NEW: 102204599<br>
<hr>NEW: 102204699<br>
<hr>NEW: 102204799<br>
<hr>NEW: 102204899<br>
<hr>NEW: 102204999<br>
<hr>NEW: 102205099<br>
<hr>NEW: 102205199<br>
<hr>NEW: 102205299<br>
<hr>NEW: 102205399<br>
<hr>NEW: 102205499<br>
<br>DELETE FROM oc_product_option_value 
			WHERE
				option_value_id = (
					SELECT
						MAX(option_value_id)
					FROM
						oc_option_value_description
					WHERE
						name LIKE '102205499 - %'
				)
		<hr>NEW: 102205599<br>
<hr>NEW: 102205699<br>
<hr>NEW: 102205799<br>
<hr>NEW: 102205899<br>
<hr>NEW: 102205999<br>
<hr>NEW: 102206099<br>
<hr>NEW: 102206199<br>
<hr>NEW: 102206299<br>
<hr>NEW: 102206399<br>
<hr>NEW: 102206499<br>
<hr>NEW: 102206599<br>
<hr>NEW: 102206699<br>
<hr>NEW: 102206799<br>
<hr>NEW: 102206899<br>
<hr>NEW: 102206999<br>
<hr>NEW: 102207099<br>
<hr>NEW: 102207199<br>
<hr>NEW: 102207299<br>
<hr>NEW: 102207399<br>
<hr>NEW: 102207499<br>
<hr>NEW: 102207599<br>
<hr>NEW: 102207699<br>
<hr>NEW: 102207799<br>
<hr>NEW: 102207899<br>
<hr>NEW: 102207999<br>
<hr>NEW: 102208099<br>
<hr>NEW: 102208199<br>
<hr>NEW: 102208299<br>
<hr>NEW: 102208399<br>
<hr>NEW: 102208499<br>
<hr>NEW: 102208599<br>
<hr>NEW: 102208699<br>
<hr>NEW: 102208799<br>
<hr>NEW: 102208899<br>
<hr>NEW: 102208999<br>
<hr>NEW: 102209099<br>
<hr>NEW: 102209199<br>
<hr>NEW: 102209299<br>
<hr>NEW: 102209399<br>
<hr>NEW: 102209499<br>
<hr>NEW: 102209599<br>
<hr>NEW: 102209699<br>
<hr>NEW: 102209799<br>
<hr>NEW: Cavalete Caixa Talens Aurore<br>
<br>DELETE FROM oc_product_option_value 
			WHERE
				option_value_id = (
					SELECT
						MAX(option_value_id)
					FROM
						oc_option_value_description
					WHERE
						name LIKE 'Cavalete Caixa Talens Aurore - %'
				)
		<hr>NEW: 102209999<br>
<hr>NEW: 102210099<br>
<hr>NEW: 102210199<br>
<hr>NEW: 102210299<br>
<hr>NEW: 102210399<br>
<hr>NEW: 102210499<br>
<hr>NEW: 102210599<br>
<hr>NEW: 102210699<br>
<hr>NEW: 102210799<br>
<hr>NEW: 102210899<br>
<hr>NEW: 102210999<br>
<hr>NEW: 102211099<br>
<hr>NEW: 102211199<br>
<hr>NEW: 102211299<br>
<hr>NEW: 102211399<br>
<hr>NEW: 102211499<br>
<hr>NEW: 102211599<br>
<hr>NEW: 102211699<br>
<hr>NEW: 102211799<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 254<br>
Input products: 100<br>
<hr>SELECT option_id FROM oc_option_description 
			WHERE
				NAME = 'Opção'
		<br>SELECT product_option_id FROM oc_product_option 
				WHERE
					product_id = 27242
					AND option_id = 15
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27242,
						option_id = 15,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '102209899 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1609
					<br>UPDATE oc_option_value_description 
						SET
							name = '102209899 - Cavalete Caixa Talens Aurore'
						WHERE
							option_value_id = 1609
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 337
							AND product_id = 27242
							AND option_id = 15
							AND option_value_id = 1609

				<br>DELETE FROM oc_product
					WHERE
						model = '102209899'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 337,
								product_id = 27242,
								option_id = 15,
								option_value_id = 1609,
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br><hr>Ok.<hr><hr>