Product Sync.<br>
Opencart products: 80<br>
Input products: 100<br>
<hr>NEW: 100636399<br>
<hr>NEW: 100636499<br>
<hr>NEW: 100636599<br>
<hr>NEW: 100636699<br>
<hr>NEW: 100636799<br>
<hr>NEW: 100636899<br>
<hr>NEW: 100636999<br>
<hr>NEW: 100637099<br>
<hr>NEW: 100637199<br>
<hr>NEW: 100637299<br>
<hr>NEW: 100637399<br>
<hr>NEW: 100637499<br>
<hr>NEW: 100637599<br>
<hr>NEW: 100637699<br>
<hr>NEW: 100637799<br>
<hr>NEW: 100637899<br>
<hr>NEW: 100637999<br>
<hr>NEW: 100638099<br>
<hr>NEW: 100638199<br>
<hr>NEW: 100638299<br>
<hr>NEW: 100638399<br>
<hr>NEW: 100638499<br>
<hr>NEW: 100638599<br>
<hr>NEW: 100638699<br>
<hr>NEW: 100638799<br>
<hr>NEW: 100638899<br>
<hr>NEW: 100638999<br>
<hr>NEW: 100639099<br>
<hr>NEW: 100639199<br>
<hr>NEW: 100639299<br>
<hr>NEW: 100639399<br>
<hr>NEW: 100639499<br>
<hr>NEW: 100639599<br>
<hr>NEW: 100639699<br>
<hr>NEW: 100639799<br>
<hr>NEW: 100639899<br>
<hr>NEW: 100639999<br>
<hr>NEW: 100640099<br>
<hr>NEW: 100640199<br>
<hr>NEW: 100640299<br>
<hr>NEW: 100640399<br>
<hr>NEW: 100640499<br>
<hr>NEW: 100640599<br>
<hr>NEW: 100640699<br>
<hr>NEW: 100640799<br>
<hr>NEW: 100640899<br>
<hr>NEW: 100640999<br>
<hr>NEW: 100641099<br>
<hr>NEW: 100641199<br>
<hr>NEW: Tela  Winsor & Newton<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  Winsor & Newton - %'
				)
		<hr>NEW: 100641399<br>
<hr>NEW: 100641499<br>
<hr>NEW: 100641599<br>
<hr>NEW: 100641699<br>
<hr>NEW: 100641799<br>
<hr>NEW: 100641899<br>
<hr>NEW: 100641999<br>
<hr>NEW: 100642099<br>
<hr>NEW: 100642199<br>
<hr>NEW: 100642299<br>
<hr>NEW: 100642399<br>
<hr>NEW: 100642499<br>
<hr>NEW: 100642599<br>
<hr>NEW: 100642699<br>
<hr>NEW: 100642799<br>
<hr>NEW: 100642899<br>
<hr>NEW: 100642999<br>
<hr>NEW: 100643099<br>
<hr>NEW: 100643199<br>
<hr>NEW: 100643299<br>
<hr>NEW: 100643399<br>
<hr>NEW: 100643499<br>
<hr>NEW: 100643599<br>
<hr>NEW: 100643699<br>
<hr>NEW: 100643799<br>
<hr>NEW: 100643899<br>
<hr>NEW: 100643999<br>
<hr>NEW: 100644099<br>
<hr>NEW: 100644199<br>
<hr>NEW: 100644299<br>
<hr>NEW: 100644399<br>
<hr>NEW: 100644499<br>
<hr>NEW: 100644599<br>
<hr>NEW: 100644699<br>
<hr>NEW: 100644799<br>
<hr>NEW: 100644899<br>
<hr>NEW: 100644999<br>
<hr>NEW: 100645099<br>
<hr>NEW: 100645199<br>
<hr>NEW: 100645299<br>
<hr>NEW: 100645399<br>
<hr>NEW: 100645499<br>
<hr>NEW: 100645599<br>
<hr>NEW: 100645699<br>
<hr>NEW: 100645799<br>
<hr>NEW: 100645899<br>
<hr>NEW: 100645999<br>
<hr>NEW: 100646099<br>
<hr>NEW: 100646199<br>
<hr>NEW: 100646299<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 81<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 = 27478
					AND option_id = 17
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27478,
						option_id = 17,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100641299 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3447 AS option_value_id,
							language_id,
							17 AS option_id,
							'100641299 - Tela Winsor & Newton 60 x 90' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 451
							AND product_id = 27478
							AND option_id = 17
							AND option_value_id = 3447

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