Product Sync.
Opencart products: 30
Input products: 100
NEW: 257892467
NEW: 257892567
NEW: 257892667
NEW: 257892767
NEW: 257892867
NEW: 257892967
NEW: 257893267
NEW: 257893367
NEW: 257893767
NEW: 257893867
NEW: 258410299
NEW: 261137099
NEW: 261601299
UPDATING: Rembrandt 15ml
Product ID: 27397
Image file: Rembrandt 15ml.png
NEW: 264330419
NEW: 264360199
NEW: 264360399
NEW: 264360699
NEW: 264360799
NEW: 264360999
NEW: 266127500
NEW: 266135600
NEW: 266135700
NEW: 266160699
NEW: 266210802
NEW: 266817300
NEW: 266841013
NEW: 266845500
NEW: 267030700
NEW: 267030800
NEW: 267030900
NEW: 267031000
NEW: 267031100
NEW: 267031200
NEW: 267038100
NEW: 267038200
NEW: 267070100
NEW: 267070300
NEW: 267081200
NEW: 267207200
NEW: 267207300
NEW: 267230200
NEW: 267234000
NEW: 267245076
NEW: 267250076
NEW: 267250176
NEW: 267250276
NEW: 267250476
NEW: 267250576
NEW: 267250776
NEW: 267251376
NEW: 267251476
NEW: 267251576
NEW: 267254076
NEW: 267254176
NEW: 267254276
NEW: 267254376
NEW: 267254476
NEW: 267254576
NEW: 267254776
NEW: 267254876
NEW: 267254976
NEW: 267255076
NEW: 267256200
NEW: 267261100
NEW: 267261200
NEW: 267261400
NEW: 267421076
NEW: 267421176
NEW: 267421276
NEW: 267421376
NEW: 267421476
NEW: 267421576
NEW: 267437076
NEW: 267437276
NEW: 267449776
NEW: 267509698
NEW: 267621400
NEW: 267622300
NEW: 267622400
NEW: 267623200
NEW: 268229498
NEW: 268229698
NEW: 268801567
NEW: 268801667
NEW: 268801767
NEW: 268801867
NEW: 268801967
NEW: 268802067
NEW: 268802167
NEW: 268802267
NEW: 268802367
NEW: 268802467
NEW: 268802567
NEW: 268802667
NEW: 268805528
NEW: 268805928
NEW: 268806028
Ok.
Product Option Sync.
Opencart products: 30
Input products: 100
SELECT option_id FROM oc_option_description
WHERE
NAME = 'Opção'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27397
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '263309598 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1933
UPDATE oc_option_value_description
SET
name = '263309598 - OLEO REMB T6-15ML S1 BRANCO MESCLADO'
WHERE
option_value_id = 1933
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 = 1933
DELETE FROM oc_product
WHERE
model = '263309598'
INSERT INTO oc_product_option_value
SET
product_option_id = 390,
product_id = 27397,
option_id = 17,
option_value_id = 1933,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '263313098 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1934
UPDATE oc_option_value_description
SET
name = '263313098 - OLEO REMB T6-15ML S2 NAPLES YELLOW LIGHT'
WHERE
option_value_id = 1934
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 = 1934
DELETE FROM oc_product
WHERE
model = '263313098'
INSERT INTO oc_product_option_value
SET
product_option_id = 390,
product_id = 27397,
option_id = 17,
option_value_id = 1934,
quantity = 1,
subtract = 1,
price = 0.731,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '263316098 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1935
UPDATE oc_option_value_description
SET
name = '263316098 - OLEO REMB T6-15ML S3 STIL GRAIN AMARELO'
WHERE
option_value_id = 1935
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 = 1935
DELETE FROM oc_product
WHERE
model = '263316098'
INSERT INTO oc_product_option_value
SET
product_option_id = 390,
product_id = 27397,
option_id = 17,
option_value_id = 1935,
quantity = 1,
subtract = 1,
price = 1.951,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.