Product Sync.<br>
Opencart products: 41<br>
Input products: 100<br>
<hr>NEW: 100222299<br>
<hr>NEW: 100222399<br>
<hr>NEW: 100222499<br>
<hr>NEW: 100222599<br>
<hr>NEW: 100222699<br>
<hr>NEW: 100222799<br>
<hr>NEW: 100222899<br>
<hr>NEW: 100222999<br>
<hr>NEW: 100223099<br>
<hr>NEW: 100223199<br>
<hr>NEW: 100223299<br>
<hr>NEW: 100223399<br>
<hr>NEW: 100223499<br>
<hr>NEW: 100223599<br>
<hr>NEW: 100223699<br>
<hr>NEW: 100223799<br>
<hr>NEW: 100223899<br>
<hr>NEW: 100223999<br>
<hr>NEW: 100224099<br>
<hr>NEW: 100224199<br>
<hr>NEW: 100224299<br>
<hr>NEW: 100224399<br>
<hr>NEW: 100224499<br>
<hr>NEW: 100224599<br>
<hr>NEW: 100224699<br>
<hr>NEW: 100224799<br>
<hr>NEW: 100224899<br>
<hr>NEW: 100224999<br>
<hr>NEW: 100225099<br>
<hr>NEW: 100225199<br>
<hr>NEW: 100225299<br>
<hr>NEW: 100225399<br>
<hr>NEW: 100225499<br>
<hr>NEW: 100225599<br>
<hr>NEW: 100225699<br>
<hr>NEW: 100225799<br>
<hr>NEW: 100225899<br>
<hr>NEW: 100225999<br>
<hr>NEW: 100226099<br>
<hr>NEW: 100226199<br>
<hr>NEW: 100226299<br>
<hr>NEW: 100226399<br>
<hr>NEW: 100226499<br>
<hr>NEW: White Spirit Talens<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 'White Spirit Talens - %'
				)
		<hr>NEW: 100226699<br>
<hr>NEW: 100226799<br>
<hr>NEW: 100226899<br>
<hr>NEW: 100226999<br>
<hr>NEW: 100227099<br>
<hr>NEW: 100227199<br>
<hr>NEW: 100227299<br>
<hr>NEW: 100227399<br>
<hr>NEW: 100227499<br>
<hr>NEW: 100227599<br>
<hr>NEW: 100227699<br>
<hr>NEW: 100227799<br>
<hr>NEW: 100227899<br>
<hr>NEW: 100227999<br>
<hr>NEW: 100228099<br>
<hr>NEW: 100228199<br>
<hr>NEW: 100228299<br>
<hr>NEW: 100228399<br>
<hr>NEW: 100228499<br>
<hr>NEW: 100228599<br>
<hr>NEW: 100228699<br>
<hr>NEW: 100228799<br>
<hr>NEW: 100228899<br>
<hr>NEW: 100228999<br>
<hr>NEW: 100229099<br>
<hr>NEW: 100229199<br>
<hr>NEW: 100229299<br>
<hr>NEW: 100229399<br>
<hr>NEW: 100229499<br>
<hr>NEW: 100229599<br>
<hr>NEW: 100229699<br>
<hr>NEW: 100229799<br>
<hr>NEW: 100229899<br>
<hr>NEW: 100229999<br>
<hr>NEW: 100230099<br>
<hr>NEW: 100230199<br>
<hr>NEW: 100230299<br>
<hr>NEW: 100230399<br>
<hr>NEW: 100230499<br>
<hr>NEW: 100230599<br>
<hr>NEW: 100230699<br>
<hr>NEW: 100230799<br>
<hr>NEW: 100230899<br>
<hr>NEW: 100230999<br>
<hr>NEW: 100231099<br>
<hr>NEW: 100231199<br>
<hr>NEW: 100231299<br>
<hr>NEW: 100231399<br>
<hr>NEW: 100231499<br>
<hr>NEW: 100231599<br>
<hr>NEW: 100231699<br>
<hr>NEW: 100231799<br>
<hr>NEW: 100231899<br>
<hr>NEW: 100231999<br>
<hr>NEW: 100232099<br>
<hr>NEW: 100232199<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 42<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 = 27439
					AND option_id = 17
			<br>INSERT INTO oc_product_option 
					SET
						product_id = 27439,
						option_id = 17,
						value = '',
						required = 1
				<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100226599 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3261 AS option_value_id,
							language_id,
							17 AS option_id,
							'100226599 - White Spirit Talens Inodoro 250 ml' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 420
							AND product_id = 27439
							AND option_id = 17
							AND option_value_id = 3261

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