Product Sync.<br>
Opencart products: 29<br>
Input products: 100<br>
<hr>NEW: 101803399<br>
<hr>NEW: 101803499<br>
<hr>NEW: 101803599<br>
<hr>NEW: 101803699<br>
<hr>NEW: 101803799<br>
<hr>NEW: 101803899<br>
<hr>NEW: 101803999<br>
<hr>NEW: 101804099<br>
<hr>NEW: 101804199<br>
<hr>NEW: 101804299<br>
<hr>NEW: 101804399<br>
<hr>NEW: 101804499<br>
<hr>NEW: 101804599<br>
<hr>NEW: 101804699<br>
<hr>NEW: 101804799<br>
<hr>UPDATING: Caixas e Conjuntos<br>
Product ID: 27382<br>
Image file: Caixas e Conjuntos.jpg<br>
<hr>NEW: 101805099<br>
<hr>NEW: 101805199<br>
<hr>NEW: 101805299<br>
<hr>NEW: 101805399<br>
<hr>NEW: 101805499<br>
<hr>NEW: 101805599<br>
<hr>NEW: 101805699<br>
<hr>NEW: 101805799<br>
<hr>NEW: 101805899<br>
<hr>NEW: 101805999<br>
<hr>NEW: 101806099<br>
<hr>NEW: 101806199<br>
<hr>NEW: 101806299<br>
<hr>NEW: 101806399<br>
<hr>NEW: 101806499<br>
<hr>NEW: 101806599<br>
<hr>NEW: 101806699<br>
<hr>NEW: 101806799<br>
<hr>NEW: 101806899<br>
<hr>NEW: 101806999<br>
<hr>NEW: 101807099<br>
<hr>NEW: 101807199<br>
<hr>NEW: 101807299<br>
<hr>NEW: 101807399<br>
<hr>NEW: 101807499<br>
<hr>NEW: 101807599<br>
<hr>NEW: 101807699<br>
<hr>NEW: 101807799<br>
<hr>NEW: 101807899<br>
<hr>NEW: 101807999<br>
<hr>NEW: 101808099<br>
<hr>NEW: 101808199<br>
<hr>NEW: 101808299<br>
<hr>NEW: 101808399<br>
<hr>NEW: 101808499<br>
<hr>NEW: 101808599<br>
<hr>NEW: 101808699<br>
<hr>NEW: 101808799<br>
<hr>NEW: 101808899<br>
<hr>NEW: 101808999<br>
<hr>NEW: 101809099<br>
<hr>NEW: 101809199<br>
<hr>NEW: 101809299<br>
<hr>NEW: 101809399<br>
<hr>NEW: 101809499<br>
<hr>NEW: 101809599<br>
<hr>NEW: 101809699<br>
<hr>NEW: 101809799<br>
<hr>NEW: 101809899<br>
<hr>NEW: 101809999<br>
<hr>NEW: 101810099<br>
<hr>NEW: 101810199<br>
<hr>NEW: 101810299<br>
<hr>NEW: 101810399<br>
<hr>NEW: 101810499<br>
<hr>NEW: 101810599<br>
<hr>NEW: 101810699<br>
<hr>NEW: 101810799<br>
<hr>NEW: 101810899<br>
<hr>NEW: 101810999<br>
<hr>NEW: 101811099<br>
<hr>NEW: 101811199<br>
<hr>NEW: 101811299<br>
<hr>NEW: 101811399<br>
<hr>NEW: 101811499<br>
<hr>NEW: 101811599<br>
<hr>NEW: 101811699<br>
<hr>NEW: 101811799<br>
<hr>NEW: 101811899<br>
<hr>NEW: 101811999<br>
<hr>NEW: 101812099<br>
<hr>NEW: 101812199<br>
<hr>NEW: 101812299<br>
<hr>NEW: 101812399<br>
<hr>NEW: 101812499<br>
<hr>NEW: 101812599<br>
<hr>NEW: 101812699<br>
<hr>NEW: 101812799<br>
<hr>NEW: 101812899<br>
<hr>NEW: 101812999<br>
<hr>NEW: 101813099<br>
<hr>NEW: 101813199<br>
<hr>NEW: 101813299<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 29<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 = 27382
					AND option_id = 17
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101804899 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1821
					<br>UPDATE oc_option_value_description 
						SET
							name = '101804899 - CXA AGUAR DR 18 MEIAS PASTILHAS + 2 TB'
						WHERE
							option_value_id = 1821
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 375
							AND product_id = 27382
							AND option_id = 17
							AND option_value_id = 1821

				<br>DELETE FROM oc_product
					WHERE
						model = '101804899'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 375,
								product_id = 27382,
								option_id = 17,
								option_value_id = 1821,
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101804999 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1822
					<br>UPDATE oc_option_value_description 
						SET
							name = '101804999 - CXA AGUAR DR C/20 MEIAS PASTILHAS'
						WHERE
							option_value_id = 1822
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 375
							AND product_id = 27382
							AND option_id = 17
							AND option_value_id = 1822

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