Product Sync.
Opencart products: 140
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
UPDATING: Tinta Acrílica Talens Amsterdam 120ml
Product ID: 26999
Image file:
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: 140
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 = 26999
AND option_id = 15
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 = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1583
DELETE FROM oc_product
WHERE
model = '100093699'
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 = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1583
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 = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1584
DELETE FROM oc_product
WHERE
model = '100093799'
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 = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1584
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 = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1585
DELETE FROM oc_product
WHERE
model = '100093899'
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 = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1585
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 = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1586
DELETE FROM oc_product
WHERE
model = '100093999'
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 = 70
AND product_id = 26999
AND option_id = 15
AND option_value_id = 1586
Ok.