Product Sync.<br>
Opencart products: 141<br>
Input products: 100<br>
<hr>NEW: 101838199<br>
<hr>NEW: 101838299<br>
<hr>NEW: 101838399<br>
<hr>NEW: 101838499<br>
<hr>NEW: 101838599<br>
<hr>NEW: 101838699<br>
<hr>NEW: 101838799<br>
<hr>NEW: 101838899<br>
<hr>NEW: 101838999<br>
<hr>NEW: 101839099<br>
<hr>NEW: 101839199<br>
<hr>NEW: 101839299<br>
<hr>NEW: 101839399<br>
<hr>NEW: 101839499<br>
<hr>NEW: 101839599<br>
<hr>NEW: 101839699<br>
<hr>NEW: 101839799<br>
<hr>NEW: 101839899<br>
<hr>NEW: 101839999<br>
<hr>NEW: 101840099<br>
<hr>NEW: 101840199<br>
<hr>NEW: 101840299<br>
<hr>NEW: 101840399<br>
<hr>NEW: 101840499<br>
<hr>NEW: 101840599<br>
<hr>NEW: 101840699<br>
<hr>NEW: 101840799<br>
<hr>NEW: 101840899<br>
<hr>NEW: 101840999<br>
<hr>NEW: 101841099<br>
<hr>NEW: 101841199<br>
<hr>NEW: 101841299<br>
<hr>NEW: 101841399<br>
<hr>NEW: 101841499<br>
<hr>NEW: 101841599<br>
<hr>NEW: 101841699<br>
<hr>NEW: 101841799<br>
<hr>NEW: 101841899<br>
<hr>NEW: 101841999<br>
<hr>NEW: 101842099<br>
<hr>NEW: 101842199<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 '101842199 - %'
				)
		<hr>NEW: 101842299<br>
<hr>NEW: 101842399<br>
<hr>NEW: 101842499<br>
<hr>NEW: 101842599<br>
<hr>NEW: 101842699<br>
<hr>NEW: 101842799<br>
<hr>NEW: 101842899<br>
<hr>NEW: 101842999<br>
<hr>NEW: 101843099<br>
<hr>NEW: 101843199<br>
<hr>UPDATING: Aguarela Líquida Ecoline<br>
Product ID: 27449<br>
Image file: <br>
<hr>NEW: 101843399<br>
<hr>NEW: 101843699<br>
<hr>NEW: 101844099<br>
<hr>NEW: 101844699<br>
<hr>NEW: 101844799<br>
<hr>NEW: 101844899<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 '101844899 - %'
				)
		<hr>NEW: 101844999<br>
<hr>NEW: 101845099<br>
<hr>NEW: 101845199<br>
<hr>NEW: 101845299<br>
<hr>NEW: 101845399<br>
<hr>NEW: 101845499<br>
<hr>NEW: 101845599<br>
<hr>NEW: 101845699<br>
<hr>NEW: 101845799<br>
<hr>NEW: 101845899<br>
<hr>NEW: 101845999<br>
<hr>NEW: 101846099<br>
<hr>NEW: 101846199<br>
<hr>NEW: 101846299<br>
<hr>NEW: 101846399<br>
<hr>NEW: 101846499<br>
<hr>NEW: 101846599<br>
<hr>NEW: 101846699<br>
<hr>NEW: 101846799<br>
<hr>NEW: 101846899<br>
<hr>NEW: 101846999<br>
<hr>NEW: 101847099<br>
<hr>NEW: 101847199<br>
<hr>NEW: 101847299<br>
<hr>NEW: 101847399<br>
<hr>NEW: 101847499<br>
<hr>NEW: 101847599<br>
<hr>NEW: 101847699<br>
<hr>NEW: 101847799<br>
<hr>NEW: 101847899<br>
<hr>NEW: 101847999<br>
<hr>NEW: 101848099<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 143<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 = 27449
					AND option_id = 17
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101843299 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1530
					<br>UPDATE oc_option_value_description 
						SET
							name = '101843299 - Aguarela Ecoline Talens 30 ml Amarelo Pastel 226'
						WHERE
							option_value_id = 1530
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 428
							AND product_id = 27449
							AND option_id = 17
							AND option_value_id = 1530

				<br>DELETE FROM oc_product
					WHERE
						model = '101843299'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 428,
								product_id = 27449,
								option_id = 17,
								option_value_id = 1530,
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101843499 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1531
					<br>UPDATE oc_option_value_description 
						SET
							name = '101843499 - Aguarela Ecoline Talens 30 ml Laranja Claro 236'
						WHERE
							option_value_id = 1531
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 428
							AND product_id = 27449
							AND option_id = 17
							AND option_value_id = 1531

				<br>DELETE FROM oc_product
					WHERE
						model = '101843499'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 428,
								product_id = 27449,
								option_id = 17,
								option_value_id = 1531,
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101843599 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1532
					<br>UPDATE oc_option_value_description 
						SET
							name = '101843599 - Aguarela Ecoline Talens 30 ml Amarelo Açafrão 245'
						WHERE
							option_value_id = 1532
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 428
							AND product_id = 27449
							AND option_id = 17
							AND option_value_id = 1532

				<br>DELETE FROM oc_product
					WHERE
						model = '101843599'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 428,
								product_id = 27449,
								option_id = 17,
								option_value_id = 1532,
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101843799 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1533
					<br>UPDATE oc_option_value_description 
						SET
							name = '101843799 - Aguarela Ecoline Talens 30 ml Amarelo Ocre 227'
						WHERE
							option_value_id = 1533
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 428
							AND product_id = 27449
							AND option_id = 17
							AND option_value_id = 1533

				<br>DELETE FROM oc_product
					WHERE
						model = '101843799'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 428,
								product_id = 27449,
								option_id = 17,
								option_value_id = 1533,
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101843899 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1534
					<br>UPDATE oc_option_value_description 
						SET
							name = '101843899 - Aguarela Ecoline Talens 30 ml Amarelo Arena 259'
						WHERE
							option_value_id = 1534
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 428
							AND product_id = 27449
							AND option_id = 17
							AND option_value_id = 1534

				<br>DELETE FROM oc_product
					WHERE
						model = '101843899'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 428,
								product_id = 27449,
								option_id = 17,
								option_value_id = 1534,
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101843999 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1535
					<br>UPDATE oc_option_value_description 
						SET
							name = '101843999 - Aguarela Ecoline Talens 30 ml Violeta Azulado 548'
						WHERE
							option_value_id = 1535
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 428
							AND product_id = 27449
							AND option_id = 17
							AND option_value_id = 1535

				<br>DELETE FROM oc_product
					WHERE
						model = '101843999'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 428,
								product_id = 27449,
								option_id = 17,
								option_value_id = 1535,
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101844199 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1536
					<br>UPDATE oc_option_value_description 
						SET
							name = '101844199 - Aguarela Ecoline Talens 30 ml Azul Pastel 580'
						WHERE
							option_value_id = 1536
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 428
							AND product_id = 27449
							AND option_id = 17
							AND option_value_id = 1536

				<br>DELETE FROM oc_product
					WHERE
						model = '101844199'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 428,
								product_id = 27449,
								option_id = 17,
								option_value_id = 1536,
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101844299 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1537
					<br>UPDATE oc_option_value_description 
						SET
							name = '101844299 - Aguarela Ecoline Talens 30 ml Rosa Pastel 390'
						WHERE
							option_value_id = 1537
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 428
							AND product_id = 27449
							AND option_id = 17
							AND option_value_id = 1537

				<br>DELETE FROM oc_product
					WHERE
						model = '101844299'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 428,
								product_id = 27449,
								option_id = 17,
								option_value_id = 1537,
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101844399 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1538
					<br>UPDATE oc_option_value_description 
						SET
							name = '101844399 - Aguarela Ecoline Talens 30 ml Cinza Escuro 706'
						WHERE
							option_value_id = 1538
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 428
							AND product_id = 27449
							AND option_id = 17
							AND option_value_id = 1538

				<br>DELETE FROM oc_product
					WHERE
						model = '101844399'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 428,
								product_id = 27449,
								option_id = 17,
								option_value_id = 1538,
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101844499 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1539
					<br>UPDATE oc_option_value_description 
						SET
							name = '101844499 - Aguarela Ecoline Talens 30 ml Cinza Quente 718'
						WHERE
							option_value_id = 1539
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 428
							AND product_id = 27449
							AND option_id = 17
							AND option_value_id = 1539

				<br>DELETE FROM oc_product
					WHERE
						model = '101844499'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 428,
								product_id = 27449,
								option_id = 17,
								option_value_id = 1539,
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101844599 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1540
					<br>UPDATE oc_option_value_description 
						SET
							name = '101844599 - Aguarela Ecoline Talens 30 ml Chartreuse 233'
						WHERE
							option_value_id = 1540
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 428
							AND product_id = 27449
							AND option_id = 17
							AND option_value_id = 1540

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