Product Sync.
Opencart products: 142
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
UPDATING: Guache Giotto Lavável 1000 ml
Product ID: 27002
Image file:
NEW: 100144199
NEW: 100144299
NEW: 100144399
UPDATING: Guache Talens
Product ID: 27003
Image file:
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: 149
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 = 27002
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100144099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2151
UPDATE oc_option_value_description
SET
name = '100144099 - Guache Giotto Lavável 1000 ml Rosa'
WHERE
option_value_id = 2151
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 73
AND product_id = 27002
AND option_id = 15
AND option_value_id = 2151
DELETE FROM oc_product
WHERE
model = '100144099'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 73
AND product_id = 27002
AND option_id = 15
AND option_value_id = 2151
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27003
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100144499 - %'
UPDATE oc_option_value
SET
image = 'catalog/100144499.jpg'
WHERE
option_value_id = 2152
UPDATE oc_option_value_description
SET
name = '100144499 - Guache Talens Caixa com 5 Cores'
WHERE
option_value_id = 2152
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 74
AND product_id = 27003
AND option_id = 15
AND option_value_id = 2152
DELETE FROM oc_product
WHERE
model = '100144499'
UPDATE oc_product_option_value
SET
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
WHERE
product_option_id = 74
AND product_id = 27003
AND option_id = 15
AND option_value_id = 2152
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27134
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27134,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100147199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2153
UPDATE oc_option_value_description
SET
name = '100147199 - Verniz Talens para Óleo de Retoque 1000 ml'
WHERE
option_value_id = 2153
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 285
AND product_id = 27134
AND option_id = 15
AND option_value_id = 2153
DELETE FROM oc_product
WHERE
model = '100147199'
INSERT INTO oc_product_option_value
SET
product_option_id = 285,
product_id = 27134,
option_id = 15,
option_value_id = 2153,
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 = 27137
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27137,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100147999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2156
UPDATE oc_option_value_description
SET
name = '100147999 - Pincel Talens Redondo para Óleo/Acrílico S295 N00'
WHERE
option_value_id = 2156
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 286
AND product_id = 27137
AND option_id = 15
AND option_value_id = 2156
DELETE FROM oc_product
WHERE
model = '100147999'
INSERT INTO oc_product_option_value
SET
product_option_id = 286,
product_id = 27137,
option_id = 15,
option_value_id = 2156,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.