Product Sync.<br>
Opencart products: 24<br>
Input products: 100<br>
<hr>NEW: 101023399<br>
<hr>NEW: 101023499<br>
<hr>NEW: 101023599<br>
<hr>NEW: 101023699<br>
<hr>NEW: 101023799<br>
<hr>NEW: 101023899<br>
<hr>NEW: 101023999<br>
<hr>NEW: 101024099<br>
<hr>NEW: 101024199<br>
<hr>NEW: 101024299<br>
<hr>NEW: 101024399<br>
<hr>NEW: 101024499<br>
<hr>NEW: 101024599<br>
<hr>NEW: 101024699<br>
<hr>NEW: 101024799<br>
<hr>NEW: 101024899<br>
<hr>NEW: 101024999<br>
<hr>NEW: 101025099<br>
<hr>NEW: 101025199<br>
<hr>NEW: 101025299<br>
<hr>NEW: 101025399<br>
<hr>NEW: 101025499<br>
<hr>NEW: 101025599<br>
<hr>NEW: 101025699<br>
<hr>NEW: 101025799<br>
<hr>NEW: 101025899<br>
<hr>NEW: 101025999<br>
<hr>NEW: 101026099<br>
<hr>NEW: 101026199<br>
<hr>NEW: 101026299<br>
<hr>NEW: 101026399<br>
<hr>NEW: 101026499<br>
<hr>NEW: 101026599<br>
<hr>NEW: 101026699<br>
<hr>NEW: 101026799<br>
<hr>NEW: 101026899<br>
<hr>NEW: 101026999<br>
<hr>NEW: 101027099<br>
<hr>NEW: 101027199<br>
<hr>NEW: 101027299<br>
<hr>NEW: 101027399<br>
<hr>NEW: 101027499<br>
<hr>NEW: 101027599<br>
<hr>NEW: 101027699<br>
<hr>NEW: 101027799<br>
<hr>NEW: 101027899<br>
<hr>NEW: 101027999<br>
<hr>NEW: 101028099<br>
<hr>NEW: 101028199<br>
<hr>NEW: 101028299<br>
<hr>NEW: 101028399<br>
<hr>NEW: 101028499<br>
<hr>NEW: 101028599<br>
<hr>NEW: 101028699<br>
<hr>NEW: 101028799<br>
<hr>NEW: 101028899<br>
<hr>NEW: 101028999<br>
<hr>NEW: 101029099<br>
<hr>NEW: 101029199<br>
<hr>NEW: 101029299<br>
<hr>NEW: 101029399<br>
<hr>NEW: 101029499<br>
<hr>NEW: 101029599<br>
<hr>NEW: 101029699<br>
<hr>NEW: 101029799<br>
<hr>NEW: 101029899<br>
<hr>NEW: 101029999<br>
<hr>NEW: 101030099<br>
<hr>NEW: 101030199<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: Pelikan 10ml<br>
Product ID: 27390<br>
Image file: Pelikan 10ml.jpg<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>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 24<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 = 27390
					AND option_id = 17
			<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 10ML 740/3 AZL ULTRAMAR'
						WHERE
							option_value_id = 1763
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 383
							AND product_id = 27390
							AND option_id = 17
							AND option_value_id = 1763

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