Product Sync.
Opencart products: 189
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: 27164
Image file:
UPDATING: Tela Creatore Premium
Product ID: 27139
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: 190
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 '101188799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2412
UPDATE oc_option_value_description
SET
name = '101188799 - Tela Winsor & Newton 70 x 70'
WHERE
option_value_id = 2412
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 = 2412
DELETE FROM oc_product
WHERE
model = '101188799'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2412,
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 = 27139
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101188899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2413
UPDATE oc_option_value_description
SET
name = '101188899 - Tela Creatore Premium 60 x 70'
WHERE
option_value_id = 2413
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 288
AND product_id = 27139
AND option_id = 15
AND option_value_id = 2413
DELETE FROM oc_product
WHERE
model = '101188899'
INSERT INTO oc_product_option_value
SET
product_option_id = 288,
product_id = 27139,
option_id = 15,
option_value_id = 2413,
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 = 27178
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27178,
option_id = 15,
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 = 309
AND product_id = 27178
AND option_id = 15
AND option_value_id = 1604
DELETE FROM oc_product
WHERE
model = '101188999'
INSERT INTO oc_product_option_value
SET
product_option_id = 309,
product_id = 27178,
option_id = 15,
option_value_id = 1604,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.