Product Sync.
Opencart products: 14
Input products: 100
NEW: 100141499
NEW: 100141599
NEW: 100141699
NEW: 100141799
NEW: 100141899
NEW: 100141999
NEW: 100142099
NEW: 100142199
NEW: 100142299
NEW: 100142399
NEW: 100142499
NEW: 100142599
NEW: 100142699
NEW: 100142799
NEW: 100142899
NEW: 100142999
NEW: 100143099
NEW: 100143199
NEW: 100143299
NEW: 100143399
NEW: 100143499
NEW: 100143599
NEW: 100143699
NEW: 100143799
NEW: 100143899
NEW: 100143999
NEW: 100144099
NEW: 100144199
NEW: 100144299
NEW: 100144399
NEW: 100144499
NEW: 100144599
NEW: 100144699
NEW: 100144799
NEW: 100144899
UPDATING: Caixas e Conjuntos
Product ID: 27382
Image file: Caixas e Conjuntos.jpg
NEW: 100145199
NEW: 100145299
NEW: 100145499
NEW: 100145599
NEW: 100145699
NEW: 100145799
NEW: 100145899
NEW: 100145999
NEW: 100146099
NEW: 100146199
NEW: 100146299
NEW: 100146399
NEW: 100146499
NEW: 100146599
NEW: 100146699
NEW: 100146799
NEW: 100146899
NEW: 100146999
NEW: 100147099
NEW: 100147199
NEW: 100147299
NEW: 100147399
NEW: 100147499
NEW: 100147599
NEW: 100147699
NEW: 100147799
NEW: 100147899
NEW: 100147999
NEW: 100148099
NEW: 100148199
NEW: 100148299
NEW: 100148399
NEW: 100148499
NEW: 100148599
NEW: 100148699
NEW: 100148799
NEW: 100148899
NEW: 100148999
NEW: 100149099
NEW: 100149199
NEW: 100149299
NEW: 100149399
NEW: 100149499
NEW: 100149599
NEW: 100149699
NEW: 100149799
NEW: 100149899
NEW: 100149999
NEW: 100150099
NEW: 100150199
NEW: 100150299
NEW: 100150399
NEW: 100150499
NEW: 100150599
NEW: 100150699
NEW: 100150799
NEW: 100150899
NEW: 100150999
NEW: 100151099
NEW: 100151199
NEW: 100151299
NEW: 100151399
Ok.
Product Option Sync.
Opencart products: 14
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 = 27382
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100144999 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1731
UPDATE oc_option_value_description
SET
name = '100144999 - CXA ACRIL V GOGH BASIC 10TB 40ML'
WHERE
option_value_id = 1731
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 375
AND product_id = 27382
AND option_id = 17
AND option_value_id = 1731
DELETE FROM oc_product
WHERE
model = '100144999'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1731,
quantity = 1,
subtract = 1,
price = 36.423,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100145099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1732
UPDATE oc_option_value_description
SET
name = '100145099 - CXA AGUAR VAN GOGH 20HP8612 C/12 PAST'
WHERE
option_value_id = 1732
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 375
AND product_id = 27382
AND option_id = 17
AND option_value_id = 1732
DELETE FROM oc_product
WHERE
model = '100145099'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1732,
quantity = 1,
subtract = 1,
price = 6.423,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100145399 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1733
UPDATE oc_option_value_description
SET
name = '100145399 - SET BASICO AGUAR ART CREATION 12X12 ML'
WHERE
option_value_id = 1733
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 375
AND product_id = 27382
AND option_id = 17
AND option_value_id = 1733
DELETE FROM oc_product
WHERE
model = '100145399'
INSERT INTO oc_product_option_value
SET
product_option_id = 375,
product_id = 27382,
option_id = 17,
option_value_id = 1733,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.