Product Sync.
Opencart products: 108
Input products: 100
NEW: 101242399
NEW: 101242499
NEW: 101242599
NEW: 101242699
NEW: 101242799
NEW: 101242899
NEW: 101242999
NEW: 101243099
NEW: 101243199
NEW: 101243299
NEW: 101243399
NEW: 101243499
NEW: 101243599
NEW: 101243699
NEW: 101243799
NEW: 101243899
NEW: 101243999
NEW: 101244099
UPDATING: Tinta Acrílica Winsor & Newton 250 ml
Product ID: 27452
Image file:
NEW: 101244499
NEW: 101244599
NEW: 101244699
NEW: 101244799
NEW: 101244899
NEW: 101244999
NEW: 101245099
NEW: 101245199
NEW: 101245299
NEW: 101245399
NEW: 101245499
NEW: 101245599
NEW: 101245699
NEW: 101245799
NEW: 101245899
NEW: 101245999
NEW: 101246099
NEW: 101246199
NEW: 101246299
NEW: 101246399
NEW: 101246499
NEW: 101246599
NEW: 101246699
NEW: 101246799
NEW: 101246899
NEW: 101246999
NEW: 101247099
NEW: 101247199
NEW: 101247299
NEW: 101247399
NEW: 101247499
NEW: 101247599
NEW: 101247699
NEW: 101247799
NEW: 101247899
NEW: 101247999
NEW: 101248099
NEW: 101248199
NEW: 101248299
NEW: 101248399
NEW: 101248499
NEW: 101248599
NEW: 101248699
NEW: 101248799
NEW: 101248899
NEW: 101248999
NEW: 101249099
NEW: 101249199
NEW: 101249299
NEW: 101249399
NEW: 101249499
NEW: 101249599
NEW: 101249699
NEW: 101249799
NEW: 101249899
NEW: 101249999
NEW: 101250099
NEW: 101250199
NEW: 101250299
NEW: 101250399
NEW: 101250499
NEW: 101250599
NEW: 101250699
NEW: 101250799
NEW: 101250899
NEW: 101250999
NEW: 101251099
NEW: 101251199
NEW: 101251299
NEW: 101251399
UPDATING: Tinta para Porcelana Pébéo Porcelaine
Product ID: 27447
Image file:
NEW: 101251599
NEW: 101251699
NEW: 101251799
NEW: 101251899
NEW: 101251999
NEW: 101252099
NEW: 101252199
NEW: 101252299
Ok.
Product Option Sync.
Opencart products: 108
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 = 27452
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101244199 - %'
UPDATE oc_option_value
SET
image = 'catalog/101244199.jpg'
WHERE
option_value_id = 1511
UPDATE oc_option_value_description
SET
name = '101244199 - Acrílico Winsor & Newton Galeria 250 ml Rosa Permanente (502)'
WHERE
option_value_id = 1511
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 431
AND product_id = 27452
AND option_id = 17
AND option_value_id = 1511
DELETE FROM oc_product
WHERE
model = '101244199'
INSERT INTO oc_product_option_value
SET
product_option_id = 431,
product_id = 27452,
option_id = 17,
option_value_id = 1511,
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 '101244299 - %'
UPDATE oc_option_value
SET
image = 'catalog/101244299.jpg'
WHERE
option_value_id = 1512
UPDATE oc_option_value_description
SET
name = '101244299 - Acrílico Winsor & Newton Galeria 250 ml Castanho Van Dyck'
WHERE
option_value_id = 1512
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 431
AND product_id = 27452
AND option_id = 17
AND option_value_id = 1512
DELETE FROM oc_product
WHERE
model = '101244299'
INSERT INTO oc_product_option_value
SET
product_option_id = 431,
product_id = 27452,
option_id = 17,
option_value_id = 1512,
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 '101244399 - %'
UPDATE oc_option_value
SET
image = 'catalog/101244399.jpg'
WHERE
option_value_id = 1513
UPDATE oc_option_value_description
SET
name = '101244399 - Acrílico Winsor & Newton Galeria 250 ml Vermelhão (682)'
WHERE
option_value_id = 1513
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 431
AND product_id = 27452
AND option_id = 17
AND option_value_id = 1513
DELETE FROM oc_product
WHERE
model = '101244399'
INSERT INTO oc_product_option_value
SET
product_option_id = 431,
product_id = 27452,
option_id = 17,
option_value_id = 1513,
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 = 27447
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101251499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3529 AS option_value_id,
language_id,
17 AS option_id,
'101251499 - Tinta Pébéo Porcelaine 150 Ardosia Preto 45 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 426
AND product_id = 27447
AND option_id = 17
AND option_value_id = 3529
DELETE FROM oc_product
WHERE
model = '101251499'
INSERT INTO oc_product_option_value
SET
product_option_id = 426,
product_id = 27447,
option_id = 17,
option_value_id = 3529,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.