Product Sync.<br>
Opencart products: 89<br>
Input products: 100<br>
<hr>NEW: 101010099<br>
<hr>NEW: 101010199<br>
<hr>NEW: 101010299<br>
<hr>NEW: 101010399<br>
<hr>NEW: 101010499<br>
<hr>NEW: 101010599<br>
<hr>NEW: 101010699<br>
<hr>NEW: 101010799<br>
<hr>NEW: 101010899<br>
<hr>NEW: 101010999<br>
<hr>UPDATING: Pincel Pentel com Reservatório<br>
Product ID: 27484<br>
Image file: <br>
<hr>NEW: 101011199<br>
<hr>NEW: 101011299<br>
<hr>NEW: 101011399<br>
<hr>NEW: 101011499<br>
<hr>NEW: 101011599<br>
<hr>NEW: 101011699<br>
<hr>NEW: 101011799<br>
<hr>NEW: 101011899<br>
<hr>NEW: 101011999<br>
<hr>NEW: 101012099<br>
<hr>NEW: 101012199<br>
<hr>NEW: 101012299<br>
<hr>NEW: 101012399<br>
<hr>NEW: 101012499<br>
<hr>NEW: 101012599<br>
<hr>NEW: 101012699<br>
<hr>NEW: 101012799<br>
<hr>NEW: 101012899<br>
<hr>NEW: 101012999<br>
<hr>NEW: 101013099<br>
<hr>NEW: 101013199<br>
<hr>NEW: 101013299<br>
<hr>NEW: 101013399<br>
<hr>NEW: 101013499<br>
<hr>NEW: 101013599<br>
<hr>NEW: 101013699<br>
<hr>NEW: 101013799<br>
<hr>NEW: 101013899<br>
<hr>NEW: 101013999<br>
<hr>NEW: 101014099<br>
<hr>NEW: 101014199<br>
<hr>NEW: 101014299<br>
<hr>NEW: 101014399<br>
<hr>NEW: 101014499<br>
<hr>NEW: 101014599<br>
<hr>NEW: 101014699<br>
<hr>NEW: 101014799<br>
<hr>NEW: 101014899<br>
<hr>NEW: 101014999<br>
<hr>NEW: 101015099<br>
<hr>NEW: 101015199<br>
<hr>NEW: 101015299<br>
<hr>NEW: 101015399<br>
<hr>NEW: 101015499<br>
<hr>NEW: 101015599<br>
<hr>NEW: 101015699<br>
<hr>NEW: 101015799<br>
<hr>NEW: 101015899<br>
<hr>NEW: 101015999<br>
<hr>NEW: 101016099<br>
<hr>NEW: 101016199<br>
<hr>NEW: 101016299<br>
<hr>NEW: 101016399<br>
<hr>NEW: 101016499<br>
<hr>NEW: 101016599<br>
<hr>NEW: 101016699<br>
<hr>NEW: 101016799<br>
<hr>NEW: 101016899<br>
<hr>NEW: 101016999<br>
<hr>NEW: 101017099<br>
<hr>NEW: 101017199<br>
<hr>NEW: 101017299<br>
<hr>NEW: 101017399<br>
<hr>NEW: 101017499<br>
<hr>NEW: 101017599<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 '101017599 - %'
				)
		<hr>NEW: 101017699<br>
<hr>NEW: 101017799<br>
<hr>NEW: 101017899<br>
<hr>NEW: 101017999<br>
<hr>NEW: 101018099<br>
<hr>NEW: 101018199<br>
<hr>NEW: 101018299<br>
<hr>NEW: 101018399<br>
<hr>NEW: 101018499<br>
<hr>NEW: 101018599<br>
<hr>NEW: 101018699<br>
<hr>NEW: 101018799<br>
<hr>NEW: 101018899<br>
<hr>NEW: 101018999<br>
<hr>NEW: 101019099<br>
<hr>NEW: 101019199<br>
<hr>NEW: 101019299<br>
<hr>NEW: 101019399<br>
<hr>NEW: 101019499<br>
<hr>NEW: 101019599<br>
<hr>NEW: 101019699<br>
<hr>NEW: 101019799<br>
<hr>NEW: 101019899<br>
<hr>NEW: 101019999<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 90<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 = 27484
					AND option_id = 17
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101011099 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3474 AS option_value_id,
							language_id,
							17 AS option_id,
							'101011099 - \''Pincel Pentel com Reservatório Grosso' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 457
							AND product_id = 27484
							AND option_id = 17
							AND option_value_id = 3474

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