Product Sync.<br>
Opencart products: 200<br>
Input products: 100<br>
<hr>NEW: 101303099<br>
<hr>NEW: 101303199<br>
<hr>NEW: 101303299<br>
<hr>NEW: 101303399<br>
<hr>NEW: 101303499<br>
<hr>NEW: 101303599<br>
<hr>NEW: 101303699<br>
<hr>NEW: 101303799<br>
<hr>NEW: 101303899<br>
<hr>NEW: 101303999<br>
<hr>NEW: 101304099<br>
<hr>NEW: 101304199<br>
<hr>NEW: 101304299<br>
<hr>NEW: 101304399<br>
<hr>NEW: 101304499<br>
<hr>NEW: 101304599<br>
<hr>NEW: 101304699<br>
<hr>NEW: 101304799<br>
<hr>NEW: 101304899<br>
<hr>NEW: 101304999<br>
<hr>NEW: 101305099<br>
<hr>NEW: 101305199<br>
<hr>NEW: 101305299<br>
<hr>NEW: 101305399<br>
<hr>NEW: 101305499<br>
<hr>NEW: 101305599<br>
<hr>NEW: 101305699<br>
<hr>NEW: 101305799<br>
<hr>NEW: 101305899<br>
<hr>NEW: 101305999<br>
<hr>NEW: 101306099<br>
<hr>NEW: 101306199<br>
<hr>NEW: 101306299<br>
<hr>NEW: 101306399<br>
<hr>NEW: 101306499<br>
<hr>NEW: 101306599<br>
<hr>NEW: 101306699<br>
<hr>NEW: 101306799<br>
<hr>NEW: 101306899<br>
<hr>NEW: 101306999<br>
<hr>NEW: 101307099<br>
<hr>NEW: 101307199<br>
<hr>NEW: 101307299<br>
<hr>NEW: 101307399<br>
<hr>NEW: 101307499<br>
<hr>NEW: 101307599<br>
<hr>NEW: 101307699<br>
<hr>NEW: 101307799<br>
<hr>NEW: 101307899<br>
<hr>NEW: 101307999<br>
<hr>NEW: 101308099<br>
<hr>NEW: 101308199<br>
<hr>NEW: 101308299<br>
<hr>NEW: 101308399<br>
<hr>NEW: 101308499<br>
<hr>NEW: 101308599<br>
<hr>NEW: 101308699<br>
<hr>NEW: 101308799<br>
<hr>NEW: 101308899<br>
<hr>NEW: 101308999<br>
<hr>NEW: 101309099<br>
<hr>NEW: 101309199<br>
<hr>NEW: 101309299<br>
<hr>NEW: 101309399<br>
<hr>NEW: 101309499<br>
<hr>NEW: 101309599<br>
<hr>NEW: 101309699<br>
<hr>NEW: 101309799<br>
<hr>NEW: 101309899<br>
<hr>NEW: 101309999<br>
<hr>NEW: 101310099<br>
<hr>NEW: 101310199<br>
<hr>NEW: 101310299<br>
<hr>NEW: 101310399<br>
<hr>NEW: 101310499<br>
<hr>NEW: 101310599<br>
<hr>NEW: 101310699<br>
<hr>NEW: 101310799<br>
<hr>NEW: 101310899<br>
<hr>NEW: 101310999<br>
<hr>NEW: 101311099<br>
<hr>NEW: 101311199<br>
<hr>NEW: 101311299<br>
<hr>NEW: 101311399<br>
<hr>NEW: 101311499<br>
<hr>NEW: 101311599<br>
<hr>NEW: 101311699<br>
<hr>NEW: 101311799<br>
<hr>NEW: 101311899<br>
<hr>NEW: 101311999<br>
<hr>NEW: 101312099<br>
<hr>NEW: 101312199<br>
<hr>NEW: 101312299<br>
<hr>UPDATING: Tela Talens<br>
Product ID: 27034<br>
Image file: <br>
<hr>NEW: 101312499<br>
<hr>NEW: 101312599<br>
<hr>NEW: 101312699<br>
<hr>NEW: 101312799<br>
<hr>NEW: 101312899<br>
<hr>NEW: 101312999<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 200<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 = 27034
					AND option_id = 15
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101312399 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2459
					<br>UPDATE oc_option_value_description 
						SET
							name = '101312399 - Tela Talens Banda Larga 100 x 120'
						WHERE
							option_value_id = 2459
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 101
							AND product_id = 27034
							AND option_id = 15
							AND option_value_id = 2459

				<br>DELETE FROM oc_product
					WHERE
						model = '101312399'
				<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 = 101
								AND product_id = 27034
								AND option_id = 15
								AND option_value_id = 2459
						<br><hr>Ok.<hr><hr>