Product Sync.
Opencart products: 227
Input products: 100
NEW: 256369299
NEW: 256369399
NEW: 256369499
NEW: 256369599
NEW: 256369899
NEW: 256369999
NEW: 256370099
NEW: 256370199
NEW: 256370299
NEW: 256626267
NEW: 256626367
NEW: 256626667
NEW: 256626767
NEW: 256626867
NEW: 256627667
NEW: 256627767
NEW: 256629367
NEW: 256629467
NEW: 256640061
NEW: 256644628
NEW: 256650040
NEW: 256652437
NEW: 256660021
NEW: 256660121
NEW: 256660221
NEW: 256660321
NEW: 256686967
NEW: 256687067
NEW: 256688767
NEW: 256689067
NEW: 256689267
NEW: 256689367
NEW: 256689467
NEW: 256689567
NEW: 256689667
NEW: 256702540
NEW: 256702740
NEW: 256705040
NEW: 256829771
NEW: 256830171
NEW: 256837671
NEW: 256838071
NEW: 256838571
NEW: 256839771
NEW: 256840071
NEW: 256847571
NEW: 256847671
NEW: 256847871
NEW: 256847971
NEW: 256848071
NEW: 256852071
NEW: 256852271
NEW: 256852471
NEW: Médio Secante para Óleo Talens
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Médio Secante para Óleo Talens - %'
)
NEW: 257234698
NEW: 257236198
NEW: 257811671
NEW: 257815567
NEW: 257829267
NEW: 257829467
NEW: 257829567
NEW: 257829667
NEW: 257829867
NEW: 257829967
NEW: 257830167
NEW: 257837571
NEW: 257840271
NEW: 257840471
NEW: 257853561
NEW: 257853761
NEW: 257854671
NEW: 257858621
NEW: 257868767
NEW: 257888167
NEW: 257888267
NEW: 257888967
NEW: 257889067
NEW: 257889167
NEW: 257889267
NEW: 257889967
NEW: 257890067
NEW: 257890167
NEW: 257891167
NEW: 257892167
NEW: 257892267
NEW: 257892467
NEW: 257892567
NEW: 257892667
NEW: 257892767
NEW: 257892867
NEW: 257892967
NEW: 257893267
NEW: 257893367
NEW: 257893767
NEW: 257893867
NEW: 258410299
NEW: 261137099
NEW: 261601299
UPDATING: Tinta Óleo Talens Rembrandt 15 ml
Product ID: 27493
Image file:
Ok.
Product Option Sync.
Opencart products: 228
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 = 27625
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27625,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '257234098 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3759 AS option_value_id,
language_id,
17 AS option_id,
'257234098 - Médio para Óleo Talens Secagem Normal 75 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 513
AND product_id = 27625
AND option_id = 17
AND option_value_id = 3759
DELETE FROM oc_product
WHERE
model = '257234098'
INSERT INTO oc_product_option_value
SET
product_option_id = 513,
product_id = 27625,
option_id = 17,
option_value_id = 3759,
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 '257234198 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/257234198.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3760 AS option_value_id,
language_id,
17 AS option_id,
'257234198 - Médio para Óleo Talens Secagem Rápida S3 75 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 513
AND product_id = 27625
AND option_id = 17
AND option_value_id = 3760
DELETE FROM oc_product
WHERE
model = '257234198'
INSERT INTO oc_product_option_value
SET
product_option_id = 513,
product_id = 27625,
option_id = 17,
option_value_id = 3760,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27493
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '263309598 - %'
UPDATE oc_option_value
SET
image = 'catalog/263309598.jpg'
WHERE
option_value_id = 1933
UPDATE oc_option_value_description
SET
name = '263309598 - Tinta Óleo Talens Rembrandt T6 - 15 ml S1 Branco Mesclado'
WHERE
option_value_id = 1933
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 462
AND product_id = 27493
AND option_id = 17
AND option_value_id = 1933
DELETE FROM oc_product
WHERE
model = '263309598'
INSERT INTO oc_product_option_value
SET
product_option_id = 462,
product_id = 27493,
option_id = 17,
option_value_id = 1933,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.