Product Sync.<br>
Opencart products: 153<br>
Input products: 100<br>
<hr>NEW: 100252599<br>
<hr>NEW: 100252699<br>
<hr>NEW: 100252799<br>
<hr>NEW: 100252999<br>
<hr>NEW: 100253099<br>
<hr>NEW: 100253199<br>
<hr>NEW: 100253299<br>
<hr>NEW: 100253399<br>
<hr>NEW: 100253499<br>
<hr>NEW: 100253599<br>
<hr>NEW: 100253699<br>
<hr>NEW: 100253799<br>
<hr>NEW: 100253899<br>
<hr>NEW: 100253999<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 '100253999 - %'
				)
		<hr>NEW: 100254099<br>
<hr>NEW: 100254199<br>
<hr>NEW: 100254299<br>
<hr>NEW: 100254399<br>
<hr>NEW: 100254499<br>
<hr>NEW: 100254599<br>
<hr>NEW: 100254699<br>
<hr>NEW: 100254799<br>
<hr>NEW: 100254899<br>
<hr>NEW: 100254999<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 '100254999 - %'
				)
		<hr>NEW: 100255099<br>
<hr>NEW: 100255199<br>
<hr>NEW: 100255299<br>
<hr>NEW: 100255399<br>
<hr>NEW: 100255499<br>
<hr>NEW: 100255599<br>
<hr>NEW: Diluente sem Cheiro Inart<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 'Diluente sem Cheiro Inart - %'
				)
		<hr>NEW: 100255799<br>
<hr>NEW: 100255899<br>
<hr>NEW: 100255999<br>
<hr>NEW: 100256099<br>
<hr>NEW: 100256199<br>
<hr>NEW: 100256299<br>
<hr>NEW: 100256399<br>
<hr>NEW: 100256499<br>
<hr>NEW: 100256599<br>
<hr>NEW: 100256699<br>
<hr>NEW: 100256799<br>
<hr>NEW: 100256899<br>
<hr>NEW: 100256999<br>
<hr>NEW: 100257099<br>
<hr>NEW: 100257199<br>
<hr>NEW: 100257299<br>
<hr>NEW: 100257399<br>
<hr>NEW: 100257499<br>
<hr>NEW: 100257599<br>
<hr>NEW: 100257699<br>
<hr>NEW: 100257799<br>
<hr>NEW: 100257899<br>
<hr>NEW: 100257999<br>
<hr>NEW: 100258099<br>
<hr>NEW: 100258199<br>
<hr>NEW: 100258299<br>
<hr>NEW: 100258399<br>
<hr>NEW: 100258499<br>
<hr>NEW: 100258599<br>
<hr>NEW: 100258699<br>
<hr>NEW: 100258799<br>
<hr>NEW: 100258899<br>
<hr>NEW: 100258999<br>
<hr>NEW: 100259099<br>
<hr>NEW: 100259199<br>
<hr>NEW: 100259299<br>
<hr>NEW: 100259399<br>
<hr>NEW: 100259499<br>
<hr>NEW: 100259599<br>
<hr>NEW: 100259699<br>
<hr>NEW: 100259799<br>
<hr>NEW: 100259899<br>
<hr>NEW: 100259999<br>
<hr>NEW: 100260099<br>
<hr>NEW: 100260199<br>
<hr>NEW: 100260299<br>
<hr>NEW: 100260399<br>
<hr>NEW: 100260499<br>
<hr>NEW: 100260599<br>
<hr>NEW: 100260699<br>
<hr>NEW: 100260799<br>
<hr>NEW: 100260899<br>
<hr>NEW: 100260999<br>
<hr>NEW: 100261099<br>
<hr>NEW: 100261199<br>
<hr>NEW: 100261299<br>
<hr>NEW: 100261399<br>
<hr>NEW: 100261499<br>
<hr>NEW: 100261599<br>
<hr>NEW: 100261699<br>
<hr>NEW: 100261799<br>
<hr>NEW: 100261899<br>
<hr>NEW: 100261999<br>
<hr>NEW: 100262099<br>
<hr>NEW: 100262199<br>
<hr>NEW: 100262299<br>
<hr>NEW: 100262399<br>
<hr>NEW: 100262499<br>
<hr>NEW: 100262599<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 156<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 = 27144
					AND option_id = 15
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27144,
						option_id = 15,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100255699 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2174
					<br>UPDATE oc_option_value_description 
						SET
							name = '100255699 - Diluente sem Cheiro Inart 500 ml'
						WHERE
							option_value_id = 2174
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 291
							AND product_id = 27144
							AND option_id = 15
							AND option_value_id = 2174

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