Product Sync.<br>
Opencart products: 184<br>
Input products: 100<br>
<hr>NEW: 101030299<br>
<hr>NEW: 101030399<br>
<hr>NEW: 101030499<br>
<hr>NEW: 101030599<br>
<hr>NEW: 101030699<br>
<hr>NEW: 101030799<br>
<hr>NEW: 101030899<br>
<hr>NEW: 101030999<br>
<hr>NEW: 101031099<br>
<hr>NEW: 101031199<br>
<hr>NEW: 101031299<br>
<hr>NEW: 101031399<br>
<hr>NEW: 101031499<br>
<hr>NEW: 101031599<br>
<hr>NEW: 101031699<br>
<hr>NEW: 101031799<br>
<hr>NEW: 101031899<br>
<hr>NEW: 101031999<br>
<hr>NEW: 101032099<br>
<hr>NEW: 101032199<br>
<hr>NEW: 101032299<br>
<hr>NEW: 101032399<br>
<hr>UPDATING: Guache Pelikan<br>
Product ID: 27022<br>
Image file: <br>
<hr>NEW: 101032599<br>
<hr>NEW: 101032699<br>
<hr>NEW: 101032799<br>
<hr>NEW: 101032899<br>
<hr>NEW: 101032999<br>
<hr>NEW: 101033099<br>
<hr>NEW: 101033199<br>
<hr>NEW: 101033299<br>
<hr>NEW: 101033399<br>
<hr>NEW: 101033499<br>
<hr>NEW: 101033599<br>
<hr>NEW: 101033699<br>
<hr>NEW: 101033799<br>
<hr>NEW: 101033899<br>
<hr>NEW: 101033999<br>
<hr>NEW: 101034099<br>
<hr>NEW: 101034199<br>
<hr>NEW: 101034299<br>
<hr>NEW: 101034399<br>
<hr>NEW: 101034499<br>
<hr>NEW: 101034599<br>
<hr>NEW: 101034699<br>
<hr>NEW: 101034799<br>
<hr>NEW: 101034899<br>
<hr>NEW: 101034999<br>
<hr>NEW: 101035099<br>
<hr>NEW: 101035199<br>
<hr>NEW: 101035299<br>
<hr>NEW: 101035399<br>
<hr>NEW: 101035499<br>
<hr>NEW: 101035599<br>
<hr>NEW: 101035699<br>
<hr>NEW: 101035799<br>
<hr>NEW: 101035899<br>
<hr>NEW: 101035999<br>
<hr>NEW: 101036099<br>
<hr>NEW: 101036199<br>
<hr>NEW: 101036299<br>
<hr>NEW: 101036399<br>
<hr>NEW: 101036499<br>
<hr>NEW: 101036599<br>
<hr>NEW: 101036699<br>
<hr>NEW: 101036799<br>
<hr>NEW: 101036899<br>
<hr>NEW: 101036999<br>
<hr>NEW: 101037099<br>
<hr>NEW: 101037199<br>
<hr>NEW: 101037299<br>
<hr>NEW: 101037399<br>
<hr>NEW: 101037499<br>
<hr>NEW: 101037599<br>
<hr>NEW: 101037699<br>
<hr>NEW: 101037799<br>
<hr>NEW: 101037899<br>
<hr>NEW: 101037999<br>
<hr>NEW: 101038099<br>
<hr>NEW: 101038199<br>
<hr>NEW: 101038299<br>
<hr>NEW: 101038399<br>
<hr>NEW: 101038499<br>
<hr>NEW: 101038599<br>
<hr>NEW: 101038699<br>
<hr>NEW: 101038799<br>
<hr>NEW: 101038899<br>
<hr>NEW: 101038999<br>
<hr>NEW: 101039099<br>
<hr>NEW: 101039199<br>
<hr>NEW: 101039299<br>
<hr>NEW: 101039399<br>
<hr>NEW: 101039499<br>
<hr>NEW: 101039599<br>
<hr>NEW: 101039699<br>
<hr>NEW: 101039799<br>
<hr>NEW: 101039899<br>
<hr>NEW: 101039999<br>
<hr>NEW: 101040099<br>
<hr>NEW: 101040199<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 184<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 = 27022
					AND option_id = 15
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101032499 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1763
					<br>UPDATE oc_option_value_description 
						SET
							name = '101032499 - Guache Pelikan  10 ml  Azul Ultramarino'
						WHERE
							option_value_id = 1763
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 90
							AND product_id = 27022
							AND option_id = 15
							AND option_value_id = 1763

				<br>DELETE FROM oc_product
					WHERE
						model = '101032499'
				<br>UPDATE oc_product_option_value 
							SET
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
							WHERE
								product_option_id = 90
								AND product_id = 27022
								AND option_id = 15
								AND option_value_id = 1763
						<br><hr>Ok.<hr><hr>