Product Sync.<br>
Opencart products: 62<br>
Input products: 100<br>
<hr>NEW: 100495099<br>
<hr>NEW: 100495199<br>
<hr>NEW: 100495299<br>
<hr>NEW: 100495399<br>
<hr>NEW: 100495499<br>
<hr>NEW: 100495599<br>
<hr>NEW: 100495699<br>
<hr>NEW: 100495799<br>
<hr>NEW: 100495899<br>
<hr>NEW: 100495999<br>
<hr>NEW: 100496099<br>
<hr>NEW: 100496199<br>
<hr>NEW: 100496299<br>
<hr>NEW: 100496399<br>
<hr>NEW: 100496499<br>
<hr>NEW: 100496599<br>
<hr>NEW: 100496699<br>
<hr>NEW: 100496799<br>
<hr>NEW: 100496899<br>
<hr>NEW: 100496999<br>
<hr>NEW: 100497099<br>
<hr>NEW: 100497199<br>
<hr>NEW: 100497299<br>
<hr>NEW: 100497399<br>
<hr>NEW: 100497499<br>
<hr>NEW: 100497599<br>
<hr>NEW: 100497699<br>
<hr>NEW: 100497799<br>
<hr>NEW: 100497899<br>
<hr>NEW: 100497999<br>
<hr>NEW: 100498099<br>
<hr>NEW: 100498199<br>
<hr>NEW: 100498299<br>
<hr>NEW: 100498399<br>
<hr>NEW: 100498499<br>
<hr>NEW: 100498599<br>
<hr>NEW: 100498699<br>
<hr>NEW: 100498799<br>
<hr>NEW: 100498899<br>
<hr>NEW: 100498999<br>
<hr>NEW: 100499099<br>
<hr>NEW: 100499199<br>
<hr>NEW: Tela Art Creation<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 'Tela Art Creation - %'
				)
		<hr>NEW: 100499399<br>
<hr>NEW: 100499499<br>
<hr>NEW: 100499599<br>
<hr>NEW: 100499699<br>
<hr>NEW: 100499799<br>
<hr>NEW: 100499899<br>
<hr>NEW: 100499999<br>
<hr>NEW: 100500099<br>
<hr>NEW: 100500199<br>
<hr>NEW: 100500299<br>
<hr>NEW: 100500399<br>
<hr>NEW: 100500499<br>
<hr>NEW: 100500599<br>
<hr>NEW: 100500699<br>
<hr>NEW: 100500799<br>
<hr>NEW: 100500899<br>
<hr>NEW: 10050099<br>
<hr>NEW: 100500999<br>
<hr>NEW: 100501099<br>
<hr>NEW: 100501199<br>
<hr>NEW: 100501299<br>
<hr>NEW: 100501399<br>
<hr>NEW: 100501499<br>
<hr>NEW: 100501599<br>
<hr>NEW: 100501699<br>
<hr>NEW: 100501799<br>
<hr>NEW: 100501899<br>
<hr>NEW: 100501999<br>
<hr>NEW: 100502099<br>
<hr>NEW: 100502199<br>
<hr>NEW: 100502299<br>
<hr>NEW: 100502399<br>
<hr>NEW: 100502499<br>
<hr>NEW: 100502599<br>
<hr>NEW: 100502699<br>
<hr>NEW: 100502799<br>
<hr>NEW: 100502899<br>
<hr>NEW: 100502999<br>
<hr>NEW: 100503099<br>
<hr>NEW: 100503199<br>
<hr>NEW: 100503299<br>
<hr>NEW: 100503399<br>
<hr>NEW: 100503499<br>
<hr>NEW: 100503599<br>
<hr>NEW: 100503699<br>
<hr>NEW: 100503799<br>
<hr>NEW: 100503899<br>
<hr>NEW: 100503999<br>
<hr>NEW: 100504099<br>
<hr>NEW: 100504199<br>
<hr>NEW: 100504299<br>
<hr>NEW: 100504399<br>
<hr>NEW: 100504499<br>
<hr>NEW: 100504599<br>
<hr>NEW: 100504699<br>
<hr>NEW: 100504799<br>
<hr>NEW: 100504899<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 63<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 = 27460
					AND option_id = 17
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27460,
						option_id = 17,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100499299 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3343 AS option_value_id,
							language_id,
							17 AS option_id,
							'100499299 - Tela Art Creation 24 x 30' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 439
							AND product_id = 27460
							AND option_id = 17
							AND option_value_id = 3343

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