Product Sync.<br>
Opencart products: 34<br>
Input products: 100<br>
<hr>NEW: 100191999<br>
<hr>NEW: 100192099<br>
<hr>NEW: 100192199<br>
<hr>NEW: 100192299<br>
<hr>NEW: 100192399<br>
<hr>NEW: 100192499<br>
<hr>NEW: 100192599<br>
<hr>NEW: 100192699<br>
<hr>NEW: 100192799<br>
<hr>NEW: 100192899<br>
<hr>NEW: 100192999<br>
<hr>NEW: 100193099<br>
<hr>NEW: 100193199<br>
<hr>NEW: 100193299<br>
<hr>NEW: 100193399<br>
<hr>NEW: 100193499<br>
<hr>NEW: 100193599<br>
<hr>NEW: 100193699<br>
<hr>NEW: 100193799<br>
<hr>NEW: 100193899<br>
<hr>NEW: 100193999<br>
<hr>NEW: 100194099<br>
<hr>NEW: 100194199<br>
<hr>NEW: 100194299<br>
<hr>NEW: 100194399<br>
<hr>NEW: 100194499<br>
<hr>NEW: 100194599<br>
<hr>NEW: 100194699<br>
<hr>NEW: 100194799<br>
<hr>NEW: 100194899<br>
<hr>NEW: 100194999<br>
<hr>NEW: 100195099<br>
<hr>NEW: 100195199<br>
<hr>NEW: 100195299<br>
<hr>NEW: 100195399<br>
<hr>NEW: 100195499<br>
<hr>NEW: 100195599<br>
<hr>NEW: 100195699<br>
<hr>NEW: 100195799<br>
<hr>NEW: 100195899<br>
<hr>NEW: 100195999<br>
<hr>NEW: 100196099<br>
<hr>NEW: 100196199<br>
<hr>NEW: 100196299<br>
<hr>NEW: 100196399<br>
<hr>NEW: 100196499<br>
<hr>NEW: 100196599<br>
<hr>NEW: 100196699<br>
<hr>NEW: 100196799<br>
<hr>NEW: 100196899<br>
<hr>NEW: 100196999<br>
<hr>NEW: 100197099<br>
<hr>NEW: 100197199<br>
<hr>NEW: 100197299<br>
<hr>NEW: 100197399<br>
<hr>NEW: 100197499<br>
<hr>NEW: 100197599<br>
<hr>NEW: 100197699<br>
<hr>NEW: 100197799<br>
<hr>NEW: 100197899<br>
<hr>NEW: 100197999<br>
<hr>NEW: 100198099<br>
<hr>NEW: 100198199<br>
<hr>NEW: 100198299<br>
<hr>NEW: 100198399<br>
<hr>NEW: 100198499<br>
<hr>NEW: 100198599<br>
<hr>NEW: 100198699<br>
<hr>NEW: 100198799<br>
<hr>NEW: 100198899<br>
<hr>NEW: 100198999<br>
<hr>NEW: 100199099<br>
<hr>NEW: 100199199<br>
<hr>NEW: 100199299<br>
<hr>NEW: 100199399<br>
<hr>NEW: 100199499<br>
<hr>NEW: 100199599<br>
<hr>NEW: 100199699<br>
<hr>NEW: 100199799<br>
<hr>NEW: 100199899<br>
<hr>NEW: 100199999<br>
<hr>NEW: 100200099<br>
<hr>NEW: 100200199<br>
<hr>NEW: 100200299<br>
<hr>NEW: 100200399<br>
<hr>NEW: 100200499<br>
<hr>NEW: 100200599<br>
<hr>NEW: 100200699<br>
<hr>NEW: 100200799<br>
<hr>NEW: 100200899<br>
<hr>NEW: 100200999<br>
<hr>NEW: 100201099<br>
<hr>NEW: 100201199<br>
<hr>NEW: 100201299<br>
<hr>NEW: Bloco Aguarela Canson Montval<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 'Bloco Aguarela Canson Montval - %'
				)
		<hr>NEW: 100201499<br>
<hr>NEW: 100201599<br>
<hr>NEW: 100201699<br>
<hr>NEW: 100201799<br>
<hr>NEW: 100201899<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 35<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 = 27432
					AND option_id = 17
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27432,
						option_id = 17,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100201399 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3252 AS option_value_id,
							language_id,
							17 AS option_id,
							'100201399 - Bloco Aguarela Canson Montval  A3 300 g 12 Fls' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 413
							AND product_id = 27432
							AND option_id = 17
							AND option_value_id = 3252

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