Product Sync.
Opencart products: 48
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: 27436
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: 27406
Image file:
NEW: 100295799
NEW: Guache Pelikan
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Guache Pelikan - %'
)
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: 49
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 = 27436
AND option_id = 17
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 = 417
AND product_id = 27436
AND option_id = 17
AND option_value_id = 1739
DELETE FROM oc_product
WHERE
model = '100294199'
INSERT INTO oc_product_option_value
SET
product_option_id = 417,
product_id = 27436,
option_id = 17,
option_value_id = 1739,
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 = 27406
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100295699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3269 AS option_value_id,
language_id,
17 AS option_id,
'100295699 - Bloco Aguarela Cotman 300 grs 35,5 x 25,4' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 399
AND product_id = 27406
AND option_id = 17
AND option_value_id = 3269
DELETE FROM oc_product
WHERE
model = '100295699'
INSERT INTO oc_product_option_value
SET
product_option_id = 399,
product_id = 27406,
option_id = 17,
option_value_id = 3269,
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 = 27446
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27446,
option_id = 17,
value = '',
required = 1
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 = 425
AND product_id = 27446
AND option_id = 17
AND option_value_id = 1740
DELETE FROM oc_product
WHERE
model = '100295899'
INSERT INTO oc_product_option_value
SET
product_option_id = 425,
product_id = 27446,
option_id = 17,
option_value_id = 1740,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.