Product Sync.
Opencart products: 21
Input products: 100
NEW: 100090999
NEW: 100091099
NEW: 100091199
NEW: 100091299
NEW: 100091399
NEW: 100091499
NEW: 100091599
NEW: 100091699
NEW: 100091799
NEW: 100091899
NEW: 100091999
NEW: 100092099
NEW: 100092199
NEW: 100092299
NEW: 100092399
NEW: 100092499
NEW: 100092599
NEW: 100092699
NEW: 100092799
NEW: 100092899
NEW: 100092999
NEW: 100093099
NEW: 100093199
NEW: 100093299
NEW: 100093399
NEW: 100093499
NEW: 100093599
NEW: Tinta Acrílica Talens Amsterdam 120ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Tinta Acrílica Talens Amsterdam 120ml - %'
)
NEW: 100094099
NEW: 100094199
NEW: 100094299
NEW: 100094399
NEW: 100094499
NEW: 100094599
NEW: 100094699
NEW: 100094799
NEW: 100094899
NEW: 100094999
NEW: 100095099
NEW: 100095199
NEW: 100095299
NEW: 100095399
NEW: 100095499
NEW: 100095599
NEW: 100095699
NEW: 100095799
NEW: 100095899
NEW: 100095999
NEW: 100096099
NEW: 100096199
NEW: 100096299
NEW: 100096399
NEW: 100096499
NEW: 100096599
NEW: 100096699
NEW: 100096799
NEW: 100096899
NEW: 100096999
NEW: 100097099
NEW: 100097199
NEW: 100097299
NEW: 100097399
NEW: 100097499
NEW: 100097599
NEW: 100097699
NEW: 100097799
NEW: 100097899
NEW: 100097999
NEW: 100098099
NEW: 100098199
NEW: 100098299
NEW: 100098399
NEW: 100098499
NEW: 100098599
NEW: 100098699
NEW: 100098799
NEW: 100098899
NEW: 100098999
NEW: 100099099
NEW: 100099199
NEW: 100099299
NEW: 100099399
NEW: 100099499
NEW: 100099599
NEW: 100099699
NEW: 100099799
NEW: 100099899
NEW: 100099999
NEW: 100100099
NEW: 100100199
NEW: 100100299
NEW: 100100399
NEW: 100100499
NEW: 100100599
NEW: 100100699
NEW: 100100799
NEW: 100100899
Ok.
Product Option Sync.
Opencart products: 22
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 = 27419
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27419,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100093699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1583
UPDATE oc_option_value_description
SET
name = '100093699 - Acrílico Amsterdam 120 ml Laranja Fluorescente 257'
WHERE
option_value_id = 1583
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 406
AND product_id = 27419
AND option_id = 17
AND option_value_id = 1583
DELETE FROM oc_product
WHERE
model = '100093699'
INSERT INTO oc_product_option_value
SET
product_option_id = 406,
product_id = 27419,
option_id = 17,
option_value_id = 1583,
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 '100093799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1584
UPDATE oc_option_value_description
SET
name = '100093799 - Acrílico Amsterdam 120 ml Amarelo Fluorescente 256'
WHERE
option_value_id = 1584
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 406
AND product_id = 27419
AND option_id = 17
AND option_value_id = 1584
DELETE FROM oc_product
WHERE
model = '100093799'
INSERT INTO oc_product_option_value
SET
product_option_id = 406,
product_id = 27419,
option_id = 17,
option_value_id = 1584,
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 '100093899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1585
UPDATE oc_option_value_description
SET
name = '100093899 - Acrílico Amsterdam 120 ml Rosa Fluorescente 384'
WHERE
option_value_id = 1585
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 406
AND product_id = 27419
AND option_id = 17
AND option_value_id = 1585
DELETE FROM oc_product
WHERE
model = '100093899'
INSERT INTO oc_product_option_value
SET
product_option_id = 406,
product_id = 27419,
option_id = 17,
option_value_id = 1585,
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 '100093999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1586
UPDATE oc_option_value_description
SET
name = '100093999 - Acrílico Amsterdam 120 ml Verde Fluorescente 672'
WHERE
option_value_id = 1586
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 406
AND product_id = 27419
AND option_id = 17
AND option_value_id = 1586
DELETE FROM oc_product
WHERE
model = '100093999'
INSERT INTO oc_product_option_value
SET
product_option_id = 406,
product_id = 27419,
option_id = 17,
option_value_id = 1586,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.