Product Sync.<br>
Opencart products: 22<br>
Input products: 100<br>
<hr>NEW: 100101099<br>
<hr>NEW: 100101199<br>
<hr>NEW: 100101299<br>
<hr>NEW: 100101399<br>
<hr>NEW: 100101499<br>
<hr>NEW: 100101599<br>
<hr>NEW: 100101699<br>
<hr>NEW: 100101799<br>
<hr>NEW: 100101899<br>
<hr>NEW: 100101999<br>
<hr>NEW: 100102099<br>
<hr>NEW: 100102199<br>
<hr>NEW: 100102299<br>
<hr>NEW: 100102399<br>
<hr>NEW: 100102499<br>
<hr>NEW: 100102599<br>
<hr>NEW: 100102699<br>
<hr>NEW: 100102799<br>
<hr>NEW: 100102899<br>
<hr>NEW: 100102999<br>
<hr>NEW: 100103099<br>
<hr>NEW: 100103199<br>
<hr>NEW: 100103299<br>
<hr>NEW: 100103399<br>
<hr>NEW: 100103499<br>
<hr>NEW: 100103599<br>
<hr>NEW: 100103699<br>
<hr>NEW: 100103799<br>
<hr>NEW: 100103899<br>
<hr>NEW: 100103999<br>
<hr>NEW: 100104099<br>
<hr>NEW: 100104199<br>
<hr>NEW: 100104299<br>
<hr>NEW: 100104399<br>
<hr>NEW: 100104499<br>
<hr>NEW: 100104599<br>
<hr>NEW: 100104699<br>
<hr>NEW: 100104799<br>
<hr>NEW: 100104899<br>
<hr>NEW: 100104999<br>
<hr>NEW: 100105099<br>
<hr>NEW: 100105199<br>
<hr>NEW: 100105299<br>
<hr>NEW: 100105399<br>
<hr>NEW: 100105499<br>
<hr>NEW: 100105599<br>
<hr>NEW: 100105699<br>
<hr>NEW: 100105799<br>
<hr>NEW: 100105899<br>
<hr>NEW: 100105999<br>
<hr>NEW: 100106099<br>
<hr>NEW: 100106199<br>
<hr>NEW: 100106299<br>
<hr>NEW: 100106399<br>
<hr>NEW: 100106499<br>
<hr>NEW: 100106599<br>
<hr>NEW: 100106699<br>
<hr>NEW: 100106799<br>
<hr>NEW: 100106899<br>
<hr>NEW: 100106999<br>
<hr>NEW: 100107099<br>
<hr>NEW: 100107199<br>
<hr>NEW: 100107299<br>
<hr>NEW: 100107399<br>
<hr>NEW: 100107499<br>
<hr>NEW: 100107599<br>
<hr>NEW: 100107699<br>
<hr>NEW: 100107799<br>
<hr>NEW: 100107899<br>
<hr>NEW: 100107999<br>
<hr>NEW: 100108099<br>
<hr>NEW: 100108199<br>
<hr>NEW: 100108299<br>
<hr>NEW: 100108399<br>
<hr>NEW: 100108499<br>
<hr>NEW: 100108599<br>
<hr>NEW: 100108699<br>
<hr>NEW: 100108799<br>
<hr>NEW: 100108899<br>
<hr>NEW: 100108999<br>
<hr>NEW: 100109099<br>
<hr>NEW: 100109199<br>
<hr>NEW: 100109299<br>
<hr>NEW: 100109399<br>
<hr>NEW: 100109499<br>
<hr>NEW: 100109599<br>
<hr>NEW: 100109699<br>
<hr>NEW: 100109799<br>
<hr>NEW: 100109899<br>
<hr>NEW: 100109999<br>
<br>DELETE FROM oc_product_option_value 
			WHERE
				option_value_id = (
					SELECT
						MAX(option_value_id)
					FROM
						oc_option_value_description
					WHERE
						name LIKE '100109999 - %'
				)
		<hr>NEW: 100110099<br>
<hr>NEW: 100110199<br>
<hr>NEW: 100110299<br>
<hr>NEW: Tela Creatore 3D<br>
<br>DELETE FROM oc_product_option_value 
			WHERE
				option_value_id = (
					SELECT
						MAX(option_value_id)
					FROM
						oc_option_value_description
					WHERE
						name LIKE 'Tela Creatore 3D - %'
				)
		<hr>NEW: 100110499<br>
<hr>NEW: 100110599<br>
<hr>NEW: 100110699<br>
<hr>NEW: 100110799<br>
<hr>NEW: 100110899<br>
<hr>NEW: 100110999<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 24<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 = 27421
					AND option_id = 17
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27421,
						option_id = 17,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100110399 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3244 AS option_value_id,
							language_id,
							17 AS option_id,
							'100110399 - Tela Creatore 3D 100 x 100' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 407
							AND product_id = 27421
							AND option_id = 17
							AND option_value_id = 3244

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