Product Sync.<br>
Opencart products: 288<br>
Input products: 100<br>
<hr>NEW: 102343399<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 '102343399 - %'
				)
		<hr>NEW: 102343499<br>
<hr>UPDATING: Tinta da China Winsor & Newton<br>
Product ID: 27049<br>
Image file: <br>
<hr>NEW: 102343899<br>
<hr>NEW: 102344099<br>
<hr>NEW: 102344299<br>
<hr>NEW: 102344699<br>
<hr>NEW: 102344899<br>
<hr>NEW: 102344999<br>
<hr>NEW: 102345099<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 '102345099 - %'
				)
		<hr>NEW: 102345199<br>
<hr>NEW: 102345299<br>
<hr>NEW: 102345399<br>
<hr>NEW: 102345499<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 '102345499 - %'
				)
		<hr>NEW: 102345599<br>
<hr>NEW: 102345699<br>
<hr>NEW: 102345799<br>
<hr>NEW: 102345899<br>
<hr>NEW: 102345999<br>
<hr>NEW: 102346099<br>
<hr>NEW: 102346199<br>
<hr>NEW: 102346299<br>
<hr>NEW: 102346399<br>
<hr>NEW: Espátula Pintura<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 'Espátula Pintura - %'
				)
		<hr>NEW: 102347499<br>
<hr>NEW: 102347599<br>
<hr>NEW: 102347699<br>
<hr>NEW: 102347799<br>
<hr>NEW: 102347899<br>
<hr>NEW: 102347999<br>
<hr>NEW: 102348099<br>
<hr>NEW: 102348199<br>
<hr>NEW: 102348299<br>
<hr>NEW: 102348399<br>
<hr>NEW: 102348499<br>
<hr>NEW: 102348599<br>
<hr>NEW: 102348699<br>
<hr>NEW: 102348799<br>
<hr>NEW: 102348899<br>
<hr>NEW: 102348999<br>
<hr>NEW: 102349099<br>
<hr>NEW: 102349199<br>
<hr>NEW: 102349299<br>
<hr>NEW: 102349399<br>
<hr>NEW: 102349499<br>
<hr>NEW: 102349599<br>
<hr>NEW: 102349699<br>
<hr>NEW: 102349799<br>
<hr>NEW: 102349899<br>
<hr>NEW: 102349999<br>
<hr>NEW: 102350099<br>
<hr>NEW: 102350199<br>
<hr>NEW: 102350299<br>
<hr>NEW: 102350399<br>
<hr>NEW: 102350499<br>
<hr>NEW: 102350599<br>
<hr>NEW: 102350699<br>
<hr>NEW: 102350799<br>
<hr>NEW: 102350899<br>
<hr>NEW: 102350999<br>
<hr>NEW: 102351099<br>
<hr>NEW: 102351199<br>
<hr>NEW: 102351299<br>
<hr>NEW: 102351399<br>
<hr>NEW: 102351499<br>
<hr>NEW: 102351599<br>
<hr>NEW: 102351699<br>
<hr>NEW: 102351799<br>
<hr>NEW: 102351899<br>
<hr>NEW: 102351999<br>
<hr>NEW: 102352099<br>
<hr>NEW: 102352199<br>
<hr>NEW: 102352299<br>
<hr>NEW: 102352399<br>
<hr>NEW: 102352499<br>
<hr>NEW: 102352599<br>
<hr>NEW: 102352699<br>
<hr>NEW: 102352799<br>
<hr>NEW: 102352899<br>
<hr>NEW: 102352999<br>
<hr>NEW: 102353099<br>
<hr>NEW: 102353199<br>
<hr>NEW: 102353299<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 292<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 '102343599 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2678
					<br>UPDATE oc_option_value_description 
						SET
							name = '102343599 - Tinta da China Winsor & Newton Vermelho Escuro 14 ml'
						WHERE
							option_value_id = 2678
					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 = 2678

				<br>DELETE FROM oc_product
					WHERE
						model = '102343599'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								option_value_id = 2678,
								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 '102343699 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2679
					<br>UPDATE oc_option_value_description 
						SET
							name = '102343699 - Tinta da China Winsor & Newton Amarelo Canário 14 ml'
						WHERE
							option_value_id = 2679
					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 = 2679

				<br>DELETE FROM oc_product
					WHERE
						model = '102343699'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								option_value_id = 2679,
								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 '102343799 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2680
					<br>UPDATE oc_option_value_description 
						SET
							name = '102343799 - Tinta da China Winsor & Newton Carmim 14 ml'
						WHERE
							option_value_id = 2680
					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 = 2680

				<br>DELETE FROM oc_product
					WHERE
						model = '102343799'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								option_value_id = 2680,
								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 '102343999 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2681
					<br>UPDATE oc_option_value_description 
						SET
							name = '102343999 - Tinta da China Winsor & Newton Castanho Nut 14 ml'
						WHERE
							option_value_id = 2681
					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 = 2681

				<br>DELETE FROM oc_product
					WHERE
						model = '102343999'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								option_value_id = 2681,
								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 '102344199 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2682
					<br>UPDATE oc_option_value_description 
						SET
							name = '102344199 - Tinta da China Winsor & Newton  Vermelho Tijolo 14 ml'
						WHERE
							option_value_id = 2682
					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 = 2682

				<br>DELETE FROM oc_product
					WHERE
						model = '102344199'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								option_value_id = 2682,
								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 '102344399 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2683
					<br>UPDATE oc_option_value_description 
						SET
							name = '102344399 - Tinta da China Winsor & Newton Scralet 14 ml'
						WHERE
							option_value_id = 2683
					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 = 2683

				<br>DELETE FROM oc_product
					WHERE
						model = '102344399'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								option_value_id = 2683,
								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 '102344499 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2684
					<br>UPDATE oc_option_value_description 
						SET
							name = '102344499 - Tinta da China Winsor & Newton Laranja 14 ml'
						WHERE
							option_value_id = 2684
					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 = 2684

				<br>DELETE FROM oc_product
					WHERE
						model = '102344499'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								option_value_id = 2684,
								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 '102344599 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2685
					<br>UPDATE oc_option_value_description 
						SET
							name = '102344599 - Tinta da China Winsor & Newton  Verde Brilhante 14 ml'
						WHERE
							option_value_id = 2685
					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 = 2685

				<br>DELETE FROM oc_product
					WHERE
						model = '102344599'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = ,
								product_id = ,
								option_id = 15,
								option_value_id = 2685,
								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 '102344799 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2686
					<br>UPDATE oc_option_value_description 
						SET
							name = '102344799 - Tinta da China Winsor & Newton Prata 14 ml'
						WHERE
							option_value_id = 2686
					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 = 2686

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

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2689
					<br>UPDATE oc_option_value_description 
						SET
							name = '102346499 - Espátula Pintura N25'
						WHERE
							option_value_id = 2689
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 342
							AND product_id = 27280
							AND option_id = 15
							AND option_value_id = 2689

				<br>DELETE FROM oc_product
					WHERE
						model = '102346499'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 342,
								product_id = 27280,
								option_id = 15,
								option_value_id = 2689,
								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 '102346599 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2690
					<br>UPDATE oc_option_value_description 
						SET
							name = '102346599 - Espátula Pintura N29'
						WHERE
							option_value_id = 2690
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 342
							AND product_id = 27280
							AND option_id = 15
							AND option_value_id = 2690

				<br>DELETE FROM oc_product
					WHERE
						model = '102346599'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 342,
								product_id = 27280,
								option_id = 15,
								option_value_id = 2690,
								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 '102346699 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2691
					<br>UPDATE oc_option_value_description 
						SET
							name = '102346699 - Espátula Pintura N30'
						WHERE
							option_value_id = 2691
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 342
							AND product_id = 27280
							AND option_id = 15
							AND option_value_id = 2691

				<br>DELETE FROM oc_product
					WHERE
						model = '102346699'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 342,
								product_id = 27280,
								option_id = 15,
								option_value_id = 2691,
								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 '102346799 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2692
					<br>UPDATE oc_option_value_description 
						SET
							name = '102346799 - Espátula Pintura N27'
						WHERE
							option_value_id = 2692
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 342
							AND product_id = 27280
							AND option_id = 15
							AND option_value_id = 2692

				<br>DELETE FROM oc_product
					WHERE
						model = '102346799'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 342,
								product_id = 27280,
								option_id = 15,
								option_value_id = 2692,
								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 '102346899 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2693
					<br>UPDATE oc_option_value_description 
						SET
							name = '102346899 - Espátula Pintura N20'
						WHERE
							option_value_id = 2693
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 342
							AND product_id = 27280
							AND option_id = 15
							AND option_value_id = 2693

				<br>DELETE FROM oc_product
					WHERE
						model = '102346899'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 342,
								product_id = 27280,
								option_id = 15,
								option_value_id = 2693,
								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 '102346999 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2694
					<br>UPDATE oc_option_value_description 
						SET
							name = '102346999 - Espátula Pintura N22'
						WHERE
							option_value_id = 2694
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 342
							AND product_id = 27280
							AND option_id = 15
							AND option_value_id = 2694

				<br>DELETE FROM oc_product
					WHERE
						model = '102346999'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 342,
								product_id = 27280,
								option_id = 15,
								option_value_id = 2694,
								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 '102347099 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2695
					<br>UPDATE oc_option_value_description 
						SET
							name = '102347099 - Espátula Pintura N28'
						WHERE
							option_value_id = 2695
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 342
							AND product_id = 27280
							AND option_id = 15
							AND option_value_id = 2695

				<br>DELETE FROM oc_product
					WHERE
						model = '102347099'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 342,
								product_id = 27280,
								option_id = 15,
								option_value_id = 2695,
								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 '102347199 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2696
					<br>UPDATE oc_option_value_description 
						SET
							name = '102347199 - Espátula Pintura N21'
						WHERE
							option_value_id = 2696
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 342
							AND product_id = 27280
							AND option_id = 15
							AND option_value_id = 2696

				<br>DELETE FROM oc_product
					WHERE
						model = '102347199'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 342,
								product_id = 27280,
								option_id = 15,
								option_value_id = 2696,
								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 '102347299 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2697
					<br>UPDATE oc_option_value_description 
						SET
							name = '102347299 - Espátula Pintura N2'
						WHERE
							option_value_id = 2697
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 342
							AND product_id = 27280
							AND option_id = 15
							AND option_value_id = 2697

				<br>DELETE FROM oc_product
					WHERE
						model = '102347299'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 342,
								product_id = 27280,
								option_id = 15,
								option_value_id = 2697,
								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 '102347399 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2698
					<br>UPDATE oc_option_value_description 
						SET
							name = '102347399 - Espátula Pintura N26'
						WHERE
							option_value_id = 2698
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 342
							AND product_id = 27280
							AND option_id = 15
							AND option_value_id = 2698

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