Product Sync.
Opencart products: 161
Input products: 100
NEW: 100404199
NEW: 100404299
NEW: 100404399
NEW: 100404499
NEW: 100404599
NEW: 100404699
NEW: 100404799
NEW: 100404899
NEW: 100404999
NEW: 100405099
NEW: 100405199
NEW: 100405299
NEW: 100405399
NEW: 100405499
NEW: 100405599
NEW: 100405699
NEW: 100405799
NEW: 100405899
NEW: 100405999
NEW: 100406099
NEW: 100406199
NEW: 100406299
NEW: 100406399
NEW: 100406499
NEW: 100406599
NEW: 100406699
NEW: 100406799
NEW: 100406899
NEW: 100406999
NEW: 100407099
NEW: 100407199
NEW: 100407299
NEW: 100407399
NEW: 100407499
NEW: 100407599
NEW: 100407699
NEW: 100407799
NEW: 100407899
NEW: 100407999
NEW: 100408099
NEW: 100408199
NEW: 100408299
NEW: 100408399
NEW: 100408499
NEW: 100408599
NEW: 100408699
NEW: 100408799
NEW: 100408899
NEW: 100408999
NEW: 100409099
NEW: 100409199
NEW: 100409299
NEW: 100409399
NEW: 100409499
NEW: 100409599
NEW: 100409699
NEW: 100409799
NEW: 100409899
NEW: 100409999
NEW: 100410099
NEW: 100410199
NEW: 100410299
NEW: 100410399
NEW: 100410499
NEW: 100410599
NEW: 100410699
NEW: 100410799
NEW: 100410899
NEW: 100410999
NEW: 100411099
NEW: 100411199
NEW: 100411299
NEW: 100411399
NEW: 100411499
NEW: 100411599
NEW: 100411699
NEW: 100411799
NEW: 100411899
NEW: 100411999
NEW: 100412099
NEW: 100412199
NEW: 100412299
NEW: 100412399
NEW: 100412499
UPDATING: Tinta para Artes Decorativas Pébéo com efeito Prisma
Product ID: 27032
Image file:
NEW: 100412799
UPDATING: Tinta para Tecido Pébéo Setacolor
Product ID: 27030
Image file:
NEW: 100412999
NEW: 100413099
NEW: 100413199
NEW: 100413299
NEW: 100413399
NEW: 100413499
NEW: 100413599
NEW: 100413699
NEW: 100413799
NEW: 100413899
NEW: 100413999
NEW: 100414099
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 = 27032
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100412599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2190
UPDATE oc_option_value_description
SET
name = '100412599 - Tinta Pébéo Prisma 45 ml Verde Folha'
WHERE
option_value_id = 2190
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 99
AND product_id = 27032
AND option_id = 15
AND option_value_id = 2190
DELETE FROM oc_product
WHERE
model = '100412599'
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 = 99
AND product_id = 27032
AND option_id = 15
AND option_value_id = 2190
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100412699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2191
UPDATE oc_option_value_description
SET
name = '100412699 - Tinta Pébéo Prisma 45 ml Azul Marina'
WHERE
option_value_id = 2191
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 99
AND product_id = 27032
AND option_id = 15
AND option_value_id = 2191
DELETE FROM oc_product
WHERE
model = '100412699'
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 = 99
AND product_id = 27032
AND option_id = 15
AND option_value_id = 2191
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 '100412899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2192
UPDATE oc_option_value_description
SET
name = '100412899 - Setacolor Opaco Azul Ganga'
WHERE
option_value_id = 2192
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 = 2192
DELETE FROM oc_product
WHERE
model = '100412899'
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 = 2192
Ok.