Product Sync.
Opencart products: 157
Input products: 100
NEW: 100293099
NEW: 100293199
NEW: 100293299
NEW: 100293399
NEW: 100293499
NEW: 100293599
NEW: 100293699
NEW: 100293799
NEW: 100293899
NEW: 100293999
NEW: 100294099
UPDATING: Guache Giotto 500 ml
Product ID: 27012
Image file:
NEW: 100294299
NEW: 100294399
NEW: 100294499
NEW: 100294599
NEW: 100294699
NEW: 100294799
NEW: 100294899
NEW: 100294999
NEW: 100295099
NEW: 100295199
NEW: 100295299
NEW: 100295399
NEW: 100295499
NEW: 100295599
UPDATING: Bloco Aguarela Cotman 300 grs
Product ID: 27116
Image file:
NEW: 100295799
UPDATING: Guache Pelikan
Product ID: 27022
Image file:
NEW: 100295999
NEW: 100296099
NEW: 100296199
NEW: 100296299
NEW: 100296399
NEW: 100296499
NEW: 100296599
NEW: 100296699
NEW: 100296799
NEW: 100296899
NEW: 100296999
NEW: 100297099
NEW: 100297199
NEW: 100297299
NEW: 100297399
NEW: 100297499
NEW: 100297599
NEW: 100297699
NEW: 100297799
NEW: 100297899
NEW: 100297999
NEW: 100298099
NEW: 100298199
NEW: 100298299
NEW: 100298399
NEW: 100298499
NEW: 100298599
NEW: 100298699
NEW: 100298799
NEW: 100298899
NEW: 100298999
NEW: 100299099
NEW: 100299199
NEW: 100299299
NEW: 100299399
NEW: 100299499
NEW: 100299599
NEW: 100299699
NEW: 100299799
NEW: 100299899
NEW: 100299999
NEW: 100300099
NEW: 100300199
NEW: 100300299
NEW: 100300399
NEW: 100300499
NEW: 100300599
NEW: 100300699
NEW: 100300799
NEW: 100300899
NEW: 100300999
NEW: 100301099
NEW: 100301199
NEW: 100301299
NEW: 100301399
NEW: 100301499
NEW: 100301599
NEW: 100301699
NEW: 100301799
NEW: 100301899
NEW: 100301999
NEW: 100302099
NEW: 100302199
NEW: 100302299
NEW: 100302399
NEW: 100302499
NEW: 100302599
NEW: 100302699
NEW: 100302799
NEW: 100302899
NEW: 100302999
Ok.
Product Option Sync.
Opencart products: 157
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 = 27012
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100294199 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1739
UPDATE oc_option_value_description
SET
name = '100294199 - Guache Giotto 500 ml Rosa'
WHERE
option_value_id = 1739
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1739
DELETE FROM oc_product
WHERE
model = '100294199'
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 = 81
AND product_id = 27012
AND option_id = 15
AND option_value_id = 1739
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27116
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100295699 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2179
UPDATE oc_option_value_description
SET
name = '100295699 - Bloco Aguarela Cotman 300 grs 35,5 x 25,4'
WHERE
option_value_id = 2179
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 278
AND product_id = 27116
AND option_id = 15
AND option_value_id = 2179
DELETE FROM oc_product
WHERE
model = '100295699'
INSERT INTO oc_product_option_value
SET
product_option_id = 278,
product_id = 27116,
option_id = 15,
option_value_id = 2179,
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 = 27022
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100295899 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1740
UPDATE oc_option_value_description
SET
name = '100295899 - Guache Pelikan 10 ml Preto'
WHERE
option_value_id = 1740
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 90
AND product_id = 27022
AND option_id = 15
AND option_value_id = 1740
DELETE FROM oc_product
WHERE
model = '100295899'
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 = 90
AND product_id = 27022
AND option_id = 15
AND option_value_id = 1740
Ok.