Product Sync.
Opencart products: 108
Input products: 100
NEW: 101262599
NEW: 101262699
NEW: 101262799
NEW: 101262899
NEW: 101262999
NEW: 101263099
NEW: 101263199
NEW: 101263299
NEW: 101263399
NEW: 101263499
NEW: 101263599
NEW: 101263699
NEW: 101263799
NEW: 101263899
NEW: 101263999
NEW: 101264099
NEW: 101264199
NEW: 101264299
NEW: 101264399
NEW: 101264499
NEW: 101264599
NEW: 101264699
NEW: 101264799
NEW: 101264899
NEW: 101264999
NEW: 101265099
NEW: 101265199
NEW: 101265299
NEW: 101265399
NEW: 101265499
NEW: 101265599
NEW: 101265699
NEW: 101265799
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101265799 - %'
)
NEW: 101265899
NEW: 101265999
NEW: 101266099
NEW: 101266199
NEW: 101266299
NEW: 101266399
NEW: 101266499
NEW: 101266599
NEW: 101266699
NEW: 101266799
NEW: 101266899
NEW: 101266999
NEW: 101267099
NEW: 101267199
NEW: 101267299
NEW: 101267399
UPDATING: Tinta Acrílica Winsor & Newton 250 ml
Product ID: 27452
Image file:
NEW: Tinta Acrílica Winsor & Newton 500 ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Tinta Acrílica Winsor & Newton 500 ml - %'
)
NEW: 101268599
NEW: 101268699
NEW: Paleta de Madeira 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 de Madeira Oval - %'
)
NEW: 101268899
NEW: 101268999
NEW: 101269099
NEW: 101269199
NEW: 101269299
NEW: 101269399
NEW: 101269499
NEW: 101269599
NEW: 101269699
NEW: 101269799
NEW: 101269899
NEW: 101269999
NEW: 101270099
NEW: 101270199
NEW: 101270299
NEW: 101270399
NEW: 101270499
NEW: 101270599
NEW: 101270699
NEW: 101270799
NEW: 101270899
NEW: 101270999
NEW: 101271099
NEW: 101271199
NEW: 101271299
NEW: 101271399
NEW: 101271499
NEW: 101271599
NEW: 101271699
NEW: 101271799
NEW: 101271899
NEW: 101271999
NEW: 101272099
NEW: 101272199
NEW: 101272299
NEW: 101272399
NEW: 101272499
Ok.
Product Option Sync.
Opencart products: 111
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 '101267499 - %'
UPDATE oc_option_value
SET
image = 'catalog/101267499.jpg'
WHERE
option_value_id = 1562
UPDATE oc_option_value_description
SET
name = '101267499 - Acrílico Winsor & Newton Galeria 250 ml Verde Azeitona (447)'
WHERE
option_value_id = 1562
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 = 1562
DELETE FROM oc_product
WHERE
model = '101267499'
INSERT INTO oc_product_option_value
SET
product_option_id = 431,
product_id = 27452,
option_id = 17,
option_value_id = 1562,
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 '101267599 - %'
UPDATE oc_option_value
SET
image = 'catalog/101267599.jpg'
WHERE
option_value_id = 1559
UPDATE oc_option_value_description
SET
name = '101267599 - Acrílico Winsor & Newton Galeria 250 ml Vermelho Cádmio HUE (095)'
WHERE
option_value_id = 1559
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 = 1559
DELETE FROM oc_product
WHERE
model = '101267599'
INSERT INTO oc_product_option_value
SET
product_option_id = 431,
product_id = 27452,
option_id = 17,
option_value_id = 1559,
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 '101267699 - %'
UPDATE oc_option_value
SET
image = 'catalog/101267699.jpg'
WHERE
option_value_id = 1560
UPDATE oc_option_value_description
SET
name = '101267699 - Acrílico Winsor & Newton Galeria 250 ml Azul Winsor (706)'
WHERE
option_value_id = 1560
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 = 1560
DELETE FROM oc_product
WHERE
model = '101267699'
INSERT INTO oc_product_option_value
SET
product_option_id = 431,
product_id = 27452,
option_id = 17,
option_value_id = 1560,
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 '101267799 - %'
UPDATE oc_option_value
SET
image = 'catalog/101267799.jpg'
WHERE
option_value_id = 1561
UPDATE oc_option_value_description
SET
name = '101267799 - Acrílico Winsor & Newton Galeria 250 ml Amarelo Cádmio Escuro HUE (115)'
WHERE
option_value_id = 1561
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 = 1561
DELETE FROM oc_product
WHERE
model = '101267799'
INSERT INTO oc_product_option_value
SET
product_option_id = 431,
product_id = 27452,
option_id = 17,
option_value_id = 1561,
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 '101267899 - %'
UPDATE oc_option_value
SET
image = 'catalog/101267899.jpg'
WHERE
option_value_id = 1563
UPDATE oc_option_value_description
SET
name = '101267899 - Acrílico Winsor & Newton Galeria 250 ml Terra Sombra Natural (554)'
WHERE
option_value_id = 1563
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 = 1563
DELETE FROM oc_product
WHERE
model = '101267899'
INSERT INTO oc_product_option_value
SET
product_option_id = 431,
product_id = 27452,
option_id = 17,
option_value_id = 1563,
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 = 27507
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27507,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101267999 - %'
UPDATE oc_option_value
SET
image = 'catalog/101267999.jpg'
WHERE
option_value_id = 1494
UPDATE oc_option_value_description
SET
name = '101267999 - Acrílico Winsor & Newton Galeria 500 ml Branco Titânio (644)'
WHERE
option_value_id = 1494
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 468
AND product_id = 27507
AND option_id = 17
AND option_value_id = 1494
DELETE FROM oc_product
WHERE
model = '101267999'
INSERT INTO oc_product_option_value
SET
product_option_id = 468,
product_id = 27507,
option_id = 17,
option_value_id = 1494,
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 '101268099 - %'
UPDATE oc_option_value
SET
image = 'catalog/101268099.jpg'
WHERE
option_value_id = 1495
UPDATE oc_option_value_description
SET
name = '101268099 - Acrílico Winsor & Newton Galeria 500 ml Amarelo Cádmio Pálido HUE (114)'
WHERE
option_value_id = 1495
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 468
AND product_id = 27507
AND option_id = 17
AND option_value_id = 1495
DELETE FROM oc_product
WHERE
model = '101268099'
INSERT INTO oc_product_option_value
SET
product_option_id = 468,
product_id = 27507,
option_id = 17,
option_value_id = 1495,
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 '101268199 - %'
UPDATE oc_option_value
SET
image = 'catalog/101268199.jpg'
WHERE
option_value_id = 1496
UPDATE oc_option_value_description
SET
name = '101268199 - Acrílico Winsor & Newton Galeria 500 ml Preto Marfim (331)'
WHERE
option_value_id = 1496
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 468
AND product_id = 27507
AND option_id = 17
AND option_value_id = 1496
DELETE FROM oc_product
WHERE
model = '101268199'
INSERT INTO oc_product_option_value
SET
product_option_id = 468,
product_id = 27507,
option_id = 17,
option_value_id = 1496,
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 '101268299 - %'
UPDATE oc_option_value
SET
image = 'catalog/101268299.jpg'
WHERE
option_value_id = 1497
UPDATE oc_option_value_description
SET
name = '101268299 - Acrílico Winsor & Newton Galeria 500 ml Verde Sap (599)'
WHERE
option_value_id = 1497
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 468
AND product_id = 27507
AND option_id = 17
AND option_value_id = 1497
DELETE FROM oc_product
WHERE
model = '101268299'
INSERT INTO oc_product_option_value
SET
product_option_id = 468,
product_id = 27507,
option_id = 17,
option_value_id = 1497,
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 '101268399 - %'
UPDATE oc_option_value
SET
image = 'catalog/101268399.jpg'
WHERE
option_value_id = 1498
UPDATE oc_option_value_description
SET
name = '101268399 - Acrílico Winsor & Newton Galeria 500 ml Terra Sombra Natural (554)'
WHERE
option_value_id = 1498
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 468
AND product_id = 27507
AND option_id = 17
AND option_value_id = 1498
DELETE FROM oc_product
WHERE
model = '101268399'
INSERT INTO oc_product_option_value
SET
product_option_id = 468,
product_id = 27507,
option_id = 17,
option_value_id = 1498,
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 '101268499 - %'
UPDATE oc_option_value
SET
image = 'catalog/101268499.jpg'
WHERE
option_value_id = 1499
UPDATE oc_option_value_description
SET
name = '101268499 - Acrílico Winsor & Newton Galeria 500 ml Vermelho Cádmio Hue (095)'
WHERE
option_value_id = 1499
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 468
AND product_id = 27507
AND option_id = 17
AND option_value_id = 1499
DELETE FROM oc_product
WHERE
model = '101268499'
INSERT INTO oc_product_option_value
SET
product_option_id = 468,
product_id = 27507,
option_id = 17,
option_value_id = 1499,
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
INSERT INTO oc_product_option
SET
product_id = 27508,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101268799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3530 AS option_value_id,
language_id,
17 AS option_id,
'101268799 - Paleta de Madeira Oval 30 x 20 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 = 3530
DELETE FROM oc_product
WHERE
model = '101268799'
INSERT INTO oc_product_option_value
SET
product_option_id = 469,
product_id = 27508,
option_id = 17,
option_value_id = 3530,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.