Product Sync.<br>
Opencart products: 30<br>
Input products: 100<br>
<hr>NEW: 102016199<br>
<hr>NEW: 102016299<br>
<hr>NEW: 102016399<br>
<hr>NEW: 102016499<br>
<hr>NEW: 102016599<br>
<hr>NEW: 102016699<br>
<hr>NEW: 102016799<br>
<hr>NEW: 102016899<br>
<hr>NEW: 102016999<br>
<hr>NEW: 102017099<br>
<hr>NEW: 102017199<br>
<hr>NEW: 102017299<br>
<hr>NEW: 102017399<br>
<hr>NEW: 102017499<br>
<hr>NEW: 102017599<br>
<hr>NEW: 102017699<br>
<hr>NEW: 102017799<br>
<hr>NEW: 102017899<br>
<hr>NEW: 102017999<br>
<hr>NEW: 102018099<br>
<hr>NEW: 102018199<br>
<hr>NEW: 102018299<br>
<hr>NEW: 102018399<br>
<hr>NEW: 102018499<br>
<hr>NEW: 102018599<br>
<hr>NEW: 102018699<br>
<hr>NEW: 102018799<br>
<hr>NEW: 102018899<br>
<hr>NEW: 102018999<br>
<hr>NEW: 102019099<br>
<hr>NEW: 102019199<br>
<hr>NEW: 102019299<br>
<hr>NEW: 102019399<br>
<hr>NEW: 102019499<br>
<hr>NEW: 102019599<br>
<hr>NEW: 102019699<br>
<hr>NEW: 102019799<br>
<hr>NEW: 102019899<br>
<hr>NEW: 102019999<br>
<hr>NEW: 102020099<br>
<hr>NEW: 102020199<br>
<hr>NEW: 102020299<br>
<hr>NEW: 102020399<br>
<hr>NEW: 102020499<br>
<hr>NEW: 102020599<br>
<hr>NEW: 102020699<br>
<hr>NEW: 102020799<br>
<hr>NEW: 102020899<br>
<hr>NEW: 102020999<br>
<hr>NEW: 102021099<br>
<hr>NEW: 102021199<br>
<hr>NEW: 102021299<br>
<hr>NEW: 102021399<br>
<hr>NEW: 102021499<br>
<hr>NEW: Van Gogh 20ml<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 'Van Gogh 20ml - %'
				)
		<hr>NEW: 102021699<br>
<hr>NEW: 102021799<br>
<hr>NEW: 102021899<br>
<hr>NEW: 102021999<br>
<hr>NEW: 102022099<br>
<hr>NEW: 102022199<br>
<hr>NEW: 102022299<br>
<hr>NEW: 102022399<br>
<hr>NEW: 102022499<br>
<hr>NEW: 102022599<br>
<hr>NEW: 102022699<br>
<hr>NEW: 102022799<br>
<hr>NEW: 102022899<br>
<hr>NEW: 102022999<br>
<hr>NEW: 102023099<br>
<hr>NEW: 102023199<br>
<hr>NEW: 102023299<br>
<hr>NEW: 102023399<br>
<hr>NEW: 102023499<br>
<hr>NEW: 102023599<br>
<hr>NEW: 102023699<br>
<hr>NEW: 102023799<br>
<hr>NEW: 102023899<br>
<hr>NEW: 102023999<br>
<hr>NEW: 102024099<br>
<hr>NEW: 102024199<br>
<hr>NEW: 102024299<br>
<hr>NEW: 102024399<br>
<hr>NEW: 102024499<br>
<hr>NEW: 102024599<br>
<hr>NEW: 102024699<br>
<hr>NEW: 102024799<br>
<hr>NEW: 102024899<br>
<hr>NEW: 102024999<br>
<hr>NEW: 102025099<br>
<hr>NEW: 102025199<br>
<hr>NEW: 102025299<br>
<hr>NEW: 102025399<br>
<hr>NEW: 102025499<br>
<hr>NEW: 102025599<br>
<hr>NEW: 102025699<br>
<hr>NEW: 102025799<br>
<hr>NEW: 102025899<br>
<hr>NEW: 102025999<br>
<hr>NEW: 102026099<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 31<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 = 27402
					AND option_id = 17
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27402,
						option_id = 17,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '102021599 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1885
					<br>UPDATE oc_option_value_description 
						SET
							name = '102021599 - OLEO V GOG T7-20ML S1 MADDER LAKE LIGHT'
						WHERE
							option_value_id = 1885
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 395
							AND product_id = 27402
							AND option_id = 17
							AND option_value_id = 1885

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