Product Sync.
Opencart products: 136
Input products: 100
NEW: 100070799
NEW: 100070899
NEW: 100070999
NEW: 100071099
NEW: 100071199
NEW: 100071299
NEW: 100071399
NEW: 100071499
NEW: 100071599
NEW: 100071699
NEW: 100071799
NEW: 100071899
NEW: 100071999
NEW: 100072099
NEW: 100072199
NEW: 100072299
NEW: 100072399
NEW: 100072499
NEW: 100072599
NEW: 100072699
NEW: 100072799
NEW: 100072899
NEW: 100072999
NEW: 100073099
NEW: 100073199
NEW: 100073299
NEW: 100073399
NEW: 100073499
NEW: 100073599
NEW: 100073699
NEW: 100073799
NEW: 100073899
NEW: 100073999
NEW: 100074099
NEW: 100074199
NEW: 100074299
NEW: 100074399
NEW: 100074499
NEW: 100074599
NEW: 100074699
NEW: 100074799
NEW: 100074899
NEW: 100074999
NEW: 100075099
NEW: 100075199
NEW: 100075299
NEW: 100075399
NEW: 100075499
NEW: 100075599
NEW: 100075699
NEW: 100075799
NEW: 100075899
NEW: 100075999
NEW: 100076099
NEW: 100076199
NEW: 100076299
NEW: 100076399
NEW: 100076499
NEW: 100076599
NEW: 100076699
NEW: 100076799
NEW: Bloco Aguarela Canson XL
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Bloco Aguarela Canson XL - %'
)
NEW: Bloco Aguarela Canson Vidalon Rústico
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Bloco Aguarela Canson Vidalon Rústico - %'
)
NEW: 100077399
NEW: 100077499
NEW: 100077599
NEW: 100077699
NEW: 100077799
NEW: 100077899
NEW: 100077999
NEW: 100078099
NEW: 100078199
NEW: 100078299
NEW: 100078399
NEW: 100078499
NEW: 100078599
NEW: 100078699
NEW: 100078799
NEW: 100078899
NEW: 100078999
NEW: 100079099
NEW: 100079199
NEW: 100079299
NEW: 100079399
NEW: 100079499
NEW: 100079599
NEW: 100079699
NEW: 100079799
NEW: 100079899
NEW: 100079999
NEW: 100080099
NEW: 100080199
NEW: 100080299
NEW: 100080399
NEW: 100080499
NEW: 100080599
NEW: 100080699
Ok.
Product Option Sync.
Opencart products: 138
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 = 27125
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27125,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100076899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2143
UPDATE oc_option_value_description
SET
name = '100076899 - Bloco Aguarela Canson XL 300 gr GF A4 30 Fls'
WHERE
option_value_id = 2143
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 281
AND product_id = 27125
AND option_id = 15
AND option_value_id = 2143
DELETE FROM oc_product
WHERE
model = '100076899'
INSERT INTO oc_product_option_value
SET
product_option_id = 281,
product_id = 27125,
option_id = 15,
option_value_id = 2143,
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 '100076999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2144
UPDATE oc_option_value_description
SET
name = '100076999 - Bloco Aguarela Canson XL 300 gr GF A3 30 Fls'
WHERE
option_value_id = 2144
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 281
AND product_id = 27125
AND option_id = 15
AND option_value_id = 2144
DELETE FROM oc_product
WHERE
model = '100076999'
INSERT INTO oc_product_option_value
SET
product_option_id = 281,
product_id = 27125,
option_id = 15,
option_value_id = 2144,
quantity = 1,
subtract = 1,
price = 4.146,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27126
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27126,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100077099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2145
UPDATE oc_option_value_description
SET
name = '100077099 - Bloco Aguarela Canson Vidalon Rústico 24 x 32 300 gr 12 Fls'
WHERE
option_value_id = 2145
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 282
AND product_id = 27126
AND option_id = 15
AND option_value_id = 2145
DELETE FROM oc_product
WHERE
model = '100077099'
INSERT INTO oc_product_option_value
SET
product_option_id = 282,
product_id = 27126,
option_id = 15,
option_value_id = 2145,
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 '100077199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2146
UPDATE oc_option_value_description
SET
name = '100077199 - Bloco Aguarela Canson Vidalon Rústico 27 x 36 300 gr 12 Fls'
WHERE
option_value_id = 2146
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 282
AND product_id = 27126
AND option_id = 15
AND option_value_id = 2146
DELETE FROM oc_product
WHERE
model = '100077199'
INSERT INTO oc_product_option_value
SET
product_option_id = 282,
product_id = 27126,
option_id = 15,
option_value_id = 2146,
quantity = 1,
subtract = 1,
price = 1.626,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100077299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2147
UPDATE oc_option_value_description
SET
name = '100077299 - Bloco Aguarela Canson Vidalon Rústico 32 x 41 300 gr 12 Fls'
WHERE
option_value_id = 2147
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 282
AND product_id = 27126
AND option_id = 15
AND option_value_id = 2147
DELETE FROM oc_product
WHERE
model = '100077299'
INSERT INTO oc_product_option_value
SET
product_option_id = 282,
product_id = 27126,
option_id = 15,
option_value_id = 2147,
quantity = 1,
subtract = 1,
price = 3.943,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.