Product Sync.
Opencart products: 233
Input products: 100
NEW: 268901699
NEW: 268901799
NEW: Trincha Talens Cerda Branca S360
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Trincha Talens Cerda Branca S360 - %'
)
UPDATING: Trincha Talens Sintética S370
Product ID: 27526
Image file:
NEW: 268902699
NEW: 268902799
NEW: 268902899
NEW: 268902999
NEW: 268903099
NEW: 268903199
NEW: 268903299
NEW: 268903399
NEW: 268903499
NEW: 270961099
NEW: 270961699
NEW: 270961799
NEW: 270961899
NEW: 270961999
NEW: 270962099
NEW: 270962199
NEW: 270962299
NEW: 270962399
NEW: 270962499
NEW: 270962599
NEW: 270962699
NEW: 270962799
NEW: 270962899
NEW: 270962999
NEW: 270963099
NEW: 270963199
NEW: 270963299
NEW: 270963399
NEW: 270963499
NEW: 270963599
NEW: 270963699
NEW: 270963799
NEW: 270963899
NEW: 270963999
NEW: 270964099
NEW: 270964199
NEW: 270964299
NEW: 270964399
NEW: 270964499
NEW: 270964599
NEW: 270964699
NEW: 270964799
NEW: 270964899
NEW: 270964999
NEW: 270965099
NEW: 270965199
NEW: 270965299
NEW: 270965399
NEW: 270965499
NEW: 270965599
NEW: 270965699
NEW: 270965799
NEW: 270965899
NEW: 270965999
NEW: 270966099
NEW: 270966199
NEW: 270966299
NEW: 270966399
NEW: 270966499
NEW: 270966599
NEW: 270966699
NEW: 270967299
NEW: 271230043
NEW: 273700319
NEW: 273972699
NEW: 278704171
NEW: 278707564
NEW: 278710128
NEW: 278710228
NEW: 278711128
NEW: 278732598
NEW: 278750564
NEW: 278750764
NEW: 278751064
NEW: 278751264
NEW: 278781400
NEW: 279007067
NEW: 279360519
NEW: 279360619
NEW: 279360719
NEW: 279360819
NEW: 279360999
NEW: 279361019
NEW: 279361219
NEW: 279361819
NEW: 280200399
NEW: 280201099
NEW: 280202400
NEW: 280202500
NEW: 280202600
Ok.
Product Option Sync.
Opencart products: 234
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 = 27631
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27631,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '268901899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/268901899.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3840 AS option_value_id,
language_id,
17 AS option_id,
'268901899 - Trincha Talens Cerda Branca S360 N1/2' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 517
AND product_id = 27631
AND option_id = 17
AND option_value_id = 3840
DELETE FROM oc_product
WHERE
model = '268901899'
INSERT INTO oc_product_option_value
SET
product_option_id = 517,
product_id = 27631,
option_id = 17,
option_value_id = 3840,
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 '268901999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3841 AS option_value_id,
language_id,
17 AS option_id,
'268901999 - Trincha Talens Cerda Branca S360 N1' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 517
AND product_id = 27631
AND option_id = 17
AND option_value_id = 3841
DELETE FROM oc_product
WHERE
model = '268901999'
INSERT INTO oc_product_option_value
SET
product_option_id = 517,
product_id = 27631,
option_id = 17,
option_value_id = 3841,
quantity = 1,
subtract = 1,
price = 1.382,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '268902099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3842 AS option_value_id,
language_id,
17 AS option_id,
'268902099 - Trincha Talens Cerda Branca S360 N1 1/2' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 517
AND product_id = 27631
AND option_id = 17
AND option_value_id = 3842
DELETE FROM oc_product
WHERE
model = '268902099'
INSERT INTO oc_product_option_value
SET
product_option_id = 517,
product_id = 27631,
option_id = 17,
option_value_id = 3842,
quantity = 1,
subtract = 1,
price = 3.17,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '268902199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3843 AS option_value_id,
language_id,
17 AS option_id,
'268902199 - Trincha Talens Cerda Branca S360 N2' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 517
AND product_id = 27631
AND option_id = 17
AND option_value_id = 3843
DELETE FROM oc_product
WHERE
model = '268902199'
INSERT INTO oc_product_option_value
SET
product_option_id = 517,
product_id = 27631,
option_id = 17,
option_value_id = 3843,
quantity = 1,
subtract = 1,
price = 3.699,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '268902299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3844 AS option_value_id,
language_id,
17 AS option_id,
'268902299 - Trincha Talens Cerda Branca S360 N3' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 517
AND product_id = 27631
AND option_id = 17
AND option_value_id = 3844
DELETE FROM oc_product
WHERE
model = '268902299'
INSERT INTO oc_product_option_value
SET
product_option_id = 517,
product_id = 27631,
option_id = 17,
option_value_id = 3844,
quantity = 1,
subtract = 1,
price = 6.91,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT product_option_id FROM oc_product_option
WHERE
product_id = 27526
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '268902399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = 'catalog/268902399.jpg',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3845 AS option_value_id,
language_id,
17 AS option_id,
'268902399 - Trincha Talens Sintética S370 N1/2' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 481
AND product_id = 27526
AND option_id = 17
AND option_value_id = 3845
DELETE FROM oc_product
WHERE
model = '268902399'
INSERT INTO oc_product_option_value
SET
product_option_id = 481,
product_id = 27526,
option_id = 17,
option_value_id = 3845,
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 '268902499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3846 AS option_value_id,
language_id,
17 AS option_id,
'268902499 - Trincha Talens Sintética S370 N1' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 481
AND product_id = 27526
AND option_id = 17
AND option_value_id = 3846
DELETE FROM oc_product
WHERE
model = '268902499'
INSERT INTO oc_product_option_value
SET
product_option_id = 481,
product_id = 27526,
option_id = 17,
option_value_id = 3846,
quantity = 1,
subtract = 1,
price = 2.195,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '268902599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3847 AS option_value_id,
language_id,
17 AS option_id,
'268902599 - Trincha Talens Sintética S370 N1 1/2' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 481
AND product_id = 27526
AND option_id = 17
AND option_value_id = 3847
DELETE FROM oc_product
WHERE
model = '268902599'
INSERT INTO oc_product_option_value
SET
product_option_id = 481,
product_id = 27526,
option_id = 17,
option_value_id = 3847,
quantity = 1,
subtract = 1,
price = 3.74,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.