Product Sync.
Opencart products: 193
Input products: 100
NEW: 102232199
NEW: 102232299
NEW: 102232399
NEW: 102232499
NEW: 102232599
NEW: 102232699
NEW: 102232799
NEW: 102232899
NEW: 102232999
NEW: 102233099
NEW: 102233199
NEW: 102233299
NEW: 102233399
NEW: 102233499
NEW: 102233599
NEW: 102233699
NEW: 102233799
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102233799 - %'
)
NEW: 102233899
NEW: 102233999
NEW: 102234099
NEW: 102234199
NEW: 102234299
NEW: 102234399
NEW: 102234499
NEW: 102234599
NEW: 102234699
NEW: 102234799
NEW: 102234899
NEW: 102234999
NEW: 102235099
NEW: 102235199
NEW: 102235299
NEW: 102235399
NEW: 102235499
NEW: 102235599
NEW: 102235699
NEW: 102235799
NEW: 102235899
NEW: 102235999
NEW: 102236099
NEW: 102236199
NEW: 102236299
NEW: 102236399
NEW: 102236499
NEW: 102236599
NEW: 102236699
NEW: 102236799
NEW: 102236899
NEW: 102236999
NEW: 102237099
NEW: 102237199
NEW: 102237299
NEW: 102237399
NEW: 102237499
NEW: 102237599
NEW: 102237699
NEW: 102237799
NEW: 102237899
NEW: 102237999
NEW: 102238099
NEW: 102238199
NEW: 102238299
NEW: 102238399
NEW: 102238499
NEW: 102238599
NEW: 102238699
NEW: 102238799
UPDATING: Tela Daler Rowney Simply
Product ID: 27557
Image file:
NEW: 102239199
NEW: 102239299
NEW: 102239399
NEW: 102239499
NEW: 102239599
NEW: 102239699
NEW: 102239799
NEW: 102239899
NEW: 102239999
NEW: 102240099
NEW: 102240199
NEW: 102240299
NEW: 102240399
NEW: 102240499
NEW: 102240599
NEW: 102240699
NEW: 102240799
NEW: 102240899
NEW: 102240999
NEW: 102241099
NEW: 102241199
NEW: 102241299
NEW: 102241399
NEW: 102241499
NEW: 102241599
NEW: 102241699
NEW: 102241799
NEW: 102241899
NEW: 102241999
NEW: 102242099
Ok.
Product Option Sync.
Opencart products: 194
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 = 27557
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102238899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3687 AS option_value_id,
language_id,
17 AS option_id,
'102238899 - Tela Daler Rowney Simply 40 x 40' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 494
AND product_id = 27557
AND option_id = 17
AND option_value_id = 3687
DELETE FROM oc_product
WHERE
model = '102238899'
INSERT INTO oc_product_option_value
SET
product_option_id = 494,
product_id = 27557,
option_id = 17,
option_value_id = 3687,
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 '102238999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3688 AS option_value_id,
language_id,
17 AS option_id,
'102238999 - Tela Daler Rowney Simply 50 x 50' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 494
AND product_id = 27557
AND option_id = 17
AND option_value_id = 3688
DELETE FROM oc_product
WHERE
model = '102238999'
INSERT INTO oc_product_option_value
SET
product_option_id = 494,
product_id = 27557,
option_id = 17,
option_value_id = 3688,
quantity = 1,
subtract = 1,
price = 3.009,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102239099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3689 AS option_value_id,
language_id,
17 AS option_id,
'102239099 - Tela Daler Rowney Simply 60 x 80' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 494
AND product_id = 27557
AND option_id = 17
AND option_value_id = 3689
DELETE FROM oc_product
WHERE
model = '102239099'
INSERT INTO oc_product_option_value
SET
product_option_id = 494,
product_id = 27557,
option_id = 17,
option_value_id = 3689,
quantity = 1,
subtract = 1,
price = 9.594,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.