Product Sync.
Opencart products: 208
Input products: 100
NEW: 101585699
NEW: 101585799
NEW: 101585899
NEW: 101585999
NEW: 101586099
NEW: 101586199
NEW: 101586299
NEW: 101586399
NEW: 101586499
NEW: 101586599
NEW: 101586699
NEW: 101586799
NEW: 101586899
NEW: 101586999
NEW: 101587099
NEW: 101587199
NEW: 101587299
NEW: 101587399
NEW: 101587499
NEW: 101587599
NEW: 101587699
NEW: 101587799
NEW: 101587899
NEW: 101587999
NEW: 101588099
NEW: 101588199
NEW: 101588299
NEW: 101588399
NEW: 101588499
NEW: 101588599
NEW: 101588699
NEW: 101588799
NEW: 101588899
NEW: 101588999
NEW: 101589099
NEW: 101589199
NEW: 101589299
NEW: 101589399
NEW: 101589499
NEW: 101589599
NEW: 101589699
NEW: 101589799
UPDATING: Bloco para Acrílico e Óleo Talens
Product ID: 27044
Image file:
NEW: Bloco para Acrílico Van Gogh
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Bloco para Acrílico Van Gogh - %'
)
UPDATING: Bloco para Aguarela Talens
Product ID: 27045
Image file:
NEW: 101590499
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101590499 - %'
)
NEW: 101590599
NEW: 101590699
NEW: 101590799
NEW: 101590899
NEW: 101590999
NEW: 101591099
NEW: 101591199
NEW: 101591299
NEW: 101591399
NEW: 101591499
NEW: 101591599
NEW: 101591699
NEW: 101591799
NEW: 101591899
NEW: 101591999
NEW: 101592099
NEW: 101592199
NEW: 101592299
NEW: 101592399
NEW: 101592499
NEW: 101592599
NEW: 101592699
NEW: 101592799
NEW: 101592899
NEW: 101592999
NEW: 101593099
NEW: 101593199
NEW: 101593299
NEW: 101593399
NEW: 101593499
NEW: 101593599
NEW: 101593699
NEW: 101593799
NEW: 101593899
NEW: 101593999
NEW: 101594099
NEW: 101594199
NEW: 101594299
NEW: 101594399
NEW: 101594499
NEW: 101594599
NEW: 101594699
NEW: 101594799
NEW: 101594899
NEW: 101594999
NEW: 101595099
NEW: 101595199
NEW: 101595299
NEW: 101595399
NEW: 101595499
NEW: 101595599
Ok.
Product Option Sync.
Opencart products: 210
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 = 27044
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101589899 - %'
UPDATE oc_option_value
SET
image = 'catalog/101589899.jpg'
WHERE
option_value_id = 2475
UPDATE oc_option_value_description
SET
name = '101589899 - Bloco para Óleo Van Gogh 24 x 32 240 gr 10 Fls'
WHERE
option_value_id = 2475
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 111
AND product_id = 27044
AND option_id = 15
AND option_value_id = 2475
DELETE FROM oc_product
WHERE
model = '101589899'
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 = 111
AND product_id = 27044
AND option_id = 15
AND option_value_id = 2475
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101589999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2476
UPDATE oc_option_value_description
SET
name = '101589999 - Bloco para Óleo Van Gogh 30 x 40 240 gr 10 Fls'
WHERE
option_value_id = 2476
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 111
AND product_id = 27044
AND option_id = 15
AND option_value_id = 2476
DELETE FROM oc_product
WHERE
model = '101589999'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 3.292,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 111
AND product_id = 27044
AND option_id = 15
AND option_value_id = 2476
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27197
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27197,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101590099 - %'
UPDATE oc_option_value
SET
image = 'catalog/101590099.jpg'
WHERE
option_value_id = 2477
UPDATE oc_option_value_description
SET
name = '101590099 - Bloco para Acrílico Van Gogh 24 X30 370 gr 10 Fls'
WHERE
option_value_id = 2477
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 320
AND product_id = 27197
AND option_id = 15
AND option_value_id = 2477
DELETE FROM oc_product
WHERE
model = '101590099'
INSERT INTO oc_product_option_value
SET
product_option_id = 320,
product_id = 27197,
option_id = 15,
option_value_id = 2477,
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 '101590199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2478
UPDATE oc_option_value_description
SET
name = '101590199 - Bloco para Acrílico Van Gogh 30X40 370GR 10FLS'
WHERE
option_value_id = 2478
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 320
AND product_id = 27197
AND option_id = 15
AND option_value_id = 2478
DELETE FROM oc_product
WHERE
model = '101590199'
INSERT INTO oc_product_option_value
SET
product_option_id = 320,
product_id = 27197,
option_id = 15,
option_value_id = 2478,
quantity = 1,
subtract = 1,
price = 3.333,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27045
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101590299 - %'
UPDATE oc_option_value
SET
image = 'catalog/101590299.jpg'
WHERE
option_value_id = 2479
UPDATE oc_option_value_description
SET
name = '101590299 - Bloco para Aguarela Van Gogh 10,5 x 15 200 gr 20 Fls'
WHERE
option_value_id = 2479
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 112
AND product_id = 27045
AND option_id = 15
AND option_value_id = 2479
DELETE FROM oc_product
WHERE
model = '101590299'
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 = 112
AND product_id = 27045
AND option_id = 15
AND option_value_id = 2479
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101590399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2480
UPDATE oc_option_value_description
SET
name = '101590399 - Bloco para Aguarela Van Gogh 24 x 32 200 gr 20 Fls'
WHERE
option_value_id = 2480
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 112
AND product_id = 27045
AND option_id = 15
AND option_value_id = 2480
DELETE FROM oc_product
WHERE
model = '101590399'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 4.472,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 112
AND product_id = 27045
AND option_id = 15
AND option_value_id = 2480
Ok.