Product Sync.<br>
Opencart products: 151<br>
Input products: 100<br>
<hr>NEW: 100212199<br>
<hr>NEW: 100212299<br>
<hr>NEW: 100212399<br>
<hr>NEW: 100212499<br>
<hr>NEW: 100212599<br>
<hr>NEW: 100212699<br>
<hr>NEW: 100212799<br>
<hr>NEW: 100212899<br>
<hr>NEW: 100212999<br>
<hr>NEW: 100213099<br>
<hr>NEW: 100213199<br>
<hr>NEW: 100213299<br>
<hr>NEW: 100213399<br>
<hr>NEW: 100213499<br>
<hr>NEW: 100213599<br>
<hr>NEW: 100213699<br>
<hr>NEW: 100213799<br>
<hr>NEW: 100213899<br>
<hr>NEW: 100213999<br>
<hr>NEW: 100214099<br>
<hr>NEW: 100214199<br>
<hr>NEW: 100214299<br>
<hr>NEW: 100214399<br>
<hr>NEW: 100214499<br>
<hr>NEW: 100214599<br>
<hr>NEW: 100214699<br>
<hr>NEW: 100214799<br>
<hr>NEW: 100214899<br>
<hr>NEW: 100214999<br>
<hr>NEW: 100215099<br>
<hr>NEW: 100215199<br>
<hr>NEW: 100215299<br>
<hr>NEW: 100215399<br>
<hr>NEW: 100215499<br>
<hr>NEW: 100215599<br>
<hr>NEW: 100215699<br>
<hr>NEW: 100215799<br>
<hr>NEW: 100215899<br>
<hr>NEW: 100215999<br>
<hr>NEW: Guache Giotto Caixa<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 'Guache Giotto Caixa - %'
				)
		<hr>NEW: 100216199<br>
<hr>NEW: 100216299<br>
<hr>NEW: 100216399<br>
<hr>NEW: 100216499<br>
<hr>NEW: 100216599<br>
<hr>NEW: 100216699<br>
<hr>NEW: 100216799<br>
<hr>NEW: 100216899<br>
<hr>NEW: 100216999<br>
<hr>NEW: 100217099<br>
<hr>NEW: 100217199<br>
<hr>NEW: 100217299<br>
<hr>NEW: 100217399<br>
<hr>NEW: 100217499<br>
<hr>NEW: 100217599<br>
<hr>NEW: 100217699<br>
<hr>UPDATING: Guache Giotto 500 ml<br>
Product ID: 27012<br>
Image file: <br>
<hr>NEW: 100218099<br>
<hr>UPDATING: Guache Giotto 1000 ml<br>
Product ID: 27013<br>
Image file: <br>
<hr>NEW: 100218999<br>
<hr>NEW: 100219099<br>
<hr>UPDATING: Guache Giotto Bebé 250 ml<br>
Product ID: 27014<br>
Image file: <br>
<hr>UPDATING: Guache Giotto Frasco 250 ml<br>
Product ID: 26995<br>
Image file: <br>
<hr>NEW: 100219699<br>
<hr>NEW: 100219899<br>
<hr>NEW: 100219999<br>
<hr>NEW: 100220099<br>
<hr>NEW: 100220199<br>
<hr>NEW: 100220299<br>
<hr>NEW: 100220399<br>
<hr>NEW: 100220499<br>
<hr>NEW: 100220599<br>
<hr>NEW: 100220699<br>
<hr>NEW: 100220799<br>
<hr>NEW: 100220899<br>
<hr>NEW: 100220999<br>
<hr>NEW: 100221099<br>
<hr>NEW: 100221199<br>
<hr>NEW: 100221299<br>
<hr>NEW: 100221399<br>
<hr>NEW: 100221499<br>
<hr>NEW: 100221599<br>
<hr>NEW: 100221699<br>
<hr>NEW: 100221799<br>
<hr>NEW: 100221899<br>
<hr>NEW: 100221999<br>
<hr>NEW: 100222099<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 152<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 = 27140
					AND option_id = 15
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27140,
						option_id = 15,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100216099 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1734
					<br>UPDATE oc_option_value_description 
						SET
							name = '100216099 - Guache Giotto  com 6'
						WHERE
							option_value_id = 1734
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 289
							AND product_id = 27140
							AND option_id = 15
							AND option_value_id = 1734

				<br>DELETE FROM oc_product
					WHERE
						model = '100216099'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 289,
								product_id = 27140,
								option_id = 15,
								option_value_id = 1734,
								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 = 27012
					AND option_id = 15
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100217799 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1564
					<br>UPDATE oc_option_value_description 
						SET
							name = '100217799 - Guache Acrílico Giotto 500 ml Azul Cyan'
						WHERE
							option_value_id = 1564
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 81
							AND product_id = 27012
							AND option_id = 15
							AND option_value_id = 1564

				<br>DELETE FROM oc_product
					WHERE
						model = '100217799'
				<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 = 81
								AND product_id = 27012
								AND option_id = 15
								AND option_value_id = 1564
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100217899 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1565
					<br>UPDATE oc_option_value_description 
						SET
							name = '100217899 - Guache Acrílico Giotto 500 ml Magenta'
						WHERE
							option_value_id = 1565
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 81
							AND product_id = 27012
							AND option_id = 15
							AND option_value_id = 1565

				<br>DELETE FROM oc_product
					WHERE
						model = '100217899'
				<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 = 81
								AND product_id = 27012
								AND option_id = 15
								AND option_value_id = 1565
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100217999 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1566
					<br>UPDATE oc_option_value_description 
						SET
							name = '100217999 - Guache Acrílico Giotto 500 ml Castanho'
						WHERE
							option_value_id = 1566
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 81
							AND product_id = 27012
							AND option_id = 15
							AND option_value_id = 1566

				<br>DELETE FROM oc_product
					WHERE
						model = '100217999'
				<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 = 81
								AND product_id = 27012
								AND option_id = 15
								AND option_value_id = 1566
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100218199 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1568
					<br>UPDATE oc_option_value_description 
						SET
							name = '100218199 - Guache Acrílico Giotto 500 ml Preto'
						WHERE
							option_value_id = 1568
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 81
							AND product_id = 27012
							AND option_id = 15
							AND option_value_id = 1568

				<br>DELETE FROM oc_product
					WHERE
						model = '100218199'
				<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 = 81
								AND product_id = 27012
								AND option_id = 15
								AND option_value_id = 1568
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100218299 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1571
					<br>UPDATE oc_option_value_description 
						SET
							name = '100218299 - Guache Acrílico Giotto 500 ml Branco'
						WHERE
							option_value_id = 1571
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 81
							AND product_id = 27012
							AND option_id = 15
							AND option_value_id = 1571

				<br>DELETE FROM oc_product
					WHERE
						model = '100218299'
				<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 = 81
								AND product_id = 27012
								AND option_id = 15
								AND option_value_id = 1571
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100218399 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1572
					<br>UPDATE oc_option_value_description 
						SET
							name = '100218399 - Guache Acrílico Giotto 500 ml Amarelo'
						WHERE
							option_value_id = 1572
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 81
							AND product_id = 27012
							AND option_id = 15
							AND option_value_id = 1572

				<br>DELETE FROM oc_product
					WHERE
						model = '100218399'
				<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 = 81
								AND product_id = 27012
								AND option_id = 15
								AND option_value_id = 1572
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100218499 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1573
					<br>UPDATE oc_option_value_description 
						SET
							name = '100218499 - Guache Acrílico Giotto 500 ml Verde'
						WHERE
							option_value_id = 1573
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 81
							AND product_id = 27012
							AND option_id = 15
							AND option_value_id = 1573

				<br>DELETE FROM oc_product
					WHERE
						model = '100218499'
				<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 = 81
								AND product_id = 27012
								AND option_id = 15
								AND option_value_id = 1573
						<br><hr>SELECT product_option_id FROM oc_product_option 
				WHERE
					product_id = 27013
					AND option_id = 15
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100218599 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2162
					<br>UPDATE oc_option_value_description 
						SET
							name = '100218599 - Guache Giotto 1000 ml Magenta'
						WHERE
							option_value_id = 2162
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 82
							AND product_id = 27013
							AND option_id = 15
							AND option_value_id = 2162

				<br>DELETE FROM oc_product
					WHERE
						model = '100218599'
				<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 = 82
								AND product_id = 27013
								AND option_id = 15
								AND option_value_id = 2162
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100218699 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2163
					<br>UPDATE oc_option_value_description 
						SET
							name = '100218699 - Guache Giotto 1000 ml Azul Ultramarino'
						WHERE
							option_value_id = 2163
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 82
							AND product_id = 27013
							AND option_id = 15
							AND option_value_id = 2163

				<br>DELETE FROM oc_product
					WHERE
						model = '100218699'
				<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 = 82
								AND product_id = 27013
								AND option_id = 15
								AND option_value_id = 2163
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100218799 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2164
					<br>UPDATE oc_option_value_description 
						SET
							name = '100218799 - Guache Giotto 1000 ml Laranja'
						WHERE
							option_value_id = 2164
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 82
							AND product_id = 27013
							AND option_id = 15
							AND option_value_id = 2164

				<br>DELETE FROM oc_product
					WHERE
						model = '100218799'
				<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 = 82
								AND product_id = 27013
								AND option_id = 15
								AND option_value_id = 2164
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100218899 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2165
					<br>UPDATE oc_option_value_description 
						SET
							name = '100218899 - Guache Giotto 1000 ml Violeta'
						WHERE
							option_value_id = 2165
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 82
							AND product_id = 27013
							AND option_id = 15
							AND option_value_id = 2165

				<br>DELETE FROM oc_product
					WHERE
						model = '100218899'
				<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 = 82
								AND product_id = 27013
								AND option_id = 15
								AND option_value_id = 2165
						<br><hr>SELECT product_option_id FROM oc_product_option 
				WHERE
					product_id = 27014
					AND option_id = 15
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100219199 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2166
					<br>UPDATE oc_option_value_description 
						SET
							name = '100219199 - Guache Giotto Bebé 250 ml Castanho'
						WHERE
							option_value_id = 2166
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 83
							AND product_id = 27014
							AND option_id = 15
							AND option_value_id = 2166

				<br>DELETE FROM oc_product
					WHERE
						model = '100219199'
				<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 = 83
								AND product_id = 27014
								AND option_id = 15
								AND option_value_id = 2166
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100219299 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2167
					<br>UPDATE oc_option_value_description 
						SET
							name = '100219299 - Guache Giotto Bebé 250 ml Vermelho'
						WHERE
							option_value_id = 2167
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 83
							AND product_id = 27014
							AND option_id = 15
							AND option_value_id = 2167

				<br>DELETE FROM oc_product
					WHERE
						model = '100219299'
				<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 = 83
								AND product_id = 27014
								AND option_id = 15
								AND option_value_id = 2167
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100219399 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2168
					<br>UPDATE oc_option_value_description 
						SET
							name = '100219399 - Guache Giotto Bebé 250 ml Azul Cyan'
						WHERE
							option_value_id = 2168
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 83
							AND product_id = 27014
							AND option_id = 15
							AND option_value_id = 2168

				<br>DELETE FROM oc_product
					WHERE
						model = '100219399'
				<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 = 83
								AND product_id = 27014
								AND option_id = 15
								AND option_value_id = 2168
						<br><hr>SELECT product_option_id FROM oc_product_option 
				WHERE
					product_id = 26995
					AND option_id = 15
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100219499 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1735
					<br>UPDATE oc_option_value_description 
						SET
							name = '100219499 - Guache Acrilico Giotto 250 ml Prata'
						WHERE
							option_value_id = 1735
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 66
							AND product_id = 26995
							AND option_id = 15
							AND option_value_id = 1735

				<br>DELETE FROM oc_product
					WHERE
						model = '100219499'
				<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 = 66
								AND product_id = 26995
								AND option_id = 15
								AND option_value_id = 1735
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100219599 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1736
					<br>UPDATE oc_option_value_description 
						SET
							name = '100219599 - Guache Acrilico Giotto 250 ml Magenta'
						WHERE
							option_value_id = 1736
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 66
							AND product_id = 26995
							AND option_id = 15
							AND option_value_id = 1736

				<br>DELETE FROM oc_product
					WHERE
						model = '100219599'
				<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 = 66
								AND product_id = 26995
								AND option_id = 15
								AND option_value_id = 1736
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100219799 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1737
					<br>UPDATE oc_option_value_description 
						SET
							name = '100219799 - Guache Giotto 250 ml Ouro Pérola'
						WHERE
							option_value_id = 1737
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 66
							AND product_id = 26995
							AND option_id = 15
							AND option_value_id = 1737

				<br>DELETE FROM oc_product
					WHERE
						model = '100219799'
				<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 = 66
								AND product_id = 26995
								AND option_id = 15
								AND option_value_id = 1737
						<br><hr>Ok.<hr><hr>