Product Sync.<br>
Opencart products: 25<br>
Input products: 100<br>
<hr>NEW: 101084099<br>
<hr>NEW: 101084199<br>
<hr>NEW: 101084299<br>
<hr>NEW: 101084399<br>
<hr>NEW: 101084499<br>
<hr>NEW: 101084599<br>
<hr>NEW: 101084699<br>
<hr>NEW: 101084799<br>
<hr>NEW: 101084899<br>
<hr>NEW: 101084999<br>
<hr>NEW: 101085099<br>
<hr>NEW: 101085199<br>
<hr>NEW: 101085299<br>
<hr>NEW: 101085399<br>
<hr>NEW: 101085499<br>
<hr>NEW: 101085599<br>
<hr>NEW: 101085699<br>
<hr>NEW: Rembrandt 15ml<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 'Rembrandt 15ml - %'
				)
		<hr>NEW: 101085899<br>
<hr>NEW: 101085999<br>
<hr>NEW: 101086099<br>
<hr>NEW: 101086199<br>
<hr>NEW: 101086299<br>
<hr>NEW: 101086399<br>
<hr>NEW: 101086499<br>
<hr>NEW: 101086599<br>
<hr>NEW: 101086699<br>
<hr>NEW: 101086799<br>
<hr>NEW: 101086899<br>
<hr>NEW: 101086999<br>
<hr>NEW: 101087099<br>
<hr>NEW: 101087199<br>
<hr>NEW: 101087299<br>
<hr>NEW: 101087399<br>
<hr>NEW: 101087499<br>
<hr>NEW: 101087599<br>
<hr>NEW: 101087699<br>
<hr>NEW: 101087799<br>
<hr>NEW: 101087899<br>
<hr>NEW: 101087999<br>
<hr>NEW: 101088099<br>
<hr>NEW: 101088199<br>
<hr>NEW: 101088299<br>
<hr>NEW: 101088399<br>
<hr>NEW: 101088499<br>
<hr>NEW: 101088599<br>
<hr>NEW: 101088699<br>
<hr>NEW: 101088799<br>
<hr>NEW: 101088899<br>
<hr>NEW: 101088999<br>
<hr>NEW: 101089099<br>
<hr>NEW: 101089199<br>
<hr>NEW: 101089299<br>
<hr>NEW: 101089399<br>
<hr>NEW: 101089499<br>
<hr>NEW: 101089599<br>
<hr>NEW: 101089699<br>
<hr>NEW: 101089799<br>
<hr>NEW: 101089899<br>
<hr>NEW: 101089999<br>
<hr>NEW: 101090099<br>
<hr>NEW: 101090199<br>
<hr>NEW: 101090299<br>
<hr>NEW: 101090399<br>
<hr>NEW: 101090499<br>
<hr>NEW: 101090599<br>
<hr>NEW: 101090699<br>
<hr>NEW: 101090799<br>
<hr>NEW: 101090899<br>
<hr>NEW: 101090999<br>
<hr>NEW: 101091099<br>
<hr>NEW: 101091199<br>
<hr>NEW: 101091399<br>
<hr>NEW: 101091499<br>
<hr>NEW: 101091599<br>
<hr>NEW: 101091699<br>
<hr>NEW: 101091799<br>
<hr>NEW: 101091899<br>
<hr>NEW: 101091999<br>
<hr>NEW: 101092099<br>
<hr>NEW: 101092199<br>
<hr>NEW: 101092299<br>
<hr>NEW: 101092399<br>
<hr>NEW: 101092499<br>
<hr>NEW: 101092599<br>
<hr>NEW: 101092699<br>
<hr>NEW: 101092799<br>
<hr>NEW: 101092899<br>
<hr>NEW: 101092999<br>
<hr>NEW: 101093099<br>
<hr>NEW: 101093199<br>
<hr>NEW: 101093299<br>
<hr>NEW: 101093399<br>
<hr>NEW: 101093499<br>
<hr>NEW: 101093599<br>
<hr>NEW: 101093699<br>
<hr>NEW: 101093799<br>
<hr>NEW: 101093899<br>
<hr>NEW: 101093999<br>
<hr>NEW: 101094099<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 26<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 = 27397
					AND option_id = 17
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27397,
						option_id = 17,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101085799 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1764
					<br>UPDATE oc_option_value_description 
						SET
							name = '101085799 - OLEO REMB T6-15ML S1 414 ALFALTO'
						WHERE
							option_value_id = 1764
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 390
							AND product_id = 27397
							AND option_id = 17
							AND option_value_id = 1764

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