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.
{"Tinta Acr\u00edlica Winsor & Newton 120 ml":"26989","Bloco para Aguarela Winsor & Newton":"26990","Caixa e Conjunto de Aguarela Winsor & Newton":"26991","Cavalete de Studio":"26992","Aguarela Escolar":"26993","Pintura Facil":"26994","Guache Giotto Frasco 250 ml":"26995","Esp\u00e1tulas":"26996","Bloco para Aguarela Canson":"26997","Pintura a Dedos Digitais":"26998","Tinta Acr\u00edlica Talens Amsterdam 120ml":"26999","Paleta de Pl\u00e1stico":"27000","Tela Creattore":"27001","Guache Giotto Lav\u00e1vel 1000 ml":"27002","Guache Talens":"27003","Caixa e Conjunto de Tinta Acr\u00edlica Talens":"27004","Caixa e Conjunto de Aguarela Talens":"27005","Verniz Talens":"27006","Tento":"27007","Tubo Porta Pinceis Talens":"27008","Tinta Acr\u00edlica Winsor & Newton 60 ml":"27009","Aguarela Winsor & Newton Cotman Tubo ou Pastilha":"27010","Guache Giotto Tubo e Pastilha":"27011","Guache Giotto 500 ml":"27012","Guache Giotto 1000 ml":"27013","Guache Giotto Beb\u00e9 250 ml":"27014","White Spirit Talens":"27015","Mordente para Folha de Ouro":"27016","\u00d3leo de Linho Inart":"27017","Gesso Winsor & Newton":"27018","Paleta Descart\u00e1vel":"27019","Terebentina e Diluentes Inart":"27020","Pincel Escolar Scriva":"27021","Guache Pelikan":"27022","Tinta para Porcelana P\u00e9b\u00e9o Porcelaine":"27023","Aguarela L\u00edquida Ecoline":"27024","Pincel Escolar Giotto":"27025","Tinta Vitral P\u00e9b\u00e9o":"27026","Tinta Acr\u00edlica Winsor & Newton 250 ml":"27027","Cavalete Tripe":"27028","Pincel Escolar Pelikan":"27029","Tinta para Tecido P\u00e9b\u00e9o Setacolor":"27030","Auxiliares e Patinas":"27031","Tinta para Artes Decorativas P\u00e9b\u00e9o com efeito Prisma":"27032","Tinta da China Pelikan":"27033","Tela Talens":"27034","Tela Art Creation":"27035","Tinta Acr\u00edlica para Artes Decorativas P\u00e9b\u00e9o Decor":"27036","Verniz P\u00e9b\u00e9o":"27037","M\u00e9dio para Artes Decorativas":"27038","Gesso P\u00e9b\u00e9o":"27039","Gel de Textura e Estruturante P\u00e9b\u00e9o":"27040","M\u00e9dio para Acr\u00edlico P\u00e9b\u00e9o":"27041","M\u00e9dio para Tecido Setacolor":"27042","Tinta Relevo Cerne P\u00e9b\u00e9o":"27043","Bloco para Acr\u00edlico e \u00d3leo Talens":"27044","Bloco para Aguarela Talens":"27045","Cavalete de Mesa":"27046","Conjuntos de Pinc\u00e9is Talens":"27047","Tela Winsor & Newton":"27048","Tinta da China Winsor & Newton":"27049","Guache Giotto Lav\u00e1vel 500 ml":"27050","Guache Caran D\u00b4Ache":"27051","Pincel para Aguarela com Reservat\u00f3rio de \u00c1gua Pentel":"27052","Goma Laca Inart":"27053","Tinta da China Sennelier":"27054","Aventais":"27055","Tinta Acr\u00edlica Talens Amsterdam 500 ml":"27056","Tinta \u00d3leo Talens Rembrandt 15 ml":"27057","Caixa e Conjunto de Tinta \u00d3leo Winsor & Newton":"27058","Caixa e Conjunto de Tinta Acr\u00edlica Winsor & Newton":"27059","Tinta da China Talens":"27060","Pincel para Aguarela Talens S195":"27061","Lava Pinceis":"27062","Gel de Textura e Estruturante Talens":"27063","Pincel para Aguarela com Reservat\u00f3rio de \u00c1gua Derwent":"27064","Tinta Acr\u00edlica Winsor & Newton 500 ml":"27065","Paleta de Madeira":"27066","Caixas Vazias":"27067","Pincel para Aguarela Talens S191":"27068","Esticadores de Tela":"27069","Tinta para Lin\u00f3leo":"27070","Pincel para Aguarela Talens S194":"27071","Marcador Aguarela Winsor & Newton Cotman":"27072","Trincha Sint\u00e9tica Talens":"27073","Caixa e Conjunto de Tinta \u00d3leo Daler Rowney":"27074","Caixas e Conjuntos de Aguarela Daler Rowney":"27075","Bloco para Acr\u00edlico Daler Rowney":"27076","\u00d3leo de Linho P\u00e9b\u00e9o":"27077","Terebentina P\u00e9b\u00e9o":"27078","Pincel para \u00d3leo e Acr\u00edlico Cabo Curto Daler Rowney":"27079","M\u00e9dio para Aguarela e Tempera":"27080","Tinta Relevo P\u00e9b\u00e9o para Tecido":"27081","Tela Daler Rowney":"27082","Secativos e Retardadores P\u00e9b\u00e9o":"27083","M\u00e9dio para \u00d3leo P\u00e9b\u00e9o":"27084","Caixa e Conjunto de Tinta Acr\u00edlica Daler Rowney":"27085","M\u00e9dio para Acr\u00edlico Winsor & Newton":"27086","Caixa e Conjunto de Tinta \u00d3leo Talens":"27087","Cavalete de Campo":"27088","Bloco para Acr\u00edlico e \u00d3leo Winsor & Newton":"27089","Paleta de Acr\u00edlico":"27090","Gesso Ghiant":"27091","M\u00e9dio Inart Para Acr\u00edlico ou \u00d3leo":"27092","God\u00e9s":"27093","Gesso Daler Rowney":"27094","Gesso Talens":"27095","M\u00e9dio para \u00d3leo Talens":"27096","Pincel para \u00d3leo e Acr\u00edlico Espatulado Cerda Talens S210":"27097","Trincha Cerda Talens":"27098","Terebentina Talens":"27099","Bloco e Folha de Papel Fabriano para Aguarela":"27100","Tubo Porta Pinceis Daler Rowney PLAST EXTENS":"27101","Verniz Winsor and Newton":"27102","\u00d3leo de Linho Winsor and Newton":"27103","Tinta \u00d3leo Winsor & Newton 37 ml":"27104","\u00d3leo de Linho Talens":"27105","Tinta \u00d3leo Talens Van Gogh 20 ml":"27106","Terebentina e Diluentes Winsor & Newton":"27107","Tinta Acr\u00edlica Talens Van Gogh 40 ml":"27108","M\u00e9dio para Acr\u00edlico Talens":"27109","Secativos e Retardadores Talens":"27110","M\u00e9dio para \u00d3leo Winsor & Newton":"27111","Gel de Textura e Estruturante Winsor & Newton":"27112","Cart\u00e3o Tela":"27113","PASTA ARQ A4 PP PERS ELBA":"27114","Van Gogh 40ml":"27115","Bloco Aguarela Cotman 300 grs":"27116","100014199":"27117","100014299":"27118","Cavalete Estudio Trip\u00e9 Madeira Ecologico":"27119","Aguarela Escolar Giotto":"27120","100032099":"27121","100032199":"27122","100032299":"27123","100034699":"27124","Bloco Aguarela Canson XL":"27125","Bloco Aguarela Canson Vidalon R\u00fastico":"27126","Aguarela Escolar Jovi":"27127","100085699":"27128","100109999":"27129","Tela Creatore 3D":"27130","100144999":"27131","100145099":"27132","100145399":"27133","Verniz Talens para \u00d3leo de Retoque 75 ml":"27134","100147399":"27135","100147599":"27136","Pincel Talens Redondo para \u00d3leo\/Acr\u00edlico S295":"27137","Bloco Aguarela Canson Montval":"27138","Tela Creatore Premium":"27139","Guache Giotto Caixa":"27140","Folha Ouro e Prata P\u00e9b\u00e9o 14 x 14 cm Caixa com 25 Folhas":"27141","100253999":"27142","100254999":"27143","Diluente sem Cheiro Inart":"27144","Pincel Scriva":"27145","Verniz Amsterdam para \u00d3leo e para Acr\u00edlico":"27146","Cavalete Talens Trip\u00e9 New York":"27147","Pincel Pelikan 25A":"27148","Cera P\u00e9b\u00e9o Gedeo para Dourar":"27149","Verniz P\u00e9beo":"27150","100519099":"27151","M\u00e9dio para Vitral P\u00e9beo":"27152","100525499":"27153","Gel de Textura P\u00e9b\u00e9o Brilhante 100 ml":"27154","Gel de Textura de Areia P\u00e9b\u00e9o 250 ml":"27155","M\u00e9dio para \u00d3leo P\u00e9beo":"27156","100612099":"27157","100612199":"27158","100612299":"27159","Cavalete Mesa Art Creation Mira":"27160","100612699":"27161","Cavalete Trip\u00e9 Lyra":"27162","Cavalete Base Quadrada com Gaveta":"27163","Tela Winsor & Newton":"27164","Cavalete Talens Trip\u00e9 Madeira":"27165","Cavalete Trip\u00e9 Talens Isabelle":"27166","Guache Caran D\u00b4Ache com 5":"27167","Pincel Pentel com Reservat\u00f3rio":"27168","100972399":"27169","Aguarela Winsor & Newton Cotman Pastilha":"27170","101017599":"27171","101023499":"27172","101067999":"27173","101105899":"27174","101118999":"27175","101119099":"27176","101180099":"27177","Cavalete de Mesa Reeves Base Quadrada Surrey":"27178","Tinta da China Talens 490 ml":"27179","Pincel Talens Lingua de Gato Aguarela S195":"27180","101199299":"27181","101206499":"27182","M\u00e9dio Gel para Acr\u00edlico Extra Forte Talens":"27183","Pincel Derwent com Reservat\u00f3rio de \u00c1gua":"27184","101211599":"27185","101265799":"27186","Paleta de Madeira Oval":"27187","101286499":"27188","Guache Giotto Pintura a Dedos 750 ml":"27189","Pincel Talens Espatulado para \u00d3leo e Acr\u00edlico S234":"27190","101407099":"27191","Cavalete Estudio Luxo":"27192","Cavalete Trident Mini de Mesa 12016":"27193","101407599":"27194","Pincel Talens Aguarela S":"27195","101529099":"27196","Bloco para Acr\u00edlico Van Gogh":"27197","101590499":"27198","Pincel Talens Aguarela Espatulado S194":"27199","101666499":"27200","Trincha Talens Sint\u00e9tica S370":"27201","101801199":"27202","101801299":"27203","101802199":"27204","101802299":"27205","101802399":"27206","101802499":"27207","101804899":"27208","101804999":"27209","101812599":"27210","\u00d3leo de Linho P\u00e9beo Refinado":"27211","101832199":"27212","101842199":"27213","101844899":"27214","101851599":"27215","Pincel Daler Rowney Cabo Comprido Espatulado Curto":"27216","101956599":"27217","Pincel Daler Rowney de Cerda Cabo Comprido L\u00edngua de Gato":"27218","Pincel Daler Rowney de Cerda Cabo Comprido Espatulado Longo":"27219","Pincel Daler Rowney de Cerda Cabo Comprido Redondo":"27220","101971699":"27221","101972899":"27222","101972999":"27223","Pincel Daler Rowney Cabo Curto P\u00ealo Sint\u00e9tico Biselado":"27224","Pincel Daler Rowney Cabo Curto Espatulado":"27225","101973599":"27226","101973999":"27227","Pincel Daler Rowney Cabo Curto P\u00ealo Redondo":"27228","Pincel Daler Rowney Cabo Comprido Redondo":"27229","Pincel Daler Rowney Cabo Comprido Espatulado":"27230","101975999":"27231","101976099":"27232","102021699":"27233","Tela Daler Rowney Simply":"27234","102073299":"27235","Verniz Talens Spray":"27236","102114899":"27237","Secante P\u00e9b\u00e9o para \u00d3leo Courtrai":"27238","Terebentina Rectificada Inart":"27239","102198099":"27240","102205499":"27241","Cavalete Caixa Talens Aurore":"27242","102218799":"27243","102218899":"27244","102218999":"27245","102219599":"27246","102219699":"27247","102219799":"27248","102220299":"27249","102220399":"27250","Cavalete Combi Mesa Caixa Acril\u00edco Daler Rowney Graduate e Acess":"27251","102220599":"27252","102220699":"27253","102220799":"27254","102220899":"27255","102220999":"27256","102221099":"27257","102221199":"27258","102221299":"27259","102223899":"27260","102224099":"27261","102224199":"27262","102224699":"27263","102224799":"27264","102224899":"27265","102224999":"27266","102225099":"27267","Cavalete Mabef Campo Basico":"27268","102233799":"27269","Cavalete Trident de Mesa 14022":"27270","102332099":"27271","Bloco Espiral Aguarela Cotman":"27272","Bloco Aguarela Cotman 425 grs":"27273","102341999":"27274","102342099":"27275","Bloco \u00d3leo Winsor & Newton Winton 230 gr":"27276","102343399":"27277","102345099":"27278","102345499":"27279","Esp\u00e1tula Pintura":"27280","102409599":"27281","102429699":"27282","102429999":"27283","102447299":"27284","102451199":"27285","102451399":"27286","Pincel Giotto S400":"27287","102496799":"27288","102499199":"27289","102499299":"27290","102499799":"27291","102499899":"27292","102550399":"27293","102580399":"27294","102580499":"27295","Cavalete de Mesa Talens Caixa Callisto":"27296","Cavalete Art Creation Estudio Vesta":"27297","Cavalete Talens Trip\u00e9 Corona Kit":"27298","Cavalete Talens Trip\u00e9 Isabel Kit":"27299","Cavalete de Mesa Talens Ibiza Natural":"27300","243510098":"27301","Guache Giotto Tubo":"27302","M\u00e9dio Secante para \u00d3leo Talens":"27303","Paleta Acr\u00edlica Oval":"27304","264360699":"27305","267509698":"27306","Pincel Talens Espatulado de Cerda para \u00d3leo e Acr\u00edlico S210":"27307","Pincel Talens Redondo Cerda para \u00d3leo e Acr\u00edlico S211":"27308","Trincha Talens Cerda Branca S360":"27309","Terebentina Rectificada Talens":"27310","400833499":"27311","400833599":"27312","400833699":"27313","400834299":"27314","Bloco Fabriano Watercolour":"27315","415070199":"27316","421000302":"27317","425100598":"27318","430600399":"27319","431418999":"27320","440311399":"27321","God\u00e9 Duplo MOD":"27322","God\u00e9 Duplo para Paleta com Tampa":"27323","440501099":"27324","440501499":"27325","Verniz Winsor & Newton":"27326","Verniz Talens para \u00d3leo":"27327","Verniz Talens para \u00d3leo Damar":"27328","\u00d3leo de Linho Winsor & Newton":"27329","455053399":"27330","455054399":"27331","Terebentina Winsor & Newton 75 ml":"27332","479870199":"27333","479870299":"27334","479870699":"27335","491011199":"27336","491040299":"27337","491060199":"27338","491100199":"27339","M\u00e9dio para Acr\u00edlico Talens":"27340","491104899":"27341","491105899":"27342","491105999":"27343","491106099":"27344","491106299":"27345","491106399":"27346","491106499":"27347","491106599":"27348","491106899":"27349","Cavalete Estudio New Orleans 130 cm":"27350","Cavalete Campo Talens Umbra":"27351","Cavalete Mesa Talens Leda em Faia":"27352","Cavalete de Mesa Talens Elara em Faia":"27353","Cavalete Trip\u00e9 Combi Talens Pinho 180 cm, Tela e Caixa Acr\u00edlico ":"27354","Cavalete Estudio Talens Madrid em Faia":"27355","Cavalete Trip\u00e9 Combi Talens Pinho 180 cm, Tela e Caixa \u00d3leo Van ":"27356","Cavalete Campo Talens Metalico PRT":"27357","Cavalete Estudio Trip\u00e9 Madeira":"27358","Cavalete Trident Est\u00fadio Base Triangulo Ref. 12005":"27359","Cavalete Trident Est\u00fadio Prateleira para Baixo 12338":"27360","Cavalete Trdident Mini de Mesa 12014":"27361","491960199":"27362","491970199":"27363","491970399":"27364","491970499":"27365","492101199":"27366","492101399":"27367","492101499":"27368","492104099":"27369","492104499":"27370","492105999":"27371","492106099":"27372","492106399":"27373","493400699":"27374","494800199":"27375","496700699":"27376","496701799":"27377","Cart\u00e3o Tela Winsor & Newton":"27378","Galeria W&N 120ml":"27379"}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 =
AND option_id = 15
INSERT INTO oc_product_option
SET
product_id = ,
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 =
AND product_id =
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 = ,
product_id = ,
option_id = 15,
option_value_id = 1032,
quantity = 1,
subtract = 1,
price = 0,
price_prefix = '+',
points = 0,
points_prefix = '+',
weight = 0,
weight_prefix = '+'
Ok.