Product Sync.<br>
Opencart products: 11<br>
Input products: 100<br>
<hr>NEW: 100020299<br>
<hr>NEW: 100020399<br>
<hr>NEW: 100020499<br>
<hr>NEW: 100020599<br>
<hr>NEW: 100020699<br>
<hr>NEW: 100020799<br>
<hr>NEW: 100020899<br>
<hr>NEW: 100020999<br>
<hr>NEW: 100021099<br>
<hr>NEW: 100021199<br>
<hr>NEW: 100021299<br>
<hr>NEW: 100021399<br>
<hr>NEW: 100021499<br>
<hr>NEW: 100021599<br>
<hr>NEW: 100021699<br>
<hr>NEW: 100021799<br>
<hr>NEW: 100021899<br>
<hr>NEW: 100021999<br>
<hr>NEW: 100022099<br>
<hr>NEW: 100022199<br>
<hr>NEW: 100022299<br>
<hr>NEW: 100022399<br>
<hr>NEW: 100022499<br>
<hr>NEW: 100022599<br>
<hr>NEW: 100022699<br>
<hr>NEW: 100022799<br>
<hr>NEW: 100022899<br>
<hr>NEW: 100022999<br>
<hr>NEW: 100023099<br>
<hr>NEW: 100023199<br>
<hr>NEW: 100023299<br>
<hr>NEW: 100023399<br>
<hr>NEW: Cavalete Estudio Tripé Madeira Ecologico<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 'Cavalete Estudio Tripé Madeira Ecologico - %'
				)
		<hr>NEW: 100023599<br>
<hr>NEW: 100023699<br>
<hr>NEW: 100023799<br>
<hr>NEW: 100023899<br>
<hr>NEW: 100023999<br>
<hr>NEW: 100024099<br>
<hr>NEW: 100024199<br>
<hr>NEW: 100024299<br>
<hr>NEW: 100024399<br>
<hr>NEW: 100024499<br>
<hr>NEW: 100024599<br>
<hr>NEW: 100024699<br>
<hr>NEW: 100024799<br>
<hr>NEW: 100024899<br>
<hr>NEW: 100024999<br>
<hr>NEW: 100025099<br>
<hr>NEW: 100025199<br>
<hr>NEW: 100025299<br>
<hr>NEW: 100025399<br>
<hr>NEW: 100025499<br>
<hr>NEW: 100025599<br>
<hr>NEW: 100025699<br>
<hr>NEW: 100025799<br>
<hr>NEW: 100025899<br>
<hr>NEW: 100025999<br>
<hr>NEW: 100026099<br>
<hr>NEW: 100026199<br>
<hr>NEW: 100026299<br>
<hr>NEW: 100026399<br>
<hr>NEW: 100026499<br>
<hr>NEW: 100026599<br>
<hr>NEW: 100026699<br>
<hr>NEW: 100026799<br>
<hr>NEW: 100026899<br>
<hr>NEW: 100026999<br>
<hr>NEW: 100027099<br>
<hr>NEW: 100027199<br>
<hr>NEW: 100027299<br>
<hr>NEW: 100027399<br>
<hr>NEW: 100027499<br>
<hr>NEW: 100027599<br>
<hr>NEW: 100027699<br>
<hr>NEW: 100027799<br>
<hr>NEW: 100027899<br>
<hr>NEW: 100027999<br>
<hr>NEW: 100028099<br>
<hr>NEW: 100028199<br>
<hr>NEW: 100028299<br>
<hr>NEW: 100028399<br>
<hr>NEW: 100028499<br>
<hr>NEW: 100028599<br>
<hr>NEW: 100028699<br>
<hr>NEW: 100028799<br>
<hr>NEW: 100028899<br>
<hr>NEW: 100028999<br>
<hr>NEW: 100029099<br>
<hr>NEW: 100029199<br>
<hr>NEW: 100029299<br>
<hr>NEW: 100029399<br>
<hr>NEW: 100029499<br>
<hr>NEW: 100029599<br>
<hr>NEW: 100029699<br>
<hr>NEW: 100029799<br>
<hr>NEW: 100029899<br>
<hr>NEW: 100029999<br>
<hr>NEW: 100030099<br>
<hr>NEW: 100030199<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 12<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 = 27409
					AND option_id = 17
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27409,
						option_id = 17,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100023499 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1174
					<br>UPDATE oc_option_value_description 
						SET
							name = '100023499 - Cavalete Estudio Tripé Madeira Ecologico'
						WHERE
							option_value_id = 1174
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 400
							AND product_id = 27409
							AND option_id = 17
							AND option_value_id = 1174

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