Product Sync.<br>
Opencart products: 86<br>
Input products: 100<br>
<hr>NEW: 100929399<br>
<hr>NEW: 100929499<br>
<hr>NEW: 100929599<br>
<hr>NEW: 100929699<br>
<hr>NEW: 100929799<br>
<hr>NEW: 100929899<br>
<hr>NEW: 100929999<br>
<hr>NEW: 100930099<br>
<hr>NEW: 100930199<br>
<hr>NEW: 100930299<br>
<hr>NEW: 100930399<br>
<hr>NEW: 100930499<br>
<hr>NEW: 100930599<br>
<hr>NEW: 100930699<br>
<hr>NEW: 100930799<br>
<hr>NEW: 100930899<br>
<hr>NEW: 100930999<br>
<hr>NEW: 100931099<br>
<hr>NEW: 100931199<br>
<hr>NEW: 100931299<br>
<hr>NEW: 100931399<br>
<hr>NEW: 100931499<br>
<hr>NEW: 100931599<br>
<hr>NEW: 100931699<br>
<hr>NEW: 100931799<br>
<hr>NEW: 100931899<br>
<hr>NEW: 100931999<br>
<hr>NEW: 100932099<br>
<hr>NEW: 100932199<br>
<hr>NEW: 100932299<br>
<hr>NEW: 100932399<br>
<hr>NEW: 100932499<br>
<hr>NEW: 100932599<br>
<hr>NEW: 100932699<br>
<hr>NEW: 100932799<br>
<hr>NEW: 100932899<br>
<hr>NEW: 100932999<br>
<hr>NEW: 100933099<br>
<hr>NEW: 100933199<br>
<hr>NEW: 100933299<br>
<hr>NEW: 100933399<br>
<hr>NEW: 100933499<br>
<hr>NEW: 100933599<br>
<hr>NEW: 100933699<br>
<hr>NEW: 100933799<br>
<hr>NEW: 100933899<br>
<hr>NEW: 100933999<br>
<hr>NEW: 100934099<br>
<hr>NEW: 100934199<br>
<hr>NEW: 100934299<br>
<hr>NEW: 100934399<br>
<hr>NEW: 100934499<br>
<hr>NEW: 100934599<br>
<hr>NEW: 100934699<br>
<hr>NEW: 100934799<br>
<hr>NEW: Pincel Pentel com Reservatório<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 'Pincel Pentel com Reservatório - %'
				)
		<hr>NEW: 100934999<br>
<hr>NEW: 100935099<br>
<hr>NEW: 100935199<br>
<hr>NEW: 100935299<br>
<hr>NEW: 100935399<br>
<hr>NEW: 100935499<br>
<hr>NEW: 100935599<br>
<hr>NEW: 100935699<br>
<hr>NEW: 100935799<br>
<hr>NEW: 100935899<br>
<hr>NEW: 100935999<br>
<hr>NEW: 100936099<br>
<hr>NEW: 100936199<br>
<hr>NEW: 100936299<br>
<hr>NEW: 100936399<br>
<hr>NEW: 100936499<br>
<hr>NEW: 100936599<br>
<hr>NEW: 100936699<br>
<hr>NEW: 100936799<br>
<hr>NEW: 100936899<br>
<hr>NEW: 100936999<br>
<hr>NEW: 100937099<br>
<hr>NEW: 100937199<br>
<hr>NEW: 100937299<br>
<hr>NEW: 100937399<br>
<hr>NEW: 100937499<br>
<hr>NEW: 100937599<br>
<hr>NEW: 100937699<br>
<hr>NEW: 100937799<br>
<hr>NEW: 100937899<br>
<hr>NEW: 100937999<br>
<hr>NEW: 100938099<br>
<hr>NEW: 100938199<br>
<hr>NEW: 100938299<br>
<hr>NEW: 100938399<br>
<hr>NEW: 100938499<br>
<hr>NEW: 100938599<br>
<hr>NEW: 100938699<br>
<hr>NEW: 100938799<br>
<hr>NEW: 100938899<br>
<hr>NEW: 100938999<br>
<hr>NEW: 100939099<br>
<hr>NEW: 100939199<br>
<hr>NEW: 100939299<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 87<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>INSERT INTO oc_product_option 
					SET
						product_id = 27484,
						option_id = 17,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100934899 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3473 AS option_value_id,
							language_id,
							17 AS option_id,
							'100934899 - \''Pincel Pentel com Reservatório Médio' 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 = 3473

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