Product Sync.<br>
Opencart products: 85<br>
Input products: 100<br>
<hr>NEW: 100737499<br>
<hr>NEW: 100737599<br>
<hr>NEW: 100737699<br>
<hr>NEW: 100737799<br>
<hr>NEW: 100737899<br>
<hr>NEW: 100737999<br>
<hr>NEW: 100738099<br>
<hr>NEW: 100738199<br>
<hr>NEW: 100738299<br>
<hr>NEW: 100738399<br>
<hr>NEW: 100738499<br>
<hr>NEW: 100738599<br>
<hr>NEW: 100738699<br>
<hr>NEW: 100738799<br>
<hr>NEW: 100738899<br>
<hr>NEW: 100738999<br>
<hr>NEW: 100739099<br>
<hr>NEW: 100739199<br>
<hr>NEW: 100739299<br>
<hr>NEW: 100739399<br>
<hr>NEW: 100739499<br>
<hr>NEW: 100739599<br>
<hr>NEW: 100739699<br>
<hr>NEW: 100739799<br>
<hr>NEW: 100739899<br>
<hr>NEW: 100739999<br>
<hr>NEW: 100740099<br>
<hr>NEW: 100740199<br>
<hr>NEW: 100740299<br>
<hr>NEW: 100740399<br>
<hr>NEW: 100740499<br>
<hr>NEW: 100740599<br>
<hr>NEW: 100740699<br>
<hr>NEW: 100740799<br>
<hr>NEW: 100740899<br>
<hr>NEW: 100740999<br>
<hr>NEW: 100741099<br>
<hr>NEW: 100741199<br>
<hr>NEW: 100741299<br>
<hr>NEW: 100741399<br>
<hr>NEW: 100741499<br>
<hr>NEW: 100741599<br>
<hr>NEW: 100741699<br>
<hr>NEW: 100741799<br>
<hr>NEW: 100741899<br>
<hr>NEW: 100741999<br>
<hr>NEW: 100742099<br>
<hr>NEW: 100742199<br>
<hr>NEW: 100742299<br>
<hr>NEW: 100742399<br>
<hr>NEW: 100742499<br>
<hr>NEW: 100742599<br>
<hr>NEW: 100742699<br>
<hr>NEW: 100742799<br>
<hr>NEW: 100742899<br>
<hr>NEW: 100742999<br>
<hr>NEW: 100743099<br>
<hr>NEW: 100743199<br>
<hr>NEW: 100743299<br>
<hr>NEW: 100743399<br>
<hr>NEW: 100743499<br>
<hr>NEW: 100743599<br>
<hr>NEW: 100743699<br>
<hr>NEW: 100743799<br>
<hr>NEW: 100743899<br>
<hr>NEW: 100743999<br>
<hr>NEW: 100744099<br>
<hr>NEW: 100744199<br>
<hr>NEW: 100744299<br>
<hr>NEW: 100744399<br>
<hr>NEW: 100744499<br>
<hr>NEW: 100744599<br>
<hr>NEW: 100744699<br>
<hr>NEW: 100744799<br>
<hr>NEW: 100744899<br>
<hr>NEW: 100744999<br>
<hr>NEW: 100745099<br>
<hr>NEW: 100745199<br>
<hr>NEW: 100745299<br>
<hr>NEW: 100745399<br>
<hr>NEW: 100745499<br>
<hr>NEW: Guache Caran D´Ache com 5<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 'Guache Caran D´Ache com 5 - %'
				)
		<hr>NEW: 100745699<br>
<hr>NEW: 100745799<br>
<hr>NEW: 100745899<br>
<hr>NEW: 100745999<br>
<hr>NEW: 100746099<br>
<hr>NEW: 100746199<br>
<hr>NEW: 100746299<br>
<hr>NEW: 100746399<br>
<hr>NEW: 100746499<br>
<hr>NEW: 100746599<br>
<hr>NEW: 100746699<br>
<hr>NEW: 100746799<br>
<hr>NEW: 100746899<br>
<hr>NEW: 100746999<br>
<hr>NEW: 100747099<br>
<hr>NEW: 100747199<br>
<hr>NEW: 100747299<br>
<hr>NEW: 100747399<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 86<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 = 27483
					AND option_id = 17
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27483,
						option_id = 17,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100745599 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3452 AS option_value_id,
							language_id,
							17 AS option_id,
							'100745599 - Guache Caran D´Ache Pastilha Caixa com 15 Cores Sortidas e Pincel' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 456
							AND product_id = 27483
							AND option_id = 17
							AND option_value_id = 3452

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