Product Sync.
Opencart products: 100
Input products: 100
NEW: 101181799
NEW: 101181899
NEW: 101181999
NEW: 101182099
NEW: 101182199
NEW: 101182299
NEW: 101182399
NEW: 101182499
NEW: 101182599
NEW: 101182699
NEW: 101182799
NEW: 101182899
NEW: 101182999
NEW: 101183099
NEW: 101183199
NEW: 101183299
NEW: 101183399
NEW: 101183499
NEW: 101183599
NEW: 101183699
NEW: 101183799
NEW: 101183899
NEW: 101183999
NEW: 101184099
NEW: 101184199
NEW: 101184299
NEW: 101184399
NEW: 101184499
NEW: 101184599
NEW: 101184699
NEW: 101184799
NEW: 101184899
NEW: 101184999
NEW: 101185099
NEW: 101185199
NEW: 101185299
NEW: 101185399
NEW: 101185499
NEW: 101185599
NEW: 101185699
NEW: 101185799
NEW: 101185899
NEW: 101185999
NEW: 101186099
NEW: 101186199
NEW: 101186299
NEW: 101186399
NEW: 101186499
NEW: 101186599
NEW: 101186699
NEW: 101186799
NEW: 101186899
NEW: 101186999
NEW: 101187099
NEW: 101187199
NEW: 101187299
NEW: 101187399
NEW: 101187499
NEW: 101187599
NEW: 101187699
NEW: 101187799
NEW: 101187899
NEW: 101187999
NEW: 101188099
NEW: 101188199
NEW: 101188299
NEW: 101188399
NEW: 101188499
NEW: 101188599
NEW: 101188699
UPDATING: Tela Winsor & Newton
Product ID: 27478
Image file:
UPDATING: Tela Creatore Premium
Product ID: 27433
Image file:
NEW: Cavalete de Mesa Reeves Base Quadrada Surrey
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 Reeves Base Quadrada Surrey - %'
)
NEW: 101189099
NEW: 101189199
NEW: 101189299
NEW: 101189399
NEW: 101189499
NEW: 101189599
NEW: 101189699
NEW: 101189799
NEW: 101189899
NEW: 101189999
NEW: 101190099
NEW: 101190199
NEW: 101190299
NEW: 101190399
NEW: 101190499
NEW: 101190599
NEW: 101190699
NEW: 101190799
NEW: 101190899
NEW: 101190999
NEW: 101191099
NEW: 101191199
NEW: 101191299
NEW: 101191399
NEW: 101191499
NEW: 101191599
NEW: 101191699
Ok.
Product Option Sync.
Opencart products: 101
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 = 27478
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101188799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3489 AS option_value_id,
language_id,
17 AS option_id,
'101188799 - Tela Winsor & Newton 70 x 70' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 451
AND product_id = 27478
AND option_id = 17
AND option_value_id = 3489
DELETE FROM oc_product
WHERE
model = '101188799'
INSERT INTO oc_product_option_value
SET
product_option_id = 451,
product_id = 27478,
option_id = 17,
option_value_id = 3489,
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 = 27433
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101188899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3490 AS option_value_id,
language_id,
17 AS option_id,
'101188899 - Tela Creatore Premium 60 x 70' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 414
AND product_id = 27433
AND option_id = 17
AND option_value_id = 3490
DELETE FROM oc_product
WHERE
model = '101188899'
INSERT INTO oc_product_option_value
SET
product_option_id = 414,
product_id = 27433,
option_id = 17,
option_value_id = 3490,
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 = 27498
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27498,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101188999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1604
UPDATE oc_option_value_description
SET
name = '101188999 - Cavalete de Mesa Reeves Base Quadrada Surrey'
WHERE
option_value_id = 1604
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 463
AND product_id = 27498
AND option_id = 17
AND option_value_id = 1604
DELETE FROM oc_product
WHERE
model = '101188999'
INSERT INTO oc_product_option_value
SET
product_option_id = 463,
product_id = 27498,
option_id = 17,
option_value_id = 1604,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.