Product Sync.
Opencart products: 315
Input products: 100
UPDATING: Tinta Óleo Talens Rembrandt 15 ml
Product ID: 27057
Image file:
UPDATING: Paleta de Madeira Oval
Product ID: 27187
Image file:
NEW: Paleta Acrílica Oval
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Paleta Acrílica Oval - %'
)
NEW: 264360699
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '264360699 - %'
)
NEW: 264360799
NEW: 264360999
NEW: 266127500
NEW: 266135600
NEW: 266135700
NEW: 266160699
NEW: 266210802
NEW: 266817300
NEW: 266841013
NEW: 266845500
NEW: 267030700
NEW: 267030800
NEW: 267030900
NEW: 267031000
NEW: 267031100
NEW: 267031200
NEW: 267038100
NEW: 267038200
NEW: 267070100
NEW: 267070300
NEW: 267081200
NEW: 267207200
NEW: 267207300
NEW: 267230200
NEW: 267234000
NEW: 267245076
NEW: 267250076
NEW: 267250176
NEW: 267250276
NEW: 267250476
NEW: 267250576
NEW: 267250776
NEW: 267251376
NEW: 267251476
NEW: 267251576
NEW: 267254076
NEW: 267254176
NEW: 267254276
NEW: 267254376
NEW: 267254476
NEW: 267254576
NEW: 267254776
NEW: 267254876
NEW: 267254976
NEW: 267255076
NEW: 267256200
NEW: 267261100
NEW: 267261200
NEW: 267261400
NEW: 267421076
NEW: 267421176
NEW: 267421276
NEW: 267421376
NEW: 267421476
NEW: 267421576
NEW: 267437076
NEW: 267437276
NEW: 267449776
NEW: 267509698
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '267509698 - %'
)
NEW: 267621400
NEW: 267622300
NEW: 267622400
NEW: 267623200
NEW: 268229498
NEW: 268229698
NEW: 268801567
NEW: 268801667
NEW: 268801767
NEW: 268801867
NEW: 268801967
NEW: 268802067
NEW: 268802167
NEW: 268802267
NEW: 268802367
NEW: 268802467
NEW: 268802567
NEW: 268802667
UPDATING: Pincel Pelikan 25A
Product ID: 27148
Image file:
NEW: 268811599
UPDATING: Pincel Derwent com Reservatório de Água
Product ID: 27184
Image file:
NEW: 268812898
NEW: 268820498
NEW: 268820698
NEW: 268820898
NEW: 268821098
NEW: 268821298
NEW: 268823999
NEW: 268826299
NEW: 268832298
NEW: 268836898
UPDATING: Pincel Talens Redondo para Óleo/Acrílico S295
Product ID: 27137
Image file:
Ok.
Product Option Sync.
Opencart products: 318
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 = 27057
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '263316098 - %'
UPDATE oc_option_value
SET
image = 'catalog/263316098.jpg'
WHERE
option_value_id = 1935
UPDATE oc_option_value_description
SET
name = '263316098 - Tinta Óleo Talens Rembrandt T6 - 15 ml S3 STIL GRAIN AMARELO'
WHERE
option_value_id = 1935
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 122
AND product_id = 27057
AND option_id = 15
AND option_value_id = 1935
DELETE FROM oc_product
WHERE
model = '263316098'
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 = 122
AND product_id = 27057
AND option_id = 15
AND option_value_id = 1935
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27187
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '264330419 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2737
UPDATE oc_option_value_description
SET
name = '264330419 - Paleta de Madeira Oval 24 x 18 cm'
WHERE
option_value_id = 2737
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 314
AND product_id = 27187
AND option_id = 15
AND option_value_id = 2737
DELETE FROM oc_product
WHERE
model = '264330419'
INSERT INTO oc_product_option_value
SET
product_option_id = 314,
product_id = 27187,
option_id = 15,
option_value_id = 2737,
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 = 27304
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27304,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '264360199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2738
UPDATE oc_option_value_description
SET
name = '264360199 - Paleta Acrílica Oval 21 x 30 cm'
WHERE
option_value_id = 2738
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 351
AND product_id = 27304
AND option_id = 15
AND option_value_id = 2738
DELETE FROM oc_product
WHERE
model = '264360199'
INSERT INTO oc_product_option_value
SET
product_option_id = 351,
product_id = 27304,
option_id = 15,
option_value_id = 2738,
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 '264360399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2739
UPDATE oc_option_value_description
SET
name = '264360399 - Paleta Acrílica Oval 30 x 40 cm'
WHERE
option_value_id = 2739
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 351
AND product_id = 27304
AND option_id = 15
AND option_value_id = 2739
DELETE FROM oc_product
WHERE
model = '264360399'
INSERT INTO oc_product_option_value
SET
product_option_id = 351,
product_id = 27304,
option_id = 15,
option_value_id = 2739,
quantity = 1,
subtract = 1,
price = 6.586,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27148
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '268805528 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2742
UPDATE oc_option_value_description
SET
name = '268805528 - Pincel Pelikan 25A N5'
WHERE
option_value_id = 2742
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 295
AND product_id = 27148
AND option_id = 15
AND option_value_id = 2742
DELETE FROM oc_product
WHERE
model = '268805528'
INSERT INTO oc_product_option_value
SET
product_option_id = 295,
product_id = 27148,
option_id = 15,
option_value_id = 2742,
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 '268805928 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2743
UPDATE oc_option_value_description
SET
name = '268805928 - Pincel Pelikan 25A N9'
WHERE
option_value_id = 2743
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 295
AND product_id = 27148
AND option_id = 15
AND option_value_id = 2743
DELETE FROM oc_product
WHERE
model = '268805928'
INSERT INTO oc_product_option_value
SET
product_option_id = 295,
product_id = 27148,
option_id = 15,
option_value_id = 2743,
quantity = 1,
subtract = 1,
price = 0.163,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '268806028 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2744
UPDATE oc_option_value_description
SET
name = '268806028 - Pincel Pelikan 25A N10'
WHERE
option_value_id = 2744
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 295
AND product_id = 27148
AND option_id = 15
AND option_value_id = 2744
DELETE FROM oc_product
WHERE
model = '268806028'
INSERT INTO oc_product_option_value
SET
product_option_id = 295,
product_id = 27148,
option_id = 15,
option_value_id = 2744,
quantity = 1,
subtract = 1,
price = 0.325,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '268806228 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2745
UPDATE oc_option_value_description
SET
name = '268806228 - Pincel Pelikan 25A N12'
WHERE
option_value_id = 2745
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 295
AND product_id = 27148
AND option_id = 15
AND option_value_id = 2745
DELETE FROM oc_product
WHERE
model = '268806228'
INSERT INTO oc_product_option_value
SET
product_option_id = 295,
product_id = 27148,
option_id = 15,
option_value_id = 2745,
quantity = 1,
subtract = 1,
price = 0.569,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27184
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '268812198 - %'
UPDATE oc_option_value
SET
image = 'catalog/268812198.jpg'
WHERE
option_value_id = 2746
UPDATE oc_option_value_description
SET
name = '268812198 - Pincel Derwent com Reservatório de Água Pequeno'
WHERE
option_value_id = 2746
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 313
AND product_id = 27184
AND option_id = 15
AND option_value_id = 2746
DELETE FROM oc_product
WHERE
model = '268812198'
INSERT INTO oc_product_option_value
SET
product_option_id = 313,
product_id = 27184,
option_id = 15,
option_value_id = 2746,
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 = 27137
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '268849498 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2747
UPDATE oc_option_value_description
SET
name = '268849498 - Pincel Talens Redondo para Óleo/Acrílico S295 N14'
WHERE
option_value_id = 2747
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 286
AND product_id = 27137
AND option_id = 15
AND option_value_id = 2747
DELETE FROM oc_product
WHERE
model = '268849498'
INSERT INTO oc_product_option_value
SET
product_option_id = 286,
product_id = 27137,
option_id = 15,
option_value_id = 2747,
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 '268850098 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2748
UPDATE oc_option_value_description
SET
name = '268850098 - Pincel Talens Redondo para Óleo/Acrílico S295 N20'
WHERE
option_value_id = 2748
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 286
AND product_id = 27137
AND option_id = 15
AND option_value_id = 2748
DELETE FROM oc_product
WHERE
model = '268850098'
INSERT INTO oc_product_option_value
SET
product_option_id = 286,
product_id = 27137,
option_id = 15,
option_value_id = 2748,
quantity = 1,
subtract = 1,
price = 2.317,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.