Product Sync.
Opencart products: 220
Input products: 100
NEW: 204508928
NEW: 204509428
NEW: 204509628
NEW: 204509728
NEW: 204511528
NEW: 204511628
NEW: 204511728
NEW: 206670421
NEW: 207201598
NEW: 208108499
NEW: 208703867
NEW: 208705467
NEW: 210550099
NEW: 210550299
NEW: 210550499
NEW: 210550699
NEW: 210550899
NEW: 210551099
NEW: 210562299
NEW: 210563499
NEW: 210563699
NEW: 211506100
NEW: 211506200
NEW: 211506300
NEW: 211506400
NEW: 211506500
NEW: 211506700
NEW: 211507200
NEW: 211507300
NEW: 211507400
NEW: 211510800
NEW: 211510900
NEW: 211511000
NEW: 211511500
NEW: 211511600
NEW: 211517600
NEW: 211549500
NEW: 211576100
NEW: 211690351
NEW: 211690451
NEW: 211690551
NEW: 211690651
NEW: 211690751
NEW: 211690951
NEW: 211691051
NEW: 211691151
NEW: 211691651
NEW: 211692051
NEW: 211694751
NEW: 211695528
NEW: 211810076
NEW: 211810176
NEW: 211810276
NEW: 211810376
NEW: 211810476
NEW: 211810576
NEW: 211810676
NEW: 211810776
NEW: 211810876
NEW: 211810976
NEW: 211811076
NEW: 211823776
NEW: 211823976
NEW: 211824176
NEW: 211824751
NEW: 211853599
NEW: 212112567
NEW: 212120628
NEW: 212121571
NEW: 212121671
NEW: 212137028
NEW: 212137228
NEW: 212137328
NEW: 212137428
NEW: 212180440
NEW: 215267200
NEW: 215267500
NEW: 215274100
NEW: 215274200
NEW: 215277900
NEW: 215278000
NEW: 215278100
NEW: 215278200
NEW: 215278300
NEW: 215288600
NEW: 217097299
NEW: 217600667
NEW: 217603221
NEW: 218106199
NEW: 218761876
NEW: 219120599
NEW: 219120699
NEW: 219402461
NEW: 219519019
NEW: 219530699
NEW: Cavalete de Mesa Talens Caixa Callisto
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete de Mesa Talens Caixa Callisto - %'
)
NEW: Cavalete Art Creation Estudio Vesta
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Art Creation Estudio Vesta - %'
)
NEW: Cavalete Talens Tripé Corona Kit
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Talens Tripé Corona Kit - %'
)
NEW: Cavalete Talens Tripé Isabel Kit
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete Talens Tripé Isabel Kit - %'
)
NEW: Cavalete de Mesa Talens Ibiza Natural
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cavalete de Mesa Talens Ibiza Natural - %'
)
Ok.
Product Option Sync.
Opencart products: 225
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 = 27618
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27618,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '219560299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1256
UPDATE oc_option_value_description
SET
name = '219560299 - Cavalete de Mesa Talens Caixa Callisto'
WHERE
option_value_id = 1256
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 507
AND product_id = 27618
AND option_id = 17
AND option_value_id = 1256
DELETE FROM oc_product
WHERE
model = '219560299'
INSERT INTO oc_product_option_value
SET
product_option_id = 507,
product_id = 27618,
option_id = 17,
option_value_id = 1256,
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 = 27619
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27619,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '219560399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1257
UPDATE oc_option_value_description
SET
name = '219560399 - Cavalete Art Creation Estudio Vesta'
WHERE
option_value_id = 1257
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 508
AND product_id = 27619
AND option_id = 17
AND option_value_id = 1257
DELETE FROM oc_product
WHERE
model = '219560399'
INSERT INTO oc_product_option_value
SET
product_option_id = 508,
product_id = 27619,
option_id = 17,
option_value_id = 1257,
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 = 27620
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27620,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '219560599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1258
UPDATE oc_option_value_description
SET
name = '219560599 - Cavalete Talens Tripé Corona Kit'
WHERE
option_value_id = 1258
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 509
AND product_id = 27620
AND option_id = 17
AND option_value_id = 1258
DELETE FROM oc_product
WHERE
model = '219560599'
INSERT INTO oc_product_option_value
SET
product_option_id = 509,
product_id = 27620,
option_id = 17,
option_value_id = 1258,
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 = 27621
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27621,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '219560699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1259
UPDATE oc_option_value_description
SET
name = '219560699 - Cavalete Talens Tripé Isabel Kit'
WHERE
option_value_id = 1259
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 510
AND product_id = 27621
AND option_id = 17
AND option_value_id = 1259
DELETE FROM oc_product
WHERE
model = '219560699'
INSERT INTO oc_product_option_value
SET
product_option_id = 510,
product_id = 27621,
option_id = 17,
option_value_id = 1259,
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 = 27622
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27622,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '219560799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1260
UPDATE oc_option_value_description
SET
name = '219560799 - Cavalete de Mesa Talens Ibiza Natural'
WHERE
option_value_id = 1260
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 511
AND product_id = 27622
AND option_id = 17
AND option_value_id = 1260
DELETE FROM oc_product
WHERE
model = '219560799'
INSERT INTO oc_product_option_value
SET
product_option_id = 511,
product_id = 27622,
option_id = 17,
option_value_id = 1260,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.