Product Sync.<br>
Opencart products: 23<br>
Input products: 100<br>
<hr>NEW: 100962599<br>
<hr>NEW: 100962699<br>
<hr>NEW: 100962799<br>
<hr>NEW: 100962899<br>
<hr>NEW: 100962999<br>
<hr>NEW: 100963099<br>
<hr>NEW: 100963199<br>
<hr>NEW: 100963299<br>
<hr>NEW: 100963399<br>
<hr>NEW: 100963499<br>
<hr>NEW: 100963599<br>
<hr>NEW: 100963699<br>
<hr>NEW: 100963799<br>
<hr>NEW: 100963899<br>
<hr>NEW: 100963999<br>
<hr>NEW: 100964099<br>
<hr>NEW: 100964199<br>
<hr>NEW: 100964299<br>
<hr>NEW: 100964399<br>
<hr>NEW: 100964499<br>
<hr>NEW: 100964599<br>
<hr>NEW: 100964699<br>
<hr>NEW: 100964799<br>
<hr>NEW: 100964899<br>
<hr>NEW: 100964999<br>
<hr>NEW: 100965099<br>
<hr>NEW: 100965199<br>
<hr>NEW: 100965299<br>
<hr>NEW: 100965399<br>
<hr>NEW: 100965499<br>
<hr>NEW: 100965599<br>
<hr>NEW: 100965699<br>
<hr>NEW: 100965799<br>
<hr>NEW: 100965899<br>
<hr>NEW: 100965999<br>
<hr>NEW: 100966099<br>
<hr>NEW: 100966199<br>
<hr>NEW: 100966299<br>
<hr>NEW: 100966399<br>
<hr>NEW: 100966499<br>
<hr>NEW: 100966599<br>
<hr>NEW: 100966699<br>
<hr>NEW: 100966799<br>
<hr>NEW: 100966899<br>
<hr>NEW: 100966999<br>
<hr>NEW: 100967099<br>
<hr>NEW: 100967199<br>
<hr>NEW: 100967299<br>
<hr>NEW: 100967399<br>
<hr>NEW: 100967499<br>
<hr>NEW: 100967599<br>
<hr>NEW: 100967699<br>
<hr>NEW: 100967799<br>
<hr>NEW: 100967899<br>
<hr>NEW: 100967999<br>
<hr>NEW: 100968099<br>
<hr>NEW: 100968199<br>
<hr>NEW: 100968299<br>
<hr>NEW: 100968399<br>
<hr>NEW: 100968499<br>
<hr>NEW: 100968599<br>
<hr>NEW: 100968699<br>
<hr>NEW: 100968799<br>
<hr>NEW: 100968899<br>
<hr>NEW: 100968999<br>
<hr>NEW: 100969099<br>
<hr>NEW: 100969199<br>
<hr>NEW: 100969299<br>
<hr>NEW: 100969399<br>
<hr>NEW: 100969499<br>
<hr>NEW: 100969599<br>
<hr>NEW: 100969699<br>
<hr>NEW: 100969799<br>
<hr>NEW: 100969899<br>
<hr>NEW: 100969999<br>
<hr>NEW: 100970099<br>
<hr>NEW: 100970199<br>
<hr>NEW: 100970299<br>
<hr>NEW: 100970399<br>
<hr>NEW: 100970499<br>
<hr>NEW: 100970599<br>
<hr>NEW: 100970699<br>
<hr>NEW: 100970799<br>
<hr>NEW: 100970899<br>
<hr>NEW: 100970999<br>
<hr>NEW: 100971099<br>
<hr>NEW: 100971199<br>
<hr>NEW: 100971299<br>
<hr>NEW: 100971399<br>
<hr>NEW: 100971499<br>
<hr>NEW: 100971599<br>
<hr>NEW: 100971699<br>
<hr>NEW: 100971799<br>
<hr>NEW: 100971899<br>
<hr>NEW: 100971999<br>
<hr>NEW: 100972099<br>
<hr>NEW: 100972199<br>
<hr>NEW: 100972299<br>
<hr>UPDATING: Caixas e Conjuntos<br>
Product ID: 27382<br>
Image file: Caixas e Conjuntos.jpg<br>
<hr>NEW: 100972599<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 23<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 '100972399 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1762
					<br>UPDATE oc_option_value_description 
						SET
							name = '100972399 - SET ACRIL ART CREATION C/5 CORES PRIMARIAS 75ML'
						WHERE
							option_value_id = 1762
					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 = 1762

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