Product Sync.<br>
Opencart products: 32<br>
Input products: 100<br>
<hr>UPDATING: Galeria W&N 60ml<br>
Product ID: 27386<br>
Image file: <br>
<hr>NEW: 479858799<br>
<hr>NEW: 479859199<br>
<hr>NEW: 479859299<br>
<hr>NEW: 479859499<br>
<hr>NEW: 479859599<br>
<hr>NEW: 479859699<br>
<hr>NEW: 479860699<br>
<hr>UPDATING: Caixas e Conjuntos<br>
Product ID: 27382<br>
Image file: Caixas e Conjuntos.jpg<br>
<hr>NEW: 479870699<br>
<hr>NEW: 479881099<br>
<hr>UPDATING: Amsterdam 120ml<br>
Product ID: 27385<br>
Image file: Amsterdam 120ml.jpg<br>
<hr>NEW: 481001499<br>
<hr>NEW: 481203199<br>
<hr>NEW: 481203299<br>
<hr>NEW: 481203499<br>
<hr>NEW: 481204199<br>
<hr>NEW: 481800602<br>
<hr>NEW: 482202128<br>
<hr>NEW: 482202228<br>
<hr>NEW: 482400120<br>
<hr>NEW: 482401699<br>
<hr>NEW: 482502099<br>
<hr>NEW: 482502199<br>
<hr>NEW: 482502399<br>
<hr>NEW: 482611528<br>
<hr>NEW: 482611628<br>
<hr>NEW: 482645099<br>
<hr>NEW: 482700302<br>
<hr>NEW: 482700664<br>
<hr>NEW: 482701064<br>
<hr>NEW: 482702264<br>
<hr>NEW: 482702520<br>
<hr>NEW: 482702799<br>
<hr>NEW: 482702899<br>
<hr>NEW: 482703799<br>
<hr>NEW: 482780328<br>
<hr>NEW: 482780799<br>
<hr>NEW: 482780899<br>
<hr>NEW: 482781099<br>
<hr>NEW: 482781299<br>
<hr>NEW: 482803599<br>
<hr>NEW: 482810128<br>
<hr>NEW: 482828199<br>
<hr>NEW: 482828299<br>
<hr>NEW: 482836699<br>
<hr>NEW: 483000299<br>
<hr>NEW: 483006520<br>
<hr>NEW: 483006820<br>
<hr>NEW: 483007020<br>
<hr>NEW: 483007420<br>
<hr>NEW: 483010871<br>
<hr>NEW: 483010971<br>
<hr>NEW: 483012571<br>
<hr>NEW: 483023564<br>
<hr>NEW: 483051099<br>
<hr>NEW: 483052571<br>
<hr>NEW: 483055799<br>
<hr>NEW: 483059320<br>
<hr>NEW: 483059520<br>
<hr>NEW: 483067199<br>
<hr>NEW: 483067299<br>
<hr>NEW: 483067399<br>
<hr>NEW: 483067499<br>
<hr>NEW: 483068899<br>
<hr>NEW: 483080899<br>
<hr>NEW: 483087364<br>
<hr>NEW: 483098171<br>
<hr>NEW: 483098271<br>
<hr>NEW: 483098371<br>
<hr>NEW: 483100399<br>
<hr>NEW: 483100499<br>
<hr>NEW: 483202164<br>
<hr>NEW: 483203228<br>
<hr>NEW: 483203820<br>
<hr>NEW: 483210471<br>
<hr>NEW: 483210571<br>
<hr>NEW: 483211428<br>
<hr>NEW: 483215499<br>
<hr>NEW: 483226021<br>
<hr>NEW: 483232021<br>
<hr>NEW: 483250171<br>
<hr>NEW: 483251599<br>
<hr>NEW: 483252299<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 32<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 = 27386
					AND option_id = 17
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '479857599 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1093
					<br>UPDATE oc_option_value_description 
						SET
							name = '479857599 - ACRIL W&N GALER 60ML MIXING WHITE'
						WHERE
							option_value_id = 1093
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 379
							AND product_id = 27386
							AND option_id = 17
							AND option_value_id = 1093

				<br>DELETE FROM oc_product
					WHERE
						model = '479857599'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 379,
								product_id = 27386,
								option_id = 17,
								option_value_id = 1093,
								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 '479857699 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1094
					<br>UPDATE oc_option_value_description 
						SET
							name = '479857699 - ACRIL W&N GALER 60ML PALE LEMON'
						WHERE
							option_value_id = 1094
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 379
							AND product_id = 27386
							AND option_id = 17
							AND option_value_id = 1094

				<br>DELETE FROM oc_product
					WHERE
						model = '479857699'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 379,
								product_id = 27386,
								option_id = 17,
								option_value_id = 1094,
								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 '479857799 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1095
					<br>UPDATE oc_option_value_description 
						SET
							name = '479857799 - ACRIL W&N GALER 60ML PALE OLIVE'
						WHERE
							option_value_id = 1095
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 379
							AND product_id = 27386
							AND option_id = 17
							AND option_value_id = 1095

				<br>DELETE FROM oc_product
					WHERE
						model = '479857799'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 379,
								product_id = 27386,
								option_id = 17,
								option_value_id = 1095,
								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 '479857899 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1096
					<br>UPDATE oc_option_value_description 
						SET
							name = '479857899 - ACRIL W&N GALER 60ML PALE TERRACOTTA'
						WHERE
							option_value_id = 1096
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 379
							AND product_id = 27386
							AND option_id = 17
							AND option_value_id = 1096

				<br>DELETE FROM oc_product
					WHERE
						model = '479857899'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 379,
								product_id = 27386,
								option_id = 17,
								option_value_id = 1096,
								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 '479857999 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1097
					<br>UPDATE oc_option_value_description 
						SET
							name = '479857999 - ACRIL W&N GALER 60ML PALE UMBER'
						WHERE
							option_value_id = 1097
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 379
							AND product_id = 27386
							AND option_id = 17
							AND option_value_id = 1097

				<br>DELETE FROM oc_product
					WHERE
						model = '479857999'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 379,
								product_id = 27386,
								option_id = 17,
								option_value_id = 1097,
								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 '479858099 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1098
					<br>UPDATE oc_option_value_description 
						SET
							name = '479858099 - ACRIL W&N GALER 60ML PALE VIOLET'
						WHERE
							option_value_id = 1098
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 379
							AND product_id = 27386
							AND option_id = 17
							AND option_value_id = 1098

				<br>DELETE FROM oc_product
					WHERE
						model = '479858099'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 379,
								product_id = 27386,
								option_id = 17,
								option_value_id = 1098,
								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 '479858199 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1099
					<br>UPDATE oc_option_value_description 
						SET
							name = '479858199 - ACRIL W&N GALER 60ML POWDER BLUE'
						WHERE
							option_value_id = 1099
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 379
							AND product_id = 27386
							AND option_id = 17
							AND option_value_id = 1099

				<br>DELETE FROM oc_product
					WHERE
						model = '479858199'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 379,
								product_id = 27386,
								option_id = 17,
								option_value_id = 1099,
								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 '479858299 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1100
					<br>UPDATE oc_option_value_description 
						SET
							name = '479858299 - ACRIL W&N GALER 60ML OLIVE GREEN'
						WHERE
							option_value_id = 1100
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 379
							AND product_id = 27386
							AND option_id = 17
							AND option_value_id = 1100

				<br>DELETE FROM oc_product
					WHERE
						model = '479858299'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 379,
								product_id = 27386,
								option_id = 17,
								option_value_id = 1100,
								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 '479858399 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1101
					<br>UPDATE oc_option_value_description 
						SET
							name = '479858399 - ACRIL W&N GALER 60ML OPERA ROSE'
						WHERE
							option_value_id = 1101
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 379
							AND product_id = 27386
							AND option_id = 17
							AND option_value_id = 1101

				<br>DELETE FROM oc_product
					WHERE
						model = '479858399'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 379,
								product_id = 27386,
								option_id = 17,
								option_value_id = 1101,
								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 '479858499 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1102
					<br>UPDATE oc_option_value_description 
						SET
							name = '479858499 - ACRIL W&N GALER 60ML PRUSSIAN BLUE HUE'
						WHERE
							option_value_id = 1102
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 379
							AND product_id = 27386
							AND option_id = 17
							AND option_value_id = 1102

				<br>DELETE FROM oc_product
					WHERE
						model = '479858499'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 379,
								product_id = 27386,
								option_id = 17,
								option_value_id = 1102,
								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 '479858599 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1103
					<br>UPDATE oc_option_value_description 
						SET
							name = '479858599 - ACRIL W&N GALER 60ML TRANSPARENT YELLOW'
						WHERE
							option_value_id = 1103
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 379
							AND product_id = 27386
							AND option_id = 17
							AND option_value_id = 1103

				<br>DELETE FROM oc_product
					WHERE
						model = '479858599'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 379,
								product_id = 27386,
								option_id = 17,
								option_value_id = 1103,
								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 = 27382
					AND option_id = 17
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '479870199 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2129
					<br>UPDATE oc_option_value_description 
						SET
							name = '479870199 - SET ACRIL AMST C/5 CORES PRIMARIAS 120ML'
						WHERE
							option_value_id = 2129
					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 = 2129

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

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2130
					<br>UPDATE oc_option_value_description 
						SET
							name = '479870299 - SET BASICO ACRIL ART CREATION 12X12 ML'
						WHERE
							option_value_id = 2130
					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 = 2130

				<br>DELETE FROM oc_product
					WHERE
						model = '479870299'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 375,
								product_id = 27382,
								option_id = 17,
								option_value_id = 2130,
								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 = 27385
					AND option_id = 17
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '479883699 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1325
					<br>UPDATE oc_option_value_description 
						SET
							name = '479883699 - ACRIL AMST 120 ML AMA NAP VDE 282'
						WHERE
							option_value_id = 1325
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 378
							AND product_id = 27385
							AND option_id = 17
							AND option_value_id = 1325

				<br>DELETE FROM oc_product
					WHERE
						model = '479883699'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 378,
								product_id = 27385,
								option_id = 17,
								option_value_id = 1325,
								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 '479883799 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1326
					<br>UPDATE oc_option_value_description 
						SET
							name = '479883799 - ACRIL AMST 120 ML CAPUT M VIOL  344'
						WHERE
							option_value_id = 1326
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 378
							AND product_id = 27385
							AND option_id = 17
							AND option_value_id = 1326

				<br>DELETE FROM oc_product
					WHERE
						model = '479883799'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 378,
								product_id = 27385,
								option_id = 17,
								option_value_id = 1326,
								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 '479883899 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1327
					<br>UPDATE oc_option_value_description 
						SET
							name = '479883899 - ACRIL AMST 120 ML AZL TURQ  522'
						WHERE
							option_value_id = 1327
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 378
							AND product_id = 27385
							AND option_id = 17
							AND option_value_id = 1327

				<br>DELETE FROM oc_product
					WHERE
						model = '479883899'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 378,
								product_id = 27385,
								option_id = 17,
								option_value_id = 1327,
								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 '479883999 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1328
					<br>UPDATE oc_option_value_description 
						SET
							name = '479883999 - ACRIL AMST 120 ML COB  805'
						WHERE
							option_value_id = 1328
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 378
							AND product_id = 27385
							AND option_id = 17
							AND option_value_id = 1328

				<br>DELETE FROM oc_product
					WHERE
						model = '479883999'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 378,
								product_id = 27385,
								option_id = 17,
								option_value_id = 1328,
								quantity = 1,
								subtract = 1,
								price = 0.487,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '479884099 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1329
					<br>UPDATE oc_option_value_description 
						SET
							name = '479884099 - ACRIL AMST 120 ML BRZ 811'
						WHERE
							option_value_id = 1329
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 378
							AND product_id = 27385
							AND option_id = 17
							AND option_value_id = 1329

				<br>DELETE FROM oc_product
					WHERE
						model = '479884099'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 378,
								product_id = 27385,
								option_id = 17,
								option_value_id = 1329,
								quantity = 1,
								subtract = 1,
								price = 0.487,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '479884199 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1330
					<br>UPDATE oc_option_value_description 
						SET
							name = '479884199 - ACRIL AMST 120 ML ESTAN  815'
						WHERE
							option_value_id = 1330
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 378
							AND product_id = 27385
							AND option_id = 17
							AND option_value_id = 1330

				<br>DELETE FROM oc_product
					WHERE
						model = '479884199'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 378,
								product_id = 27385,
								option_id = 17,
								option_value_id = 1330,
								quantity = 1,
								subtract = 1,
								price = 0.487,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br><hr>Ok.<hr><hr>