Product Sync.
Opencart products: 391
Input products: 1
{"Galeria W&N 120ml":{"model":"Galeria W&N 120ml","desc":"Galeria W&N 120ml","description":{"0":"\n\n"},"family":"PINTURA\\\\TINTAS\\\\ACRILICO","custom_category":"2 - PINTURA > TINTA ACR\u00cdLICA","price":"4.797","stock":"0","tax":"23","image":{},"status":"1","brand":"W & N"}}UPDATING: Galeria W&N 120ml
Product ID: 27379
Image file:
Ok.
Product Option Sync.
Opencart products: 391
Input products: 1
{"Galeria W&N 120ml":[{"model":"100009099","desc":"ACRIL GALER 120ML MARS BLACK Test","description":{"0":"\n\n"},"family":"PINTURA\\\\TINTAS\\\\ACRILICO","price":"4.797","price_total_tax":"5.9","stock":"0","tax":"23","image":{},"status":"1","family_status":"1","parent_group":"Galeria W&N 120ml","parent_group_image":{},"custom_category":"2 - PINTURA > TINTA ACR\u00cdLICA","brand":"W & N","tags":{},"weight":"0"}]}SELECT option_id FROM oc_option_description
WHERE
NAME = 'Opção'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27379
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = 27379,
option_id = 15,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '100009099 - %'
UPDATE oc_option_value
SET
image = NULL
WHERE
option_value_id = 1032
UPDATE oc_option_value_description
SET
name = '100009099 - ACRIL GALER 120ML MARS BLACK Test'
WHERE
option_value_id = 1032
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 372
AND product_id = 27379
AND option_id = 15
AND option_value_id = 1032
DELETE FROM oc_product
WHERE
model = '100009099'
INSERT INTO oc_product_option_value
SET
product_option_id = 372,
product_id = 27379,
option_id = 15,
option_value_id = 1032,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.