Product Sync.
Opencart products: 258
Input products: 100
UPDATING: Tinta Óleo Talens Van Gogh 20 ml
Product ID: 27655
Image file:
NEW: 455053399
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '455053399 - %'
)
NEW: 455053999
NEW: 455054399
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '455054399 - %'
)
NEW: 455054699
NEW: 455108599
NEW: 455108699
NEW: 455108799
NEW: 455109399
NEW: 455109499
NEW: 455109699
NEW: 455109799
NEW: 455109899
NEW: 455150699
NEW: 455151099
NEW: 455151399
NEW: 455152699
NEW: 455153099
NEW: 455154099
NEW: 455154499
NEW: 455154599
NEW: 455154799
NEW: 455154899
NEW: 455162599
NEW: 455162699
NEW: 455162799
NEW: 455162899
NEW: 455162999
NEW: 455163099
NEW: 455163199
NEW: 455163299
NEW: 455163499
NEW: 455165099
NEW: 455165199
NEW: 455165299
NEW: 456029899
NEW: 456030099
NEW: 456031699
NEW: 456033699
NEW: 456038299
NEW: 456038499
NEW: 456038699
NEW: 456038799
NEW: 456038899
NEW: 456038999
NEW: 456039099
NEW: 456039199
NEW: 456039899
NEW: 456040899
NEW: 456090199
NEW: 456091599
NEW: 456091899
NEW: 456091999
NEW: 456092099
NEW: 456092199
NEW: 456100699
NEW: 456100999
NEW: 456102498
NEW: 456102499
NEW: 456103599
NEW: 456105199
NEW: 456107099
NEW: 456107399
NEW: 456107499
NEW: 456107599
NEW: 456107999
NEW: 456108399
NEW: 456108499
NEW: 456108599
NEW: 456108699
NEW: 456108799
NEW: 456108899
NEW: 456108999
NEW: 456109099
NEW: 456109199
NEW: 456113398
NEW: 456114598
NEW: 456115798
NEW: 456116198
NEW: 456116598
NEW: 456116798
NEW: 456116898
NEW: 456117098
NEW: 456117298
NEW: 456117398
NEW: 456117498
NEW: 456117821
NEW: 456118121
NEW: 456126521
NEW: 456127521
NEW: 456127821
NEW: 456128999
Ok.
Product Option Sync.
Opencart products: 260
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 = 27655
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '455051499 - %'
UPDATE oc_option_value
SET
image = 'catalog/455051499.jpg'
WHERE
option_value_id = 2118
UPDATE oc_option_value_description
SET
name = '455051499 - Óleo Talens Van Gogh T7 - 20 ml S1 Branco Titânio (Óleo Linhaça)'
WHERE
option_value_id = 2118
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 529
AND product_id = 27655
AND option_id = 17
AND option_value_id = 2118
DELETE FROM oc_product
WHERE
model = '455051499'
INSERT INTO oc_product_option_value
SET
product_option_id = 529,
product_id = 27655,
option_id = 17,
option_value_id = 2118,
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 '455051599 - %'
UPDATE oc_option_value
SET
image = 'catalog/455051599.jpg'
WHERE
option_value_id = 2119
UPDATE oc_option_value_description
SET
name = '455051599 - Óleo Talens Van Gogh T7 - 20 ml S1 Rosa Quinacridona'
WHERE
option_value_id = 2119
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 529
AND product_id = 27655
AND option_id = 17
AND option_value_id = 2119
DELETE FROM oc_product
WHERE
model = '455051599'
INSERT INTO oc_product_option_value
SET
product_option_id = 529,
product_id = 27655,
option_id = 17,
option_value_id = 2119,
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 '455051699 - %'
UPDATE oc_option_value
SET
image = 'catalog/455051699.jpg'
WHERE
option_value_id = 2120
UPDATE oc_option_value_description
SET
name = '455051699 - Óleo Talens Van Gogh T7 - 20 ml S1 Violeta'
WHERE
option_value_id = 2120
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 529
AND product_id = 27655
AND option_id = 17
AND option_value_id = 2120
DELETE FROM oc_product
WHERE
model = '455051699'
INSERT INTO oc_product_option_value
SET
product_option_id = 529,
product_id = 27655,
option_id = 17,
option_value_id = 2120,
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 '455051799 - %'
UPDATE oc_option_value
SET
image = 'catalog/455051799.jpg'
WHERE
option_value_id = 2121
UPDATE oc_option_value_description
SET
name = '455051799 - Óleo Talens Van Gogh T7 - 20 ml S1 Verde Permanente Médio'
WHERE
option_value_id = 2121
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 529
AND product_id = 27655
AND option_id = 17
AND option_value_id = 2121
DELETE FROM oc_product
WHERE
model = '455051799'
INSERT INTO oc_product_option_value
SET
product_option_id = 529,
product_id = 27655,
option_id = 17,
option_value_id = 2121,
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 '455052099 - %'
UPDATE oc_option_value
SET
image = 'catalog/455052099.jpg'
WHERE
option_value_id = 2122
UPDATE oc_option_value_description
SET
name = '455052099 - Óleo Talens Van Gogh T7 - 20 ml S2 Amarelo Cádmio Claro'
WHERE
option_value_id = 2122
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 529
AND product_id = 27655
AND option_id = 17
AND option_value_id = 2122
DELETE FROM oc_product
WHERE
model = '455052099'
INSERT INTO oc_product_option_value
SET
product_option_id = 529,
product_id = 27655,
option_id = 17,
option_value_id = 2122,
quantity = 1,
subtract = 1,
price = 2.277,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '455052399 - %'
UPDATE oc_option_value
SET
image = 'catalog/455052399.jpg'
WHERE
option_value_id = 2123
UPDATE oc_option_value_description
SET
name = '455052399 - Óleo Talens Van Gogh T7 - 20 ml S2 Amarelo Cádmino Médio'
WHERE
option_value_id = 2123
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 529
AND product_id = 27655
AND option_id = 17
AND option_value_id = 2123
DELETE FROM oc_product
WHERE
model = '455052399'
INSERT INTO oc_product_option_value
SET
product_option_id = 529,
product_id = 27655,
option_id = 17,
option_value_id = 2123,
quantity = 1,
subtract = 1,
price = 2.277,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '455052699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2124
UPDATE oc_option_value_description
SET
name = '455052699 - Óleo Talens Van Gogh T7 - 20 ml S2 Vermelho Cádmio Médio'
WHERE
option_value_id = 2124
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 529
AND product_id = 27655
AND option_id = 17
AND option_value_id = 2124
DELETE FROM oc_product
WHERE
model = '455052699'
INSERT INTO oc_product_option_value
SET
product_option_id = 529,
product_id = 27655,
option_id = 17,
option_value_id = 2124,
quantity = 1,
subtract = 1,
price = 2.277,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '455052799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2125
UPDATE oc_option_value_description
SET
name = '455052799 - Óleo Talens Van Gogh T7 - 20 ml S2 Vermelho Permanente'
WHERE
option_value_id = 2125
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 529
AND product_id = 27655
AND option_id = 17
AND option_value_id = 2125
DELETE FROM oc_product
WHERE
model = '455052799'
INSERT INTO oc_product_option_value
SET
product_option_id = 529,
product_id = 27655,
option_id = 17,
option_value_id = 2125,
quantity = 1,
subtract = 1,
price = 2.277,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '455052899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2126
UPDATE oc_option_value_description
SET
name = '455052899 - Óleo Talens Van Gogh T7 - 20 ml S2 Azul Cobalto'
WHERE
option_value_id = 2126
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 529
AND product_id = 27655
AND option_id = 17
AND option_value_id = 2126
DELETE FROM oc_product
WHERE
model = '455052899'
INSERT INTO oc_product_option_value
SET
product_option_id = 529,
product_id = 27655,
option_id = 17,
option_value_id = 2126,
quantity = 1,
subtract = 1,
price = 2.277,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.