Product Sync.
Opencart products: 31
Input products: 100
UPDATING: Caixas e Conjuntos
Product ID: 27382
Image file: Caixas e Conjuntos.jpg
NEW: 102221199
NEW: 102221399
NEW: 102221499
NEW: 102221599
NEW: 102221699
NEW: 102221799
NEW: 102221899
NEW: 102221999
NEW: 102222099
NEW: 102222199
NEW: 102222299
NEW: 102222399
NEW: 102222499
NEW: 102222599
NEW: 102222699
NEW: 102222799
NEW: 102222899
NEW: 102222999
NEW: 102223099
NEW: 102223199
NEW: 102223299
NEW: 102223399
NEW: 102223499
NEW: 102223599
NEW: 102223699
NEW: 102223799
NEW: 102223899
NEW: 102223999
NEW: 102224099
NEW: 102224299
NEW: 102224399
NEW: 102224499
NEW: 102224599
UPDATING: 102224699
Product ID: 27263
Image file:
Category PINTURA: Exists
Category : Exists
Category CONJUNTOS TINTAS: Not Found
Category : Exists
Category AGUARELA: Exists
UPDATING: 102224899
Product ID: 27265
Image file:
Category PINTURA: Exists
Category : Exists
Category CONJUNTOS TINTAS: Exists
Category : Exists
Category OLEO: Exists
NEW: 102224999
NEW: 102225099
NEW: 102225199
NEW: 102225299
NEW: 102225399
NEW: 102225499
NEW: 102225599
NEW: 102225699
NEW: 102225799
NEW: 102225899
NEW: 102225999
NEW: 102226099
NEW: 102226199
NEW: 102226299
NEW: 102226399
NEW: 102226499
NEW: 102226599
NEW: 102226699
NEW: 102226799
NEW: 102226899
NEW: 102226999
NEW: 102227099
NEW: 102227199
NEW: 102227299
NEW: 102227399
NEW: 102227499
NEW: 102227599
NEW: 102227699
NEW: 102227799
NEW: 102227899
NEW: 102227999
NEW: 102228099
NEW: 102228199
NEW: 102228299
NEW: 102228399
NEW: 102228499
NEW: 102228599
NEW: 102228699
NEW: 102228799
NEW: 102228899
NEW: 102228999
NEW: 102229099
NEW: 102229199
NEW: 102229299
NEW: 102229399
NEW: 102229499
NEW: 102229599
NEW: 102229699
NEW: 102229799
NEW: 102229899
NEW: 102229999
NEW: 102230099
NEW: 102230199
NEW: 102230299
NEW: 102230399
NEW: 102230499
NEW: 102230599
NEW: 102230699
NEW: 102230799
NEW: 102230899
Ok.
Product Option Sync.
Opencart products: 31
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 = 27382
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102220999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1911
UPDATE oc_option_value_description
SET
name = '102220999 - CXA AGUAR DR AQUAFINE REDONDA TRAVEL C/18'
WHERE
option_value_id = 1911
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 375
AND product_id = 27382
AND option_id = 17
AND option_value_id = 1911
DELETE FROM oc_product
WHERE
model = '102220999'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1911,
quantity = 1,
subtract = 1,
price = 9.756,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102221099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1912
UPDATE oc_option_value_description
SET
name = '102221099 - CXA AGUAR DR AQUAFINE METAL TRAVEL C/24'
WHERE
option_value_id = 1912
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 375
AND product_id = 27382
AND option_id = 17
AND option_value_id = 1912
DELETE FROM oc_product
WHERE
model = '102221099'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1912,
quantity = 1,
subtract = 1,
price = 17.073,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102221299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1913
UPDATE oc_option_value_description
SET
name = '102221299 - CONJ ESTOJO DR SIMPLY ACRIL TRAVEL'
WHERE
option_value_id = 1913
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 375
AND product_id = 27382
AND option_id = 17
AND option_value_id = 1913
DELETE FROM oc_product
WHERE
model = '102221299'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1913,
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 '102224199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1914
UPDATE oc_option_value_description
SET
name = '102224199 - CX AGUAR W&N ARTIST CX BAMBOO C/12TUB + ACESS'
WHERE
option_value_id = 1914
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 375
AND product_id = 27382
AND option_id = 17
AND option_value_id = 1914
DELETE FROM oc_product
WHERE
model = '102224199'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1914,
quantity = 1,
subtract = 1,
price = 68.293,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102224799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1915
UPDATE oc_option_value_description
SET
name = '102224799 - SET ACRIL VAN GOGH THAT´S ME C/ 10TB 40ML + ACESS'
WHERE
option_value_id = 1915
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 375
AND product_id = 27382
AND option_id = 17
AND option_value_id = 1915
DELETE FROM oc_product
WHERE
model = '102224799'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1915,
quantity = 1,
subtract = 1,
price = 10.244,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.