Product Sync.<br>
Opencart products: 10<br>
Input products: 100<br>
<hr>UPDATING: Galeria W&N 120ml<br>
Product ID: 27381<br>
Image file: <br>
<hr>NEW: 100011699<br>
<hr>NEW: 100011799<br>
<hr>NEW: 100011899<br>
<hr>NEW: 100011999<br>
<hr>NEW: 100012099<br>
<hr>NEW: 100012199<br>
<hr>NEW: 100012299<br>
<hr>NEW: 100012399<br>
<hr>NEW: 100012499<br>
<hr>NEW: 100012599<br>
<hr>NEW: 100012699<br>
<hr>NEW: 100012799<br>
<hr>NEW: 100012899<br>
<hr>NEW: 100012999<br>
<hr>NEW: 100013099<br>
<hr>NEW: 100013199<br>
<hr>NEW: 100013299<br>
<hr>NEW: 100013399<br>
<hr>NEW: 100013499<br>
<hr>NEW: 100013599<br>
<hr>NEW: 100013699<br>
<hr>NEW: 100013799<br>
<hr>NEW: 100013899<br>
<hr>NEW: 100013999<br>
<hr>NEW: 100014099<br>
<hr>NEW: Caixas e Conjuntos<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 'Caixas e Conjuntos - %'
				)
		<hr>NEW: 100014399<br>
<hr>NEW: 100014499<br>
<hr>NEW: 100014599<br>
<hr>NEW: 100014699<br>
<hr>NEW: 100014799<br>
<hr>NEW: 100014899<br>
<hr>NEW: 100014999<br>
<hr>NEW: 100015099<br>
<hr>NEW: 100015199<br>
<hr>NEW: 100015299<br>
<hr>NEW: 100015399<br>
<hr>NEW: 100015499<br>
<hr>NEW: 100015599<br>
<hr>NEW: 100015699<br>
<hr>NEW: 100015799<br>
<hr>NEW: 100015899<br>
<hr>NEW: 100015999<br>
<hr>NEW: 100016099<br>
<hr>NEW: 100016199<br>
<hr>NEW: 100016299<br>
<hr>NEW: 100016399<br>
<hr>NEW: 100016499<br>
<hr>NEW: 100016599<br>
<hr>NEW: 100016699<br>
<hr>NEW: 100016799<br>
<hr>NEW: 100016899<br>
<hr>NEW: 100016999<br>
<hr>NEW: 100017099<br>
<hr>NEW: 100017199<br>
<hr>NEW: 100017299<br>
<hr>NEW: 100017399<br>
<hr>NEW: 100017499<br>
<hr>NEW: 100017599<br>
<hr>NEW: 100017699<br>
<hr>NEW: 100017799<br>
<hr>NEW: 100017899<br>
<hr>NEW: 100017999<br>
<hr>NEW: 100018099<br>
<hr>NEW: 100018199<br>
<hr>NEW: 100018299<br>
<hr>NEW: 100018399<br>
<hr>NEW: 100018499<br>
<hr>NEW: 100018599<br>
<hr>NEW: 100018699<br>
<hr>NEW: 100018799<br>
<hr>NEW: 100018899<br>
<hr>NEW: 100018999<br>
<hr>NEW: 100019099<br>
<hr>NEW: 100019199<br>
<hr>NEW: 100019299<br>
<hr>NEW: 100019399<br>
<hr>NEW: 100019499<br>
<hr>NEW: 100019599<br>
<hr>NEW: 100019699<br>
<hr>NEW: 100019799<br>
<hr>NEW: 100019899<br>
<hr>NEW: 100019999<br>
<hr>NEW: 100020099<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 11<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 = 27381
					AND option_id = 17
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100010199 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1137
					<br>UPDATE oc_option_value_description 
						SET
							name = '100010199 - ACRIL GALER 120ML PERMANENT ROSE'
						WHERE
							option_value_id = 1137
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 374
							AND product_id = 27381
							AND option_id = 17
							AND option_value_id = 1137

				<br>DELETE FROM oc_product
					WHERE
						model = '100010199'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 374,
								product_id = 27381,
								option_id = 17,
								option_value_id = 1137,
								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 '100010299 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1138
					<br>UPDATE oc_option_value_description 
						SET
							name = '100010299 - ACRIL GALER 120ML PROCESS MAGENTA'
						WHERE
							option_value_id = 1138
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 374
							AND product_id = 27381
							AND option_id = 17
							AND option_value_id = 1138

				<br>DELETE FROM oc_product
					WHERE
						model = '100010299'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 374,
								product_id = 27381,
								option_id = 17,
								option_value_id = 1138,
								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 '100010399 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1139
					<br>UPDATE oc_option_value_description 
						SET
							name = '100010399 - ACRIL GALER 120ML PROCESS CYAN 535'
						WHERE
							option_value_id = 1139
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 374
							AND product_id = 27381
							AND option_id = 17
							AND option_value_id = 1139

				<br>DELETE FROM oc_product
					WHERE
						model = '100010399'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 374,
								product_id = 27381,
								option_id = 17,
								option_value_id = 1139,
								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 '100010499 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1140
					<br>UPDATE oc_option_value_description 
						SET
							name = '100010499 - ACRIL GALER 120ML PROCESS YELLOW 537'
						WHERE
							option_value_id = 1140
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 374
							AND product_id = 27381
							AND option_id = 17
							AND option_value_id = 1140

				<br>DELETE FROM oc_product
					WHERE
						model = '100010499'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 374,
								product_id = 27381,
								option_id = 17,
								option_value_id = 1140,
								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 '100010599 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1141
					<br>UPDATE oc_option_value_description 
						SET
							name = '100010599 - ACRIL GALER 120ML PRUSSIAN BLUE HUE'
						WHERE
							option_value_id = 1141
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 374
							AND product_id = 27381
							AND option_id = 17
							AND option_value_id = 1141

				<br>DELETE FROM oc_product
					WHERE
						model = '100010599'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 374,
								product_id = 27381,
								option_id = 17,
								option_value_id = 1141,
								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 '100010699 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1142
					<br>UPDATE oc_option_value_description 
						SET
							name = '100010699 - ACRIL GALER 120ML RAW SIENNA'
						WHERE
							option_value_id = 1142
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 374
							AND product_id = 27381
							AND option_id = 17
							AND option_value_id = 1142

				<br>DELETE FROM oc_product
					WHERE
						model = '100010699'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 374,
								product_id = 27381,
								option_id = 17,
								option_value_id = 1142,
								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 '100010799 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1143
					<br>UPDATE oc_option_value_description 
						SET
							name = '100010799 - ACRIL GALER 120ML RAW UMBER 554'
						WHERE
							option_value_id = 1143
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 374
							AND product_id = 27381
							AND option_id = 17
							AND option_value_id = 1143

				<br>DELETE FROM oc_product
					WHERE
						model = '100010799'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 374,
								product_id = 27381,
								option_id = 17,
								option_value_id = 1143,
								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 '100010899 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1144
					<br>UPDATE oc_option_value_description 
						SET
							name = '100010899 - ACRIL GALER 120ML SAP GREEN'
						WHERE
							option_value_id = 1144
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 374
							AND product_id = 27381
							AND option_id = 17
							AND option_value_id = 1144

				<br>DELETE FROM oc_product
					WHERE
						model = '100010899'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 374,
								product_id = 27381,
								option_id = 17,
								option_value_id = 1144,
								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 '100010999 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1145
					<br>UPDATE oc_option_value_description 
						SET
							name = '100010999 - ACRIL GALER 120ML TITANIUM WHITE 644'
						WHERE
							option_value_id = 1145
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 374
							AND product_id = 27381
							AND option_id = 17
							AND option_value_id = 1145

				<br>DELETE FROM oc_product
					WHERE
						model = '100010999'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 374,
								product_id = 27381,
								option_id = 17,
								option_value_id = 1145,
								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 '100011099 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1146
					<br>UPDATE oc_option_value_description 
						SET
							name = '100011099 - ACRIL GALER 120ML ULTRAMARINE'
						WHERE
							option_value_id = 1146
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 374
							AND product_id = 27381
							AND option_id = 17
							AND option_value_id = 1146

				<br>DELETE FROM oc_product
					WHERE
						model = '100011099'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 374,
								product_id = 27381,
								option_id = 17,
								option_value_id = 1146,
								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 '100011199 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1147
					<br>UPDATE oc_option_value_description 
						SET
							name = '100011199 - ACRIL GALER 120ML VANDYKE BROWN'
						WHERE
							option_value_id = 1147
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 374
							AND product_id = 27381
							AND option_id = 17
							AND option_value_id = 1147

				<br>DELETE FROM oc_product
					WHERE
						model = '100011199'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 374,
								product_id = 27381,
								option_id = 17,
								option_value_id = 1147,
								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 '100011299 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1148
					<br>UPDATE oc_option_value_description 
						SET
							name = '100011299 - ACRIL GALER 120ML VERMILION HUE'
						WHERE
							option_value_id = 1148
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 374
							AND product_id = 27381
							AND option_id = 17
							AND option_value_id = 1148

				<br>DELETE FROM oc_product
					WHERE
						model = '100011299'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 374,
								product_id = 27381,
								option_id = 17,
								option_value_id = 1148,
								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 '100011399 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1149
					<br>UPDATE oc_option_value_description 
						SET
							name = '100011399 - ACRIL GALER 120ML YELLOW OCHRE'
						WHERE
							option_value_id = 1149
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 374
							AND product_id = 27381
							AND option_id = 17
							AND option_value_id = 1149

				<br>DELETE FROM oc_product
					WHERE
						model = '100011399'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 374,
								product_id = 27381,
								option_id = 17,
								option_value_id = 1149,
								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 '100011499 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1150
					<br>UPDATE oc_option_value_description 
						SET
							name = '100011499 - ACRIL GALER 120ML S2 GOLD'
						WHERE
							option_value_id = 1150
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 374
							AND product_id = 27381
							AND option_id = 17
							AND option_value_id = 1150

				<br>DELETE FROM oc_product
					WHERE
						model = '100011499'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 374,
								product_id = 27381,
								option_id = 17,
								option_value_id = 1150,
								quantity = 1,
								subtract = 1,
								price = 1.057,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100011599 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1151
					<br>UPDATE oc_option_value_description 
						SET
							name = '100011599 - ACRIL GALER 120ML S2 SILVER'
						WHERE
							option_value_id = 1151
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 374
							AND product_id = 27381
							AND option_id = 17
							AND option_value_id = 1151

				<br>DELETE FROM oc_product
					WHERE
						model = '100011599'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 374,
								product_id = 27381,
								option_id = 17,
								option_value_id = 1151,
								quantity = 1,
								subtract = 1,
								price = 1.057,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br><hr>SELECT product_option_id FROM oc_product_option 
				WHERE
					product_id = 27382
					AND option_id = 17
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27382,
						option_id = 17,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100014199 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1711
					<br>UPDATE oc_option_value_description 
						SET
							name = '100014199 - CXA AGUAR COTMAN 24 MEIAS PASTIL+PINCEL PAINT PLUS'
						WHERE
							option_value_id = 1711
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 375
							AND product_id = 27382
							AND option_id = 17
							AND option_value_id = 1711

				<br>DELETE FROM oc_product
					WHERE
						model = '100014199'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 375,
								product_id = 27382,
								option_id = 17,
								option_value_id = 1711,
								quantity = 1,
								subtract = 1,
								price = 1.951,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100014299 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1712
					<br>UPDATE oc_option_value_description 
						SET
							name = '100014299 - CXA AGUAR COTMAN 12 TUBOS E PINCEL'
						WHERE
							option_value_id = 1712
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 375
							AND product_id = 27382
							AND option_id = 17
							AND option_value_id = 1712

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