Product Sync.
Opencart products: 201
Input products: 100
NEW: 102343399
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102343399 - %'
)
NEW: 102343499
UPDATING: Tinta da China Winsor & Newton
Product ID: 27479
Image file:
NEW: 102343899
NEW: 102344099
NEW: 102344299
NEW: 102344699
NEW: 102344899
NEW: 102344999
NEW: 102345099
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102345099 - %'
)
NEW: 102345199
NEW: 102345299
NEW: 102345399
NEW: 102345499
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE '102345499 - %'
)
NEW: 102345599
NEW: 102345699
NEW: 102345799
NEW: 102345899
NEW: 102345999
NEW: 102346099
NEW: 102346199
NEW: 102346299
NEW: 102346399
NEW: Espátula Pintura
DELETE FROM oc_product_option_value
WHERE
option_value_id = (
SELECT
MAX(option_value_id)
FROM
oc_option_value_description
WHERE
name LIKE 'Espátula Pintura - %'
)
NEW: 102347499
NEW: 102347599
NEW: 102347699
NEW: 102347799
NEW: 102347899
NEW: 102347999
NEW: 102348099
NEW: 102348199
NEW: 102348299
NEW: 102348399
NEW: 102348499
NEW: 102348599
NEW: 102348699
NEW: 102348799
NEW: 102348899
NEW: 102348999
NEW: 102349099
NEW: 102349199
NEW: 102349299
NEW: 102349399
NEW: 102349499
NEW: 102349599
NEW: 102349699
NEW: 102349799
NEW: 102349899
NEW: 102349999
NEW: 102350099
NEW: 102350199
NEW: 102350299
NEW: 102350399
NEW: 102350499
NEW: 102350599
NEW: 102350699
NEW: 102350799
NEW: 102350899
NEW: 102350999
NEW: 102351099
NEW: 102351199
NEW: 102351299
NEW: 102351399
NEW: 102351499
NEW: 102351599
NEW: 102351699
NEW: 102351799
NEW: 102351899
NEW: 102351999
NEW: 102352099
NEW: 102352199
NEW: 102352299
NEW: 102352399
NEW: 102352499
NEW: 102352599
NEW: 102352699
NEW: 102352799
NEW: 102352899
NEW: 102352999
NEW: 102353099
NEW: 102353199
NEW: 102353299
Ok.
Product Option Sync.
Opencart products: 205
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 = 27479
AND option_id = 17
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102343599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3713 AS option_value_id,
language_id,
17 AS option_id,
'102343599 - Tinta da China Winsor & Newton Vermelho Escuro 14 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 452
AND product_id = 27479
AND option_id = 17
AND option_value_id = 3713
DELETE FROM oc_product
WHERE
model = '102343599'
INSERT INTO oc_product_option_value
SET
product_option_id = 452,
product_id = 27479,
option_id = 17,
option_value_id = 3713,
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 '102343699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3714 AS option_value_id,
language_id,
17 AS option_id,
'102343699 - Tinta da China Winsor & Newton Amarelo Canário 14 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 452
AND product_id = 27479
AND option_id = 17
AND option_value_id = 3714
DELETE FROM oc_product
WHERE
model = '102343699'
INSERT INTO oc_product_option_value
SET
product_option_id = 452,
product_id = 27479,
option_id = 17,
option_value_id = 3714,
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 '102343799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3715 AS option_value_id,
language_id,
17 AS option_id,
'102343799 - Tinta da China Winsor & Newton Carmim 14 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 452
AND product_id = 27479
AND option_id = 17
AND option_value_id = 3715
DELETE FROM oc_product
WHERE
model = '102343799'
INSERT INTO oc_product_option_value
SET
product_option_id = 452,
product_id = 27479,
option_id = 17,
option_value_id = 3715,
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 '102343999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3716 AS option_value_id,
language_id,
17 AS option_id,
'102343999 - Tinta da China Winsor & Newton Castanho Nut 14 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 452
AND product_id = 27479
AND option_id = 17
AND option_value_id = 3716
DELETE FROM oc_product
WHERE
model = '102343999'
INSERT INTO oc_product_option_value
SET
product_option_id = 452,
product_id = 27479,
option_id = 17,
option_value_id = 3716,
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 '102344199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3717 AS option_value_id,
language_id,
17 AS option_id,
'102344199 - Tinta da China Winsor & Newton Vermelho Tijolo 14 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 452
AND product_id = 27479
AND option_id = 17
AND option_value_id = 3717
DELETE FROM oc_product
WHERE
model = '102344199'
INSERT INTO oc_product_option_value
SET
product_option_id = 452,
product_id = 27479,
option_id = 17,
option_value_id = 3717,
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 '102344399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3718 AS option_value_id,
language_id,
17 AS option_id,
'102344399 - Tinta da China Winsor & Newton Scralet 14 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 452
AND product_id = 27479
AND option_id = 17
AND option_value_id = 3718
DELETE FROM oc_product
WHERE
model = '102344399'
INSERT INTO oc_product_option_value
SET
product_option_id = 452,
product_id = 27479,
option_id = 17,
option_value_id = 3718,
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 '102344499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3719 AS option_value_id,
language_id,
17 AS option_id,
'102344499 - Tinta da China Winsor & Newton Laranja 14 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 452
AND product_id = 27479
AND option_id = 17
AND option_value_id = 3719
DELETE FROM oc_product
WHERE
model = '102344499'
INSERT INTO oc_product_option_value
SET
product_option_id = 452,
product_id = 27479,
option_id = 17,
option_value_id = 3719,
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 '102344599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3720 AS option_value_id,
language_id,
17 AS option_id,
'102344599 - Tinta da China Winsor & Newton Verde Brilhante 14 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 452
AND product_id = 27479
AND option_id = 17
AND option_value_id = 3720
DELETE FROM oc_product
WHERE
model = '102344599'
INSERT INTO oc_product_option_value
SET
product_option_id = 452,
product_id = 27479,
option_id = 17,
option_value_id = 3720,
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 '102344799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3721 AS option_value_id,
language_id,
17 AS option_id,
'102344799 - Tinta da China Winsor & Newton Prata 14 ml' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 452
AND product_id = 27479
AND option_id = 17
AND option_value_id = 3721
DELETE FROM oc_product
WHERE
model = '102344799'
INSERT INTO oc_product_option_value
SET
product_option_id = 452,
product_id = 27479,
option_id = 17,
option_value_id = 3721,
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 = 27602
AND option_id = 17
INSERT INTO oc_product_option
SET
product_id = 27602,
option_id = 17,
value = '',
required = 1
SELECT DISTINCT option_value_id FROM oc_option_value_description
WHERE
name LIKE '102346499 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3722 AS option_value_id,
language_id,
17 AS option_id,
'102346499 - Espátula Pintura N25' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3722
DELETE FROM oc_product
WHERE
model = '102346499'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3722,
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 '102346599 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3723 AS option_value_id,
language_id,
17 AS option_id,
'102346599 - Espátula Pintura N29' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3723
DELETE FROM oc_product
WHERE
model = '102346599'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3723,
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 '102346699 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3724 AS option_value_id,
language_id,
17 AS option_id,
'102346699 - Espátula Pintura N30' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3724
DELETE FROM oc_product
WHERE
model = '102346699'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3724,
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 '102346799 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3725 AS option_value_id,
language_id,
17 AS option_id,
'102346799 - Espátula Pintura N27' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3725
DELETE FROM oc_product
WHERE
model = '102346799'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3725,
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 '102346899 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3726 AS option_value_id,
language_id,
17 AS option_id,
'102346899 - Espátula Pintura N20' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3726
DELETE FROM oc_product
WHERE
model = '102346899'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3726,
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 '102346999 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3727 AS option_value_id,
language_id,
17 AS option_id,
'102346999 - Espátula Pintura N22' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3727
DELETE FROM oc_product
WHERE
model = '102346999'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3727,
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 '102347099 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3728 AS option_value_id,
language_id,
17 AS option_id,
'102347099 - Espátula Pintura N28' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3728
DELETE FROM oc_product
WHERE
model = '102347099'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3728,
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 '102347199 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3729 AS option_value_id,
language_id,
17 AS option_id,
'102347199 - Espátula Pintura N21' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3729
DELETE FROM oc_product
WHERE
model = '102347199'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3729,
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 '102347299 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3730 AS option_value_id,
language_id,
17 AS option_id,
'102347299 - Espátula Pintura N2' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3730
DELETE FROM oc_product
WHERE
model = '102347299'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3730,
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 '102347399 - %'
INSERT INTO oc_option_value
SET
option_id = 17,
image = '',
sort_order = 0
INSERT INTO oc_option_value_description
SELECT
3731 AS option_value_id,
language_id,
17 AS option_id,
'102347399 - Espátula Pintura N26' AS name
FROM
oc_language
SELECT DISTINCT product_option_value_id FROM oc_product_option_value
WHERE
product_option_id = 505
AND product_id = 27602
AND option_id = 17
AND option_value_id = 3731
DELETE FROM oc_product
WHERE
model = '102347399'
INSERT INTO oc_product_option_value
SET
product_option_id = 505,
product_id = 27602,
option_id = 17,
option_value_id = 3731,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.