Product Sync.<br>
Opencart products: 159<br>
Input products: 100<br>
<hr>NEW: 102050399<br>
<hr>NEW: 102050499<br>
<hr>NEW: 102050599<br>
<hr>NEW: 102050699<br>
<hr>NEW: 102050799<br>
<hr>NEW: 102050899<br>
<hr>NEW: 102050999<br>
<hr>NEW: 102051099<br>
<hr>NEW: 102051199<br>
<hr>NEW: 102051299<br>
<hr>NEW: 102051399<br>
<hr>NEW: 102051499<br>
<hr>NEW: 102051599<br>
<hr>NEW: 102051699<br>
<hr>NEW: 102051799<br>
<hr>NEW: 102051899<br>
<hr>NEW: 102051999<br>
<hr>NEW: 102052099<br>
<hr>NEW: 102052199<br>
<hr>NEW: 102052299<br>
<hr>NEW: 102052399<br>
<hr>NEW: 102052499<br>
<hr>NEW: 102052599<br>
<hr>NEW: 102052699<br>
<hr>NEW: 102052799<br>
<hr>NEW: 102052899<br>
<hr>NEW: 102052999<br>
<hr>NEW: 102053099<br>
<hr>NEW: 102053199<br>
<hr>NEW: 102053299<br>
<hr>NEW: 102053399<br>
<hr>NEW: 102053499<br>
<hr>NEW: 102053599<br>
<hr>NEW: 102053699<br>
<hr>NEW: 102053799<br>
<hr>NEW: 102053899<br>
<hr>NEW: 102053999<br>
<hr>NEW: 102054099<br>
<hr>NEW: 102054199<br>
<hr>NEW: 102054299<br>
<hr>NEW: 102054399<br>
<hr>NEW: 102054499<br>
<hr>NEW: 102054599<br>
<hr>UPDATING: Tinta Relevo Pébéo para Tecido<br>
Product ID: 27556<br>
Image file: <br>
<hr>NEW: 102056299<br>
<hr>NEW: 102056399<br>
<hr>NEW: 102056499<br>
<hr>NEW: 102056599<br>
<hr>NEW: 102056699<br>
<hr>NEW: 102056799<br>
<hr>NEW: 102056899<br>
<hr>NEW: 102056999<br>
<hr>NEW: 102057099<br>
<hr>NEW: 102057199<br>
<hr>NEW: 102057299<br>
<hr>NEW: 102057399<br>
<hr>NEW: 102057499<br>
<hr>NEW: 102057599<br>
<hr>NEW: 102057699<br>
<hr>NEW: 102057799<br>
<hr>NEW: 102057899<br>
<hr>NEW: 102057999<br>
<hr>NEW: 102058099<br>
<hr>NEW: 102058199<br>
<hr>NEW: 102058299<br>
<hr>NEW: 102058399<br>
<hr>NEW: 102058499<br>
<hr>NEW: 102058599<br>
<hr>NEW: 102058699<br>
<hr>NEW: 102058799<br>
<hr>NEW: 102058899<br>
<hr>NEW: 102058999<br>
<hr>NEW: 102059099<br>
<hr>NEW: 102059199<br>
<hr>NEW: 102059299<br>
<hr>NEW: 102059399<br>
<hr>NEW: 102059499<br>
<hr>NEW: 102059599<br>
<hr>NEW: 102059699<br>
<hr>NEW: 102059799<br>
<hr>NEW: 102059899<br>
<hr>NEW: 102059999<br>
<hr>NEW: 102060099<br>
<hr>NEW: 102060199<br>
<hr>NEW: 102060299<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 159<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 = 27556
					AND option_id = 17
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '102054699 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3647 AS option_value_id,
							language_id,
							17 AS option_id,
							'102054699 - Setacolor 3D Metal 20 ml  Ouro Branco' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 493
							AND product_id = 27556
							AND option_id = 17
							AND option_value_id = 3647

				<br>DELETE FROM oc_product
					WHERE
						model = '102054699'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 493,
								product_id = 27556,
								option_id = 17,
								option_value_id = 3647,
								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 '102054799 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3648 AS option_value_id,
							language_id,
							17 AS option_id,
							'102054799 - Setacolor 3D Metal 20 ml  Papoila' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 493
							AND product_id = 27556
							AND option_id = 17
							AND option_value_id = 3648

				<br>DELETE FROM oc_product
					WHERE
						model = '102054799'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 493,
								product_id = 27556,
								option_id = 17,
								option_value_id = 3648,
								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 '102054899 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3649 AS option_value_id,
							language_id,
							17 AS option_id,
							'102054899 - Setacolor 3D Metal 20 ml  Verde esmeralda' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 493
							AND product_id = 27556
							AND option_id = 17
							AND option_value_id = 3649

				<br>DELETE FROM oc_product
					WHERE
						model = '102054899'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 493,
								product_id = 27556,
								option_id = 17,
								option_value_id = 3649,
								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 '102054999 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3650 AS option_value_id,
							language_id,
							17 AS option_id,
							'102054999 - Setacolor 3D Metal 20 ml  Cinza' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 493
							AND product_id = 27556
							AND option_id = 17
							AND option_value_id = 3650

				<br>DELETE FROM oc_product
					WHERE
						model = '102054999'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 493,
								product_id = 27556,
								option_id = 17,
								option_value_id = 3650,
								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 '102055099 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3651 AS option_value_id,
							language_id,
							17 AS option_id,
							'102055099 - Setacolor 3D Metal 20 ml  Prateado' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 493
							AND product_id = 27556
							AND option_id = 17
							AND option_value_id = 3651

				<br>DELETE FROM oc_product
					WHERE
						model = '102055099'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 493,
								product_id = 27556,
								option_id = 17,
								option_value_id = 3651,
								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 '102055199 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3652 AS option_value_id,
							language_id,
							17 AS option_id,
							'102055199 - Setacolor 3D Metal 20 ml  Azul Faiança' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 493
							AND product_id = 27556
							AND option_id = 17
							AND option_value_id = 3652

				<br>DELETE FROM oc_product
					WHERE
						model = '102055199'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 493,
								product_id = 27556,
								option_id = 17,
								option_value_id = 3652,
								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 '102055299 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3653 AS option_value_id,
							language_id,
							17 AS option_id,
							'102055299 - Setacolor 3D Metal 20 ml  Lilás' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 493
							AND product_id = 27556
							AND option_id = 17
							AND option_value_id = 3653

				<br>DELETE FROM oc_product
					WHERE
						model = '102055299'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 493,
								product_id = 27556,
								option_id = 17,
								option_value_id = 3653,
								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 '102055399 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3654 AS option_value_id,
							language_id,
							17 AS option_id,
							'102055399 - Setacolor 3D Gloss 20 ml Preto' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 493
							AND product_id = 27556
							AND option_id = 17
							AND option_value_id = 3654

				<br>DELETE FROM oc_product
					WHERE
						model = '102055399'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 493,
								product_id = 27556,
								option_id = 17,
								option_value_id = 3654,
								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 '102055499 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3655 AS option_value_id,
							language_id,
							17 AS option_id,
							'102055499 - Setacolor 3D Gloss 20 ml Azul Escuro' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 493
							AND product_id = 27556
							AND option_id = 17
							AND option_value_id = 3655

				<br>DELETE FROM oc_product
					WHERE
						model = '102055499'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 493,
								product_id = 27556,
								option_id = 17,
								option_value_id = 3655,
								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 '102055599 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3656 AS option_value_id,
							language_id,
							17 AS option_id,
							'102055599 - Setacolor 3D Gloss 20 ml Amarelo Limão' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 493
							AND product_id = 27556
							AND option_id = 17
							AND option_value_id = 3656

				<br>DELETE FROM oc_product
					WHERE
						model = '102055599'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 493,
								product_id = 27556,
								option_id = 17,
								option_value_id = 3656,
								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 '102055699 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3657 AS option_value_id,
							language_id,
							17 AS option_id,
							'102055699 - Setacolor 3D Gloss 20 ml Vermelho Pimentão' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 493
							AND product_id = 27556
							AND option_id = 17
							AND option_value_id = 3657

				<br>DELETE FROM oc_product
					WHERE
						model = '102055699'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 493,
								product_id = 27556,
								option_id = 17,
								option_value_id = 3657,
								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 '102055799 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3658 AS option_value_id,
							language_id,
							17 AS option_id,
							'102055799 - Setacolor 3D Gloss 20 ml Azul Brilhante' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 493
							AND product_id = 27556
							AND option_id = 17
							AND option_value_id = 3658

				<br>DELETE FROM oc_product
					WHERE
						model = '102055799'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 493,
								product_id = 27556,
								option_id = 17,
								option_value_id = 3658,
								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 '102055899 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3659 AS option_value_id,
							language_id,
							17 AS option_id,
							'102055899 - Setacolor 3D Gloss 20 ml Rosa' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 493
							AND product_id = 27556
							AND option_id = 17
							AND option_value_id = 3659

				<br>DELETE FROM oc_product
					WHERE
						model = '102055899'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 493,
								product_id = 27556,
								option_id = 17,
								option_value_id = 3659,
								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 '102055999 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3660 AS option_value_id,
							language_id,
							17 AS option_id,
							'102055999 - Setacolor 3D Gloss 20 ml Laranja' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 493
							AND product_id = 27556
							AND option_id = 17
							AND option_value_id = 3660

				<br>DELETE FROM oc_product
					WHERE
						model = '102055999'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 493,
								product_id = 27556,
								option_id = 17,
								option_value_id = 3660,
								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 '102056099 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3661 AS option_value_id,
							language_id,
							17 AS option_id,
							'102056099 - Setacolor 3D Gloss 20 ml Azul Claro' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 493
							AND product_id = 27556
							AND option_id = 17
							AND option_value_id = 3661

				<br>DELETE FROM oc_product
					WHERE
						model = '102056099'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 493,
								product_id = 27556,
								option_id = 17,
								option_value_id = 3661,
								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 '102056199 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3662 AS option_value_id,
							language_id,
							17 AS option_id,
							'102056199 - Setacolor 3D Gloss 20 ml Azul Bermuda' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 493
							AND product_id = 27556
							AND option_id = 17
							AND option_value_id = 3662

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