Product Sync.<br>
Opencart products: 265<br>
Input products: 100<br>
<hr>NEW: 484009999<br>
<hr>NEW: 484010499<br>
<hr>NEW: 484010599<br>
<hr>NEW: 484010699<br>
<hr>NEW: 484010799<br>
<hr>NEW: 484010899<br>
<hr>NEW: 484011499<br>
<hr>NEW: 484011899<br>
<hr>NEW: 484011999<br>
<hr>NEW: 484012099<br>
<hr>NEW: 484012399<br>
<hr>NEW: 484012799<br>
<hr>NEW: 484012999<br>
<hr>NEW: 484013099<br>
<hr>NEW: 484013299<br>
<hr>NEW: 484200164<br>
<hr>NEW: 484200402<br>
<hr>NEW: 484205021<br>
<hr>NEW: 484400164<br>
<hr>NEW: 484401502<br>
<hr>NEW: 484402120<br>
<hr>NEW: 484402321<br>
<hr>NEW: 484402421<br>
<hr>NEW: 484402799<br>
<hr>NEW: 484402861<br>
<hr>NEW: 484403102<br>
<hr>NEW: 484403561<br>
<hr>NEW: 484403661<br>
<hr>NEW: 484403761<br>
<hr>NEW: 484403861<br>
<hr>NEW: 484403961<br>
<hr>NEW: 484404161<br>
<hr>NEW: 484404464<br>
<hr>NEW: 484404564<br>
<hr>NEW: 484404761<br>
<hr>NEW: 484405064<br>
<hr>NEW: 484405164<br>
<hr>NEW: 484405264<br>
<hr>NEW: 484405364<br>
<hr>NEW: 484406099<br>
<hr>NEW: 484406299<br>
<hr>NEW: 484406499<br>
<hr>NEW: 484407299<br>
<hr>NEW: 484408302<br>
<hr>NEW: 484408402<br>
<hr>NEW: 485100499<br>
<hr>NEW: 485102199<br>
<hr>NEW: 485102399<br>
<hr>NEW: 485102599<br>
<hr>NEW: 485102699<br>
<hr>NEW: 485102799<br>
<hr>NEW: 485102899<br>
<hr>NEW: 485102999<br>
<hr>NEW: 485103099<br>
<hr>NEW: 485103199<br>
<hr>NEW: 485103399<br>
<hr>NEW: 487603799<br>
<hr>NEW: 487608099<br>
<hr>NEW: 487608199<br>
<hr>NEW: 487618299<br>
<hr>NEW: 487618399<br>
<hr>NEW: 487618499<br>
<hr>NEW: 488113199<br>
<hr>NEW: 488113299<br>
<hr>NEW: 488113799<br>
<hr>NEW: 491011199<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 '491011199 - %'
				)
		<hr>NEW: 491040299<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 '491040299 - %'
				)
		<hr>NEW: 491060199<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 '491060199 - %'
				)
		<hr>NEW: 491080399<br>
<hr>NEW: 491080499<br>
<hr>NEW: 491080699<br>
<hr>NEW: 491083199<br>
<hr>NEW: 491083299<br>
<hr>NEW: 491083399<br>
<hr>NEW: 491083499<br>
<hr>NEW: 491083599<br>
<hr>NEW: 491085999<br>
<hr>NEW: 491100199<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 '491100199 - %'
				)
		<hr>NEW: 491100399<br>
<hr>NEW: 491100699<br>
<hr>NEW: 491100799<br>
<hr>NEW: 491100899<br>
<hr>NEW: Médio para  Acrílico Talens<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 'Médio para  Acrílico Talens - %'
				)
		<hr>NEW: 491101099<br>
<hr>UPDATING: Médio Secante para Óleo Talens<br>
Product ID: 27625<br>
Image file: <br>
<hr>UPDATING: White Spirit Talens<br>
Product ID: 27439<br>
Image file: <br>
<hr>NEW: Médio para Óleo Winsor & Newton<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 'Médio para Óleo Winsor & Newton - %'
				)
		<hr>NEW: 491102199<br>
<hr>NEW: 491102299<br>
<hr>NEW: 491102499<br>
<hr>NEW: 491102599<br>
<hr>NEW: 491102999<br>
<hr>UPDATING: Médio Gel para Acrílico Extra Forte Talens<br>
Product ID: 27503<br>
Image file: <br>
<hr>NEW: 491104899<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 '491104899 - %'
				)
		<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 272<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 = 27667
					AND option_id = 17
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27667,
						option_id = 17,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '491100999 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3909 AS option_value_id,
							language_id,
							17 AS option_id,
							'491100999 - Médio para Acrílico Talens 012 Brilhante S2 75 ml' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 532
							AND product_id = 27667
							AND option_id = 17
							AND option_value_id = 3909

				<br>DELETE FROM oc_product
					WHERE
						model = '491100999'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 532,
								product_id = 27667,
								option_id = 17,
								option_value_id = 3909,
								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 '491101199 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = 'catalog/491101199.jpg',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3910 AS option_value_id,
							language_id,
							17 AS option_id,
							'491101199 - Médio para Acrílico Talens Brilhante S2 250 ml' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 532
							AND product_id = 27667
							AND option_id = 17
							AND option_value_id = 3910

				<br>DELETE FROM oc_product
					WHERE
						model = '491101199'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 532,
								product_id = 27667,
								option_id = 17,
								option_value_id = 3910,
								quantity = 1,
								subtract = 1,
								price = 8.821,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '491101299 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = 'catalog/491101299.jpg',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3911 AS option_value_id,
							language_id,
							17 AS option_id,
							'491101299 - Médio para Acrílico Talens 117 Mate S2 250 ml' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 532
							AND product_id = 27667
							AND option_id = 17
							AND option_value_id = 3911

				<br>DELETE FROM oc_product
					WHERE
						model = '491101299'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 532,
								product_id = 27667,
								option_id = 17,
								option_value_id = 3911,
								quantity = 1,
								subtract = 1,
								price = 8.821,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '491101799 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3912 AS option_value_id,
							language_id,
							17 AS option_id,
							'491101799 - Médio para Acrílico Talens 117 Mate S2 75 ml' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 532
							AND product_id = 27667
							AND option_id = 17
							AND option_value_id = 3912

				<br>DELETE FROM oc_product
					WHERE
						model = '491101799'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 532,
								product_id = 27667,
								option_id = 17,
								option_value_id = 3912,
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br><hr>SELECT product_option_id FROM oc_product_option 
				WHERE
					product_id = 27625
					AND option_id = 17
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '491101399 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = 'catalog/491101399.jpg',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3913 AS option_value_id,
							language_id,
							17 AS option_id,
							'491101399 - Médio Secante para Óleo Talens  Courtrai Claro 75 ml' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 513
							AND product_id = 27625
							AND option_id = 17
							AND option_value_id = 3913

				<br>DELETE FROM oc_product
					WHERE
						model = '491101399'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 513,
								product_id = 27625,
								option_id = 17,
								option_value_id = 3913,
								quantity = 1,
								subtract = 1,
								price = 0.162,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '491101499 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3914 AS option_value_id,
							language_id,
							17 AS option_id,
							'491101499 - Médio Secante para òleo Talens Harlem Escuro 75 ml' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 513
							AND product_id = 27625
							AND option_id = 17
							AND option_value_id = 3914

				<br>DELETE FROM oc_product
					WHERE
						model = '491101499'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 513,
								product_id = 27625,
								option_id = 17,
								option_value_id = 3914,
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br><hr>SELECT product_option_id FROM oc_product_option 
				WHERE
					product_id = 27439
					AND option_id = 17
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '491101599 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3915 AS option_value_id,
							language_id,
							17 AS option_id,
							'491101599 - White Spirit Talens 75 ml' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 420
							AND product_id = 27439
							AND option_id = 17
							AND option_value_id = 3915

				<br>DELETE FROM oc_product
					WHERE
						model = '491101599'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 420,
								product_id = 27439,
								option_id = 17,
								option_value_id = 3915,
								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 '491101699 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = 'catalog/491101699.jpg',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3916 AS option_value_id,
							language_id,
							17 AS option_id,
							'491101699 - White Spirit Talens Inodoro 75 ml' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 420
							AND product_id = 27439
							AND option_id = 17
							AND option_value_id = 3916

				<br>DELETE FROM oc_product
					WHERE
						model = '491101699'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 420,
								product_id = 27439,
								option_id = 17,
								option_value_id = 3916,
								quantity = 1,
								subtract = 1,
								price = 0.244,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br><hr>SELECT product_option_id FROM oc_product_option 
				WHERE
					product_id = 27668
					AND option_id = 17
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27668,
						option_id = 17,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '491102099 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = 'catalog/491102099.jpg',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3917 AS option_value_id,
							language_id,
							17 AS option_id,
							'491102099 - Médio para Óleo Winsor & Newton Liquin 75 ml' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 533
							AND product_id = 27668
							AND option_id = 17
							AND option_value_id = 3917

				<br>DELETE FROM oc_product
					WHERE
						model = '491102099'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 533,
								product_id = 27668,
								option_id = 17,
								option_value_id = 3917,
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br><hr>SELECT product_option_id FROM oc_product_option 
				WHERE
					product_id = 27503
					AND option_id = 17
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '491104499 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3918 AS option_value_id,
							language_id,
							17 AS option_id,
							'491104499 - Médio Gel para Acrílico Talens 094 Brilhante 1 lt' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 466
							AND product_id = 27503
							AND option_id = 17
							AND option_value_id = 3918

				<br>DELETE FROM oc_product
					WHERE
						model = '491104499'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 466,
								product_id = 27503,
								option_id = 17,
								option_value_id = 3918,
								quantity = 1,
								subtract = 1,
								price = 14.065,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '491105399 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = 'catalog/491105399.jpg',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3919 AS option_value_id,
							language_id,
							17 AS option_id,
							'491105399 - Médio Gel para Acrílico Talens 094 Brilhante 250 ml' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 466
							AND product_id = 27503
							AND option_id = 17
							AND option_value_id = 3919

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