Product Sync.
Opencart products: 144
Input products: 100
NEW: 101858399
NEW: 101858499
NEW: 101858599
NEW: 101858699
NEW: 101858799
NEW: 101858899
NEW: 101858999
NEW: 101859099
NEW: 101859199
NEW: 101859299
NEW: 101859399
NEW: 101859499
NEW: 101859599
NEW: 101859699
NEW: 101859799
NEW: 101859899
NEW: 101859999
NEW: 101860099
NEW: 101860199
NEW: 101860299
NEW: 101860399
NEW: 101860499
NEW: 101860599
NEW: 101860699
NEW: 101860799
NEW: 101860899
NEW: 101860999
NEW: 101861099
NEW: 101861199
NEW: 101861299
NEW: 101861399
NEW: 101861499
NEW: 101861599
NEW: 101861699
NEW: 101861799
NEW: 101861899
NEW: 101861999
UPDATING: Guache Giotto 500 ml
Product ID: 27436
Image file:
NEW: 101862199
NEW: 101862299
NEW: 101862399
NEW: 101862499
NEW: 101862599
NEW: 101862699
NEW: 101862799
NEW: 101862899
NEW: 101862999
NEW: 101863099
NEW: 101863199
NEW: 101863299
NEW: 101863399
NEW: 101863499
NEW: 101863599
NEW: 101863699
NEW: 101863799
NEW: 101863899
NEW: 101863999
NEW: 101864099
NEW: 101864199
NEW: 101864299
NEW: 101864399
NEW: 101864499
NEW: 101864599
NEW: 101864699
NEW: 101864799
NEW: 101864899
NEW: 101864999
NEW: 101865099
NEW: 101865199
NEW: 101865299
NEW: 101865399
NEW: 101865499
NEW: 101865599
NEW: 101865699
NEW: 101865799
NEW: 101865899
NEW: 101865999
NEW: 101866099
NEW: 101866199
NEW: 101866299
NEW: 101866399
NEW: 101866499
NEW: 101866599
NEW: 101866699
NEW: 101866799
NEW: 101866899
NEW: 101866999
NEW: 101867099
NEW: 101867199
NEW: 101867299
NEW: 101867399
NEW: 101867499
NEW: 101867599
NEW: 101867699
NEW: 101867799
NEW: 101867899
NEW: 101867999
NEW: 101868099
NEW: 101868199
NEW: 101868299
Ok.
Product Option Sync.
Opencart products: 144
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 = 27436
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '101862099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1884
UPDATE oc_option_value_description
SET
name = '101862099 - Guache Giotto 500 ml Amarelo Ocre'
WHERE
option_value_id = 1884
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 417
AND product_id = 27436
AND option_id = 17
AND option_value_id = 1884
DELETE FROM oc_product
WHERE
model = '101862099'
INSERT INTO oc_product_option_value
SET
product_option_id = 417,
product_id = 27436,
option_id = 17,
option_value_id = 1884,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.