Product Sync.
Opencart products: 31
Input products: 100
NEW: 102180399
NEW: 102180499
NEW: 102180599
NEW: 102180699
NEW: 102180799
NEW: 102180899
NEW: 102180999
NEW: 102181099
NEW: 102181199
NEW: 102181299
NEW: 102181399
NEW: 102181499
NEW: 102181599
NEW: 102181699
NEW: 102181799
NEW: 102181899
NEW: 102181999
NEW: 102182099
NEW: 102182199
NEW: 102182299
NEW: 102182399
UPDATING: Aguarela Líquida Ecoline
Product ID: 27391
Image file:
NEW: 102182699
NEW: 102182899
NEW: 102182999
NEW: 102183099
NEW: 102183199
NEW: 102183299
NEW: 102183399
NEW: 102183499
NEW: 102183599
NEW: 102183699
NEW: 102183799
NEW: 102183899
NEW: 102183999
NEW: 102184099
NEW: 102184199
NEW: 102184299
NEW: 102184399
NEW: 102184499
NEW: 102184599
NEW: 102184699
NEW: 102184799
NEW: 102184899
NEW: 102184999
NEW: 102185099
NEW: 102185199
NEW: 102185299
NEW: 102185399
NEW: 102185499
NEW: 102185599
NEW: 102185699
NEW: 102185799
NEW: 102185899
NEW: 102185999
NEW: 102186099
NEW: 102186199
NEW: 102186299
NEW: 102186399
NEW: 102186499
NEW: 102186599
NEW: 102186699
NEW: 102186799
NEW: 102186899
NEW: 102186999
NEW: 102187099
NEW: 102187199
NEW: 102187299
NEW: 102187399
NEW: 102187499
NEW: 102187599
NEW: 102187699
NEW: 102187799
NEW: 102187899
NEW: 102187999
NEW: 102188099
NEW: 102188199
NEW: 102188299
NEW: 102188399
NEW: 102188499
NEW: 102188599
NEW: 102188699
NEW: 102188799
NEW: 102188899
NEW: 102188999
NEW: 102189099
NEW: 102189199
NEW: 102189299
NEW: 102189399
NEW: 102189499
NEW: 102189599
NEW: 102189699
NEW: 102189799
NEW: 102189899
NEW: 102189999
NEW: 102190099
NEW: 102190199
NEW: 102190299
Ok.
Product Option Sync.
Opencart products: 31
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 = 27391
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102182499 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1673
UPDATE oc_option_value_description
SET
name = '102182499 - AGUAR ECOLINE TALENS 30 ML VDE 600'
WHERE
option_value_id = 1673
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 384
AND product_id = 27391
AND option_id = 17
AND option_value_id = 1673
DELETE FROM oc_product
WHERE
model = '102182499'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 1673,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102182599 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1674
UPDATE oc_option_value_description
SET
name = '102182599 - AGUAR ECOLINE TALENS 30 ML VDE ERVA 676'
WHERE
option_value_id = 1674
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 384
AND product_id = 27391
AND option_id = 17
AND option_value_id = 1674
DELETE FROM oc_product
WHERE
model = '102182599'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 1674,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102182799 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1675
UPDATE oc_option_value_description
SET
name = '102182799 - AGUAR ECOLINE TALENS 30 ML AMA CLR 201'
WHERE
option_value_id = 1675
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 384
AND product_id = 27391
AND option_id = 17
AND option_value_id = 1675
DELETE FROM oc_product
WHERE
model = '102182799'
INSERT INTO oc_product_option_value
SET
product_option_id = 384,
product_id = 27391,
option_id = 17,
option_value_id = 1675,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.