Product Sync.
Opencart products: 158
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
UPDATING: Tinta Acrílica Winsor & Newton 250 ml
Product ID: 27027
Image file:
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: 27024
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: 159
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 =
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 15,
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 =
AND product_id =
AND option_id = 15
AND option_value_id = 1332
DELETE FROM oc_product
WHERE
model = '100391699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
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 = 27147
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27147,
option_id = 15,
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 = 294
AND product_id = 27147
AND option_id = 15
AND option_value_id = 1347
DELETE FROM oc_product
WHERE
model = '100391899'
INSERT INTO oc_product_option_value
SET
product_option_id = 294,
product_id = 27147,
option_id = 15,
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 = 27024
AND option_id = 15
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 = 92
AND product_id = 27024
AND option_id = 15
AND option_value_id = 972
DELETE FROM oc_product
WHERE
model = '100392399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 92
AND product_id = 27024
AND option_id = 15
AND option_value_id = 972
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 = 92
AND product_id = 27024
AND option_id = 15
AND option_value_id = 973
DELETE FROM oc_product
WHERE
model = '100392499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 92
AND product_id = 27024
AND option_id = 15
AND option_value_id = 973
Ok.