Product Sync.
Opencart products: 59
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
NEW: Tinta para Artes Decorativas Pébéo com efeito Prisma
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Tinta para Artes Decorativas Pébéo com efeito Prisma - %'
)
NEW: 100412799
UPDATING: Tinta para Tecido Pébéo Setacolor
Product ID: 27455
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: 60
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 = 27457
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27457,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100412599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3280 AS option_value_id,
language_id,
17 AS option_id,
'100412599 - Tinta Pébéo Prisma 45 ml Verde Folha' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3280
DELETE FROM oc_product
WHERE
model = '100412599'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3280,
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 '100412699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3281 AS option_value_id,
language_id,
17 AS option_id,
'100412699 - Tinta Pébéo Prisma 45 ml Azul Marina' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 436
AND product_id = 27457
AND option_id = 17
AND option_value_id = 3281
DELETE FROM oc_product
WHERE
model = '100412699'
INSERT INTO oc_product_option_value
SET
product_option_id = 436,
product_id = 27457,
option_id = 17,
option_value_id = 3281,
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 = 27455
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100412899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3282 AS option_value_id,
language_id,
17 AS option_id,
'100412899 - Setacolor Opaco Azul Ganga' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 434
AND product_id = 27455
AND option_id = 17
AND option_value_id = 3282
DELETE FROM oc_product
WHERE
model = '100412899'
INSERT INTO oc_product_option_value
SET
product_option_id = 434,
product_id = 27455,
option_id = 17,
option_value_id = 3282,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.