Product Sync.<br>
Opencart products: 30<br>
Input products: 100<br>
<hr>NEW: 102231099<br>
<hr>NEW: 102231199<br>
<hr>NEW: 102231299<br>
<hr>NEW: 102231399<br>
<hr>NEW: 102231499<br>
<hr>NEW: 102231599<br>
<hr>NEW: 102231699<br>
<hr>NEW: 102231799<br>
<hr>NEW: 102231899<br>
<hr>NEW: 102231999<br>
<hr>NEW: 102232099<br>
<hr>NEW: 102232199<br>
<hr>NEW: 102232299<br>
<hr>NEW: 102232399<br>
<hr>NEW: 102232499<br>
<hr>NEW: 102232599<br>
<hr>NEW: 102232699<br>
<hr>NEW: 102232799<br>
<hr>NEW: 102232899<br>
<hr>NEW: 102232999<br>
<hr>NEW: 102233099<br>
<hr>NEW: 102233199<br>
<hr>NEW: 102233299<br>
<hr>NEW: 102233399<br>
<hr>NEW: 102233499<br>
<hr>NEW: 102233599<br>
<hr>NEW: 102233699<br>
<hr>UPDATING: Cotman W&N TB 8ml<br>
Product ID: 27387<br>
Image file: <br>
<hr>NEW: 102233899<br>
<hr>NEW: 102233999<br>
<hr>NEW: 102234099<br>
<hr>NEW: 102234199<br>
<hr>NEW: 102234299<br>
<hr>NEW: 102234399<br>
<hr>NEW: 102234499<br>
<hr>NEW: 102234599<br>
<hr>NEW: 102234699<br>
<hr>NEW: 102234799<br>
<hr>NEW: 102234899<br>
<hr>NEW: 102234999<br>
<hr>NEW: 102235099<br>
<hr>NEW: 102235199<br>
<hr>NEW: 102235299<br>
<hr>NEW: 102235399<br>
<hr>NEW: 102235499<br>
<hr>NEW: 102235599<br>
<hr>NEW: 102235699<br>
<hr>NEW: 102235799<br>
<hr>NEW: 102235899<br>
<hr>NEW: 102235999<br>
<hr>NEW: 102236099<br>
<hr>NEW: 102236199<br>
<hr>NEW: 102236299<br>
<hr>NEW: 102236399<br>
<hr>NEW: 102236499<br>
<hr>NEW: 102236599<br>
<hr>NEW: 102236699<br>
<hr>NEW: 102236799<br>
<hr>NEW: 102236899<br>
<hr>NEW: 102236999<br>
<hr>NEW: 102237099<br>
<hr>NEW: 102237199<br>
<hr>NEW: 102237299<br>
<hr>NEW: 102237399<br>
<hr>NEW: 102237499<br>
<hr>NEW: 102237599<br>
<hr>NEW: 102237699<br>
<hr>NEW: 102237799<br>
<hr>NEW: 102237899<br>
<hr>NEW: 102237999<br>
<hr>NEW: 102238099<br>
<hr>NEW: 102238199<br>
<hr>NEW: 102238299<br>
<hr>NEW: 102238399<br>
<hr>NEW: 102238499<br>
<hr>NEW: 102238599<br>
<hr>NEW: 102238699<br>
<hr>NEW: 102238799<br>
<hr>NEW: 102238899<br>
<hr>NEW: 102238999<br>
<hr>NEW: 102239099<br>
<hr>NEW: 102239199<br>
<hr>NEW: 102239299<br>
<hr>NEW: 102239399<br>
<hr>NEW: 102239499<br>
<hr>NEW: 102239599<br>
<hr>NEW: 102239699<br>
<hr>NEW: 102239799<br>
<hr>NEW: 102239899<br>
<hr>NEW: 102239999<br>
<hr>NEW: 102240099<br>
<hr>NEW: 102240199<br>
<hr>NEW: 102240299<br>
<hr>NEW: 102240399<br>
<hr>NEW: 102240499<br>
<hr>NEW: 102240599<br>
<hr>NEW: 102240699<br>
<hr>NEW: 102240799<br>
<hr>NEW: 102240899<br>
<hr>NEW: 102240999<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 30<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 = 27387
					AND option_id = 17
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '102233799 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1541
					<br>UPDATE oc_option_value_description 
						SET
							name = '102233799 - AGUAR W&N COTMAN 8ML CONJ 6'
						WHERE
							option_value_id = 1541
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 380
							AND product_id = 27387
							AND option_id = 17
							AND option_value_id = 1541

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