Product Sync.<br>
Opencart products: 83<br>
Input products: 100<br>
<hr>NEW: 100686899<br>
<hr>NEW: 100686999<br>
<hr>NEW: 100687099<br>
<hr>NEW: 100687199<br>
<hr>NEW: 100687299<br>
<hr>NEW: 100687399<br>
<hr>NEW: 100687499<br>
<hr>NEW: 100687599<br>
<hr>NEW: 100687699<br>
<hr>NEW: 100687799<br>
<hr>NEW: 100687899<br>
<hr>NEW: 100687999<br>
<hr>NEW: 100688099<br>
<hr>NEW: 100688199<br>
<hr>NEW: 100688299<br>
<hr>NEW: 100688399<br>
<hr>NEW: 100688499<br>
<hr>NEW: 100688599<br>
<hr>NEW: 100688699<br>
<hr>NEW: 100688799<br>
<hr>NEW: 100688899<br>
<hr>NEW: 100688999<br>
<hr>NEW: 100689099<br>
<hr>NEW: 100689199<br>
<hr>NEW: 100689299<br>
<hr>NEW: 100689399<br>
<hr>NEW: 100689499<br>
<hr>NEW: 100689599<br>
<hr>NEW: 100689699<br>
<hr>NEW: 100689799<br>
<hr>NEW: 100689899<br>
<hr>NEW: 100689999<br>
<hr>NEW: 100690099<br>
<hr>NEW: 100690199<br>
<hr>NEW: 100690299<br>
<hr>NEW: 100690399<br>
<hr>NEW: 100690499<br>
<hr>NEW: 100690599<br>
<hr>NEW: 100690699<br>
<hr>NEW: 100690799<br>
<hr>NEW: 100690899<br>
<hr>NEW: 100690999<br>
<hr>NEW: 100691099<br>
<hr>NEW: 100691199<br>
<hr>NEW: 100691299<br>
<hr>NEW: 100691399<br>
<hr>NEW: 100691499<br>
<hr>NEW: 100691599<br>
<hr>NEW: 100691699<br>
<hr>NEW: 100691799<br>
<hr>NEW: 100691899<br>
<hr>NEW: 100691999<br>
<hr>NEW: 100692099<br>
<hr>NEW: 100692199<br>
<hr>NEW: 100692299<br>
<hr>NEW: 100692399<br>
<hr>NEW: 100692499<br>
<hr>NEW: Cavalete Tripé Talens Isabelle<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 'Cavalete Tripé Talens Isabelle - %'
				)
		<hr>NEW: 100692699<br>
<hr>NEW: 100692799<br>
<hr>NEW: 100692899<br>
<hr>NEW: 100692999<br>
<hr>NEW: 100693099<br>
<hr>NEW: 100693199<br>
<hr>NEW: 100693299<br>
<hr>NEW: 100693399<br>
<hr>NEW: 100693499<br>
<hr>NEW: 100693599<br>
<hr>NEW: 100693699<br>
<hr>NEW: 100693799<br>
<hr>NEW: 100693899<br>
<hr>NEW: 100693999<br>
<hr>NEW: 100694099<br>
<hr>NEW: 100694199<br>
<hr>NEW: 100694299<br>
<hr>NEW: 100694399<br>
<hr>NEW: 100694499<br>
<hr>NEW: 100694599<br>
<hr>NEW: 100694699<br>
<hr>NEW: 100694799<br>
<hr>NEW: 100694899<br>
<hr>NEW: 100694999<br>
<hr>NEW: 100695099<br>
<hr>NEW: 100695199<br>
<hr>NEW: 100695299<br>
<hr>NEW: 100695399<br>
<hr>NEW: 100695499<br>
<hr>NEW: 100695599<br>
<hr>NEW: 100695699<br>
<hr>NEW: 100695799<br>
<hr>NEW: 100695899<br>
<hr>NEW: 100695999<br>
<hr>NEW: 100696099<br>
<hr>NEW: 100696199<br>
<hr>NEW: 100696299<br>
<hr>NEW: 100696399<br>
<hr>NEW: 100696499<br>
<hr>NEW: 100696599<br>
<hr>NEW: 100696699<br>
<hr>NEW: 100696799<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 84<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 = 27481
					AND option_id = 17
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27481,
						option_id = 17,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100692599 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1519
					<br>UPDATE oc_option_value_description 
						SET
							name = '100692599 - Cavalete Tripé Talens Isabelle'
						WHERE
							option_value_id = 1519
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 454
							AND product_id = 27481
							AND option_id = 17
							AND option_value_id = 1519

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