Product Sync.<br>
Opencart products: 15<br>
Input products: 100<br>
<hr>NEW: 100202099<br>
<hr>NEW: 100202199<br>
<hr>NEW: 100202299<br>
<hr>NEW: 100202399<br>
<hr>NEW: 100202499<br>
<hr>NEW: 100202599<br>
<hr>NEW: 100202699<br>
<hr>NEW: 100202799<br>
<hr>NEW: 100202899<br>
<hr>NEW: 100202999<br>
<hr>NEW: 100203099<br>
<hr>NEW: 100203199<br>
<hr>NEW: 100203299<br>
<hr>NEW: 100203399<br>
<hr>NEW: 100203499<br>
<hr>NEW: 100203599<br>
<hr>NEW: 100203699<br>
<hr>NEW: 100203799<br>
<hr>NEW: 100203899<br>
<hr>NEW: 100203999<br>
<hr>NEW: 100204099<br>
<hr>NEW: 100204199<br>
<hr>NEW: 100204299<br>
<hr>NEW: 100204399<br>
<hr>NEW: 100204499<br>
<hr>NEW: 100204599<br>
<hr>NEW: 100204699<br>
<hr>NEW: 100204799<br>
<hr>NEW: 100204899<br>
<hr>NEW: 100204999<br>
<hr>NEW: 100205099<br>
<hr>NEW: 100205199<br>
<hr>NEW: 100205299<br>
<hr>NEW: 100205399<br>
<hr>NEW: 100205499<br>
<hr>NEW: 100205599<br>
<hr>NEW: 100205699<br>
<hr>NEW: 100205799<br>
<hr>NEW: 100205899<br>
<hr>NEW: 100205999<br>
<hr>NEW: 100206099<br>
<hr>NEW: 100206199<br>
<hr>NEW: 100206299<br>
<hr>NEW: 100206399<br>
<hr>NEW: 100206499<br>
<hr>NEW: 100206599<br>
<hr>NEW: 100206699<br>
<hr>NEW: 100206799<br>
<hr>NEW: 100206899<br>
<hr>NEW: 100206999<br>
<hr>NEW: 100207099<br>
<hr>NEW: 100207199<br>
<hr>NEW: 100207299<br>
<hr>NEW: 100207399<br>
<hr>NEW: 100207499<br>
<hr>NEW: 100207599<br>
<hr>NEW: 100207699<br>
<hr>NEW: 100207799<br>
<hr>NEW: 100207899<br>
<hr>NEW: Cotman W&N TB 8ml<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 'Cotman W&N TB 8ml - %'
				)
		<hr>NEW: 100208099<br>
<hr>NEW: 100208199<br>
<hr>NEW: 100208299<br>
<hr>NEW: 100208399<br>
<hr>NEW: 100208499<br>
<hr>NEW: 100208599<br>
<hr>NEW: 100208699<br>
<hr>NEW: 100208799<br>
<hr>NEW: 100208899<br>
<hr>NEW: 100208999<br>
<hr>NEW: 100209099<br>
<hr>NEW: 100209199<br>
<hr>NEW: 100209299<br>
<hr>NEW: 100209399<br>
<hr>NEW: 100209499<br>
<hr>NEW: 100209599<br>
<hr>NEW: 100209699<br>
<hr>NEW: 100209799<br>
<hr>NEW: 100209899<br>
<hr>NEW: 100209999<br>
<hr>NEW: 100210099<br>
<hr>NEW: 100210199<br>
<hr>NEW: 100210299<br>
<hr>NEW: 100210399<br>
<hr>NEW: 100210499<br>
<hr>NEW: 100210599<br>
<hr>NEW: 100210699<br>
<hr>NEW: 100210799<br>
<hr>NEW: 100210899<br>
<hr>NEW: 100210999<br>
<hr>NEW: 100211099<br>
<hr>NEW: 100211199<br>
<hr>NEW: 100211299<br>
<hr>NEW: 100211399<br>
<hr>NEW: 100211499<br>
<hr>NEW: 100211599<br>
<hr>NEW: 100211699<br>
<hr>NEW: 100211799<br>
<hr>NEW: 100211899<br>
<hr>NEW: 100211999<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 16<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 = 27387
					AND option_id = 17
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27387,
						option_id = 17,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100207999 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 962
					<br>UPDATE oc_option_value_description 
						SET
							name = '100207999 - AGUAR W&N COTMAN 8ML MAUVE'
						WHERE
							option_value_id = 962
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 380
							AND product_id = 27387
							AND option_id = 17
							AND option_value_id = 962

				<br>DELETE FROM oc_product
					WHERE
						model = '100207999'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 380,
								product_id = 27387,
								option_id = 17,
								option_value_id = 962,
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br><hr>Ok.<hr><hr>