Product Sync.
Opencart products: 260
Input products: 100
NEW: 475376499
NEW: 475376599
NEW: 475376699
NEW: 475376799
NEW: 475376899
NEW: 475376999
NEW: 475377099
NEW: 475377199
NEW: 475377299
NEW: 475377399
NEW: 475377499
NEW: 475377599
NEW: 475377699
NEW: 475377799
NEW: 475377899
NEW: 475377999
NEW: 475378099
NEW: 475378199
NEW: 475378299
NEW: 475378399
NEW: 475378499
NEW: 475378599
NEW: 475378699
NEW: 475378799
NEW: 475378899
NEW: 475378999
NEW: 475379099
NEW: 475379199
NEW: 475379299
NEW: 475379399
NEW: 475379499
NEW: 475379599
NEW: 475379699
NEW: 475379799
NEW: 475379899
NEW: 475379999
NEW: 475380099
NEW: 475380199
NEW: 475380299
NEW: 475380399
NEW: 475380499
NEW: 475380599
NEW: 475380699
NEW: 475380799
NEW: 475380899
NEW: 475380999
NEW: 475381099
NEW: 475381199
NEW: 475381299
NEW: 475381399
NEW: 475381499
NEW: 475381599
NEW: 475381699
NEW: 475381799
NEW: 475381899
NEW: 475381999
NEW: 475382099
NEW: 475382199
NEW: 475382299
NEW: 475407799
NEW: 475500639
NEW: 475601599
NEW: 475605199
NEW: 475606099
NEW: 475900999
NEW: 475901599
NEW: 475904999
NEW: 477101799
NEW: 477103599
NEW: 477103699
NEW: 477103799
NEW: 477109099
NEW: 477109199
NEW: 477120299
NEW: 478000699
UPDATING: Terebentina Rectificada Talens
Product ID: 27632
Image file:
NEW: 478800299
NEW: 478800399
NEW: 478800499
NEW: 478800699
NEW: Terebentina Winsor & Newton 75 ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Terebentina Winsor & Newton 75 ml - %'
)
NEW: 478800999
NEW: 479201699
NEW: 479203420
NEW: 479205099
NEW: 479205420
NEW: 479206799
NEW: 479299199
NEW: 479299299
NEW: 479299399
NEW: 479300099
NEW: 479300199
NEW: 479300299
NEW: 479501099
NEW: 479501199
NEW: 479501299
NEW: 479501599
UPDATING: Tinta Acrílica Talens Amsterdam 120ml
Product ID: 27419
Image file:
Ok.
Product Option Sync.
Opencart products: 261
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 = 27632
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '478800198 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3900 AS option_value_id,
language_id,
17 AS option_id,
'478800198 - Terebentina Rectificada Talens 250 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 518
AND product_id = 27632
AND option_id = 17
AND option_value_id = 3900
DELETE FROM oc_product
WHERE
model = '478800198'
INSERT INTO oc_product_option_value
SET
product_option_id = 518,
product_id = 27632,
option_id = 17,
option_value_id = 3900,
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 '478800899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3901 AS option_value_id,
language_id,
17 AS option_id,
'478800899 - Terebentina Rectificada Talens 1000 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 518
AND product_id = 27632
AND option_id = 17
AND option_value_id = 3901
DELETE FROM oc_product
WHERE
model = '478800899'
INSERT INTO oc_product_option_value
SET
product_option_id = 518,
product_id = 27632,
option_id = 17,
option_value_id = 3901,
quantity = 1,
subtract = 1,
price = 15.772,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27658
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27658,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '478800799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3902 AS option_value_id,
language_id,
17 AS option_id,
'478800799 - Terebentina Winsor & Newton 75 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 530
AND product_id = 27658
AND option_id = 17
AND option_value_id = 3902
DELETE FROM oc_product
WHERE
model = '478800799'
INSERT INTO oc_product_option_value
SET
product_option_id = 530,
product_id = 27658,
option_id = 17,
option_value_id = 3902,
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 = 27419
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479801999 - %'
UPDATE oc_option_value
SET
image = 'catalog/479801999.jpg'
WHERE
option_value_id = 1331
UPDATE oc_option_value_description
SET
name = '479801999 - Acrílico Amsterdam 120 ml Branco Zinco 104'
WHERE
option_value_id = 1331
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 406
AND product_id = 27419
AND option_id = 17
AND option_value_id = 1331
DELETE FROM oc_product
WHERE
model = '479801999'
INSERT INTO oc_product_option_value
SET
product_option_id = 406,
product_id = 27419,
option_id = 17,
option_value_id = 1331,
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 '479802299 - %'
UPDATE oc_option_value
SET
image = 'catalog/479802299.jpg'
WHERE
option_value_id = 1211
UPDATE oc_option_value_description
SET
name = '479802299 - Acrílico Amsterdam 120 ml Amarelo Nápoles Escuro 223'
WHERE
option_value_id = 1211
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 406
AND product_id = 27419
AND option_id = 17
AND option_value_id = 1211
DELETE FROM oc_product
WHERE
model = '479802299'
INSERT INTO oc_product_option_value
SET
product_option_id = 406,
product_id = 27419,
option_id = 17,
option_value_id = 1211,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.