Product Sync.<br>
Opencart products: 343<br>
Input products: 100<br>
<hr>NEW: 463116021<br>
<hr>NEW: 463116121<br>
<hr>NEW: 463116221<br>
<hr>NEW: 463116321<br>
<hr>NEW: 463116421<br>
<hr>NEW: 463116521<br>
<hr>NEW: 463116621<br>
<hr>NEW: 463116721<br>
<hr>NEW: 463116821<br>
<hr>NEW: 463116921<br>
<hr>NEW: 463117021<br>
<hr>NEW: 463117121<br>
<hr>NEW: 463117221<br>
<hr>NEW: 463117321<br>
<hr>NEW: 463117421<br>
<hr>NEW: 463117521<br>
<hr>NEW: 463117621<br>
<hr>NEW: 463117721<br>
<hr>NEW: 463117821<br>
<hr>NEW: 463117921<br>
<hr>NEW: 463118021<br>
<hr>NEW: 463118121<br>
<hr>NEW: 463118221<br>
<hr>NEW: 463118321<br>
<hr>NEW: 463118421<br>
<hr>NEW: 463118521<br>
<hr>NEW: 463118621<br>
<hr>NEW: 463118721<br>
<hr>NEW: 463118821<br>
<hr>NEW: 463118921<br>
<hr>NEW: 463119021<br>
<hr>NEW: 463119121<br>
<hr>NEW: 463119221<br>
<hr>NEW: 463119321<br>
<hr>NEW: 463119421<br>
<hr>NEW: 463119521<br>
<hr>NEW: 463119621<br>
<hr>NEW: 463119721<br>
<hr>NEW: 463119821<br>
<hr>NEW: 463119921<br>
<hr>NEW: 463120021<br>
<hr>NEW: 463120121<br>
<hr>NEW: 463120221<br>
<hr>NEW: 463120321<br>
<hr>NEW: 463120421<br>
<hr>NEW: 463120521<br>
<hr>NEW: 463120621<br>
<hr>NEW: 463120721<br>
<hr>NEW: 463146199<br>
<hr>NEW: 463150399<br>
<hr>NEW: 463158999<br>
<hr>UPDATING: Tinta para Tecido Pébéo Setacolor<br>
Product ID: 27030<br>
Image file: <br>
<hr>NEW: 463700599<br>
<hr>NEW: 463700799<br>
<hr>NEW: 463800867<br>
<hr>NEW: 463804799<br>
<hr>NEW: 464400199<br>
<hr>NEW: 464500699<br>
<hr>NEW: 464500799<br>
<hr>NEW: 464500899<br>
<hr>NEW: 464501199<br>
<hr>NEW: 464501299<br>
<hr>NEW: 464501699<br>
<hr>NEW: 464501899<br>
<hr>NEW: 464501999<br>
<hr>NEW: 464502099<br>
<hr>NEW: 464502199<br>
<hr>NEW: 464502399<br>
<hr>NEW: 464502499<br>
<hr>NEW: 464502699<br>
<hr>NEW: 464502899<br>
<hr>NEW: 464502999<br>
<hr>NEW: 464503099<br>
<hr>NEW: 464503299<br>
<hr>NEW: 464503499<br>
<hr>NEW: 464503599<br>
<hr>NEW: 464503699<br>
<hr>NEW: 464503799<br>
<hr>NEW: 464503899<br>
<hr>NEW: 464503999<br>
<hr>NEW: 464504099<br>
<hr>NEW: 464504199<br>
<hr>NEW: 464504299<br>
<hr>NEW: 464508399<br>
<hr>NEW: 464508499<br>
<hr>NEW: 464508599<br>
<hr>NEW: 464508699<br>
<hr>NEW: 464508799<br>
<hr>NEW: 464508899<br>
<hr>NEW: 464508999<br>
<hr>NEW: 464509099<br>
<hr>NEW: 464509199<br>
<hr>NEW: 465106999<br>
<hr>NEW: 465301028<br>
<hr>NEW: 465301599<br>
<hr>NEW: 465303167<br>
<hr>NEW: 465303267<br>
<hr>NEW: 465303367<br>
<hr>NEW: 465303467<br>
<hr>NEW: 465303567<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 343<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 = 27030
					AND option_id = 15
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '463700399 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2887
					<br>UPDATE oc_option_value_description 
						SET
							name = '463700399 - Setacolor Opaco Rosa Pérola'
						WHERE
							option_value_id = 2887
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 97
							AND product_id = 27030
							AND option_id = 15
							AND option_value_id = 2887

				<br>DELETE FROM oc_product
					WHERE
						model = '463700399'
				<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 = 97
								AND product_id = 27030
								AND option_id = 15
								AND option_value_id = 2887
						<br><hr>Ok.<hr><hr>