Product Sync.<br>
Opencart products: 178<br>
Input products: 100<br>
<hr>NEW: 100717199<br>
<hr>NEW: 100717299<br>
<hr>NEW: 100717399<br>
<hr>NEW: 100717499<br>
<hr>NEW: 100717599<br>
<hr>NEW: 100717699<br>
<hr>NEW: 100717799<br>
<hr>NEW: 100717899<br>
<hr>NEW: 100717999<br>
<hr>NEW: 100718099<br>
<hr>NEW: 100718199<br>
<hr>NEW: 100718299<br>
<hr>NEW: 100718399<br>
<hr>NEW: 100718499<br>
<hr>NEW: 100718599<br>
<hr>NEW: 100718699<br>
<hr>NEW: 100718799<br>
<hr>NEW: 100718899<br>
<hr>NEW: 100718999<br>
<hr>NEW: 100719099<br>
<hr>NEW: 100719199<br>
<hr>NEW: 100719299<br>
<hr>NEW: 100719399<br>
<hr>NEW: 100719499<br>
<hr>NEW: 100719599<br>
<hr>NEW: 100719699<br>
<hr>NEW: 100719799<br>
<hr>NEW: 100719899<br>
<hr>NEW: 100719999<br>
<hr>NEW: 100720099<br>
<hr>NEW: 100720199<br>
<hr>NEW: 100720299<br>
<hr>NEW: 100720399<br>
<hr>NEW: 100720499<br>
<hr>NEW: 100720599<br>
<hr>NEW: 100720699<br>
<hr>NEW: 100720799<br>
<hr>NEW: 100720899<br>
<hr>NEW: 100720999<br>
<hr>NEW: 100721099<br>
<hr>NEW: 100721199<br>
<hr>NEW: 100721299<br>
<hr>NEW: 100721399<br>
<hr>NEW: 100721499<br>
<hr>NEW: 100721599<br>
<hr>NEW: 100721699<br>
<hr>NEW: 100721799<br>
<hr>NEW: 100721899<br>
<hr>NEW: 100721999<br>
<hr>NEW: 100722099<br>
<hr>NEW: 100722199<br>
<hr>NEW: 100722299<br>
<hr>NEW: 100722399<br>
<hr>NEW: 100722499<br>
<hr>NEW: 100722599<br>
<hr>NEW: 100722699<br>
<hr>NEW: 100722799<br>
<hr>NEW: 100722899<br>
<hr>NEW: 100722999<br>
<hr>NEW: 100723099<br>
<hr>NEW: 100723199<br>
<hr>NEW: 100723299<br>
<hr>NEW: 100723399<br>
<hr>NEW: 100723499<br>
<hr>NEW: 100723599<br>
<hr>NEW: 100723699<br>
<hr>NEW: 100723799<br>
<hr>NEW: 100723899<br>
<hr>NEW: 100723999<br>
<hr>UPDATING: Aguarela Líquida Ecoline<br>
Product ID: 27024<br>
Image file: <br>
<hr>NEW: 100724199<br>
<hr>NEW: 100724299<br>
<hr>NEW: 100724399<br>
<hr>NEW: 100724499<br>
<hr>NEW: 100724599<br>
<hr>NEW: 100724699<br>
<hr>NEW: 100724799<br>
<hr>NEW: 100724899<br>
<hr>NEW: 100724999<br>
<hr>NEW: 100725099<br>
<hr>NEW: 100725199<br>
<hr>NEW: 100725299<br>
<hr>NEW: 100725399<br>
<hr>NEW: 100725499<br>
<hr>NEW: 100725599<br>
<hr>NEW: 100725699<br>
<hr>NEW: 100725799<br>
<hr>NEW: 100725899<br>
<hr>NEW: 100725999<br>
<hr>NEW: 100726099<br>
<hr>NEW: 100726199<br>
<hr>NEW: 100726299<br>
<hr>NEW: 100726399<br>
<hr>NEW: 100726499<br>
<hr>NEW: 100726599<br>
<hr>NEW: 100726699<br>
<hr>NEW: 100726799<br>
<hr>NEW: 100726899<br>
<hr>NEW: 100726999<br>
<hr>NEW: 100727099<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 178<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 = 27024
					AND option_id = 15
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100724099 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1529
					<br>UPDATE oc_option_value_description 
						SET
							name = '100724099 - Aguarela Ecoline Talens 25 - 30 ml Verde Claro 601'
						WHERE
							option_value_id = 1529
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 92
							AND product_id = 27024
							AND option_id = 15
							AND option_value_id = 1529

				<br>DELETE FROM oc_product
					WHERE
						model = '100724099'
				<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 = 92
								AND product_id = 27024
								AND option_id = 15
								AND option_value_id = 1529
						<br><hr>Ok.<hr><hr>