Product Sync.
Opencart products: 211
Input products: 100
NEW: 101666499
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101666499 - %'
)
UPDATING: Marcador Aguarela Winsor & Newton Cotman
Product ID: 27072
Image file:
NEW: 101666799
NEW: 101666899
NEW: 101666999
NEW: 101667099
NEW: 101667199
NEW: 101667299
NEW: 101667399
NEW: 101667499
NEW: 101667599
NEW: 101667699
NEW: 101667799
NEW: 101667899
NEW: 101667999
NEW: 101668099
NEW: 101668199
NEW: 101668299
NEW: 101668399
NEW: 101668499
NEW: 101668599
NEW: 101668699
NEW: 101668799
NEW: 101668899
NEW: 101668999
NEW: 101669099
NEW: 101669199
NEW: 101669299
NEW: 101669399
NEW: 101669499
NEW: 101669599
NEW: 101669699
NEW: 101669799
NEW: 101669899
NEW: 101669999
NEW: 101670099
NEW: 101670199
NEW: 101670299
NEW: 101670399
NEW: 101670499
NEW: 101670599
NEW: 101670699
NEW: 101670799
NEW: 101670899
NEW: 101670999
NEW: 101671099
NEW: 101671199
NEW: 101671299
NEW: 101671399
NEW: 101671499
NEW: 101671599
NEW: 101671699
NEW: 101671799
NEW: 101671899
NEW: 101671999
NEW: 101672099
NEW: 101672199
NEW: 101672299
NEW: 101672399
NEW: 101672499
NEW: 101672599
NEW: 101672699
NEW: 101672799
NEW: 101672899
NEW: 101672999
NEW: 101673099
NEW: 101673199
NEW: 101673299
NEW: 101673399
NEW: 101673499
NEW: 101673599
NEW: 101673699
NEW: 101673799
NEW: 101673899
NEW: 101673999
NEW: 101674099
NEW: 101674199
NEW: 101674299
NEW: 101674399
NEW: 101674499
NEW: 101674599
NEW: 101674699
NEW: 101674799
NEW: 101674899
NEW: 101674999
NEW: 101675099
NEW: 101675199
NEW: 101675299
NEW: 101675399
NEW: 101675499
NEW: 101675599
NEW: 101675699
NEW: 101675799
NEW: 101675899
NEW: 101675999
NEW: 101676099
NEW: 101676199
NEW: 101676299
NEW: 101676399
Ok.
Product Option Sync.
Opencart products: 212
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 '101666599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1816
UPDATE oc_option_value_description
SET
name = '101666599 - Marcador Aguarela Winsor & Newton Caixa com 6'
WHERE
option_value_id = 1816
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 = 1816
DELETE FROM oc_product
WHERE
model = '101666599'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1816,
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 '101666699 - %'
UPDATE oc_option_value
SET
image = 'catalog/101666699.jpg'
WHERE
option_value_id = 1817
UPDATE oc_option_value_description
SET
name = '101666699 - Marcador Aguarela Winsor & Newton Caixa com 12'
WHERE
option_value_id = 1817
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 = 1817
DELETE FROM oc_product
WHERE
model = '101666699'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 1817,
quantity = 1,
subtract = 1,
price = 19.025,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.