Product Sync.<br>
Opencart products: 152<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>UPDATING: White Spirit Talens<br>
Product ID: 27015<br>
Image file: <br>
<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: 152<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 = 27015
					AND option_id = 15
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '100226599 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2169
					<br>UPDATE oc_option_value_description 
						SET
							name = '100226599 - White Spirit Talens Inodoro 250 ml'
						WHERE
							option_value_id = 2169
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 84
							AND product_id = 27015
							AND option_id = 15
							AND option_value_id = 2169

				<br>DELETE FROM oc_product
					WHERE
						model = '100226599'
				<br>UPDATE oc_product_option_value 
							SET
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
							WHERE
								product_option_id = 84
								AND product_id = 27015
								AND option_id = 15
								AND option_value_id = 2169
						<br><hr>Ok.<hr><hr>