Product Sync.<br>
Opencart products: 127<br>
Input products: 100<br>
<hr>UPDATING: Tinta Acrílica Winsor & Newton 120 ml<br>
Product ID: 26989<br>
Image file: <br>
<hr>NEW: 100011699<br>
<hr>NEW: Bloco Aguarela Cotman 300 grs<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 'Bloco Aguarela Cotman 300 grs - %'
				)
		<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: 100014199<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 '100014199 - %'
				)
		<hr>NEW: 100014299<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 '100014299 - %'
				)
		<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: 130<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 = 
					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 '100010199 - %'

				<br>UPDATE oc_option_value 
						SET
							image = 'catalog/100010199.jpg'
						WHERE
							option_value_id = 1137
					<br>UPDATE oc_option_value_description 
						SET
							name = '100010199 - Acrílico Winsor & Newton  Galeria 120 ml Rosa Permanente'
						WHERE
							option_value_id = 1137
					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 = 1137

				<br>DELETE FROM oc_product
					WHERE
						model = '100010199'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								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 = 'catalog/100010299.jpg'
						WHERE
							option_value_id = 1138
					<br>UPDATE oc_option_value_description 
						SET
							name = '100010299 - Acrílico Winsor & Newton  Galeria 120 ml Magenta Processo'
						WHERE
							option_value_id = 1138
					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 = 1138

				<br>DELETE FROM oc_product
					WHERE
						model = '100010299'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								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 = 'catalog/100010399.jpg'
						WHERE
							option_value_id = 1139
					<br>UPDATE oc_option_value_description 
						SET
							name = '100010399 - Acrílico Winsor & Newton  Galeria 120 ml Azul Primário (535)'
						WHERE
							option_value_id = 1139
					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 = 1139

				<br>DELETE FROM oc_product
					WHERE
						model = '100010399'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								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 = 'catalog/100010499.jpg'
						WHERE
							option_value_id = 1140
					<br>UPDATE oc_option_value_description 
						SET
							name = '100010499 - Acrílico Winsor & Newton  Galeria 120 ml Amarelo Processo (537)'
						WHERE
							option_value_id = 1140
					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 = 1140

				<br>DELETE FROM oc_product
					WHERE
						model = '100010499'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								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 = 'catalog/100010599.jpg'
						WHERE
							option_value_id = 1141
					<br>UPDATE oc_option_value_description 
						SET
							name = '100010599 - Acrílico Winsor & Newton  Galeria 120 ml Azul Prússia HUE'
						WHERE
							option_value_id = 1141
					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 = 1141

				<br>DELETE FROM oc_product
					WHERE
						model = '100010599'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								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 = 'catalog/100010699.jpg'
						WHERE
							option_value_id = 1142
					<br>UPDATE oc_option_value_description 
						SET
							name = '100010699 - Acrílico Winsor & Newton  Galeria 120 ml Terra Sienna Natural'
						WHERE
							option_value_id = 1142
					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 = 1142

				<br>DELETE FROM oc_product
					WHERE
						model = '100010699'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								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 = 'catalog/100010799.jpg'
						WHERE
							option_value_id = 1143
					<br>UPDATE oc_option_value_description 
						SET
							name = '100010799 - Acrílico Winsor & Newton  Galeria 120 ml Terra Sombra Natural'
						WHERE
							option_value_id = 1143
					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 = 1143

				<br>DELETE FROM oc_product
					WHERE
						model = '100010799'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								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 = 'catalog/100010899.jpg'
						WHERE
							option_value_id = 1144
					<br>UPDATE oc_option_value_description 
						SET
							name = '100010899 - Acrílico Winsor & Newton  Galeria 120 ml Verde Sap'
						WHERE
							option_value_id = 1144
					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 = 1144

				<br>DELETE FROM oc_product
					WHERE
						model = '100010899'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								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 = 'catalog/100010999.jpg'
						WHERE
							option_value_id = 1145
					<br>UPDATE oc_option_value_description 
						SET
							name = '100010999 - Acrílico Winsor & Newton  Galeria 120 ml Branco Titânio (644)'
						WHERE
							option_value_id = 1145
					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 = 1145

				<br>DELETE FROM oc_product
					WHERE
						model = '100010999'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								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 = 'catalog/100011099.jpg'
						WHERE
							option_value_id = 1146
					<br>UPDATE oc_option_value_description 
						SET
							name = '100011099 - Acrílico Winsor & Newton  Galeria 120 ml Ultramarino'
						WHERE
							option_value_id = 1146
					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 = 1146

				<br>DELETE FROM oc_product
					WHERE
						model = '100011099'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								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 = 'catalog/100011199.jpg'
						WHERE
							option_value_id = 1147
					<br>UPDATE oc_option_value_description 
						SET
							name = '100011199 - Acrílico Winsor & Newton  Galeria 120 ml Castanho Van Dyck'
						WHERE
							option_value_id = 1147
					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 = 1147

				<br>DELETE FROM oc_product
					WHERE
						model = '100011199'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								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 = 'catalog/100011299.jpg'
						WHERE
							option_value_id = 1148
					<br>UPDATE oc_option_value_description 
						SET
							name = '100011299 - Acrílico Winsor & Newton  Galeria 120 ml Vernelhão HUE'
						WHERE
							option_value_id = 1148
					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 = 1148

				<br>DELETE FROM oc_product
					WHERE
						model = '100011299'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								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 = 'catalog/100011399.jpg'
						WHERE
							option_value_id = 1149
					<br>UPDATE oc_option_value_description 
						SET
							name = '100011399 - Acrílico Winsor & Newton  Galeria 120 ml Amarelo Ocre'
						WHERE
							option_value_id = 1149
					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 = 1149

				<br>DELETE FROM oc_product
					WHERE
						model = '100011399'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								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 = 'catalog/100011499.jpg'
						WHERE
							option_value_id = 1150
					<br>UPDATE oc_option_value_description 
						SET
							name = '100011499 - Acrílico Winsor & Newton  Galeria 120 ml S2 Ouro'
						WHERE
							option_value_id = 1150
					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 = 1150

				<br>DELETE FROM oc_product
					WHERE
						model = '100011499'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								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 = 'catalog/100011599.jpg'
						WHERE
							option_value_id = 1151
					<br>UPDATE oc_option_value_description 
						SET
							name = '100011599 - Acrílico Winsor & Newton  Galeria 120 ml S2 Prata'
						WHERE
							option_value_id = 1151
					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 = 1151

				<br>DELETE FROM oc_product
					WHERE
						model = '100011599'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								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 = 27116
					AND option_id = 15
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27116,
						option_id = 15,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100011799 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2133
					<br>UPDATE oc_option_value_description 
						SET
							name = '100011799 - Bloco Aguarela Cotman 300 grs Formato Postal'
						WHERE
							option_value_id = 2133
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 278
							AND product_id = 27116
							AND option_id = 15
							AND option_value_id = 2133

				<br>DELETE FROM oc_product
					WHERE
						model = '100011799'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 278,
								product_id = 27116,
								option_id = 15,
								option_value_id = 2133,
								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 '100011899 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2134
					<br>UPDATE oc_option_value_description 
						SET
							name = '100011899 - Bloco Aguarela Cotman 300 grs 30 x 23'
						WHERE
							option_value_id = 2134
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 278
							AND product_id = 27116
							AND option_id = 15
							AND option_value_id = 2134

				<br>DELETE FROM oc_product
					WHERE
						model = '100011899'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 278,
								product_id = 27116,
								option_id = 15,
								option_value_id = 2134,
								quantity = 1,
								subtract = 1,
								price = 0.488,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100011999 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2135
					<br>UPDATE oc_option_value_description 
						SET
							name = '100011999 - Bloco Aguarela Cotman 300 grs 40,6 x 30,5'
						WHERE
							option_value_id = 2135
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 278
							AND product_id = 27116
							AND option_id = 15
							AND option_value_id = 2135

				<br>DELETE FROM oc_product
					WHERE
						model = '100011999'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 278,
								product_id = 27116,
								option_id = 15,
								option_value_id = 2135,
								quantity = 1,
								subtract = 1,
								price = 6.423,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br><hr>Ok.<hr><hr>