{"id":1136,"date":"2024-08-23T14:47:47","date_gmt":"2024-08-23T17:47:47","guid":{"rendered":"https:\/\/kickstarter.infinitoag.com\/docs\/?p=1136"},"modified":"2024-08-23T15:54:48","modified_gmt":"2024-08-23T18:54:48","slug":"como-importar-produtos","status":"publish","type":"post","link":"https:\/\/kickstarter.infinitoag.com\/docs\/como-importar-produtos\/","title":{"rendered":"Como importar produtos"},"content":{"rendered":"\n<div class=\"wp-block-uagb-container uagb-block-e6b95f08 alignfull uagb-is-root-container\"><div class=\"uagb-container-inner-blocks-wrap\">\t\t\t\t<div class=\"wp-block-uagb-table-of-contents uagb-toc__align-left uagb-toc__columns-1  uagb-block-f9b68cc5      \"\n\t\t\t\t\tdata-scroll= \"1\"\n\t\t\t\t\tdata-offset= \"30\"\n\t\t\t\t\tstyle=\"\"\n\t\t\t\t>\n\t\t\t\t<div class=\"uagb-toc__wrap\">\n\t\t\t\t\t\t<div class=\"uagb-toc__title\">\n\t\t\t\t\t\t\t<strong>Neste artigo<\/strong>\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"uagb-toc__list-wrap \">\n\t\t\t\t\t\t<ol class=\"uagb-toc__list\"><li class=\"uagb-toc__list\"><a href=\"#passo-1-limpar-a-planilha\" class=\"uagb-toc-link__trigger\">Passo 1 : Limpar a planilha<\/a><li class=\"uagb-toc__list\"><a href=\"#passo-2-salvar-a-planilha\" class=\"uagb-toc-link__trigger\">Passo 2 : Salvar a planilha<\/a><li class=\"uagb-toc__list\"><a href=\"#passo-3-acessar-o-painel-de-administra\u00e7\u00e3o-do-wordpress\" class=\"uagb-toc-link__trigger\">Passo 3 : Acessar o painel de administra\u00e7\u00e3o do WordPress.<\/a><li class=\"uagb-toc__list\"><a href=\"#passo-4-importar-os-produtos\" class=\"uagb-toc-link__trigger\">Passo 4 : Importar os produtos<\/a><li class=\"uagb-toc__list\"><a href=\"#passo-5-mapear-campos-do-csv\" class=\"uagb-toc-link__trigger\">Passo 5 : Mapear campos do CSV<\/a><\/ol>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-a54dd92e\"><h2 class=\"uagb-heading-text\">Passo 1 : Limpar a planilha <\/h2><\/div>\n\n\n\n<ul style=\"padding-left:50px\" class=\"wp-block-list\">\n<li>Nesse primeiro momento voc\u00ea deve realizar a limpeza da planilha , deixando apenas os campos que realmente ser\u00e3o utilizados na importa\u00e7\u00e3o dos produtos. <\/li>\n\n\n\n<li>Campos que ser\u00e3o necess\u00e1rio permanecer na planilha ,(excluir qualquer campo diferente):\n<ul class=\"wp-block-list\">\n<li><strong>REFER\u00caNCIA<\/strong> ou <strong>C\u00d3DIGO <\/strong><\/li>\n\n\n\n<li><strong>PRODUTO<\/strong> <\/li>\n\n\n\n<li><strong>P.VENDA<\/strong> <\/li>\n\n\n\n<li><strong>ESTOQUE<\/strong> <\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-03c430d1\"><h2 class=\"uagb-heading-text\">Passo 2 : Salvar a planilha<\/h2><\/div>\n\n\n\n<ul style=\"padding-left:50px\" class=\"wp-block-list\">\n<li>Agora que voc\u00ea j\u00e1 formatou a planilha deixando apenas os campos necess\u00e1rios , o pr\u00f3ximo passo ser\u00e1 de salvar essa planilha no formato de arquivo <strong>CSV<\/strong> (<strong>valores separados por v\u00edrgulas<\/strong>) que \u00e9 um arquivo de texto com formato espec\u00edfico para possibilitar o salvamento dos dados em um formato estruturado de tabela.<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-483853d3\"><h2 class=\"uagb-heading-text\">Passo 3 : Acessar o painel de administra\u00e7\u00e3o do WordPress.<\/h2><\/div>\n\n\n\n<ul style=\"padding-left:50px\" class=\"wp-block-list\">\n<li>Agora que voc\u00ea j\u00e1 formatou a planilha com os produtos de maneira correta, voc\u00ea deve importar as informa\u00e7\u00f5es dos produtos para dentro do seu site.<\/li>\n\n\n\n<li>Por isso voc\u00ea vai precisar realizar o acesso no <a href=\"https:\/\/kickstarter.infinitoag.com\/docs\/como-accesar-o-painel-admin\/\">painel de administra\u00e7\u00e3o<\/a> do seu site. <\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-c2242540\"><h2 class=\"uagb-heading-text\">Passo 4 : Importar os produtos<\/h2><\/div>\n\n\n\n<ul style=\"padding-left:50px\" class=\"wp-block-list\">\n<li>Dentro do painel voc\u00ea deve ir em <strong>Produtos<\/strong> e depois em  <strong>Importar Produto<\/strong>.<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-d5e75fa1 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" srcset=\"https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/IMPORTAR-PRODUTO.png ,https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/IMPORTAR-PRODUTO.png 780w, https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/IMPORTAR-PRODUTO.png 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/IMPORTAR-PRODUTO.png\" alt=\"\" class=\"uag-image-1139\" width=\"675\" height=\"503\" title=\"IMPORTAR PRODUTO\" loading=\"lazy\" role=\"img\"><\/figure><\/div>\n\n\n\n<ul style=\"padding-left:50px\" class=\"wp-block-list\">\n<li>Nessa nova janela voc\u00ea deve clicar em <strong>&#8220;Escolher Arquivo&#8221;<\/strong> , depois ir at\u00e9 o locar em que voc\u00ea salvou a planilha em seu computador ou celular e seleciona-la.<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-90aee56d wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" srcset=\"https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/importar-produtos-2-1024x543.png ,https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/importar-produtos-2.png 780w, https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/importar-produtos-2.png 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/importar-produtos-2-1024x543.png\" alt=\"\" class=\"uag-image-1141\" width=\"1033\" height=\"548\" title=\"importar produtos 2\" loading=\"lazy\" role=\"img\"><\/figure><\/div>\n\n\n\n<ul style=\"padding-left:50px\" class=\"wp-block-list\">\n<li>Clique em <strong>&#8220;Exibir op\u00e7\u00f5es avan\u00e7adas&#8221; <\/strong><\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-b1983c59 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" srcset=\"https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/IMPORTAR-PRODUTO-2.png ,https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/IMPORTAR-PRODUTO-2.png 780w, https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/IMPORTAR-PRODUTO-2.png 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/IMPORTAR-PRODUTO-2.png\" alt=\"\" class=\"uag-image-1142\" width=\"940\" height=\"544\" title=\"IMPORTAR PRODUTO 2\" loading=\"lazy\" role=\"img\"><\/figure><\/div>\n\n\n\n<ul style=\"padding-left:50px\" class=\"wp-block-list\">\n<li>Agora procure pelo campo <strong>&#8220;Delimitador do CSV&#8221;<\/strong> <\/li>\n\n\n\n<li>Nesse campo \u00e9 necess\u00e1rio o preenchimento de um caractere especifico(<strong>normalmente \u00e9 virgula)<\/strong> utilizado na separa\u00e7\u00e3o das informa\u00e7\u00f5es dos produtos.<\/li>\n\n\n\n<li>Para realizar o preenchimento correto desse campo voc\u00ea deve abrir o arquivo <strong>CSV<\/strong> que salvamos com o bloco de notas.<\/li>\n\n\n\n<li>Ap\u00f3s isso preencha o campo  com o caractere correto.<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-7ac3f444 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" srcset=\"https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/importar-produto-3.png ,https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/importar-produto-3.png 780w, https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/importar-produto-3.png 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/importar-produto-3.png\" alt=\"\" class=\"uag-image-1144\" width=\"723\" height=\"452\" title=\"importar produto 3\" loading=\"lazy\" role=\"img\"><\/figure><\/div>\n\n\n\n<ul style=\"padding-left:50px\" class=\"wp-block-list\">\n<li>Depois clique em &#8220;<strong>Continuar<\/strong>&#8220;<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-134835b0 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" srcset=\"https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/importar-produto-4.png ,https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/importar-produto-4.png 780w, https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/importar-produto-4.png 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/importar-produto-4.png\" alt=\"\" class=\"uag-image-1146\" width=\"784\" height=\"773\" title=\"importar produto 4]\" loading=\"lazy\" role=\"img\"><\/figure><\/div>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-29cb8be8\"><h2 class=\"uagb-heading-text\">Passo 5 : Mapear campos do CSV<\/h2><\/div>\n\n\n\n<ul style=\"padding-left:50px\" class=\"wp-block-list\">\n<li>Nessa nova janela., voc\u00ea deve selecionar os campos a partir do seu arquivo CSV para mapear contra os campos dos produto,<\/li>\n\n\n\n<li><strong>REFER\u00caNCIA <\/strong>ou <strong>C\u00d3DIGO<\/strong> vai ser <strong>&#8220;SKU&#8221;<\/strong><\/li>\n\n\n\n<li>PRODUTO vai ser <strong>&#8220;NOME&#8221;<\/strong><\/li>\n\n\n\n<li>ESTOQUE vai ser <strong>&#8220;ESTOQUE&#8221;<\/strong><\/li>\n\n\n\n<li>P.VENDA vai ser <strong>&#8220;PRE\u00c7O&#8221;<\/strong><\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-684e4d0f wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" srcset=\"https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/importar-proasd.png ,https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/importar-proasd.png 780w, https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/importar-proasd.png 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/importar-proasd.png\" alt=\"\" class=\"uag-image-1147\" width=\"844\" height=\"609\" title=\"importar proasd\" loading=\"lazy\" role=\"img\"><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ap\u00f3s mapear corretamente os campos , clique em <strong>&#8220;Executar o importador&#8221;<\/strong><\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-d607a62e wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" srcset=\"https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/importar-mais-ujma-vez.png ,https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/importar-mais-ujma-vez.png 780w, https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/importar-mais-ujma-vez.png 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/kickstarter.infinitoag.com\/docs\/wp-content\/uploads\/2024\/08\/importar-mais-ujma-vez.png\" alt=\"\" class=\"uag-image-1148\" width=\"844\" height=\"609\" title=\"importar mais ujma vez\" loading=\"lazy\" role=\"img\"><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ap\u00f3s isso , ele vai come\u00e7ar a importar os produtos , isso pode demorar alguns minutos ou at\u00e9 horas.<\/li>\n<\/ul>\n\n\n\n<p style=\"font-size:20px\">Realizando esse tutorial corretamente , voc\u00ea vai ter conclu\u00eddo com sucesso a importa\u00e7\u00e3o de produtos de uma planilha para o seu site.<\/p>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Passo 1 : Limpar a planilha Passo 2 : Salvar a planilha Passo 3 : Acessar o painel de administra\u00e7\u00e3o [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[44],"tags":[],"class_list":["post-1136","post","type-post","status-publish","format-standard","hentry","category-outros-assuntos"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"woocommerce_thumbnail":false,"woocommerce_single":false,"woocommerce_gallery_thumbnail":false},"uagb_author_info":{"display_name":"admin","author_link":"https:\/\/kickstarter.infinitoag.com\/docs\/author\/administrador\/"},"uagb_comment_info":0,"uagb_excerpt":"Passo 1 : Limpar a planilha Passo 2 : Salvar a planilha Passo 3 : Acessar o painel de administra\u00e7\u00e3o [&hellip;]","_links":{"self":[{"href":"https:\/\/kickstarter.infinitoag.com\/docs\/wp-json\/wp\/v2\/posts\/1136","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kickstarter.infinitoag.com\/docs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kickstarter.infinitoag.com\/docs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kickstarter.infinitoag.com\/docs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kickstarter.infinitoag.com\/docs\/wp-json\/wp\/v2\/comments?post=1136"}],"version-history":[{"count":0,"href":"https:\/\/kickstarter.infinitoag.com\/docs\/wp-json\/wp\/v2\/posts\/1136\/revisions"}],"wp:attachment":[{"href":"https:\/\/kickstarter.infinitoag.com\/docs\/wp-json\/wp\/v2\/media?parent=1136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kickstarter.infinitoag.com\/docs\/wp-json\/wp\/v2\/categories?post=1136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kickstarter.infinitoag.com\/docs\/wp-json\/wp\/v2\/tags?post=1136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}