Product Sync.
Opencart products: 159
Input products: 100
NEW: 100394099
NEW: Pincel Pelikan 25A
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Pincel Pelikan 25A - %'
)
NEW: 100394499
UPDATING: Tinta para Tecido Pébéo Setacolor
Product ID: 27030
Image file:
NEW: 100394699
NEW: 100394799
NEW: 100394899
NEW: 100394999
NEW: 100395099
NEW: 100395199
NEW: 100395299
NEW: Cera Pébéo Gedeo para Dourar
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Cera Pébéo Gedeo para Dourar - %'
)
NEW: 100395499
NEW: 100395599
NEW: 100395699
NEW: 100395799
NEW: 100395899
NEW: 100395999
NEW: 100396199
NEW: 100396299
NEW: 100396399
NEW: 100396499
NEW: 100396599
NEW: 100396699
NEW: 100396799
NEW: 100396899
NEW: 100396999
NEW: 100397099
NEW: 100397199
NEW: 100397299
NEW: 100397399
NEW: 100397499
NEW: 100397599
NEW: 100397699
NEW: 100397799
NEW: 100397899
NEW: 100397999
NEW: 100398099
NEW: 100398199
NEW: 100398299
NEW: 100398399
NEW: 100398499
NEW: 100398599
NEW: 100398699
NEW: 100398799
NEW: 100398899
NEW: 100398999
NEW: 100399099
NEW: 100399199
NEW: 100399299
NEW: 100399399
NEW: 100399499
NEW: 100399599
NEW: 100399699
NEW: 100399799
NEW: 100399899
NEW: 100399999
NEW: 100400099
NEW: 100400199
NEW: 100400299
NEW: 100400399
NEW: 100400499
NEW: 100400599
NEW: 100400699
NEW: 100400799
NEW: 100400899
NEW: 100400999
NEW: 100401099
NEW: 100401199
NEW: 100401299
NEW: 100401399
NEW: 100401499
NEW: 100401599
NEW: 100401699
NEW: 100401799
NEW: 100401899
NEW: 100401999
NEW: 100402099
NEW: 100402199
NEW: 100402299
NEW: 100402399
NEW: 100402499
NEW: 100402599
NEW: 100402699
NEW: 100402799
NEW: 100402899
NEW: 100402999
NEW: 100403099
NEW: 100403199
NEW: 100403299
NEW: 100403399
NEW: 100403499
NEW: 100403599
NEW: 100403699
NEW: 100403799
NEW: 100403899
NEW: 100403999
Ok.
Product Option Sync.
Opencart products: 161
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 = 27148
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27148,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100394199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2184
UPDATE oc_option_value_description
SET
name = '100394199 - Pincel Pelikan 25A N1'
WHERE
option_value_id = 2184
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 295
AND product_id = 27148
AND option_id = 15
AND option_value_id = 2184
DELETE FROM oc_product
WHERE
model = '100394199'
INSERT INTO oc_product_option_value
SET
product_option_id = 295,
product_id = 27148,
option_id = 15,
option_value_id = 2184,
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 '100394299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2185
UPDATE oc_option_value_description
SET
name = '100394299 - Pincel Pelikan 25A N4'
WHERE
option_value_id = 2185
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 295
AND product_id = 27148
AND option_id = 15
AND option_value_id = 2185
DELETE FROM oc_product
WHERE
model = '100394299'
INSERT INTO oc_product_option_value
SET
product_option_id = 295,
product_id = 27148,
option_id = 15,
option_value_id = 2185,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100394399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2186
UPDATE oc_option_value_description
SET
name = '100394399 - Pincel Pelikan 25A N3'
WHERE
option_value_id = 2186
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 295
AND product_id = 27148
AND option_id = 15
AND option_value_id = 2186
DELETE FROM oc_product
WHERE
model = '100394399'
INSERT INTO oc_product_option_value
SET
product_option_id = 295,
product_id = 27148,
option_id = 15,
option_value_id = 2186,
quantity = 1,
subtract = 1,
price = 0.081,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27030
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100394599 - %'
INSERT INTO oc_option_value
SET
option_id = 15,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3174 AS option_value_id,
language_id,
15 AS option_id,
'100394599 - \''Setacolor Opaco Amarelo Rico Brilho' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 3174
DELETE FROM oc_product
WHERE
model = '100394599'
INSERT INTO oc_product_option_value
SET
product_option_id = 97,
product_id = 27030,
option_id = 15,
option_value_id = 3174,
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 '100396099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2188
UPDATE oc_option_value_description
SET
name = '100396099 - Setacolor Opaco Preto Brilhante'
WHERE
option_value_id = 2188
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2188
DELETE FROM oc_product
WHERE
model = '100396099'
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 = 97
AND product_id = 27030
AND option_id = 15
AND option_value_id = 2188
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27149
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27149,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100395399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2189
UPDATE oc_option_value_description
SET
name = '100395399 - Cera Pébéo Gedeo para Dourar 30 ml Prata'
WHERE
option_value_id = 2189
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 296
AND product_id = 27149
AND option_id = 15
AND option_value_id = 2189
DELETE FROM oc_product
WHERE
model = '100395399'
INSERT INTO oc_product_option_value
SET
product_option_id = 296,
product_id = 27149,
option_id = 15,
option_value_id = 2189,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.