Product Sync.<br>
Opencart products: 304<br>
Input products: 100<br>
<hr>NEW: 102530799<br>
<hr>NEW: 102530899<br>
<hr>NEW: 102530999<br>
<hr>NEW: 102531099<br>
<hr>NEW: 102531199<br>
<hr>NEW: 102531299<br>
<hr>NEW: 102531399<br>
<hr>NEW: 102531499<br>
<hr>NEW: 102531599<br>
<hr>NEW: 102531699<br>
<hr>NEW: 102531799<br>
<hr>NEW: 102531899<br>
<hr>NEW: 102531999<br>
<hr>NEW: 102532099<br>
<hr>NEW: 102532199<br>
<hr>NEW: 102532299<br>
<hr>NEW: 102532399<br>
<hr>NEW: 102532499<br>
<hr>NEW: 102532599<br>
<hr>NEW: 102532699<br>
<hr>NEW: 102532799<br>
<hr>NEW: 102532899<br>
<hr>NEW: 102532999<br>
<hr>NEW: 102533099<br>
<hr>NEW: 102533199<br>
<hr>NEW: 102533299<br>
<hr>NEW: 102533399<br>
<hr>NEW: 102533499<br>
<hr>NEW: 102533599<br>
<hr>NEW: 102533699<br>
<hr>NEW: 102533799<br>
<hr>NEW: 102533899<br>
<hr>NEW: 102533999<br>
<hr>NEW: 102534099<br>
<hr>NEW: 102534199<br>
<hr>NEW: 102534299<br>
<hr>NEW: 102534399<br>
<hr>NEW: 102534499<br>
<hr>NEW: 102534599<br>
<hr>NEW: 102534699<br>
<hr>NEW: 102534799<br>
<hr>NEW: 102534899<br>
<hr>NEW: 102534999<br>
<hr>NEW: 102535099<br>
<hr>NEW: 102535199<br>
<hr>NEW: 102535299<br>
<hr>NEW: 102535399<br>
<hr>NEW: 102535499<br>
<hr>NEW: 102535599<br>
<hr>NEW: 102535699<br>
<hr>NEW: 102535799<br>
<hr>NEW: 102535899<br>
<hr>NEW: 102535999<br>
<hr>NEW: 102536099<br>
<hr>NEW: 102536199<br>
<hr>NEW: 102536399<br>
<hr>NEW: 102536499<br>
<hr>NEW: 102536599<br>
<hr>NEW: 102536699<br>
<hr>NEW: 102536799<br>
<hr>NEW: 102536899<br>
<hr>NEW: 102536999<br>
<hr>NEW: 102537099<br>
<hr>NEW: 102537199<br>
<hr>NEW: 102537299<br>
<hr>NEW: 102537399<br>
<hr>NEW: 102537499<br>
<hr>UPDATING: Tela Creatore 3D<br>
Product ID: 27130<br>
Image file: <br>
<hr>NEW: 102537699<br>
<hr>NEW: 102537799<br>
<hr>NEW: 102537899<br>
<hr>NEW: 102537999<br>
<hr>NEW: 102538099<br>
<hr>NEW: 102538199<br>
<hr>NEW: 102538299<br>
<hr>NEW: 102538399<br>
<hr>UPDATING: Pincel Talens Aguarela Espatulado S194<br>
Product ID: 27199<br>
Image file: <br>
<hr>NEW: 102538599<br>
<hr>NEW: 102538699<br>
<hr>NEW: 102538799<br>
<hr>NEW: 102538899<br>
<hr>NEW: 102538999<br>
<hr>NEW: 102539099<br>
<hr>NEW: 102539199<br>
<hr>NEW: 102539299<br>
<hr>NEW: 102539399<br>
<hr>NEW: 102539499<br>
<hr>NEW: 102539599<br>
<hr>NEW: 102539699<br>
<hr>NEW: 102539799<br>
<hr>NEW: 102539899<br>
<hr>NEW: 102539999<br>
<hr>NEW: 102540099<br>
<hr>NEW: 102540199<br>
<hr>NEW: 102540299<br>
<hr>NEW: 102540399<br>
<hr>NEW: 102540499<br>
<hr>NEW: 102540599<br>
<hr>NEW: 102540699<br>
<hr>NEW: 102540799<br>
<hr>Ok.<hr><hr>Product Option Sync.<br>
Opencart products: 304<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 = 27130
					AND option_id = 15
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '102537599 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2724
					<br>UPDATE oc_option_value_description 
						SET
							name = '102537599 - Tela Creatore 3D 70 x 70'
						WHERE
							option_value_id = 2724
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 284
							AND product_id = 27130
							AND option_id = 15
							AND option_value_id = 2724

				<br>DELETE FROM oc_product
					WHERE
						model = '102537599'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 284,
								product_id = 27130,
								option_id = 15,
								option_value_id = 2724,
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br><hr>SELECT product_option_id FROM oc_product_option 
				WHERE
					product_id = 27199
					AND option_id = 15
			<br>SELECT DISTINCT option_value_id FROM oc_option_value_description
						WHERE
							name LIKE '102538499 - %'

				<br>UPDATE oc_option_value 
						SET
							image = NULL
						WHERE
							option_value_id = 2725
					<br>UPDATE oc_option_value_description 
						SET
							name = '102538499 - Pincel Talens Aguarela Espatulado S194 N24'
						WHERE
							option_value_id = 2725
					SELECT DISTINCT product_option_value_id FROM oc_product_option_value
						WHERE
							product_option_id = 321
							AND product_id = 27199
							AND option_id = 15
							AND option_value_id = 2725

				<br>DELETE FROM oc_product
					WHERE
						model = '102538499'
				<br>INSERT INTO oc_product_option_value 
							SET
								product_option_id = 321,
								product_id = 27199,
								option_id = 15,
								option_value_id = 2725,
								quantity = 1,
								subtract = 1,
								price = 0,
								price_prefix = '+',
								points = 0,
								points_prefix = '+',
								weight = 0,
								weight_prefix = '+'
						<br><hr>Ok.<hr><hr>