Product Sync.
Opencart products: 176
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
UPDATING: Tinta da China Winsor & Newton
Product ID: 27049
Image file:
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: 27043
Image file:
NEW: 100666399
NEW: 100666499
Ok.
Product Option Sync.
Opencart products: 177
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 =
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100663499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2364
UPDATE oc_option_value_description
SET
name = '100663499 - Tinta da China Winsor & Newton Branco 14 ml'
WHERE
option_value_id = 2364
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2364
DELETE FROM oc_product
WHERE
model = '100663499'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2364,
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 = 27165
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27165,
option_id = 15,
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 = 305
AND product_id = 27165
AND option_id = 15
AND option_value_id = 1516
DELETE FROM oc_product
WHERE
model = '100665099'
INSERT INTO oc_product_option_value
SET
product_option_id = 305,
product_id = 27165,
option_id = 15,
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 = 27043
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100666299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2365
UPDATE oc_option_value_description
SET
name = '100666299 - Cerne Pébéo Ouro Rico'
WHERE
option_value_id = 2365
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 110
AND product_id = 27043
AND option_id = 15
AND option_value_id = 2365
DELETE FROM oc_product
WHERE
model = '100666299'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 110
AND product_id = 27043
AND option_id = 15
AND option_value_id = 2365
Ok.