Product Sync.
Opencart products: 227
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: 230
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 = 27216
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27216,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101956299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2514
UPDATE oc_option_value_description
SET
name = '101956299 - Pincel Daler Rowney Cabo Comprido Espatulado Curto N2'
WHERE
option_value_id = 2514
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 324
AND product_id = 27216
AND option_id = 15
AND option_value_id = 2514
DELETE FROM oc_product
WHERE
model = '101956299'
INSERT INTO oc_product_option_value
SET
product_option_id = 324,
product_id = 27216,
option_id = 15,
option_value_id = 2514,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2515
UPDATE oc_option_value_description
SET
name = '101956399 - Pincel Daler Rowney Cabo Comprido Espatulado Curto N6'
WHERE
option_value_id = 2515
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 324
AND product_id = 27216
AND option_id = 15
AND option_value_id = 2515
DELETE FROM oc_product
WHERE
model = '101956399'
INSERT INTO oc_product_option_value
SET
product_option_id = 324,
product_id = 27216,
option_id = 15,
option_value_id = 2515,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2516
UPDATE oc_option_value_description
SET
name = '101956499 - Pincel Daler Rowney Cabo Comprido Espatulado Curto N10'
WHERE
option_value_id = 2516
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 324
AND product_id = 27216
AND option_id = 15
AND option_value_id = 2516
DELETE FROM oc_product
WHERE
model = '101956499'
INSERT INTO oc_product_option_value
SET
product_option_id = 324,
product_id = 27216,
option_id = 15,
option_value_id = 2516,
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 = 27218
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27218,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101956699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2518
UPDATE oc_option_value_description
SET
name = '101956699 - Pincel Daler Rowney de Cerda Cabo Comprido Língua de Gato N1'
WHERE
option_value_id = 2518
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 325
AND product_id = 27218
AND option_id = 15
AND option_value_id = 2518
DELETE FROM oc_product
WHERE
model = '101956699'
INSERT INTO oc_product_option_value
SET
product_option_id = 325,
product_id = 27218,
option_id = 15,
option_value_id = 2518,
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 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2519
UPDATE oc_option_value_description
SET
name = '101956799 - Pincel Daler Rowney de Cerda Cabo Comprido Língua de Gato N4'
WHERE
option_value_id = 2519
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 325
AND product_id = 27218
AND option_id = 15
AND option_value_id = 2519
DELETE FROM oc_product
WHERE
model = '101956799'
INSERT INTO oc_product_option_value
SET
product_option_id = 325,
product_id = 27218,
option_id = 15,
option_value_id = 2519,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.