Product Sync.<br>
Opencart products: 158<br>
Input products: 100<br>
<hr>NEW: 100373899<br>
<hr>NEW: 100373999<br>
<hr>NEW: 100374099<br>
<hr>NEW: 100374199<br>
<hr>NEW: 100374299<br>
<hr>NEW: 100374399<br>
<hr>NEW: 100374499<br>
<hr>NEW: 100374599<br>
<hr>NEW: 100374699<br>
<hr>NEW: 100374799<br>
<hr>NEW: 100374899<br>
<hr>NEW: 100374999<br>
<hr>NEW: 100375099<br>
<hr>NEW: 100375199<br>
<hr>NEW: 100375299<br>
<hr>NEW: 100375399<br>
<hr>NEW: 100375499<br>
<hr>UPDATING: Tinta Vitral Pébéo<br>
Product ID: 27026<br>
Image file: <br>
<hr>NEW: 100375699<br>
<hr>NEW: 100375799<br>
<hr>NEW: 100375899<br>
<hr>NEW: 100375999<br>
<hr>NEW: 100376099<br>
<hr>NEW: 100376199<br>
<hr>NEW: 100376299<br>
<hr>NEW: 100376399<br>
<hr>NEW: 100376499<br>
<hr>NEW: 100376599<br>
<hr>NEW: 100376699<br>
<hr>NEW: 100376799<br>
<hr>NEW: 100376899<br>
<hr>NEW: 100376999<br>
<hr>NEW: 100377099<br>
<hr>NEW: 100377199<br>
<hr>NEW: 100377299<br>
<hr>NEW: 100377399<br>
<hr>NEW: 100377499<br>
<hr>NEW: 100377599<br>
<hr>NEW: 100377699<br>
<hr>NEW: 100377799<br>
<hr>NEW: 100377899<br>
<hr>NEW: 100377999<br>
<hr>NEW: 100378099<br>
<hr>NEW: 100378199<br>
<hr>NEW: 100378299<br>
<hr>NEW: 100378399<br>
<hr>NEW: 100378499<br>
<hr>NEW: 100378599<br>
<hr>NEW: 100378699<br>
<hr>NEW: 100378799<br>
<hr>NEW: 100378899<br>
<hr>NEW: 100378999<br>
<hr>NEW: 100379099<br>
<hr>NEW: 100379199<br>
<hr>NEW: 100379299<br>
<hr>NEW: 100379399<br>
<hr>NEW: 100379499<br>
<hr>NEW: 100379599<br>
<hr>NEW: 100379699<br>
<hr>NEW: 100379799<br>
<hr>NEW: 100379899<br>
<hr>NEW: 100379999<br>
<hr>NEW: 100380099<br>
<hr>NEW: 100380199<br>
<hr>NEW: 100380299<br>
<hr>NEW: 100380399<br>
<hr>NEW: 100380499<br>
<hr>NEW: 100380599<br>
<hr>NEW: 100380699<br>
<hr>NEW: 100380799<br>
<hr>NEW: 100380899<br>
<hr>NEW: 100380999<br>
<hr>NEW: 100381099<br>
<hr>NEW: 100381199<br>
<hr>NEW: 100381299<br>
<hr>NEW: 100381399<br>
<hr>NEW: 100381499<br>
<hr>NEW: 100381599<br>
<hr>NEW: 100381699<br>
<hr>NEW: 100381799<br>
<hr>NEW: 100381899<br>
<hr>NEW: 100381999<br>
<hr>NEW: 100382099<br>
<hr>NEW: 100382199<br>
<hr>NEW: 100382299<br>
<hr>NEW: 100382399<br>
<hr>NEW: 100382499<br>
<hr>NEW: 100382599<br>
<hr>NEW: 100382699<br>
<hr>NEW: 100382799<br>
<hr>NEW: 100382899<br>
<hr>NEW: 100382999<br>
<hr>NEW: 100383099<br>
<hr>NEW: 100383199<br>
<hr>NEW: 100383299<br>
<hr>NEW: 100383399<br>
<hr>NEW: 100383499<br>
<hr>NEW: 100383599<br>
<hr>NEW: 100383699<br>
<hr>NEW: 100383799<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 158<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 = 27026
					AND option_id = 15
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100375599 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2183
					<br>UPDATE oc_option_value_description 
						SET
							name = '100375599 - Tinta Vitral Pébéo Cinzento'
						WHERE
							option_value_id = 2183
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 94
							AND product_id = 27026
							AND option_id = 15
							AND option_value_id = 2183

				<br>DELETE FROM oc_product
					WHERE
						model = '100375599'
				<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 = 94
								AND product_id = 27026
								AND option_id = 15
								AND option_value_id = 2183
						<br><hr>Ok.<hr><hr>