Product Sync.
Opencart products: 228
Input products: 100
UPDATING: Tinta Óleo Talens Rembrandt 15 ml
Product ID: 27493
Image file:
UPDATING: Paleta de Madeira Oval
Product ID: 27508
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: 27454
Image file:
NEW: 268811599
UPDATING: Pincel Derwent com Reservatório de Água
Product ID: 27504
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: 27430
Image file:
Ok.
Product Option Sync.
Opencart products: 231
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 = 27493
AND option_id = 17
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 = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 1935
DELETE FROM oc_product
WHERE
model = '263316098'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 1935,
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 = 27508
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '264330419 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3761 AS option_value_id,
language_id,
17 AS option_id,
'264330419 - Paleta de Madeira Oval 24 x 18 cm' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 469
AND product_id = 27508
AND option_id = 17
AND option_value_id = 3761
DELETE FROM oc_product
WHERE
model = '264330419'
INSERT INTO oc_product_option_value
SET
product_option_id = 469,
product_id = 27508,
option_id = 17,
option_value_id = 3761,
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 = 27626
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27626,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '264360199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3762 AS option_value_id,
language_id,
17 AS option_id,
'264360199 - Paleta Acrílica Oval 21 x 30 cm' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 514
AND product_id = 27626
AND option_id = 17
AND option_value_id = 3762
DELETE FROM oc_product
WHERE
model = '264360199'
INSERT INTO oc_product_option_value
SET
product_option_id = 514,
product_id = 27626,
option_id = 17,
option_value_id = 3762,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3763 AS option_value_id,
language_id,
17 AS option_id,
'264360399 - Paleta Acrílica Oval 30 x 40 cm' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 514
AND product_id = 27626
AND option_id = 17
AND option_value_id = 3763
DELETE FROM oc_product
WHERE
model = '264360399'
INSERT INTO oc_product_option_value
SET
product_option_id = 514,
product_id = 27626,
option_id = 17,
option_value_id = 3763,
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 = 27454
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '268805528 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3764 AS option_value_id,
language_id,
17 AS option_id,
'268805528 - Pincel Pelikan 25A N5' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 433
AND product_id = 27454
AND option_id = 17
AND option_value_id = 3764
DELETE FROM oc_product
WHERE
model = '268805528'
INSERT INTO oc_product_option_value
SET
product_option_id = 433,
product_id = 27454,
option_id = 17,
option_value_id = 3764,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3765 AS option_value_id,
language_id,
17 AS option_id,
'268805928 - Pincel Pelikan 25A N9' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 433
AND product_id = 27454
AND option_id = 17
AND option_value_id = 3765
DELETE FROM oc_product
WHERE
model = '268805928'
INSERT INTO oc_product_option_value
SET
product_option_id = 433,
product_id = 27454,
option_id = 17,
option_value_id = 3765,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3766 AS option_value_id,
language_id,
17 AS option_id,
'268806028 - Pincel Pelikan 25A N10' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 433
AND product_id = 27454
AND option_id = 17
AND option_value_id = 3766
DELETE FROM oc_product
WHERE
model = '268806028'
INSERT INTO oc_product_option_value
SET
product_option_id = 433,
product_id = 27454,
option_id = 17,
option_value_id = 3766,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3767 AS option_value_id,
language_id,
17 AS option_id,
'268806228 - Pincel Pelikan 25A N12' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 433
AND product_id = 27454
AND option_id = 17
AND option_value_id = 3767
DELETE FROM oc_product
WHERE
model = '268806228'
INSERT INTO oc_product_option_value
SET
product_option_id = 433,
product_id = 27454,
option_id = 17,
option_value_id = 3767,
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 = 27504
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '268812198 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/268812198.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3768 AS option_value_id,
language_id,
17 AS option_id,
'268812198 - Pincel Derwent com Reservatório de Água Pequeno' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 467
AND product_id = 27504
AND option_id = 17
AND option_value_id = 3768
DELETE FROM oc_product
WHERE
model = '268812198'
INSERT INTO oc_product_option_value
SET
product_option_id = 467,
product_id = 27504,
option_id = 17,
option_value_id = 3768,
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 = 27430
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '268849498 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3769 AS option_value_id,
language_id,
17 AS option_id,
'268849498 - Pincel Talens Redondo para Óleo/Acrílico S295 N14' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 411
AND product_id = 27430
AND option_id = 17
AND option_value_id = 3769
DELETE FROM oc_product
WHERE
model = '268849498'
INSERT INTO oc_product_option_value
SET
product_option_id = 411,
product_id = 27430,
option_id = 17,
option_value_id = 3769,
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 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3770 AS option_value_id,
language_id,
17 AS option_id,
'268850098 - Pincel Talens Redondo para Óleo/Acrílico S295 N20' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 411
AND product_id = 27430
AND option_id = 17
AND option_value_id = 3770
DELETE FROM oc_product
WHERE
model = '268850098'
INSERT INTO oc_product_option_value
SET
product_option_id = 411,
product_id = 27430,
option_id = 17,
option_value_id = 3770,
quantity = 1,
subtract = 1,
price = 2.317,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.