Product Sync.
Opencart products: 81
Input products: 100
NEW: 100656599
NEW: 100656699
NEW: 100656799
NEW: 100656899
NEW: 100656999
NEW: 100657099
NEW: 100657199
NEW: 100657299
NEW: 100657399
NEW: 100657499
NEW: 100657599
NEW: 100657699
NEW: 100657799
NEW: 100657899
NEW: 100657999
NEW: 100658099
NEW: 100658199
NEW: 100658299
NEW: 100658399
NEW: 100658499
NEW: 100658599
NEW: 100658699
NEW: 100658799
NEW: 100658899
NEW: 100658999
NEW: 100659099
NEW: 100659199
NEW: 100659299
NEW: 100659399
NEW: 100659499
NEW: 100659599
NEW: 100659699
NEW: 100659799
NEW: 100659899
NEW: 100659999
NEW: 100660099
NEW: 100660199
NEW: 100660299
NEW: 100660399
NEW: 100660499
NEW: 100660599
NEW: 100660699
NEW: 100660799
NEW: 100660899
NEW: 100660999
NEW: 100661099
NEW: 100661199
NEW: 100661299
NEW: 100661399
NEW: 100661499
NEW: 100661599
NEW: 100661699
NEW: 100661799
NEW: 100661899
NEW: 100661999
NEW: 100662099
NEW: 100662199
NEW: 100662299
NEW: 100662399
NEW: 100662499
NEW: 100662599
NEW: 100662699
NEW: 100662799
NEW: 100662899
NEW: 100662999
NEW: 100663099
NEW: 100663199
NEW: 100663299
NEW: 100663399
NEW: Tinta da China Winsor & Newton
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Tinta da China Winsor & Newton - %'
)
NEW: 100663599
NEW: 100663699
NEW: 100663799
NEW: 100663899
NEW: 100663999
NEW: 100664099
NEW: 100664199
NEW: 100664299
NEW: 100664399
NEW: 100664499
NEW: 100664599
NEW: 100664699
NEW: 100664799
NEW: 100664899
NEW: 100664999
NEW: Cavalete Talens Tripé Madeira
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é Madeira - %'
)
NEW: 100665199
NEW: 100665299
NEW: 100665399
NEW: 100665499
NEW: 100665599
NEW: 100665699
NEW: 100665799
NEW: 100665899
NEW: 100665999
NEW: 100666099
NEW: 100666199
UPDATING: Tinta Relevo Cerne Pébéo
Product ID: 27470
Image file:
NEW: 100666399
NEW: 100666499
Ok.
Product Option Sync.
Opencart products: 83
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 = 27479
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27479,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100663499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3448 AS option_value_id,
language_id,
17 AS option_id,
'100663499 - Tinta da China Winsor & Newton Branco 14 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 452
AND product_id = 27479
AND option_id = 17
AND option_value_id = 3448
DELETE FROM oc_product
WHERE
model = '100663499'
INSERT INTO oc_product_option_value
SET
product_option_id = 452,
product_id = 27479,
option_id = 17,
option_value_id = 3448,
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 = 27480
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27480,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100665099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1516
UPDATE oc_option_value_description
SET
name = '100665099 - Cavalete Talens Tripé Madeira'
WHERE
option_value_id = 1516
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 453
AND product_id = 27480
AND option_id = 17
AND option_value_id = 1516
DELETE FROM oc_product
WHERE
model = '100665099'
INSERT INTO oc_product_option_value
SET
product_option_id = 453,
product_id = 27480,
option_id = 17,
option_value_id = 1516,
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 = 27470
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100666299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3449 AS option_value_id,
language_id,
17 AS option_id,
'100666299 - Cerne Pébéo Ouro Rico' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 447
AND product_id = 27470
AND option_id = 17
AND option_value_id = 3449
DELETE FROM oc_product
WHERE
model = '100666299'
INSERT INTO oc_product_option_value
SET
product_option_id = 447,
product_id = 27470,
option_id = 17,
option_value_id = 3449,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.