Product Sync.<br>
Opencart products: 30<br>
Input products: 100<br>
<hr>NEW: 101853999<br>
<hr>NEW: 101854099<br>
<hr>NEW: 101854199<br>
<hr>NEW: 101854299<br>
<hr>NEW: 101854399<br>
<hr>NEW: 101854499<br>
<hr>NEW: 101854599<br>
<hr>NEW: 101854699<br>
<hr>NEW: 101854799<br>
<hr>NEW: 101854899<br>
<hr>NEW: 101854999<br>
<hr>NEW: 101855099<br>
<hr>NEW: 101855199<br>
<hr>NEW: 101855299<br>
<hr>NEW: 101855399<br>
<hr>NEW: 101855499<br>
<hr>NEW: 101855599<br>
<hr>NEW: 101855699<br>
<hr>NEW: 101855799<br>
<hr>NEW: 101855899<br>
<hr>NEW: 101855999<br>
<hr>NEW: 101856099<br>
<hr>NEW: 101856199<br>
<hr>NEW: 101856299<br>
<hr>NEW: 101856399<br>
<hr>NEW: 101856499<br>
<hr>NEW: 101856599<br>
<hr>NEW: 101856699<br>
<hr>NEW: 101856799<br>
<hr>NEW: 101856899<br>
<hr>NEW: 101856999<br>
<hr>NEW: 101857099<br>
<hr>NEW: 101857199<br>
<hr>NEW: 101857299<br>
<hr>NEW: 101857399<br>
<hr>NEW: 101857499<br>
<hr>NEW: 101857599<br>
<hr>NEW: 101857699<br>
<hr>NEW: 101857799<br>
<hr>NEW: 101857899<br>
<hr>NEW: 101857999<br>
<hr>NEW: 101858099<br>
<hr>NEW: 101858199<br>
<hr>NEW: 101858299<br>
<hr>NEW: 101858399<br>
<hr>NEW: 101858499<br>
<hr>NEW: 101858599<br>
<hr>NEW: 101858699<br>
<hr>NEW: 101858799<br>
<hr>NEW: 101858899<br>
<hr>NEW: 101858999<br>
<hr>NEW: 101859099<br>
<hr>NEW: 101859199<br>
<hr>NEW: 101859299<br>
<hr>NEW: 101859399<br>
<hr>NEW: 101859499<br>
<hr>NEW: 101859599<br>
<hr>NEW: 101859699<br>
<hr>NEW: 101859799<br>
<hr>NEW: 101859899<br>
<hr>NEW: 101859999<br>
<hr>NEW: 101860099<br>
<hr>NEW: 101860199<br>
<hr>NEW: 101860299<br>
<hr>NEW: 101860399<br>
<hr>NEW: 101860499<br>
<hr>NEW: 101860599<br>
<hr>NEW: 101860699<br>
<hr>NEW: 101860799<br>
<hr>NEW: 101860899<br>
<hr>NEW: 101860999<br>
<hr>NEW: 101861099<br>
<hr>NEW: 101861199<br>
<hr>NEW: 101861299<br>
<hr>NEW: 101861399<br>
<hr>NEW: 101861499<br>
<hr>NEW: 101861599<br>
<hr>NEW: 101861699<br>
<hr>NEW: 101861799<br>
<hr>NEW: 101861899<br>
<hr>NEW: 101861999<br>
<hr>UPDATING: Giotto 500ml<br>
Product ID: 27389<br>
Image file: Giotto 500ml.jpg<br>
<hr>NEW: 101862199<br>
<hr>NEW: 101862299<br>
<hr>NEW: 101862399<br>
<hr>NEW: 101862499<br>
<hr>NEW: 101862599<br>
<hr>NEW: 101862699<br>
<hr>NEW: 101862799<br>
<hr>NEW: 101862899<br>
<hr>NEW: 101862999<br>
<hr>NEW: 101863099<br>
<hr>NEW: 101863199<br>
<hr>NEW: 101863299<br>
<hr>NEW: 101863399<br>
<hr>NEW: 101863499<br>
<hr>NEW: 101863599<br>
<hr>NEW: 101863699<br>
<hr>NEW: 101863799<br>
<hr>NEW: 101863899<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 = 27389
					AND option_id = 17
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101862099 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1884
					<br>UPDATE oc_option_value_description 
						SET
							name = '101862099 - GUACHE GIOT REF 532802 AMA OCRE 500ML'
						WHERE
							option_value_id = 1884
					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 = 1884

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