Product Sync.
Opencart products: 179
Input products: 100
NEW: 100777799
NEW: 100777899
NEW: 100777999
NEW: 100778099
NEW: 100778199
NEW: 100778299
NEW: 100778399
NEW: 100778499
NEW: 100778599
NEW: 100778699
NEW: 100778799
NEW: 100778899
NEW: 100778999
NEW: 100779099
NEW: 100779199
NEW: 100779299
NEW: 100779399
NEW: 100779499
NEW: 100779599
NEW: 100779699
NEW: 100779799
NEW: 100779899
NEW: 100779999
NEW: 100780099
NEW: 100780199
NEW: 100780299
NEW: 100780399
NEW: 100780499
NEW: 100780599
NEW: 100780699
NEW: 100780799
NEW: 100780899
NEW: 100780999
NEW: 100781099
NEW: 100781199
NEW: 100781299
NEW: 100781399
NEW: 100781499
NEW: 100781599
NEW: 100781699
NEW: 100781799
NEW: 100781899
NEW: 100781999
NEW: 100782099
NEW: 100782199
NEW: 100782299
NEW: 100782399
NEW: 100782499
NEW: 100782599
NEW: 100782699
NEW: 100782799
NEW: 100782899
NEW: 100782999
NEW: 100783099
NEW: 100783199
NEW: 100783299
NEW: 100783399
NEW: 100783499
NEW: 100783599
NEW: 100783699
NEW: 100783799
NEW: 100783899
NEW: 100783999
NEW: 100784099
NEW: 100784199
NEW: 100784299
NEW: 100784399
NEW: 100784499
NEW: 100784599
NEW: 100784699
NEW: 100784799
NEW: 100784899
NEW: 100784999
NEW: 100785099
NEW: 100785199
NEW: 100785299
NEW: 100785399
NEW: 100785499
NEW: 100785599
NEW: 100785699
NEW: 100785799
NEW: 100785899
NEW: 100785999
UPDATING: Guache Giotto Lavável 500 ml
Product ID: 27050
Image file:
NEW: 100786899
NEW: 100786999
NEW: 100787099
NEW: 100787199
NEW: 100787299
NEW: 100787399
NEW: 100787499
NEW: 100787599
NEW: 100787699
Ok.
Product Option Sync.
Opencart products: 179
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 = 27050
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100786099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2373
UPDATE oc_option_value_description
SET
name = '100786099 - Guache Giotto 500 ml Lavável Verde Claro'
WHERE
option_value_id = 2373
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2373
DELETE FROM oc_product
WHERE
model = '100786099'
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 = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2373
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100786199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2374
UPDATE oc_option_value_description
SET
name = '100786199 - Guache Giotto 500 ml Lavável Verde Escuro'
WHERE
option_value_id = 2374
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2374
DELETE FROM oc_product
WHERE
model = '100786199'
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 = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2374
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100786299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2375
UPDATE oc_option_value_description
SET
name = '100786299 - Guache Giotto 500 ml Lavável Verde Esmeralda'
WHERE
option_value_id = 2375
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2375
DELETE FROM oc_product
WHERE
model = '100786299'
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 = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2375
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100786399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2376
UPDATE oc_option_value_description
SET
name = '100786399 - Guache Giotto 500 ml Lavável Azul Cyan'
WHERE
option_value_id = 2376
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2376
DELETE FROM oc_product
WHERE
model = '100786399'
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 = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2376
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100786499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2377
UPDATE oc_option_value_description
SET
name = '100786499 - Guache Giotto 500 ml Lavável Azul Ultramarino'
WHERE
option_value_id = 2377
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2377
DELETE FROM oc_product
WHERE
model = '100786499'
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 = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2377
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100786599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2378
UPDATE oc_option_value_description
SET
name = '100786599 - Guache Giotto 500 ml Lavável Azul Turquesa'
WHERE
option_value_id = 2378
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2378
DELETE FROM oc_product
WHERE
model = '100786599'
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 = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2378
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100786699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2379
UPDATE oc_option_value_description
SET
name = '100786699 - Guache Giotto 500 ml Lavável Violeta'
WHERE
option_value_id = 2379
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2379
DELETE FROM oc_product
WHERE
model = '100786699'
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 = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2379
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100786799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2380
UPDATE oc_option_value_description
SET
name = '100786799 - Guache Giotto 500 ml Lavável Rosa Carne'
WHERE
option_value_id = 2380
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2380
DELETE FROM oc_product
WHERE
model = '100786799'
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 = 115
AND product_id = 27050
AND option_id = 15
AND option_value_id = 2380
Ok.