Product Sync.<br>
Opencart products: 17<br>
Input products: 100<br>
<hr>NEW: 100262799<br>
<hr>NEW: 100262899<br>
<hr>NEW: 100262999<br>
<hr>NEW: 100263099<br>
<hr>NEW: 100263199<br>
<hr>NEW: 100263299<br>
<hr>NEW: 100263399<br>
<hr>NEW: 100263499<br>
<hr>NEW: 100263599<br>
<hr>NEW: 100263699<br>
<hr>NEW: 100263799<br>
<hr>NEW: 100263899<br>
<hr>NEW: 100263999<br>
<hr>NEW: 100264099<br>
<hr>NEW: 100264199<br>
<hr>NEW: 100264299<br>
<hr>NEW: 100264399<br>
<hr>NEW: 100264499<br>
<hr>NEW: 100264599<br>
<hr>NEW: 100264699<br>
<hr>NEW: 100264799<br>
<hr>NEW: 100264899<br>
<hr>NEW: 100264999<br>
<hr>NEW: 100265099<br>
<hr>NEW: 100265199<br>
<hr>NEW: 100265299<br>
<hr>NEW: 100265399<br>
<hr>NEW: 100265499<br>
<hr>NEW: 100265599<br>
<hr>NEW: 100265699<br>
<hr>NEW: 100265799<br>
<hr>NEW: 100265899<br>
<hr>NEW: 100265999<br>
<hr>NEW: 100266099<br>
<hr>NEW: 100266199<br>
<hr>NEW: 100266299<br>
<hr>NEW: 100266399<br>
<hr>NEW: 100266499<br>
<hr>NEW: 100266599<br>
<hr>NEW: 100266699<br>
<hr>NEW: 100266799<br>
<hr>NEW: 100266899<br>
<hr>NEW: 100266999<br>
<hr>NEW: 100267099<br>
<hr>NEW: 100267199<br>
<hr>NEW: 100267299<br>
<hr>NEW: 100267399<br>
<hr>NEW: 100267499<br>
<hr>NEW: 100267599<br>
<hr>NEW: 100267699<br>
<hr>NEW: 100267799<br>
<hr>NEW: 100267899<br>
<hr>NEW: 100267999<br>
<hr>NEW: 100268099<br>
<hr>NEW: 100268199<br>
<hr>NEW: 100268299<br>
<hr>NEW: 100268399<br>
<hr>NEW: 100268499<br>
<hr>NEW: 100268599<br>
<hr>NEW: 100268699<br>
<hr>NEW: 100268799<br>
<hr>NEW: 100268899<br>
<hr>NEW: 100268999<br>
<hr>NEW: 100269099<br>
<hr>NEW: 100269199<br>
<hr>NEW: 100269299<br>
<hr>NEW: 100269399<br>
<hr>NEW: 100269499<br>
<hr>NEW: 100269599<br>
<hr>NEW: 100269699<br>
<hr>NEW: 100269799<br>
<hr>NEW: 100269899<br>
<hr>NEW: 100269999<br>
<hr>NEW: 100270099<br>
<hr>NEW: 100270199<br>
<hr>NEW: 100270299<br>
<hr>NEW: 100270399<br>
<hr>NEW: 100270499<br>
<hr>NEW: 100270599<br>
<hr>NEW: 100270699<br>
<hr>NEW: 100270799<br>
<hr>NEW: 100270899<br>
<hr>NEW: 100270999<br>
<hr>NEW: 100271099<br>
<hr>NEW: Giotto 500ml<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 'Giotto 500ml - %'
				)
		<hr>NEW: 100271299<br>
<hr>NEW: 100271399<br>
<hr>NEW: 100271499<br>
<hr>NEW: 100271599<br>
<hr>NEW: 100271699<br>
<hr>NEW: 100271799<br>
<hr>NEW: 100271899<br>
<hr>NEW: 100271999<br>
<hr>NEW: 100272099<br>
<hr>NEW: 100272199<br>
<hr>NEW: 100272299<br>
<hr>NEW: 100272399<br>
<hr>NEW: 100272499<br>
<hr>NEW: 100272599<br>
<hr>NEW: 100272699<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 18<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 = 27389
					AND option_id = 17
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27389,
						option_id = 17,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100271199 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1738
					<br>UPDATE oc_option_value_description 
						SET
							name = '100271199 - GUACHE GIOT REF 532820 ROSA CARNE 500ML'
						WHERE
							option_value_id = 1738
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 382
							AND product_id = 27389
							AND option_id = 17
							AND option_value_id = 1738

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