Product Sync.<br>
Opencart products: 347<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: 27303<br>
Image file: <br>
<hr>UPDATING: White Spirit Talens<br>
Product ID: 27015<br>
Image file: <br>
<hr>UPDATING: Médio para Óleo Winsor & Newton<br>
Product ID: 27111<br>
Image file: <br>
<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: 27183<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: 353<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 = 27340
					AND option_id = 15
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27340,
						option_id = 15,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '491100999 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2902
					<br>UPDATE oc_option_value_description 
						SET
							name = '491100999 - Médio para Acrílico Talens 012 Brilhante S2 75 ml'
						WHERE
							option_value_id = 2902
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 361
							AND product_id = 27340
							AND option_id = 15
							AND option_value_id = 2902

				<br>DELETE FROM oc_product
					WHERE
						model = '491100999'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 361,
								product_id = 27340,
								option_id = 15,
								option_value_id = 2902,
								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>UPDATE oc_option_value 
						SET
							image = 'catalog/491101199.jpg'
						WHERE
							option_value_id = 2903
					<br>UPDATE oc_option_value_description 
						SET
							name = '491101199 - Médio para Acrílico Talens Brilhante S2 250 ml'
						WHERE
							option_value_id = 2903
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 361
							AND product_id = 27340
							AND option_id = 15
							AND option_value_id = 2903

				<br>DELETE FROM oc_product
					WHERE
						model = '491101199'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 361,
								product_id = 27340,
								option_id = 15,
								option_value_id = 2903,
								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>UPDATE oc_option_value 
						SET
							image = 'catalog/491101299.jpg'
						WHERE
							option_value_id = 2904
					<br>UPDATE oc_option_value_description 
						SET
							name = '491101299 - Médio para Acrílico Talens 117 Mate S2 250 ml'
						WHERE
							option_value_id = 2904
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 361
							AND product_id = 27340
							AND option_id = 15
							AND option_value_id = 2904

				<br>DELETE FROM oc_product
					WHERE
						model = '491101299'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 361,
								product_id = 27340,
								option_id = 15,
								option_value_id = 2904,
								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>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2905
					<br>UPDATE oc_option_value_description 
						SET
							name = '491101799 - Médio para Acrílico Talens 117 Mate S2 75 ml'
						WHERE
							option_value_id = 2905
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 361
							AND product_id = 27340
							AND option_id = 15
							AND option_value_id = 2905

				<br>DELETE FROM oc_product
					WHERE
						model = '491101799'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 361,
								product_id = 27340,
								option_id = 15,
								option_value_id = 2905,
								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 = 27303
					AND option_id = 15
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '491101399 - %'

				<br>UPDATE oc_option_value 
						SET
							image = 'catalog/491101399.jpg'
						WHERE
							option_value_id = 2906
					<br>UPDATE oc_option_value_description 
						SET
							name = '491101399 - Médio Secante para Óleo Talens  Courtrai Claro 75 ml'
						WHERE
							option_value_id = 2906
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 350
							AND product_id = 27303
							AND option_id = 15
							AND option_value_id = 2906

				<br>DELETE FROM oc_product
					WHERE
						model = '491101399'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 350,
								product_id = 27303,
								option_id = 15,
								option_value_id = 2906,
								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>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2907
					<br>UPDATE oc_option_value_description 
						SET
							name = '491101499 - Médio Secante para òleo Talens Harlem Escuro 75 ml'
						WHERE
							option_value_id = 2907
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 350
							AND product_id = 27303
							AND option_id = 15
							AND option_value_id = 2907

				<br>DELETE FROM oc_product
					WHERE
						model = '491101499'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 350,
								product_id = 27303,
								option_id = 15,
								option_value_id = 2907,
								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 = 27015
					AND option_id = 15
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '491101599 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2908
					<br>UPDATE oc_option_value_description 
						SET
							name = '491101599 - White Spirit Talens 75 ml'
						WHERE
							option_value_id = 2908
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 84
							AND product_id = 27015
							AND option_id = 15
							AND option_value_id = 2908

				<br>DELETE FROM oc_product
					WHERE
						model = '491101599'
				<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 = 84
								AND product_id = 27015
								AND option_id = 15
								AND option_value_id = 2908
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '491101699 - %'

				<br>UPDATE oc_option_value 
						SET
							image = 'catalog/491101699.jpg'
						WHERE
							option_value_id = 2909
					<br>UPDATE oc_option_value_description 
						SET
							name = '491101699 - White Spirit Talens Inodoro 75 ml'
						WHERE
							option_value_id = 2909
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 84
							AND product_id = 27015
							AND option_id = 15
							AND option_value_id = 2909

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

				<br>UPDATE oc_option_value 
						SET
							image = 'catalog/491102099.jpg'
						WHERE
							option_value_id = 2910
					<br>UPDATE oc_option_value_description 
						SET
							name = '491102099 - Médio para Óleo Winsor & Newton Liquin 75 ml'
						WHERE
							option_value_id = 2910
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 
							AND product_id = 
							AND option_id = 15
							AND option_value_id = 2910

				<br>DELETE FROM oc_product
					WHERE
						model = '491102099'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								option_value_id = 2910,
								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 = 27183
					AND option_id = 15
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '491104499 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2911
					<br>UPDATE oc_option_value_description 
						SET
							name = '491104499 - Médio Gel para Acrílico Talens 094 Brilhante 1 lt'
						WHERE
							option_value_id = 2911
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 312
							AND product_id = 27183
							AND option_id = 15
							AND option_value_id = 2911

				<br>DELETE FROM oc_product
					WHERE
						model = '491104499'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 312,
								product_id = 27183,
								option_id = 15,
								option_value_id = 2911,
								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>UPDATE oc_option_value 
						SET
							image = 'catalog/491105399.jpg'
						WHERE
							option_value_id = 2912
					<br>UPDATE oc_option_value_description 
						SET
							name = '491105399 - Médio Gel para Acrílico Talens 094 Brilhante 250 ml'
						WHERE
							option_value_id = 2912
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 312
							AND product_id = 27183
							AND option_id = 15
							AND option_value_id = 2912

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