Product Sync.<br>
Opencart products: 30<br>
Input products: 100<br>
<hr>NEW: 102261499<br>
<hr>NEW: 102261599<br>
<hr>NEW: 102261699<br>
<hr>NEW: 102261799<br>
<hr>NEW: 102261899<br>
<hr>NEW: 102261999<br>
<hr>NEW: 102262099<br>
<hr>NEW: 102262199<br>
<hr>NEW: 102262299<br>
<hr>NEW: 102262399<br>
<hr>NEW: 102262499<br>
<hr>NEW: 102262599<br>
<hr>NEW: 102262699<br>
<hr>NEW: 102262799<br>
<hr>NEW: 102262899<br>
<hr>NEW: 102262999<br>
<hr>NEW: 102263099<br>
<hr>UPDATING: Amsterdam 500ml<br>
Product ID: 27396<br>
Image file: Amsterdam 500ml.jpg<br>
<hr>NEW: 102263299<br>
<hr>NEW: 102263399<br>
<hr>NEW: 102263499<br>
<hr>NEW: 102263599<br>
<hr>NEW: 102263699<br>
<hr>NEW: 102263799<br>
<hr>NEW: 102263899<br>
<hr>NEW: 102263999<br>
<hr>NEW: 102264099<br>
<hr>NEW: 102264199<br>
<hr>NEW: 102264299<br>
<hr>NEW: 102264399<br>
<hr>NEW: 102264499<br>
<hr>NEW: 102264599<br>
<hr>NEW: 102264699<br>
<hr>NEW: 102264799<br>
<hr>NEW: 102264899<br>
<hr>NEW: 102264999<br>
<hr>NEW: 102265099<br>
<hr>NEW: 102265199<br>
<hr>NEW: 102265299<br>
<hr>NEW: 102265399<br>
<hr>NEW: 102265499<br>
<hr>NEW: 102265599<br>
<hr>NEW: 102265699<br>
<hr>NEW: 102265799<br>
<hr>NEW: 102265899<br>
<hr>NEW: 102265999<br>
<hr>NEW: 102266099<br>
<hr>NEW: 102266199<br>
<hr>NEW: 102266299<br>
<hr>NEW: 102266399<br>
<hr>NEW: 102266499<br>
<hr>NEW: 102266599<br>
<hr>NEW: 102266699<br>
<hr>NEW: 102266799<br>
<hr>NEW: 102266899<br>
<hr>NEW: 102266999<br>
<hr>NEW: 102267099<br>
<hr>NEW: 102267199<br>
<hr>NEW: 102267299<br>
<hr>NEW: 102267399<br>
<hr>NEW: 102267499<br>
<hr>NEW: 102267599<br>
<hr>NEW: 102267699<br>
<hr>NEW: 102267799<br>
<hr>NEW: 102267899<br>
<hr>NEW: 102267999<br>
<hr>NEW: 102268099<br>
<hr>NEW: 102268199<br>
<hr>NEW: 102268299<br>
<hr>NEW: 102268399<br>
<hr>NEW: 102268499<br>
<hr>NEW: 102268599<br>
<hr>NEW: 102268699<br>
<hr>NEW: 102268799<br>
<hr>NEW: 102268899<br>
<hr>NEW: 102268999<br>
<hr>NEW: 102269099<br>
<hr>NEW: 102269199<br>
<hr>NEW: 102269299<br>
<hr>NEW: 102269399<br>
<hr>NEW: 102269499<br>
<hr>NEW: 102269599<br>
<hr>NEW: 102269699<br>
<hr>NEW: 102269799<br>
<hr>NEW: 102269899<br>
<hr>NEW: 102269999<br>
<hr>NEW: 102270099<br>
<hr>NEW: 102270199<br>
<hr>NEW: 102270299<br>
<hr>NEW: 102270399<br>
<hr>NEW: 102270499<br>
<hr>NEW: 102270599<br>
<hr>NEW: 102270699<br>
<hr>NEW: 102270799<br>
<hr>NEW: 102270899<br>
<hr>NEW: 102270999<br>
<hr>NEW: 102271099<br>
<hr>NEW: 102271199<br>
<hr>NEW: 102271299<br>
<hr>NEW: 102271399<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 30<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 = 27396
					AND option_id = 17
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '102263199 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1916
					<br>UPDATE oc_option_value_description 
						SET
							name = '102263199 - ACRIL AMST 500ML AZL COBALTO 512'
						WHERE
							option_value_id = 1916
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 389
							AND product_id = 27396
							AND option_id = 17
							AND option_value_id = 1916

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