Product Sync.
Opencart products: 54
Input products: 100
NEW: 100383999
NEW: 100384099
NEW: 100384199
NEW: 100384299
NEW: 100384399
NEW: 100384499
NEW: 100384599
NEW: 100384699
NEW: 100384799
NEW: 100384899
NEW: 100384999
NEW: 100385099
NEW: 100385199
NEW: 100385299
NEW: 100385399
NEW: 100385499
NEW: 100385599
NEW: 100385699
NEW: 100385799
NEW: 100385899
NEW: 100385999
NEW: 100386099
NEW: 100386199
NEW: 100386299
NEW: 100386399
NEW: 100386499
NEW: 100386599
NEW: 100386699
NEW: 100386799
NEW: 100386899
NEW: 100386999
NEW: 100387099
NEW: 100387199
NEW: 100387299
NEW: 100387399
NEW: 100387499
NEW: 100387599
NEW: 100387699
NEW: 100387799
NEW: 100387899
NEW: 100387999
NEW: 100388099
NEW: 100388199
NEW: 100388299
NEW: 100388399
NEW: 100388499
NEW: 100388599
NEW: 100388699
NEW: 100388799
NEW: 100388899
NEW: 100388999
NEW: 100389099
NEW: 100389199
NEW: 100389299
NEW: 100389399
NEW: 100389499
NEW: 100389599
NEW: 100389699
NEW: 100389799
NEW: 100389899
NEW: 100389999
NEW: 100390099
NEW: 100390199
NEW: 100390299
NEW: 100390399
NEW: 100390499
NEW: 100390599
NEW: 100390699
NEW: 100390799
NEW: 100390899
NEW: 100390999
NEW: 100391099
NEW: 100391199
NEW: 100391299
NEW: 100391399
NEW: 100391499
NEW: 100391599
NEW: Tinta Acrílica Winsor & Newton 250 ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Tinta Acrílica Winsor & Newton 250 ml - %'
)
NEW: 100391799
NEW: Cavalete Talens Tripé New York
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Talens Tripé New York - %'
)
NEW: 100391999
NEW: 100392099
NEW: 100392199
NEW: 100392299
UPDATING: Aguarela Líquida Ecoline
Product ID: 27449
Image file:
NEW: 100392599
NEW: 100392699
NEW: 100392799
NEW: 100392899
NEW: 100392999
NEW: 100393099
NEW: 100393199
NEW: 100393299
NEW: 100393399
NEW: 100393499
NEW: 100393599
NEW: 100393699
NEW: 100393799
NEW: 100393899
Ok.
Product Option Sync.
Opencart products: 56
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 = 27452
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27452,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100391699 - %'
UPDATE oc_option_value
SET
image = 'catalog/100391699.jpg'
WHERE
option_value_id = 1332
UPDATE oc_option_value_description
SET
name = '100391699 - Acrílico Winsor & Newton Galeria 250 ml Verde Sap (599)'
WHERE
option_value_id = 1332
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 431
AND product_id = 27452
AND option_id = 17
AND option_value_id = 1332
DELETE FROM oc_product
WHERE
model = '100391699'
INSERT INTO oc_product_option_value
SET
product_option_id = 431,
product_id = 27452,
option_id = 17,
option_value_id = 1332,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27453
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27453,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100391899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1347
UPDATE oc_option_value_description
SET
name = '100391899 - Cavalete Talens Tripé New York'
WHERE
option_value_id = 1347
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 432
AND product_id = 27453
AND option_id = 17
AND option_value_id = 1347
DELETE FROM oc_product
WHERE
model = '100391899'
INSERT INTO oc_product_option_value
SET
product_option_id = 432,
product_id = 27453,
option_id = 17,
option_value_id = 1347,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27449
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100392399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 972
UPDATE oc_option_value_description
SET
name = '100392399 - Aguarela Ecoline Talens 25 - 30 ml Verde Bosque 656'
WHERE
option_value_id = 972
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 428
AND product_id = 27449
AND option_id = 17
AND option_value_id = 972
DELETE FROM oc_product
WHERE
model = '100392399'
INSERT INTO oc_product_option_value
SET
product_option_id = 428,
product_id = 27449,
option_id = 17,
option_value_id = 972,
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 '100392499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 973
UPDATE oc_option_value_description
SET
name = '100392499 - Aguarela Ecoline Talens 25 - 30 ml Rosa Claro'
WHERE
option_value_id = 973
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 428
AND product_id = 27449
AND option_id = 17
AND option_value_id = 973
DELETE FROM oc_product
WHERE
model = '100392499'
INSERT INTO oc_product_option_value
SET
product_option_id = 428,
product_id = 27449,
option_id = 17,
option_value_id = 973,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.