Product Sync.<br>
Opencart products: 108<br>
Input products: 100<br>
<hr>NEW: 101212099<br>
<hr>NEW: 101212199<br>
<hr>NEW: 101212299<br>
<hr>NEW: 101212399<br>
<hr>NEW: 101212499<br>
<hr>NEW: 101212599<br>
<hr>NEW: 101212699<br>
<hr>NEW: 101212799<br>
<hr>NEW: 101212899<br>
<hr>NEW: 101212999<br>
<hr>NEW: 101213099<br>
<hr>NEW: 101213199<br>
<hr>NEW: 101213299<br>
<hr>NEW: 101213399<br>
<hr>NEW: 101213499<br>
<hr>NEW: 101213599<br>
<hr>NEW: 101213699<br>
<hr>NEW: 101213799<br>
<hr>NEW: 101213899<br>
<hr>NEW: 101213999<br>
<hr>NEW: 101214099<br>
<hr>NEW: 101214199<br>
<hr>NEW: 101214299<br>
<hr>NEW: 101214399<br>
<hr>NEW: 101214499<br>
<hr>NEW: 101214599<br>
<hr>NEW: 101214699<br>
<hr>NEW: 101214799<br>
<hr>NEW: 101214899<br>
<hr>NEW: 101214999<br>
<hr>NEW: 101215099<br>
<hr>NEW: 101215199<br>
<hr>NEW: 101215299<br>
<hr>NEW: 101215399<br>
<hr>NEW: 101215499<br>
<hr>NEW: 101215599<br>
<hr>NEW: 101215699<br>
<hr>NEW: 101215799<br>
<hr>NEW: 101215899<br>
<hr>NEW: 101215999<br>
<hr>NEW: 101216099<br>
<hr>NEW: 101216199<br>
<hr>NEW: 101216299<br>
<hr>NEW: 101216399<br>
<hr>NEW: 101216499<br>
<hr>NEW: 101216599<br>
<hr>NEW: 101216699<br>
<hr>NEW: 101216799<br>
<hr>NEW: 101216899<br>
<hr>NEW: 101216999<br>
<hr>NEW: 101217099<br>
<hr>NEW: 101217199<br>
<hr>NEW: 101217299<br>
<hr>NEW: 101217399<br>
<hr>NEW: 101217499<br>
<hr>NEW: 101217599<br>
<hr>NEW: 101217699<br>
<hr>NEW: 101217799<br>
<hr>NEW: 101217899<br>
<hr>NEW: 101217999<br>
<hr>NEW: 101218099<br>
<hr>NEW: 101218199<br>
<hr>NEW: 101218299<br>
<hr>NEW: 101218399<br>
<hr>NEW: 101218499<br>
<hr>NEW: 101218599<br>
<hr>NEW: 101218699<br>
<hr>NEW: 101218799<br>
<hr>NEW: 101218899<br>
<hr>NEW: 101218999<br>
<hr>NEW: 101219099<br>
<hr>NEW: 101219199<br>
<hr>NEW: 101219299<br>
<hr>NEW: 101219399<br>
<hr>NEW: 101219499<br>
<hr>NEW: 101219599<br>
<hr>NEW: 101219699<br>
<hr>NEW: 101219799<br>
<hr>NEW: 101219899<br>
<hr>UPDATING: Tinta para Porcelana Pébéo Porcelaine<br>
Product ID: 27447<br>
Image file: <br>
<hr>NEW: 101220099<br>
<hr>NEW: 101220199<br>
<hr>NEW: 101220299<br>
<hr>NEW: 101220399<br>
<hr>NEW: 101220499<br>
<hr>NEW: 101220599<br>
<hr>NEW: 101220699<br>
<hr>NEW: 101220799<br>
<hr>NEW: 101220899<br>
<hr>NEW: 101220999<br>
<hr>NEW: 101221099<br>
<hr>NEW: 101221199<br>
<hr>NEW: 101221299<br>
<hr>NEW: 101221399<br>
<hr>NEW: 101221499<br>
<hr>NEW: 101221599<br>
<hr>NEW: 101221699<br>
<hr>NEW: 101221799<br>
<hr>NEW: 101221899<br>
<hr>NEW: 101221999<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 108<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 = 27447
					AND option_id = 17
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '101219999 - %'

				<br>INSERT INTO oc_option_value 
						SET
							option_id = 17,
							image = '',
							sort_order = 0
					<br>INSERT INTO oc_option_value_description 
						SELECT
							3528 AS option_value_id,
							language_id,
							17 AS option_id,
							'101219999 - Tinta Pébéo Porcelaine 150 Ardosia Preto 250 ml' AS name
						FROM
							oc_language
					<br>SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 426
							AND product_id = 27447
							AND option_id = 17
							AND option_value_id = 3528

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