Product Sync.<br>
Opencart products: 222<br>
Input products: 100<br>
<hr>NEW: 101828099<br>
<hr>NEW: 101828199<br>
<hr>NEW: 101828299<br>
<hr>NEW: 101828399<br>
<hr>NEW: 101828499<br>
<hr>NEW: 101828599<br>
<hr>NEW: 101828699<br>
<hr>NEW: 101828799<br>
<hr>NEW: 101828899<br>
<hr>NEW: 101828999<br>
<hr>NEW: 101829099<br>
<hr>NEW: 101829199<br>
<hr>NEW: 101829299<br>
<hr>NEW: 101829399<br>
<hr>NEW: 101829499<br>
<hr>NEW: 101829599<br>
<hr>NEW: 101829699<br>
<hr>NEW: 101829799<br>
<hr>NEW: 101829899<br>
<hr>NEW: 101829999<br>
<hr>NEW: 101830099<br>
<hr>NEW: 101830199<br>
<hr>NEW: 101830299<br>
<hr>NEW: 101830399<br>
<hr>NEW: 101830499<br>
<hr>NEW: 101830599<br>
<hr>NEW: 101830699<br>
<hr>NEW: 101830799<br>
<hr>NEW: 101830899<br>
<hr>NEW: 101830999<br>
<hr>NEW: 101831099<br>
<hr>NEW: 101831199<br>
<hr>NEW: 101831299<br>
<hr>NEW: 101831399<br>
<hr>NEW: 101831499<br>
<hr>NEW: 101831599<br>
<hr>NEW: 101831699<br>
<hr>NEW: 101831799<br>
<hr>NEW: 101831899<br>
<hr>NEW: 101831999<br>
<hr>NEW: Óleo de Linho Pébeo Refinado<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 'Óleo de Linho Pébeo Refinado - %'
				)
		<hr>NEW: 101832199<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 '101832199 - %'
				)
		<hr>NEW: 101832299<br>
<hr>NEW: 101832399<br>
<hr>NEW: 101832499<br>
<hr>NEW: 101832599<br>
<hr>NEW: 101832699<br>
<hr>NEW: 101832799<br>
<hr>NEW: 101832899<br>
<hr>NEW: 101832999<br>
<hr>NEW: 101833099<br>
<hr>NEW: 101833199<br>
<hr>NEW: 101833299<br>
<hr>NEW: 101833399<br>
<hr>NEW: 101833499<br>
<hr>NEW: 101833599<br>
<hr>NEW: 101833699<br>
<hr>NEW: 101833799<br>
<hr>NEW: 101833899<br>
<hr>NEW: 101833999<br>
<hr>NEW: 101834099<br>
<hr>NEW: 101834199<br>
<hr>NEW: 101834299<br>
<hr>NEW: 101834399<br>
<hr>NEW: 101834499<br>
<hr>NEW: 101834599<br>
<hr>NEW: 101834699<br>
<hr>NEW: 101834799<br>
<hr>NEW: 101834899<br>
<hr>NEW: 101834999<br>
<hr>NEW: 101835099<br>
<hr>NEW: 101835199<br>
<hr>NEW: 101835299<br>
<hr>NEW: 101835399<br>
<hr>NEW: 101835499<br>
<hr>NEW: 101835599<br>
<hr>NEW: 101835699<br>
<hr>NEW: 101835799<br>
<hr>NEW: 101835899<br>
<hr>NEW: 101835999<br>
<hr>NEW: 101836099<br>
<hr>NEW: 101836199<br>
<hr>NEW: 101836299<br>
<hr>NEW: 101836399<br>
<hr>NEW: 101836499<br>
<hr>NEW: 101836599<br>
<hr>NEW: 101836699<br>
<hr>NEW: 101836799<br>
<hr>NEW: 101836899<br>
<hr>NEW: 101836999<br>
<hr>NEW: 101837099<br>
<hr>NEW: 101837199<br>
<hr>NEW: 101837299<br>
<hr>NEW: 101837399<br>
<hr>NEW: 101837499<br>
<hr>NEW: 101837599<br>
<hr>NEW: 101837699<br>
<hr>NEW: 101837799<br>
<hr>NEW: 101837899<br>
<hr>NEW: 101837999<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 224<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 = 27211
					AND option_id = 15
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27211,
						option_id = 15,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101832099 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2507
					<br>UPDATE oc_option_value_description 
						SET
							name = '101832099 - Óleo Linho Pébéo Refinado 75 ml'
						WHERE
							option_value_id = 2507
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 323
							AND product_id = 27211
							AND option_id = 15
							AND option_value_id = 2507

				<br>DELETE FROM oc_product
					WHERE
						model = '101832099'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 323,
								product_id = 27211,
								option_id = 15,
								option_value_id = 2507,
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br><hr>Ok.<hr><hr>