Product Sync.
Opencart products: 161
Input products: 100
NEW: 102080699
NEW: 102080799
NEW: 102080899
NEW: 102080999
NEW: 102081099
NEW: 102081199
NEW: 102081299
NEW: 102081399
NEW: 102081499
NEW: 102081599
NEW: 102081699
NEW: 102081799
NEW: 102081899
NEW: 102081999
NEW: Verniz Talens Spray
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Verniz Talens Spray - %'
)
NEW: 102082199
NEW: 102082299
NEW: 102082399
NEW: 102082499
NEW: 102082599
NEW: 102082699
NEW: 102082799
NEW: 102082899
NEW: 102082999
NEW: 102083099
NEW: 102083199
NEW: 102083299
NEW: 102083399
NEW: 102083499
NEW: 102083599
NEW: 102083699
NEW: 102083799
NEW: 102083899
NEW: 102083999
NEW: 102084099
NEW: 102084199
NEW: 102084299
NEW: 102084399
NEW: 102084499
NEW: 102084599
NEW: 102084699
NEW: 102084799
NEW: 102084899
NEW: 102084999
NEW: 102085099
NEW: 102085199
NEW: 102085299
NEW: 102085399
NEW: 102085499
NEW: 102085599
NEW: 102085699
NEW: 102085799
NEW: 102085899
NEW: 102085999
NEW: 102086099
NEW: 102086199
NEW: 102086299
NEW: 102086399
NEW: 102086499
NEW: 102086599
NEW: 102086699
NEW: 102086799
NEW: 102086899
NEW: 102086999
NEW: 102087099
NEW: 102087199
NEW: 102087299
NEW: 102087399
NEW: 102087499
NEW: 102087599
NEW: 102087699
NEW: 102087799
NEW: 102087899
NEW: 102087999
NEW: 102088099
NEW: 102088199
NEW: 102088299
NEW: 102088399
NEW: 102088499
NEW: 102088599
NEW: 102088699
NEW: 102088799
NEW: 102088899
NEW: 102088999
NEW: 102089099
NEW: 102089199
NEW: 102089299
NEW: 102089399
NEW: 102089499
NEW: 102089599
NEW: 102089699
NEW: 102089799
NEW: 102089899
NEW: 102089999
NEW: 102090099
NEW: 102090199
NEW: 102090299
NEW: 102090399
NEW: 102090499
UPDATING: Guache Caran D´Ache com 5
Product ID: 27483
Image file:
Ok.
Product Option Sync.
Opencart products: 162
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 = 27559
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27559,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102082099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/102082099.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3665 AS option_value_id,
language_id,
17 AS option_id,
'102082099 - Verniz Talens Brilhante para Óleo Spray 400 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 495
AND product_id = 27559
AND option_id = 17
AND option_value_id = 3665
DELETE FROM oc_product
WHERE
model = '102082099'
INSERT INTO oc_product_option_value
SET
product_option_id = 495,
product_id = 27559,
option_id = 17,
option_value_id = 3665,
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 = 27483
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102090599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3666 AS option_value_id,
language_id,
17 AS option_id,
'102090599 - Guache Caran D´Ache 10 ml Caixa com 5 Tubos de Branco' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 456
AND product_id = 27483
AND option_id = 17
AND option_value_id = 3666
DELETE FROM oc_product
WHERE
model = '102090599'
INSERT INTO oc_product_option_value
SET
product_option_id = 456,
product_id = 27483,
option_id = 17,
option_value_id = 3666,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.