Product Sync.<br>
Opencart products: 212<br>
Input products: 100<br>
<hr>NEW: 101686699<br>
<hr>NEW: 101686799<br>
<hr>NEW: 101686899<br>
<hr>NEW: 101686999<br>
<hr>NEW: 101687099<br>
<hr>NEW: 101687199<br>
<hr>NEW: 101687299<br>
<hr>NEW: 101687399<br>
<hr>NEW: 101687499<br>
<hr>NEW: 101687599<br>
<hr>NEW: 101687699<br>
<hr>NEW: 101687799<br>
<hr>NEW: 101687899<br>
<hr>NEW: 101687999<br>
<hr>NEW: 101688099<br>
<hr>NEW: 101688199<br>
<hr>NEW: 101688299<br>
<hr>NEW: 101688399<br>
<hr>NEW: 101688499<br>
<hr>NEW: 101688599<br>
<hr>NEW: 101688699<br>
<hr>NEW: 101688799<br>
<hr>NEW: 101688899<br>
<hr>NEW: 101688999<br>
<hr>NEW: 101689099<br>
<hr>NEW: 101689199<br>
<hr>NEW: 101689299<br>
<hr>NEW: 101689399<br>
<hr>NEW: 101689499<br>
<hr>NEW: 101689599<br>
<hr>NEW: 101689699<br>
<hr>NEW: 101689799<br>
<hr>NEW: 101689899<br>
<hr>NEW: 101689999<br>
<hr>NEW: 101690099<br>
<hr>NEW: 101690199<br>
<hr>NEW: 101690299<br>
<hr>NEW: 101690399<br>
<hr>NEW: 101690499<br>
<hr>NEW: 101690599<br>
<hr>NEW: 101690699<br>
<hr>NEW: 101690799<br>
<hr>NEW: 101690899<br>
<hr>NEW: 101690999<br>
<hr>NEW: 101691099<br>
<hr>NEW: 101691199<br>
<hr>NEW: 101691299<br>
<hr>NEW: 101691399<br>
<hr>NEW: 101691499<br>
<hr>NEW: 101691599<br>
<hr>NEW: 101691699<br>
<hr>NEW: 101691799<br>
<hr>NEW: 101691899<br>
<hr>NEW: 101691999<br>
<hr>NEW: 101692099<br>
<hr>NEW: Trincha Talens Sintética S370<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 'Trincha Talens Sintética S370 - %'
				)
		<hr>NEW: 101692299<br>
<hr>NEW: 101692399<br>
<hr>NEW: 101692499<br>
<hr>NEW: 101692599<br>
<hr>NEW: 101692699<br>
<hr>NEW: 101692799<br>
<hr>NEW: 101692899<br>
<hr>NEW: 101692999<br>
<hr>NEW: 101693099<br>
<hr>NEW: 101693199<br>
<hr>NEW: 101693299<br>
<hr>NEW: 101693399<br>
<hr>NEW: 101693499<br>
<hr>NEW: 101693599<br>
<hr>NEW: 101693699<br>
<hr>NEW: 101693799<br>
<hr>NEW: 101693899<br>
<hr>NEW: 101693999<br>
<hr>NEW: 101694099<br>
<hr>NEW: 101694199<br>
<hr>NEW: 101694299<br>
<hr>NEW: 101694399<br>
<hr>NEW: 101694499<br>
<hr>NEW: 101694599<br>
<hr>NEW: 101694699<br>
<hr>NEW: 101694799<br>
<hr>NEW: 101694899<br>
<hr>NEW: 101694999<br>
<hr>NEW: 101695099<br>
<hr>NEW: 101695199<br>
<hr>NEW: 101695299<br>
<hr>NEW: 101695399<br>
<hr>NEW: 101695499<br>
<hr>NEW: 101695599<br>
<hr>NEW: 101695699<br>
<hr>NEW: 101695799<br>
<hr>NEW: 101695899<br>
<hr>NEW: 101695999<br>
<hr>NEW: 101696099<br>
<hr>NEW: 101696199<br>
<hr>NEW: 101696299<br>
<hr>NEW: 101696399<br>
<hr>NEW: 101696499<br>
<hr>NEW: 101696599<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 213<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 = 27201
					AND option_id = 15
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27201,
						option_id = 15,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101692199 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2491
					<br>UPDATE oc_option_value_description 
						SET
							name = '101692199 - Trincha Talens Sintética S370 N2 1/2'
						WHERE
							option_value_id = 2491
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 322
							AND product_id = 27201
							AND option_id = 15
							AND option_value_id = 2491

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