Product Sync.<br>
Opencart products: 19<br>
Input products: 100<br>
<hr>NEW: 100080899<br>
<hr>NEW: 100080999<br>
<hr>NEW: 100081099<br>
<hr>NEW: 100081199<br>
<hr>NEW: 100081299<br>
<hr>NEW: 100081399<br>
<hr>NEW: 100081499<br>
<hr>NEW: 100081599<br>
<hr>NEW: 100081699<br>
<hr>NEW: 100081799<br>
<hr>NEW: 100081899<br>
<hr>NEW: 100081999<br>
<hr>NEW: 100082099<br>
<hr>NEW: 100082199<br>
<hr>NEW: 100082299<br>
<hr>NEW: 100082399<br>
<hr>NEW: 100082499<br>
<hr>NEW: 100082599<br>
<hr>NEW: 100082699<br>
<hr>NEW: 100082799<br>
<hr>NEW: 100082899<br>
<hr>NEW: 100082999<br>
<hr>NEW: 100083099<br>
<hr>NEW: 100083199<br>
<hr>NEW: 100083299<br>
<hr>NEW: 100083399<br>
<hr>NEW: 100083499<br>
<hr>NEW: 100083599<br>
<hr>NEW: 100083699<br>
<hr>NEW: 100083799<br>
<hr>NEW: 100083899<br>
<hr>NEW: 100083999<br>
<hr>NEW: 100084099<br>
<hr>NEW: 100084199<br>
<hr>NEW: 100084299<br>
<hr>NEW: 100084399<br>
<hr>NEW: 100084499<br>
<hr>NEW: 100084599<br>
<hr>NEW: 100084699<br>
<hr>NEW: 100084799<br>
<hr>NEW: 100084899<br>
<hr>NEW: 100084999<br>
<hr>NEW: 100085099<br>
<hr>NEW: Aguarela Escolar Jovi<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 'Aguarela Escolar Jovi - %'
				)
		<hr>NEW: 100085299<br>
<hr>NEW: 100085399<br>
<hr>NEW: 100085499<br>
<hr>NEW: 100085599<br>
<hr>NEW: 100085699<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 '100085699 - %'
				)
		<hr>NEW: 100085799<br>
<hr>NEW: 100085899<br>
<hr>NEW: 100085999<br>
<hr>NEW: 100086099<br>
<hr>NEW: 100086199<br>
<hr>NEW: 100086299<br>
<hr>NEW: 100086399<br>
<hr>NEW: 100086499<br>
<hr>NEW: 100086599<br>
<hr>NEW: 100086699<br>
<hr>NEW: 100086799<br>
<hr>NEW: 100086899<br>
<hr>NEW: 100086999<br>
<hr>NEW: 100087099<br>
<hr>NEW: 100087199<br>
<hr>NEW: 100087299<br>
<hr>NEW: 100087399<br>
<hr>NEW: 100087499<br>
<hr>NEW: 100087599<br>
<hr>NEW: 100087699<br>
<hr>NEW: 100087799<br>
<hr>NEW: 100087899<br>
<hr>NEW: 100087999<br>
<hr>NEW: 100088099<br>
<hr>NEW: 100088199<br>
<hr>NEW: 100088299<br>
<hr>NEW: 100088399<br>
<hr>NEW: 100088499<br>
<hr>NEW: 100088599<br>
<hr>NEW: 100088699<br>
<hr>NEW: 100088799<br>
<hr>NEW: 100088899<br>
<hr>NEW: 100088999<br>
<hr>NEW: 100089099<br>
<hr>NEW: 100089199<br>
<hr>NEW: 100089299<br>
<hr>NEW: 100089399<br>
<hr>NEW: 100089499<br>
<hr>NEW: 100089599<br>
<hr>NEW: 100089699<br>
<hr>NEW: 100089799<br>
<hr>NEW: 100089899<br>
<hr>NEW: 100089999<br>
<hr>NEW: 100090099<br>
<hr>NEW: 100090199<br>
<hr>NEW: 100090299<br>
<hr>NEW: 100090399<br>
<hr>NEW: 100090499<br>
<hr>NEW: 100090599<br>
<hr>NEW: 100090699<br>
<hr>NEW: 100090799<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 21<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 = 27417
					AND option_id = 17
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27417,
						option_id = 17,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100085199 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1730
					<br>UPDATE oc_option_value_description 
						SET
							name = '100085199 - Aguarela Jovi com 24 Cores'
						WHERE
							option_value_id = 1730
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 405
							AND product_id = 27417
							AND option_id = 17
							AND option_value_id = 1730

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