Product Sync.
Opencart products: 194
Input products: 100
NEW: 102262499
NEW: 102262599
NEW: 102262699
NEW: 102262799
NEW: 102262899
NEW: 102262999
NEW: 102263099
UPDATING: Tinta Acrílica Talens Amsterdam 500 ml
Product ID: 27492
Image file:
NEW: 102263299
NEW: 102263399
NEW: 102263499
NEW: 102263599
NEW: 102263699
NEW: 102263799
NEW: 102263899
NEW: 102263999
NEW: 102264099
NEW: 102264199
NEW: 102264299
NEW: 102264399
NEW: 102264499
NEW: 102264599
NEW: 102264699
NEW: 102264799
NEW: 102264899
NEW: 102264999
NEW: 102265099
NEW: 102265199
NEW: 102265299
NEW: 102265399
NEW: 102265499
NEW: 102265599
NEW: 102265699
NEW: 102265799
NEW: 102265899
NEW: 102265999
NEW: 102266099
NEW: 102266199
NEW: 102266299
NEW: 102266399
NEW: 102266499
NEW: 102266599
NEW: 102266699
NEW: 102266799
NEW: 102266899
NEW: 102266999
NEW: 102267099
NEW: 102267199
NEW: 102267299
NEW: 102267399
NEW: 102267499
NEW: 102267599
NEW: 102267699
NEW: 102267799
NEW: 102267899
NEW: 102267999
NEW: 102268099
NEW: 102268199
NEW: 102268299
NEW: 102268399
NEW: 102268499
NEW: 102268599
NEW: 102268699
NEW: 102268799
NEW: 102268899
NEW: 102268999
NEW: 102269099
NEW: 102269199
NEW: 102269299
NEW: 102269399
NEW: 102269499
NEW: 102269599
NEW: 102269699
NEW: 102269799
NEW: 102269899
NEW: 102269999
NEW: 102270099
NEW: 102270199
NEW: 102270299
NEW: 102270399
NEW: 102270499
NEW: 102270599
NEW: 102270699
NEW: 102270799
NEW: 102270899
NEW: 102270999
NEW: 102271099
NEW: 102271199
NEW: 102271299
NEW: 102271399
NEW: 102271499
NEW: 102271599
NEW: 102271699
NEW: 102271799
NEW: 102271899
NEW: 102271999
NEW: 102272099
NEW: 102272199
NEW: 102272299
NEW: 102272399
Ok.
Product Option Sync.
Opencart products: 194
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 = 27492
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102263199 - %'
UPDATE oc_option_value
SET
image = 'catalog/102263199.jpg'
WHERE
option_value_id = 1916
UPDATE oc_option_value_description
SET
name = '102263199 - Acrílico Amsterdam 500 ml Azul Cobalto 512'
WHERE
option_value_id = 1916
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 461
AND product_id = 27492
AND option_id = 17
AND option_value_id = 1916
DELETE FROM oc_product
WHERE
model = '102263199'
INSERT INTO oc_product_option_value
SET
product_option_id = 461,
product_id = 27492,
option_id = 17,
option_value_id = 1916,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.