Product Sync.
Opencart products: 262
Input products: 100
NEW: 479859599
NEW: 479859699
UPDATING: Tinta da China Pelikan
Product ID: 27458
Image file:
NEW: 479870199
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '479870199 - %'
)
NEW: 479870299
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '479870299 - %'
)
NEW: 479870699
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '479870699 - %'
)
NEW: 479881099
UPDATING: Tinta Acrílica Talens Amsterdam 120ml
Product ID: 27419
Image file:
NEW: 481001499
NEW: 481203199
NEW: 481203299
NEW: 481203499
NEW: 481204199
NEW: 481800602
NEW: 482202128
NEW: 482202228
NEW: 482400120
NEW: 482401699
NEW: 482502099
NEW: 482502199
NEW: 482502399
NEW: 482611528
NEW: 482611628
NEW: 482645099
NEW: 482700302
NEW: 482700664
NEW: 482701064
NEW: 482702264
NEW: 482702520
NEW: 482702799
NEW: 482702899
NEW: 482703799
NEW: 482780328
NEW: 482780799
NEW: 482780899
NEW: 482781099
NEW: 482781299
NEW: 482803599
NEW: 482810128
NEW: 482828199
NEW: 482828299
NEW: 482836699
NEW: 483000299
NEW: 483006520
NEW: 483006820
NEW: 483007020
NEW: 483007420
NEW: 483010871
NEW: 483010971
NEW: 483012571
NEW: 483023564
NEW: 483051099
NEW: 483052571
NEW: 483055799
NEW: 483059320
NEW: 483059520
NEW: 483067199
NEW: 483067299
NEW: 483067399
NEW: 483067499
NEW: 483068899
NEW: 483080899
NEW: 483087364
NEW: 483098171
NEW: 483098271
NEW: 483098371
NEW: 483100399
NEW: 483100499
NEW: 483202164
NEW: 483203228
NEW: 483203820
NEW: 483210471
NEW: 483210571
NEW: 483211428
NEW: 483215499
NEW: 483226021
NEW: 483232021
NEW: 483250171
NEW: 483251599
NEW: 483252299
NEW: 483257099
NEW: 483257199
NEW: 483257299
NEW: 483258999
NEW: 483259099
NEW: 483501799
NEW: 483501899
NEW: 483600571
NEW: 483606040
NEW: 483606340
NEW: 483606640
NEW: 483606840
NEW: 483608140
NEW: 483608640
NEW: 483608940
Ok.
Product Option Sync.
Opencart products: 265
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 = 27458
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479860699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3908 AS option_value_id,
language_id,
17 AS option_id,
'479860699 - Tinta da China Pelikan 10 ml Sepia' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 437
AND product_id = 27458
AND option_id = 17
AND option_value_id = 3908
DELETE FROM oc_product
WHERE
model = '479860699'
INSERT INTO oc_product_option_value
SET
product_option_id = 437,
product_id = 27458,
option_id = 17,
option_value_id = 3908,
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 = 27419
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479883699 - %'
UPDATE oc_option_value
SET
image = 'catalog/479883699.jpg'
WHERE
option_value_id = 1325
UPDATE oc_option_value_description
SET
name = '479883699 - Acrílico Amsterdam 120 ml Amarelo Nápoles Verde 282'
WHERE
option_value_id = 1325
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 406
AND product_id = 27419
AND option_id = 17
AND option_value_id = 1325
DELETE FROM oc_product
WHERE
model = '479883699'
INSERT INTO oc_product_option_value
SET
product_option_id = 406,
product_id = 27419,
option_id = 17,
option_value_id = 1325,
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 '479883799 - %'
UPDATE oc_option_value
SET
image = 'catalog/479883799.jpg'
WHERE
option_value_id = 1326
UPDATE oc_option_value_description
SET
name = '479883799 - Acrílico Amsterdam 120 ml Violeta Caput Mortuum 344'
WHERE
option_value_id = 1326
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 406
AND product_id = 27419
AND option_id = 17
AND option_value_id = 1326
DELETE FROM oc_product
WHERE
model = '479883799'
INSERT INTO oc_product_option_value
SET
product_option_id = 406,
product_id = 27419,
option_id = 17,
option_value_id = 1326,
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 '479883899 - %'
UPDATE oc_option_value
SET
image = 'catalog/479883899.jpg'
WHERE
option_value_id = 1327
UPDATE oc_option_value_description
SET
name = '479883899 - Acrílico Amsterdam 120 ml Azul Turquesa 522'
WHERE
option_value_id = 1327
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 406
AND product_id = 27419
AND option_id = 17
AND option_value_id = 1327
DELETE FROM oc_product
WHERE
model = '479883899'
INSERT INTO oc_product_option_value
SET
product_option_id = 406,
product_id = 27419,
option_id = 17,
option_value_id = 1327,
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 '479883999 - %'
UPDATE oc_option_value
SET
image = 'catalog/479883999.jpg'
WHERE
option_value_id = 1328
UPDATE oc_option_value_description
SET
name = '479883999 - Acrílico Amsterdam 120 ml Cobre 805'
WHERE
option_value_id = 1328
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 406
AND product_id = 27419
AND option_id = 17
AND option_value_id = 1328
DELETE FROM oc_product
WHERE
model = '479883999'
INSERT INTO oc_product_option_value
SET
product_option_id = 406,
product_id = 27419,
option_id = 17,
option_value_id = 1328,
quantity = 1,
subtract = 1,
price = 0.487,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479884099 - %'
UPDATE oc_option_value
SET
image = 'catalog/479884099.jpg'
WHERE
option_value_id = 1329
UPDATE oc_option_value_description
SET
name = '479884099 - Acrílico Amsterdam 120 ml Bronze 811'
WHERE
option_value_id = 1329
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 406
AND product_id = 27419
AND option_id = 17
AND option_value_id = 1329
DELETE FROM oc_product
WHERE
model = '479884099'
INSERT INTO oc_product_option_value
SET
product_option_id = 406,
product_id = 27419,
option_id = 17,
option_value_id = 1329,
quantity = 1,
subtract = 1,
price = 0.487,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '479884199 - %'
UPDATE oc_option_value
SET
image = 'catalog/479884199.jpg'
WHERE
option_value_id = 1330
UPDATE oc_option_value_description
SET
name = '479884199 - Acrílico Amsterdam 120 ml Estanho 815'
WHERE
option_value_id = 1330
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 406
AND product_id = 27419
AND option_id = 17
AND option_value_id = 1330
DELETE FROM oc_product
WHERE
model = '479884199'
INSERT INTO oc_product_option_value
SET
product_option_id = 406,
product_id = 27419,
option_id = 17,
option_value_id = 1330,
quantity = 1,
subtract = 1,
price = 0.487,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.