Product Sync.
Opencart products: 164
Input products: 100
NEW: 102181699
NEW: 102181799
NEW: 102181899
NEW: 102181999
NEW: 102182099
NEW: 102182199
NEW: 102182299
NEW: 102182399
UPDATING: Aguarela Líquida Ecoline
Product ID: 27449
Image file:
NEW: 102182699
NEW: 102182899
NEW: 102182999
NEW: 102183099
NEW: 102183199
NEW: 102183299
NEW: 102183399
UPDATING: Verniz Pébeo
Product ID: 27462
Image file:
NEW: 102183699
NEW: 102183799
NEW: 102183899
NEW: 102183999
NEW: 102184099
NEW: 102184199
NEW: 102184299
NEW: 102184399
NEW: 102184499
NEW: 102184599
NEW: 102184699
NEW: 102184799
NEW: 102184899
NEW: 102184999
NEW: 102185099
NEW: 102185199
NEW: 102185299
NEW: 102185399
NEW: 102185499
NEW: 102185599
NEW: 102185699
NEW: 102185799
NEW: 102185899
NEW: 102185999
NEW: 102186099
NEW: 102186199
NEW: 102186299
NEW: 102186399
NEW: 102186499
NEW: 102186599
NEW: 102186699
NEW: 102186799
NEW: 102186899
NEW: 102186999
NEW: 102187099
NEW: 102187199
NEW: 102187299
NEW: 102187399
NEW: 102187499
NEW: 102187599
NEW: 102187699
NEW: 102187799
NEW: 102187899
NEW: 102187999
NEW: 102188099
NEW: 102188199
NEW: 102188299
NEW: 102188399
NEW: 102188499
NEW: 102188599
NEW: 102188699
NEW: 102188799
NEW: 102188899
NEW: 102188999
NEW: 102189099
NEW: 102189199
NEW: 102189299
NEW: 102189399
NEW: 102189499
NEW: 102189599
NEW: 102189699
NEW: 102189799
NEW: 102189899
NEW: 102189999
NEW: 102190099
NEW: 102190199
NEW: 102190299
NEW: 102190399
NEW: 102190499
NEW: 102190599
NEW: 102190699
NEW: 102190799
NEW: 102190899
NEW: 102190999
NEW: 102191099
NEW: 102191199
NEW: 102191299
NEW: 102191399
NEW: 102191499
NEW: 102191599
Ok.
Product Option Sync.
Opencart products: 164
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 = 27449
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102182499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1673
UPDATE oc_option_value_description
SET
name = '102182499 - Aguarela Ecoline Talens 30 ml Verde 600'
WHERE
option_value_id = 1673
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 = 1673
DELETE FROM oc_product
WHERE
model = '102182499'
INSERT INTO oc_product_option_value
SET
product_option_id = 428,
product_id = 27449,
option_id = 17,
option_value_id = 1673,
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 '102182599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1674
UPDATE oc_option_value_description
SET
name = '102182599 - Aguarela Ecoline Talens 30 ml Verde Erva 676'
WHERE
option_value_id = 1674
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 = 1674
DELETE FROM oc_product
WHERE
model = '102182599'
INSERT INTO oc_product_option_value
SET
product_option_id = 428,
product_id = 27449,
option_id = 17,
option_value_id = 1674,
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 '102182799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1675
UPDATE oc_option_value_description
SET
name = '102182799 - Aguarela Ecoline Talens 30 ml Amarelo Claro 201'
WHERE
option_value_id = 1675
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 = 1675
DELETE FROM oc_product
WHERE
model = '102182799'
INSERT INTO oc_product_option_value
SET
product_option_id = 428,
product_id = 27449,
option_id = 17,
option_value_id = 1675,
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 = 27462
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102183499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3679 AS option_value_id,
language_id,
17 AS option_id,
'102183499 - Verniz Pébéo 75 ml Mate' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 441
AND product_id = 27462
AND option_id = 17
AND option_value_id = 3679
DELETE FROM oc_product
WHERE
model = '102183499'
INSERT INTO oc_product_option_value
SET
product_option_id = 441,
product_id = 27462,
option_id = 17,
option_value_id = 3679,
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 '102183599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3680 AS option_value_id,
language_id,
17 AS option_id,
'102183599 - Verniz Pébéo 75 ml Acetinado' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 441
AND product_id = 27462
AND option_id = 17
AND option_value_id = 3680
DELETE FROM oc_product
WHERE
model = '102183599'
INSERT INTO oc_product_option_value
SET
product_option_id = 441,
product_id = 27462,
option_id = 17,
option_value_id = 3680,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.