Product Sync.
Opencart products: 24
Input products: 100
NEW: 100141499
NEW: 100141599
NEW: 100141699
NEW: 100141799
NEW: 100141899
NEW: 100141999
NEW: 100142099
NEW: 100142199
NEW: 100142299
NEW: 100142399
NEW: 100142499
NEW: 100142599
NEW: 100142699
NEW: 100142799
NEW: 100142899
NEW: 100142999
NEW: 100143099
NEW: 100143199
NEW: 100143299
NEW: 100143399
NEW: 100143499
NEW: 100143599
NEW: 100143699
NEW: 100143799
NEW: 100143899
NEW: 100143999
NEW: Guache Giotto Lavável 1000 ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Guache Giotto Lavável 1000 ml - %'
)
NEW: 100144199
NEW: 100144299
NEW: 100144399
NEW: Guache Talens
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Guache Talens - %'
)
NEW: 100144599
NEW: 100144699
NEW: 100144799
NEW: 100144899
NEW: 100144999
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '100144999 - %'
)
NEW: 100145099
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '100145099 - %'
)
NEW: 100145199
NEW: 100145299
NEW: 100145399
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '100145399 - %'
)
NEW: 100145499
NEW: 100145599
NEW: 100145699
NEW: 100145799
NEW: 100145899
NEW: 100145999
NEW: 100146099
NEW: 100146199
NEW: 100146299
NEW: 100146399
NEW: 100146499
NEW: 100146599
NEW: 100146699
NEW: 100146799
NEW: 100146899
NEW: 100146999
NEW: 100147099
NEW: Verniz Talens para Óleo de Retoque 75 ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Verniz Talens para Óleo de Retoque 75 ml - %'
)
NEW: 100147299
NEW: 100147399
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '100147399 - %'
)
NEW: 100147499
NEW: 100147599
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '100147599 - %'
)
NEW: 100147699
NEW: 100147799
NEW: 100147899
NEW: Pincel Talens Redondo para Óleo/Acrílico S295
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Pincel Talens Redondo para Óleo/Acrílico S295 - %'
)
NEW: 100148099
NEW: 100148199
NEW: 100148299
NEW: 100148399
NEW: 100148499
NEW: 100148599
NEW: 100148699
NEW: 100148799
NEW: 100148899
NEW: 100148999
NEW: 100149099
NEW: 100149199
NEW: 100149299
NEW: 100149399
NEW: 100149499
NEW: 100149599
NEW: 100149699
NEW: 100149799
NEW: 100149899
NEW: 100149999
NEW: 100150099
NEW: 100150199
NEW: 100150299
NEW: 100150399
NEW: 100150499
NEW: 100150599
NEW: 100150699
NEW: 100150799
NEW: 100150899
NEW: 100150999
NEW: 100151099
NEW: 100151199
NEW: 100151299
NEW: 100151399
Ok.
Product Option Sync.
Opencart products: 33
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 = 27422
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27422,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100144099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3245 AS option_value_id,
language_id,
17 AS option_id,
'100144099 - Guache Giotto Lavável 1000 ml Rosa' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 408
AND product_id = 27422
AND option_id = 17
AND option_value_id = 3245
DELETE FROM oc_product
WHERE
model = '100144099'
INSERT INTO oc_product_option_value
SET
product_option_id = 408,
product_id = 27422,
option_id = 17,
option_value_id = 3245,
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 = 27423
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27423,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100144499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/100144499.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3246 AS option_value_id,
language_id,
17 AS option_id,
'100144499 - Guache Talens Caixa com 5 Cores' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 409
AND product_id = 27423
AND option_id = 17
AND option_value_id = 3246
DELETE FROM oc_product
WHERE
model = '100144499'
INSERT INTO oc_product_option_value
SET
product_option_id = 409,
product_id = 27423,
option_id = 17,
option_value_id = 3246,
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 = 27427
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27427,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100147199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3247 AS option_value_id,
language_id,
17 AS option_id,
'100147199 - Verniz Talens para Óleo de Retoque 1000 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 410
AND product_id = 27427
AND option_id = 17
AND option_value_id = 3247
DELETE FROM oc_product
WHERE
model = '100147199'
INSERT INTO oc_product_option_value
SET
product_option_id = 410,
product_id = 27427,
option_id = 17,
option_value_id = 3247,
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 = 27430
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27430,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100147999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3248 AS option_value_id,
language_id,
17 AS option_id,
'100147999 - Pincel Talens Redondo para Óleo/Acrílico S295 N00' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 411
AND product_id = 27430
AND option_id = 17
AND option_value_id = 3248
DELETE FROM oc_product
WHERE
model = '100147999'
INSERT INTO oc_product_option_value
SET
product_option_id = 411,
product_id = 27430,
option_id = 17,
option_value_id = 3248,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.