Product Sync.
Opencart products: 144
Input products: 100
NEW: 101949299
NEW: 101949399
NEW: 101949499
NEW: 101949599
NEW: 101949699
NEW: 101949799
NEW: 101949899
NEW: 101949999
NEW: 101950099
NEW: 101950199
NEW: 101950299
NEW: 101950399
NEW: 101950499
NEW: 101950599
NEW: 101950699
NEW: 101950799
NEW: 101950899
NEW: 101950999
NEW: 101951099
NEW: 101951199
NEW: 101951299
NEW: 101951399
NEW: 101951499
NEW: 101951599
NEW: 101951699
NEW: 101951799
NEW: 101951899
NEW: 101951999
NEW: 101952099
NEW: 101952199
NEW: 101952299
NEW: 101952399
NEW: 101952499
NEW: 101952599
NEW: 101952699
NEW: 101952799
NEW: 101952899
NEW: 101952999
NEW: 101953099
NEW: 101953199
NEW: 101953299
NEW: 101953399
NEW: 101953499
NEW: 101953599
NEW: 101953699
NEW: 101953799
NEW: 101953899
NEW: 101953999
NEW: 101954099
NEW: 101954199
NEW: 101954299
NEW: 101954399
NEW: 101954499
NEW: 101954599
NEW: 101954699
NEW: 101954799
NEW: 101954899
NEW: 101954999
NEW: 101955099
NEW: 101955199
NEW: 101955299
NEW: 101955399
NEW: 101955499
NEW: 101955599
NEW: 101955699
NEW: 101955799
NEW: 101955899
NEW: 101955999
NEW: 101956099
NEW: 101956199
NEW: Pincel Daler Rowney Cabo Comprido Espatulado Curto
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Pincel Daler Rowney Cabo Comprido Espatulado Curto - %'
)
NEW: 101956599
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '101956599 - %'
)
NEW: Pincel Daler Rowney de Cerda Cabo Comprido Língua de Gato
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Pincel Daler Rowney de Cerda Cabo Comprido Língua de Gato - %'
)
NEW: 101956899
NEW: 101956999
NEW: 101957099
NEW: 101957199
NEW: 101957299
NEW: 101957399
NEW: 101957499
NEW: 101957599
NEW: 101957699
NEW: 101957799
NEW: 101957899
NEW: 101957999
NEW: 101958099
NEW: 101958199
NEW: 101958299
NEW: 101958399
NEW: 101958499
NEW: 101958599
NEW: 101958699
NEW: 101958799
NEW: 101958899
NEW: 101958999
NEW: 101959099
NEW: 101959199
Ok.
Product Option Sync.
Opencart products: 147
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 = 27542
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27542,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101956299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3578 AS option_value_id,
language_id,
17 AS option_id,
'101956299 - Pincel Daler Rowney Cabo Comprido Espatulado Curto N2' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 484
AND product_id = 27542
AND option_id = 17
AND option_value_id = 3578
DELETE FROM oc_product
WHERE
model = '101956299'
INSERT INTO oc_product_option_value
SET
product_option_id = 484,
product_id = 27542,
option_id = 17,
option_value_id = 3578,
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 '101956399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3579 AS option_value_id,
language_id,
17 AS option_id,
'101956399 - Pincel Daler Rowney Cabo Comprido Espatulado Curto N6' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 484
AND product_id = 27542
AND option_id = 17
AND option_value_id = 3579
DELETE FROM oc_product
WHERE
model = '101956399'
INSERT INTO oc_product_option_value
SET
product_option_id = 484,
product_id = 27542,
option_id = 17,
option_value_id = 3579,
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 '101956499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3580 AS option_value_id,
language_id,
17 AS option_id,
'101956499 - Pincel Daler Rowney Cabo Comprido Espatulado Curto N10' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 484
AND product_id = 27542
AND option_id = 17
AND option_value_id = 3580
DELETE FROM oc_product
WHERE
model = '101956499'
INSERT INTO oc_product_option_value
SET
product_option_id = 484,
product_id = 27542,
option_id = 17,
option_value_id = 3580,
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 = 27544
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27544,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101956699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3581 AS option_value_id,
language_id,
17 AS option_id,
'101956699 - Pincel Daler Rowney de Cerda Cabo Comprido Língua de Gato N1' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 485
AND product_id = 27544
AND option_id = 17
AND option_value_id = 3581
DELETE FROM oc_product
WHERE
model = '101956699'
INSERT INTO oc_product_option_value
SET
product_option_id = 485,
product_id = 27544,
option_id = 17,
option_value_id = 3581,
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 '101956799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3582 AS option_value_id,
language_id,
17 AS option_id,
'101956799 - Pincel Daler Rowney de Cerda Cabo Comprido Língua de Gato N4' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 485
AND product_id = 27544
AND option_id = 17
AND option_value_id = 3582
DELETE FROM oc_product
WHERE
model = '101956799'
INSERT INTO oc_product_option_value
SET
product_option_id = 485,
product_id = 27544,
option_id = 17,
option_value_id = 3582,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.