Product Sync.<br>
Opencart products: 162<br>
Input products: 100<br>
<hr>NEW: 102110999<br>
<hr>NEW: 102111099<br>
<hr>NEW: 102111199<br>
<hr>NEW: 102111299<br>
<hr>NEW: 102111399<br>
<hr>NEW: 102111499<br>
<hr>NEW: 102111599<br>
<hr>NEW: 102111699<br>
<hr>NEW: 102111799<br>
<hr>NEW: 102111899<br>
<hr>NEW: 102111999<br>
<hr>NEW: 102112099<br>
<hr>UPDATING: Médio Gel para Acrílico Extra Forte Talens<br>
Product ID: 27503<br>
Image file: <br>
<hr>NEW: 102112299<br>
<hr>NEW: 102112399<br>
<hr>NEW: 102112499<br>
<hr>NEW: 102112599<br>
<hr>NEW: 102112699<br>
<hr>NEW: 102112799<br>
<hr>NEW: 102112899<br>
<hr>NEW: 102112999<br>
<hr>NEW: 102113099<br>
<hr>NEW: 102113199<br>
<hr>NEW: 102113299<br>
<hr>NEW: 102113399<br>
<hr>NEW: 102113499<br>
<hr>NEW: 102113599<br>
<hr>NEW: 102113699<br>
<hr>NEW: 102113799<br>
<hr>NEW: 102113899<br>
<hr>NEW: 102113999<br>
<hr>NEW: 102114099<br>
<hr>NEW: 102114199<br>
<hr>NEW: 102114299<br>
<hr>NEW: 102114399<br>
<hr>NEW: 102114499<br>
<hr>NEW: 102114599<br>
<hr>NEW: 102114699<br>
<hr>NEW: 102114799<br>
<hr>NEW: 102114899<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 '102114899 - %'
				)
		<hr>NEW: 102114999<br>
<hr>NEW: 102115099<br>
<hr>NEW: 102115199<br>
<hr>NEW: 102115299<br>
<hr>NEW: 102115399<br>
<hr>NEW: 102115499<br>
<hr>NEW: 102115599<br>
<hr>NEW: 102115699<br>
<hr>NEW: 102115799<br>
<hr>NEW: 102115899<br>
<hr>NEW: 102115999<br>
<hr>NEW: 102116099<br>
<hr>NEW: 102116199<br>
<hr>NEW: 102116299<br>
<hr>NEW: 102116399<br>
<hr>NEW: 102116499<br>
<hr>NEW: 102116599<br>
<hr>NEW: 102116699<br>
<hr>NEW: 102116799<br>
<hr>NEW: 102116899<br>
<hr>NEW: 102116999<br>
<hr>NEW: 102117099<br>
<hr>NEW: 102117199<br>
<hr>NEW: 102117299<br>
<hr>NEW: 102117399<br>
<hr>NEW: 102117499<br>
<hr>NEW: 102117599<br>
<hr>NEW: 102117699<br>
<hr>NEW: 102117799<br>
<hr>NEW: 102117899<br>
<hr>NEW: 102117999<br>
<hr>NEW: 102118099<br>
<hr>NEW: 102118199<br>
<hr>NEW: 102118299<br>
<hr>NEW: 102118399<br>
<hr>NEW: 102118499<br>
<hr>NEW: 102118599<br>
<hr>NEW: 102118699<br>
<hr>NEW: 102118799<br>
<hr>NEW: 102118899<br>
<hr>NEW: 102118999<br>
<hr>NEW: 102119099<br>
<hr>NEW: 102119199<br>
<hr>NEW: 102119299<br>
<hr>NEW: 102119399<br>
<hr>NEW: 102119499<br>
<hr>NEW: 102119599<br>
<hr>NEW: 102119699<br>
<hr>NEW: 102119799<br>
<hr>NEW: 102119899<br>
<hr>NEW: 102119999<br>
<hr>NEW: 102120099<br>
<hr>NEW: 102120199<br>
<hr>NEW: 102120299<br>
<hr>NEW: 102120399<br>
<hr>NEW: 102120499<br>
<hr>NEW: 102120599<br>
<hr>NEW: 102120699<br>
<hr>NEW: 102120799<br>
<hr>NEW: 102120899<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 163<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 = 27503
					AND option_id = 17
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '102112199 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = 'catalog/102112199.jpg',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3667 AS option_value_id,
							language_id,
							17 AS option_id,
							'102112199 - Médio Gel para Acrílico Extra Forte Talens Brilhante 250 ml' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 466
							AND product_id = 27503
							AND option_id = 17
							AND option_value_id = 3667

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