Product Sync.<br>
Opencart products: 53<br>
Input products: 100<br>
<hr>NEW: 100373899<br>
<hr>NEW: 100373999<br>
<hr>NEW: 100374099<br>
<hr>NEW: 100374199<br>
<hr>NEW: 100374299<br>
<hr>NEW: 100374399<br>
<hr>NEW: 100374499<br>
<hr>NEW: 100374599<br>
<hr>NEW: 100374699<br>
<hr>NEW: 100374799<br>
<hr>NEW: 100374899<br>
<hr>NEW: 100374999<br>
<hr>NEW: 100375099<br>
<hr>NEW: 100375199<br>
<hr>NEW: 100375299<br>
<hr>NEW: 100375399<br>
<hr>NEW: 100375499<br>
<hr>NEW: Tinta Vitral Pébéo<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 'Tinta Vitral Pébéo - %'
				)
		<hr>NEW: 100375699<br>
<hr>NEW: 100375799<br>
<hr>NEW: 100375899<br>
<hr>NEW: 100375999<br>
<hr>NEW: 100376099<br>
<hr>NEW: 100376199<br>
<hr>NEW: 100376299<br>
<hr>NEW: 100376399<br>
<hr>NEW: 100376499<br>
<hr>NEW: 100376599<br>
<hr>NEW: 100376699<br>
<hr>NEW: 100376799<br>
<hr>NEW: 100376899<br>
<hr>NEW: 100376999<br>
<hr>NEW: 100377099<br>
<hr>NEW: 100377199<br>
<hr>NEW: 100377299<br>
<hr>NEW: 100377399<br>
<hr>NEW: 100377499<br>
<hr>NEW: 100377599<br>
<hr>NEW: 100377699<br>
<hr>NEW: 100377799<br>
<hr>NEW: 100377899<br>
<hr>NEW: 100377999<br>
<hr>NEW: 100378099<br>
<hr>NEW: 100378199<br>
<hr>NEW: 100378299<br>
<hr>NEW: 100378399<br>
<hr>NEW: 100378499<br>
<hr>NEW: 100378599<br>
<hr>NEW: 100378699<br>
<hr>NEW: 100378799<br>
<hr>NEW: 100378899<br>
<hr>NEW: 100378999<br>
<hr>NEW: 100379099<br>
<hr>NEW: 100379199<br>
<hr>NEW: 100379299<br>
<hr>NEW: 100379399<br>
<hr>NEW: 100379499<br>
<hr>NEW: 100379599<br>
<hr>NEW: 100379699<br>
<hr>NEW: 100379799<br>
<hr>NEW: 100379899<br>
<hr>NEW: 100379999<br>
<hr>NEW: 100380099<br>
<hr>NEW: 100380199<br>
<hr>NEW: 100380299<br>
<hr>NEW: 100380399<br>
<hr>NEW: 100380499<br>
<hr>NEW: 100380599<br>
<hr>NEW: 100380699<br>
<hr>NEW: 100380799<br>
<hr>NEW: 100380899<br>
<hr>NEW: 100380999<br>
<hr>NEW: 100381099<br>
<hr>NEW: 100381199<br>
<hr>NEW: 100381299<br>
<hr>NEW: 100381399<br>
<hr>NEW: 100381499<br>
<hr>NEW: 100381599<br>
<hr>NEW: 100381699<br>
<hr>NEW: 100381799<br>
<hr>NEW: 100381899<br>
<hr>NEW: 100381999<br>
<hr>NEW: 100382099<br>
<hr>NEW: 100382199<br>
<hr>NEW: 100382299<br>
<hr>NEW: 100382399<br>
<hr>NEW: 100382499<br>
<hr>NEW: 100382599<br>
<hr>NEW: 100382699<br>
<hr>NEW: 100382799<br>
<hr>NEW: 100382899<br>
<hr>NEW: 100382999<br>
<hr>NEW: 100383099<br>
<hr>NEW: 100383199<br>
<hr>NEW: 100383299<br>
<hr>NEW: 100383399<br>
<hr>NEW: 100383499<br>
<hr>NEW: 100383599<br>
<hr>NEW: 100383699<br>
<hr>NEW: 100383799<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 54<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 = 27451
					AND option_id = 17
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27451,
						option_id = 17,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100375599 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3273 AS option_value_id,
							language_id,
							17 AS option_id,
							'100375599 - Tinta Vitral Pébéo Cinzento' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 430
							AND product_id = 27451
							AND option_id = 17
							AND option_value_id = 3273

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