Product Sync.
Opencart products: 99
Input products: 100
NEW: 101131299
NEW: 101131399
NEW: 101131499
NEW: 101131599
NEW: 101131699
NEW: 101131799
NEW: 101131899
NEW: 101131999
NEW: 101132099
NEW: 101132199
NEW: 101132299
NEW: 101132399
NEW: 101132499
NEW: 101132599
NEW: 101132699
NEW: 101132799
NEW: 101132899
NEW: 101132999
NEW: 101133099
NEW: 101133199
NEW: 101133299
NEW: 101133399
NEW: 101133499
NEW: 101133599
NEW: 101133699
NEW: 101133799
NEW: 101133899
NEW: 101133999
NEW: 101134099
NEW: 101134199
NEW: 101134299
NEW: 101134399
NEW: 101134499
NEW: 101134599
NEW: 101134699
NEW: 101134799
NEW: 101134899
NEW: 101134999
NEW: 101135099
NEW: 101135199
NEW: 101135299
NEW: 101135399
NEW: 101135499
NEW: 101135599
NEW: 101135699
NEW: 101135799
NEW: 101135899
NEW: 101135999
NEW: 101136099
NEW: 101136199
NEW: 101136299
NEW: 101136399
NEW: 101136499
NEW: 101136599
NEW: 101136699
NEW: 101136799
NEW: 101136899
NEW: 101136999
NEW: 101137099
NEW: 101137199
NEW: 101137299
NEW: 101137399
NEW: 101137499
NEW: 101137599
NEW: 101137699
NEW: 101137799
NEW: 101137899
NEW: 101137999
NEW: 101138099
NEW: 101138199
NEW: 101138299
NEW: 101138399
NEW: 101138499
NEW: 101138599
NEW: 101138699
NEW: 101138799
NEW: 101138899
NEW: 101138999
NEW: 101139099
NEW: 101139199
UPDATING: Tela Talens
Product ID: 27459
Image file:
NEW: 101139399
NEW: 101139499
NEW: 101139599
NEW: 101139699
NEW: 101139799
NEW: 101139899
NEW: 101139999
NEW: 101140099
NEW: 101140199
NEW: 101140299
NEW: 101140399
NEW: 101140499
NEW: 101140599
NEW: 101140699
NEW: 101140799
NEW: 101140899
NEW: 101140999
NEW: 101141099
NEW: 101141199
Ok.
Product Option Sync.
Opencart products: 99
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 = 27459
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101139299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3481 AS option_value_id,
language_id,
17 AS option_id,
'101139299 - Tela Talens 40 x 40' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 438
AND product_id = 27459
AND option_id = 17
AND option_value_id = 3481
DELETE FROM oc_product
WHERE
model = '101139299'
INSERT INTO oc_product_option_value
SET
product_option_id = 438,
product_id = 27459,
option_id = 17,
option_value_id = 3481,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.