Product Sync.
Opencart products: 188
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: 27034
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: 188
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 = 27034
AND option_id = 15
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101139299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2403
UPDATE oc_option_value_description
SET
name = '101139299 - Tela Talens 40 x 40'
WHERE
option_value_id = 2403
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2403
DELETE FROM oc_product
WHERE
model = '101139299'
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 = 101
AND product_id = 27034
AND option_id = 15
AND option_value_id = 2403
Ok.