Product Sync.
Opencart products: 20
Input products: 100
NEW: 100384099
NEW: 100384199
NEW: 100384299
NEW: 100384399
NEW: 100384499
NEW: 100384599
NEW: 100384699
NEW: 100384799
NEW: 100384899
NEW: 100384999
NEW: 100385099
NEW: 100385199
NEW: 100385299
NEW: 100385399
NEW: 100385499
NEW: 100385599
NEW: 100385699
NEW: 100385799
NEW: 100385899
NEW: 100385999
NEW: 100386099
NEW: 100386199
NEW: 100386299
NEW: 100386399
NEW: 100386499
NEW: 100386599
NEW: 100386699
NEW: 100386799
NEW: 100386899
NEW: 100386999
NEW: 100387099
NEW: 100387199
NEW: 100387299
NEW: 100387399
NEW: 100387499
NEW: 100387599
NEW: 100387699
NEW: 100387799
NEW: 100387899
NEW: 100387999
NEW: 100388099
NEW: 100388199
NEW: 100388299
NEW: 100388399
NEW: 100388499
NEW: 100388599
NEW: 100388699
NEW: 100388799
NEW: 100388899
NEW: 100388999
NEW: 100389099
NEW: 100389199
NEW: 100389299
NEW: 100389399
NEW: 100389499
NEW: 100389599
NEW: 100389699
NEW: 100389799
NEW: 100389899
NEW: 100389999
NEW: 100390099
NEW: 100390199
NEW: 100390299
NEW: 100390399
NEW: 100390499
NEW: 100390599
NEW: 100390699
NEW: 100390799
NEW: 100390899
NEW: 100390999
NEW: 100391099
NEW: 100391199
NEW: 100391299
NEW: 100391399
NEW: 100391499
NEW: 100391599
NEW: Galeria W&N 250ml
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Galeria W&N 250ml - %'
)
NEW: 100391799
NEW: 100391899
NEW: 100391999
NEW: 100392099
NEW: 100392199
NEW: 100392299
UPDATING: Aguarela Líquida Ecoline
Product ID: 27391
Image file:
NEW: 100392599
NEW: 100392699
NEW: 100392799
NEW: 100392899
NEW: 100392999
NEW: 100393099
NEW: 100393199
NEW: 100393299
NEW: 100393399
NEW: 100393499
NEW: 100393599
NEW: 100393699
NEW: 100393799
NEW: 100393899
NEW: 100393999
Ok.
Product Option Sync.
Opencart products: 21
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 = 27392
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27392,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100391699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1332
UPDATE oc_option_value_description
SET
name = '100391699 - ACRIL GALERIA W&N 250ML SAP GREEN 599'
WHERE
option_value_id = 1332
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 385
AND product_id = 27392
AND option_id = 17
AND option_value_id = 1332
DELETE FROM oc_product
WHERE
model = '100391699'
INSERT INTO oc_product_option_value
SET
product_option_id = 385,
product_id = 27392,
option_id = 17,
option_value_id = 1332,
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 = 27391
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100392399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 972
UPDATE oc_option_value_description
SET
name = '100392399 - AGUAR ECOLINE TALENS 25-30 ML VDE BOSQUE 656'
WHERE
option_value_id = 972
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 384
AND product_id = 27391
AND option_id = 17
AND option_value_id = 972
DELETE FROM oc_product
WHERE
model = '100392399'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 972,
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 '100392499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 973
UPDATE oc_option_value_description
SET
name = '100392499 - AGUAR ECOLINE TALENS 25-30 ML ROSA CL'
WHERE
option_value_id = 973
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 384
AND product_id = 27391
AND option_id = 17
AND option_value_id = 973
DELETE FROM oc_product
WHERE
model = '100392499'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 973,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.