Product Sync.
Opencart products: 210
Input products: 100
NEW: 101605899
NEW: 101605999
NEW: 101606099
NEW: 101606199
NEW: 101606299
NEW: 101606399
NEW: 101606499
NEW: 101606599
NEW: 101606699
NEW: 101606799
NEW: 101606899
NEW: 101606999
NEW: 101607099
NEW: 101607199
NEW: 101607299
NEW: 101607399
NEW: 101607499
NEW: 101607599
NEW: 101607699
NEW: 101607799
NEW: 101607899
NEW: 101607999
NEW: 101608099
NEW: 101608199
NEW: 101608299
NEW: 101608399
NEW: 101608499
NEW: 101608599
NEW: 101608699
NEW: 101608799
NEW: 101608899
NEW: 101608999
NEW: 101609099
NEW: 101609199
NEW: 101609299
NEW: 101609399
NEW: 101609499
NEW: 101609599
NEW: 101609699
NEW: 101609799
NEW: 101609899
NEW: 101609999
NEW: 101610099
NEW: 101610199
NEW: 101610299
NEW: 101610399
NEW: 101610499
NEW: 101610599
NEW: 101610699
NEW: 101610799
NEW: 101610899
NEW: 101610999
NEW: 101611099
NEW: 101611199
NEW: 101611299
NEW: 101611399
NEW: 101611499
NEW: 101611599
NEW: 101611699
NEW: 101611799
NEW: 101611899
NEW: 101611999
NEW: 101612099
NEW: 101612199
NEW: 101612299
NEW: 101612399
NEW: 101612499
NEW: 101612599
NEW: 101612699
NEW: 101612799
NEW: 101612899
NEW: 101612999
NEW: 101613099
NEW: 101613199
NEW: 101613299
NEW: Pincel Talens Aguarela Espatulado S194
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Pincel Talens Aguarela Espatulado S194 - %'
)
NEW: 101613499
NEW: 101613599
NEW: 101613699
NEW: 101613799
NEW: 101613899
NEW: 101613999
NEW: 101614099
NEW: 101614199
NEW: 101614299
NEW: 101614399
NEW: 101614499
NEW: 101614599
NEW: 101614699
NEW: 101614799
NEW: 101614899
NEW: 101614999
NEW: 101615099
NEW: 101615199
NEW: 101615299
NEW: 101615399
NEW: 101615499
NEW: 101615599
NEW: 101615699
NEW: 101615799
Ok.
Product Option Sync.
Opencart products: 211
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 = 27199
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27199,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101613399 - %'
UPDATE oc_option_value
SET
image = 'catalog/101613399.jpg'
WHERE
option_value_id = 2482
UPDATE oc_option_value_description
SET
name = '101613399 - Pincel Talens Espatulado Aguarela S194 N2'
WHERE
option_value_id = 2482
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 321
AND product_id = 27199
AND option_id = 15
AND option_value_id = 2482
DELETE FROM oc_product
WHERE
model = '101613399'
INSERT INTO oc_product_option_value
SET
product_option_id = 321,
product_id = 27199,
option_id = 15,
option_value_id = 2482,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.