Product Sync.
Opencart products: 175
Input products: 100
NEW: 100636399
NEW: 100636499
NEW: 100636599
NEW: 100636699
NEW: 100636799
NEW: 100636899
NEW: 100636999
NEW: 100637099
NEW: 100637199
NEW: 100637299
NEW: 100637399
NEW: 100637499
NEW: 100637599
NEW: 100637699
NEW: 100637799
NEW: 100637899
NEW: 100637999
NEW: 100638099
NEW: 100638199
NEW: 100638299
NEW: 100638399
NEW: 100638499
NEW: 100638599
NEW: 100638699
NEW: 100638799
NEW: 100638899
NEW: 100638999
NEW: 100639099
NEW: 100639199
NEW: 100639299
NEW: 100639399
NEW: 100639499
NEW: 100639599
NEW: 100639699
NEW: 100639799
NEW: 100639899
NEW: 100639999
NEW: 100640099
NEW: 100640199
NEW: 100640299
NEW: 100640399
NEW: 100640499
NEW: 100640599
NEW: 100640699
NEW: 100640799
NEW: 100640899
NEW: 100640999
NEW: 100641099
NEW: 100641199
NEW: Tela Winsor & Newton
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Tela Winsor & Newton - %'
)
NEW: 100641399
NEW: 100641499
NEW: 100641599
NEW: 100641699
NEW: 100641799
NEW: 100641899
NEW: 100641999
NEW: 100642099
NEW: 100642199
NEW: 100642299
NEW: 100642399
NEW: 100642499
NEW: 100642599
NEW: 100642699
NEW: 100642799
NEW: 100642899
NEW: 100642999
NEW: 100643099
NEW: 100643199
NEW: 100643299
NEW: 100643399
NEW: 100643499
NEW: 100643599
NEW: 100643699
NEW: 100643799
NEW: 100643899
NEW: 100643999
NEW: 100644099
NEW: 100644199
NEW: 100644299
NEW: 100644399
NEW: 100644499
NEW: 100644599
NEW: 100644699
NEW: 100644799
NEW: 100644899
NEW: 100644999
NEW: 100645099
NEW: 100645199
NEW: 100645299
NEW: 100645399
NEW: 100645499
NEW: 100645599
NEW: 100645699
NEW: 100645799
NEW: 100645899
NEW: 100645999
NEW: 100646099
NEW: 100646199
NEW: 100646299
Ok.
Product Option Sync.
Opencart products: 176
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 =
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = ,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100641299 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 2363
UPDATE oc_option_value_description
SET
name = '100641299 - Tela Winsor & Newton 60 x 90'
WHERE
option_value_id = 2363
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id =
AND product_id =
AND option_id = 15
AND option_value_id = 2363
DELETE FROM oc_product
WHERE
model = '100641299'
INSERT INTO oc_product_option_value
SET
product_option_id = ,
product_id = ,
option_id = 15,
option_value_id = 2363,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.