Product Sync.
Opencart products: 73
Input products: 100
NEW: 100545499
NEW: 100545599
NEW: 100545699
NEW: 100545799
NEW: 100545899
NEW: 100545999
NEW: 100546099
NEW: 100546199
NEW: 100546299
NEW: 100546399
NEW: 100546499
NEW: 100546599
NEW: 100546699
NEW: 100546799
NEW: 100546899
NEW: 100546999
NEW: 100547099
NEW: 100547199
NEW: 100547299
NEW: 100547399
NEW: 100547499
NEW: 100547599
NEW: 100547699
NEW: 100547799
NEW: 100547899
NEW: 100547999
NEW: 100548099
NEW: 100548199
NEW: 100548299
NEW: 100548399
NEW: 100548499
NEW: 100548599
NEW: 100548699
NEW: 100548799
NEW: 100548899
NEW: 100548999
NEW: 100549099
NEW: 100549199
NEW: 100549299
NEW: 100549399
NEW: 100549499
NEW: 100549599
NEW: 100549699
NEW: 100549799
NEW: 100549899
NEW: 100549999
NEW: 100550099
NEW: 100550199
NEW: 100550299
NEW: 100550399
NEW: 100550499
NEW: 100550599
NEW: 100550699
NEW: 100550799
NEW: 100550899
NEW: 100550999
NEW: 100551099
NEW: 100551199
NEW: 100551299
NEW: 100551399
NEW: 100551499
NEW: 100551599
NEW: 100551699
NEW: 100551799
NEW: 100551899
NEW: 100551999
NEW: 100552099
NEW: 100552199
NEW: 100552299
NEW: 100552399
NEW: 100552499
NEW: 100552599
NEW: 100552699
NEW: 100552799
NEW: 100552899
NEW: 100552999
NEW: 100553099
NEW: 100553199
NEW: 100553299
NEW: 100553399
NEW: 100553499
NEW: 100553599
NEW: 100553699
NEW: 100553799
NEW: 100553899
NEW: 100553999
NEW: 100554099
NEW: 100554199
NEW: 100554299
UPDATING: Tela Art Creation
Product ID: 27460
Image file:
NEW: 100554499
NEW: 100554599
NEW: 100554699
NEW: 100554799
NEW: 100554899
NEW: 100554999
NEW: 100555099
NEW: 100555199
NEW: 100555299
NEW: 100555399
Ok.
Product Option Sync.
Opencart products: 73
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 = 27460
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100554399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3445 AS option_value_id,
language_id,
17 AS option_id,
'100554399 - Tela Medidas Especiais' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 439
AND product_id = 27460
AND option_id = 17
AND option_value_id = 3445
DELETE FROM oc_product
WHERE
model = '100554399'
INSERT INTO oc_product_option_value
SET
product_option_id = 439,
product_id = 27460,
option_id = 17,
option_value_id = 3445,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.