Product Sync.<br>
Opencart products: 28<br>
Input products: 100<br>
<hr>NEW: 101560399<br>
<hr>NEW: 101560499<br>
<hr>NEW: 101560599<br>
<hr>NEW: 101560699<br>
<hr>NEW: 101560799<br>
<hr>NEW: 101560899<br>
<hr>NEW: 101560999<br>
<hr>NEW: 101561099<br>
<hr>NEW: 101561199<br>
<hr>NEW: 101561299<br>
<hr>NEW: 101561399<br>
<hr>NEW: 101561499<br>
<hr>NEW: 101561599<br>
<hr>NEW: 101561699<br>
<hr>NEW: 101561799<br>
<hr>NEW: 101561899<br>
<hr>NEW: 101561999<br>
<hr>NEW: 101562099<br>
<hr>NEW: 101562199<br>
<hr>NEW: 101562299<br>
<hr>NEW: 101562399<br>
<hr>NEW: 101562499<br>
<hr>NEW: 101562599<br>
<hr>NEW: 101562699<br>
<hr>NEW: 101562799<br>
<hr>NEW: 101562899<br>
<hr>NEW: 101562999<br>
<hr>NEW: 101563099<br>
<hr>NEW: 101563199<br>
<hr>NEW: 101563299<br>
<hr>NEW: 101563399<br>
<hr>NEW: 101563499<br>
<hr>NEW: 101563599<br>
<hr>NEW: 101563699<br>
<hr>NEW: 101563799<br>
<hr>NEW: 101563899<br>
<hr>NEW: 101563999<br>
<hr>NEW: 101564099<br>
<hr>NEW: 101564199<br>
<hr>NEW: 101564299<br>
<hr>NEW: 101564399<br>
<hr>NEW: 101564499<br>
<hr>NEW: 101564599<br>
<hr>UPDATING: Rembrandt 15ml<br>
Product ID: 27397<br>
Image file: Rembrandt 15ml.png<br>
<hr>NEW: 101564899<br>
<hr>NEW: 101564999<br>
<hr>NEW: 101565099<br>
<hr>NEW: 101565199<br>
<hr>NEW: 101565299<br>
<hr>NEW: 101565399<br>
<hr>NEW: 101565499<br>
<hr>NEW: 101565599<br>
<hr>NEW: 101565699<br>
<hr>NEW: 101565799<br>
<hr>NEW: 101565899<br>
<hr>NEW: 101565999<br>
<hr>NEW: 101566099<br>
<hr>NEW: 101566199<br>
<hr>NEW: 101566299<br>
<hr>NEW: 101566399<br>
<hr>NEW: 101566499<br>
<hr>NEW: 101566599<br>
<hr>NEW: 101566699<br>
<hr>NEW: 101566799<br>
<hr>NEW: 101566899<br>
<hr>NEW: 101566999<br>
<hr>NEW: 101567099<br>
<hr>NEW: 101567199<br>
<hr>NEW: 101567299<br>
<hr>NEW: 101567399<br>
<hr>NEW: 101567499<br>
<hr>NEW: 101567599<br>
<hr>NEW: 101567699<br>
<hr>NEW: 101567799<br>
<hr>NEW: 101567899<br>
<hr>NEW: 101567999<br>
<hr>NEW: 101568099<br>
<hr>NEW: 101568199<br>
<hr>NEW: 101568299<br>
<hr>NEW: 101568399<br>
<hr>NEW: 101568499<br>
<hr>NEW: 101568599<br>
<hr>NEW: 101568699<br>
<hr>NEW: 101568799<br>
<hr>NEW: 101568899<br>
<hr>NEW: 101568999<br>
<hr>NEW: 101569099<br>
<hr>NEW: 101569199<br>
<hr>NEW: 101569299<br>
<hr>NEW: 101569399<br>
<hr>NEW: 101569499<br>
<hr>NEW: 101569599<br>
<hr>NEW: 101569699<br>
<hr>NEW: 101569799<br>
<hr>NEW: 101569899<br>
<hr>NEW: 101569999<br>
<hr>NEW: 101570099<br>
<hr>NEW: 101570199<br>
<hr>NEW: 101570299<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 28<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 = 27397
					AND option_id = 17
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101564699 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1768
					<br>UPDATE oc_option_value_description 
						SET
							name = '101564699 - OLEO REMB T6-15ML S1 CORES DESCONT'
						WHERE
							option_value_id = 1768
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 390
							AND product_id = 27397
							AND option_id = 17
							AND option_value_id = 1768

				<br>DELETE FROM oc_product
					WHERE
						model = '101564699'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 390,
								product_id = 27397,
								option_id = 17,
								option_value_id = 1768,
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101564799 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 1769
					<br>UPDATE oc_option_value_description 
						SET
							name = '101564799 - OLEO REMB T6-15ML S3 CORES DESCONT'
						WHERE
							option_value_id = 1769
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 390
							AND product_id = 27397
							AND option_id = 17
							AND option_value_id = 1769

				<br>DELETE FROM oc_product
					WHERE
						model = '101564799'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 390,
								product_id = 27397,
								option_id = 17,
								option_value_id = 1769,
								quantity = 1,
								subtract = 1,
								price = 2.317,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br><hr>Ok.<hr><hr>