{"id":15990951,"date":"2024-01-31T13:32:27","date_gmt":"2024-01-31T13:32:27","guid":{"rendered":"https:\/\/wpml.org\/documentacao\/projetos-relacionados\/exportacao-e-importacao-wpml\/preparando-arquivos-xml-e-csv-para-importar-dados-multilingues-com-wpml-export-and-import\/"},"modified":"2026-02-26T08:04:18","modified_gmt":"2026-02-26T08:04:18","slug":"preparando-arquivos-xml-e-csv-para-importar-dados-multilingues-com-wpml-export-and-import","status":"publish","type":"page","link":"https:\/\/wpml.org\/pt-br\/documentacao\/projetos-relacionados\/exportacao-e-importacao-wpml\/preparando-arquivos-xml-e-csv-para-importar-dados-multilingues-com-wpml-export-and-import\/","title":{"rendered":"Preparando arquivos XML e CSV para importar dados multil\u00edngues com o WPML Export and Import"},"content":{"rendered":"\n<p class=\"lead\">Saiba como adicionar colunas de idioma a planilhas para importar conte\u00fado multil\u00edngue para um novo site, permitindo que o WPML Export and Import atribua detalhes de idioma e conecte tradu\u00e7\u00f5es.<\/p>\n\n<h2 class=\"wp-block-heading\" id=\"when-to-manually-prepare-import-files\">Quando Voc\u00ea Precisa Preparar Manualmente Arquivos XML ou CSV<\/h2>\n\n<p>Se voc\u00ea usar <a href=\"https:\/\/wpml.org\/pt-br\/documentacao\/projetos-relacionados\/exportacao-e-importacao-wpml\/\">plugins compat\u00edveis para migrar conte\u00fado entre sites WordPress<\/a>, o WPML Export and Import adicionar\u00e1 automaticamente os detalhes de idioma aos seus arquivos.  <\/p>\n\n<p>No entanto, h\u00e1 momentos em que voc\u00ea pode precisar criar os arquivos CSV voc\u00ea mesmo, por exemplo:<\/p>\n\n<ul class=\"wp-block-list\">\n<li>Voc\u00ea mant\u00e9m conte\u00fado multil\u00edngue em planilhas e deseja importar o conte\u00fado diretamente da planilha<\/li>\n\n\n\n<li>Seu plugin de exporta\u00e7\u00e3o ainda n\u00e3o \u00e9 compat\u00edvel com o WPML Export and Import, portanto o arquivo CSV ou XML que seu plugin de exporta\u00e7\u00e3o gera n\u00e3o inclui automaticamente as informa\u00e7\u00f5es de idioma<\/li>\n<\/ul>\n\n<p>Nesses casos, voc\u00ea precisar\u00e1 adicionar manualmente as informa\u00e7\u00f5es de idioma \u00e0s suas planilhas. Voc\u00ea aprender\u00e1 como preparar o arquivo abaixo, mas tamb\u00e9m pode assistir ao nosso v\u00eddeo passo a passo para uma explica\u00e7\u00e3o visual. <\/p>\n\n<div class=\"tb-youtube\" data-toolset-blocks-youtube=\"2858aa87bb1de5c7c02ac0833dcae2a2\"><div><iframe data-src=\"https:\/\/www.youtube.com\/embed\/f34HTBgMdPk?rel=0&#038;toolset=1\" frameBorder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/div><\/div>\n\n<h2 class=\"wp-block-heading\">Plugins necess\u00e1rios<\/h2>\n\n<p>Instale e ative os seguintes plugins no site para o qual voc\u00ea est\u00e1 importando:<\/p>\n\n<ul class=\"wp-block-list\">\n<li>Seu plugin de importa\u00e7\u00e3o preferido<\/li>\n\n\n\n<li>WPML  <\/li>\n\n\n\n<li>WPML String Translation<\/li>\n\n\n\n<li>WPML Export and Import<\/li>\n\n\n\n<li>WPML Multilingual &amp; Multicurrency for WooCommerce (somente se voc\u00ea estiver importando produtos do WooCommerce)<\/li>\n<\/ul>\n\n<h2 class=\"wp-block-heading\" id=\"creating-spreadsheets-with-language-columns\">1. Crie Planilhas com Colunas de Idioma <\/h2>\n\n<p>Dependendo da sua ferramenta de importa\u00e7\u00e3o, voc\u00ea pode precisar preparar uma ou duas planilhas.<\/p>\n\n<p>Para o <a href=\"https:\/\/www.wpallimport.com\/\">WP All Import Pro<\/a> e plugins de importa\u00e7\u00e3o semelhantes, crie duas planilhas:<\/p>\n\n<ul class=\"wp-block-list\">\n<li>Uma para taxonomias (por exemplo, categorias, tags, categorias de produtos).<\/li>\n\n\n\n<li>Outra para posts (incluindo p\u00e1ginas, produtos e outros tipos de post).<\/li>\n<\/ul>\n\n<p>Para o <a href=\"https:\/\/woo.com\/document\/product-csv-importer-exporter\/\">importador CSV nativo do WooCommerce<\/a>, voc\u00ea precisa apenas de uma planilha, com as categorias de produto inclu\u00eddas nas linhas que detalham os pr\u00f3prios produtos.<\/p>\n\n<p>Cada planilha deve incluir os detalhes de conte\u00fado usuais, juntamente com tr\u00eas colunas de idioma cruciais para WPML:<\/p>\n\n<ul class=\"wp-block-list\">\n<li><strong>_wpml_import_translation_group<\/strong>: Use esta coluna para um valor exclusivo que associa o conte\u00fado do idioma padr\u00e3o com suas tradu\u00e7\u00f5es. Para sites de e-commerce, use o SKU do produto. Se n\u00e3o houver SKU, use um ID de tradu\u00e7\u00e3o (<strong>trid<\/strong>). Este \u00e9 um n\u00famero de ID que voc\u00ea cria, que deve ser o mesmo para cada parte do conte\u00fado e suas tradu\u00e7\u00f5es.  <\/li>\n\n\n\n<li><strong>_wpml_import_language_code:<\/strong> Indique o c\u00f3digo do idioma para cada item, por exemplo <strong>en<\/strong> para ingl\u00eas, <strong>es<\/strong> para espanhol). <a href=\"https:\/\/en.wikipedia.org\/wiki\/List_of_ISO_639_language_codes\">Consulte os padr\u00f5es ISO<\/a> para idiomas personalizados (por exemplo, \u201ces-MX\u201d para espanhol mexicano).<\/li>\n\n\n\n<li><strong>_wpml_import_source_language_code<\/strong>: Use esta coluna para especificar o c\u00f3digo de idioma original do conte\u00fado. Este campo \u00e9 necess\u00e1rio apenas para tradu\u00e7\u00f5es e voc\u00ea pode deix\u00e1-lo vazio para conte\u00fado no idioma de origem. <\/li>\n<\/ul>\n\n<p>Aqui est\u00e1 um resumo das informa\u00e7\u00f5es que sua(s) planilha(s) deve(m) conter:<\/p>\n\n<div class=\"wp-block-toolset-blocks-container tb-container\" data-toolset-blocks-container=\"ac2475577c136840daf4101b936a8f4f\">\n<div class=\"wp-block-toolset-blocks-grid tb-grid\" data-toolset-blocks-grid=\"d70bbb145b06936c9085b50b6bb23fc7\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<p class=\"tb-heading has-text-color has-background wa aligncenter\" data-toolset-blocks-heading=\"70a551bfdc2ae08056668566d8d03055\" data-last-update=\"1.4\">Detalhes do Conte\u00fado<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid tb-grid\" data-toolset-blocks-grid=\"71040d8e170c45a44dd5047215200d9a\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"98575fc8df596fef3a971c1c1e73e063\">\n<p class=\"tb-heading\" data-toolset-blocks-heading=\"af8f0a1b54c0a15c59e6b9a402ff8035\" data-last-update=\"1.4\"><strong>Planilha de Taxonomias<\/strong><\/p>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid tb-grid\" data-toolset-blocks-grid=\"dbc5b0208a44f3fb5d3407edd4239182\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<div class=\"wp-block-toolset-blocks-container tb-container\" data-toolset-blocks-container=\"129cbcdfb5323433411d290d31e42b73\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<p class=\"tb-heading\" data-toolset-blocks-heading=\"adef0d439dc185d9052242e930df1467\" data-last-update=\"1.4\">ID do termo (use os IDs de termo existentes se voc\u00ea estiver atualizando os termos j\u00e1 no site)<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid tb-grid\" data-toolset-blocks-grid=\"6d884e3758259a6ca2a13b9bfa8772d8\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<div class=\"wp-block-toolset-blocks-container tb-container\" data-toolset-blocks-container=\"b8460dc948ec9674fef4ce21d4f70fb0\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<p class=\"tb-heading\" data-toolset-blocks-heading=\"adef0d439dc185d9052242e930df1467\" data-last-update=\"1.4\">Nome e slug<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid tb-grid\" data-toolset-blocks-grid=\"99cc3a5ab60df794a57bb6b8d25eb72b\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<div class=\"wp-block-toolset-blocks-container tb-container\" data-toolset-blocks-container=\"129cbcdfb5323433411d290d31e42b73\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<p class=\"tb-heading\" data-toolset-blocks-heading=\"adef0d439dc185d9052242e930df1467\" data-last-update=\"1.4\">ID, nome e slug do pai (se aplic\u00e1vel, adicione itens pai antes dos filhos)<\/p>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"25b3ebdc7ce824ff67ca020ac661e474\">\n<p class=\"tb-heading\" data-toolset-blocks-heading=\"af8f0a1b54c0a15c59e6b9a402ff8035\" data-last-update=\"1.4\"><strong><strong>Planilha de tipos de post<\/strong><\/strong><\/p>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid tb-grid\" data-toolset-blocks-grid=\"dbc5b0208a44f3fb5d3407edd4239182\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<div class=\"wp-block-toolset-blocks-container tb-container\" data-toolset-blocks-container=\"b8460dc948ec9674fef4ce21d4f70fb0\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<p class=\"tb-heading\" data-toolset-blocks-heading=\"adef0d439dc185d9052242e930df1467\" data-last-update=\"1.4\">T\u00edtulos de post\/p\u00e1gina<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid tb-grid\" data-toolset-blocks-grid=\"6d884e3758259a6ca2a13b9bfa8772d8\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<div class=\"wp-block-toolset-blocks-container tb-container\" data-toolset-blocks-container=\"b8460dc948ec9674fef4ce21d4f70fb0\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<p class=\"tb-heading\" data-toolset-blocks-heading=\"adef0d439dc185d9052242e930df1467\" data-last-update=\"1.4\">IDs de post\/produto<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid tb-grid\" data-toolset-blocks-grid=\"f47abe1a6ffe1578fa5e403632753c33\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<div class=\"wp-block-toolset-blocks-container tb-container\" data-toolset-blocks-container=\"b8460dc948ec9674fef4ce21d4f70fb0\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<p class=\"tb-heading\" data-toolset-blocks-heading=\"adef0d439dc185d9052242e930df1467\" data-last-update=\"1.4\">Conte\u00fado principal e URLs de imagem em destaque<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid tb-grid\" data-toolset-blocks-grid=\"f47abe1a6ffe1578fa5e403632753c33\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<div class=\"wp-block-toolset-blocks-container tb-container\" data-toolset-blocks-container=\"b8460dc948ec9674fef4ce21d4f70fb0\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<p class=\"tb-heading\" data-toolset-blocks-heading=\"adef0d439dc185d9052242e930df1467\" data-last-update=\"1.4\">Categorias atribu\u00eddas ou categorias de produtos<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid tb-grid\" data-toolset-blocks-grid=\"f47abe1a6ffe1578fa5e403632753c33\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<div class=\"wp-block-toolset-blocks-container tb-container\" data-toolset-blocks-container=\"b8460dc948ec9674fef4ce21d4f70fb0\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<p class=\"tb-heading\" data-toolset-blocks-heading=\"adef0d439dc185d9052242e930df1467\" data-last-update=\"1.4\">Rela\u00e7\u00f5es pai-filho (se aplic\u00e1vel, liste os itens pai primeiro)<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid tb-grid\" data-toolset-blocks-grid=\"f47abe1a6ffe1578fa5e403632753c33\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<div class=\"wp-block-toolset-blocks-container tb-container\" data-toolset-blocks-container=\"b8460dc948ec9674fef4ce21d4f70fb0\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<p class=\"tb-heading\" data-toolset-blocks-heading=\"adef0d439dc185d9052242e930df1467\" data-last-update=\"1.4\">*(WooCommerce apenas) Tipo de produto, atributos e pre\u00e7os (consulte <a href=\"#custom-attributes-column\">informa\u00e7\u00f5es sobre atributos personalizados<\/a>)<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid tb-grid\" data-toolset-blocks-grid=\"dbc5b0208a44f3fb5d3407edd4239182\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<div class=\"wp-block-toolset-blocks-container tb-container\" data-toolset-blocks-container=\"b8460dc948ec9674fef4ce21d4f70fb0\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<p class=\"tb-heading\" data-toolset-blocks-heading=\"adef0d439dc185d9052242e930df1467\" data-last-update=\"1.4\">*(WooCommerce apenas) ID da varia\u00e7\u00e3o do produto e ID do produto pai<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n<div class=\"wp-block-toolset-blocks-container tb-container\" data-toolset-blocks-container=\"ac2475577c136840daf4101b936a8f4f\">\n<div class=\"wp-block-toolset-blocks-grid tb-grid\" data-toolset-blocks-grid=\"d70bbb145b06936c9085b50b6bb23fc7\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<p class=\"tb-heading has-text-color has-background wa aligncenter\" data-toolset-blocks-heading=\"70a551bfdc2ae08056668566d8d03055\" data-last-update=\"1.4\">Colunas de idioma (para WPML)<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid tb-grid\" data-toolset-blocks-grid=\"71040d8e170c45a44dd5047215200d9a\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"98575fc8df596fef3a971c1c1e73e063\">\n<p class=\"tb-heading\" data-toolset-blocks-heading=\"af8f0a1b54c0a15c59e6b9a402ff8035\" data-last-update=\"1.4\"><strong>Planilha de Taxonomias<\/strong><\/p>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid tb-grid\" data-toolset-blocks-grid=\"dbc5b0208a44f3fb5d3407edd4239182\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<div class=\"wp-block-toolset-blocks-container tb-container\" data-toolset-blocks-container=\"129cbcdfb5323433411d290d31e42b73\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<p class=\"tb-heading\" data-toolset-blocks-heading=\"adef0d439dc185d9052242e930df1467\" data-last-update=\"1.4\">_wpml_import_translation_group<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid tb-grid\" data-toolset-blocks-grid=\"6d884e3758259a6ca2a13b9bfa8772d8\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<div class=\"wp-block-toolset-blocks-container tb-container\" data-toolset-blocks-container=\"b8460dc948ec9674fef4ce21d4f70fb0\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<p class=\"tb-heading\" data-toolset-blocks-heading=\"adef0d439dc185d9052242e930df1467\" data-last-update=\"1.4\">_wpml_import_language_code<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid tb-grid\" data-toolset-blocks-grid=\"99cc3a5ab60df794a57bb6b8d25eb72b\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<div class=\"wp-block-toolset-blocks-container tb-container\" data-toolset-blocks-container=\"129cbcdfb5323433411d290d31e42b73\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<p class=\"tb-heading\" data-toolset-blocks-heading=\"adef0d439dc185d9052242e930df1467\" data-last-update=\"1.4\">_wpml_import_source_language_code<\/p>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"25b3ebdc7ce824ff67ca020ac661e474\">\n<p class=\"tb-heading\" data-toolset-blocks-heading=\"af8f0a1b54c0a15c59e6b9a402ff8035\" data-last-update=\"1.4\"><strong><strong>Planilha de tipos de post<\/strong><\/strong><\/p>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid tb-grid\" data-toolset-blocks-grid=\"dbc5b0208a44f3fb5d3407edd4239182\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<div class=\"wp-block-toolset-blocks-container tb-container\" data-toolset-blocks-container=\"b8460dc948ec9674fef4ce21d4f70fb0\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<p class=\"tb-heading\" data-toolset-blocks-heading=\"adef0d439dc185d9052242e930df1467\" data-last-update=\"1.4\">_wpml_import_translation_group<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid tb-grid\" data-toolset-blocks-grid=\"6d884e3758259a6ca2a13b9bfa8772d8\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<div class=\"wp-block-toolset-blocks-container tb-container\" data-toolset-blocks-container=\"b8460dc948ec9674fef4ce21d4f70fb0\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<p class=\"tb-heading\" data-toolset-blocks-heading=\"adef0d439dc185d9052242e930df1467\" data-last-update=\"1.4\">_wpml_import_language_code<\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid tb-grid\" data-toolset-blocks-grid=\"dbc5b0208a44f3fb5d3407edd4239182\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<div class=\"wp-block-toolset-blocks-container tb-container\" data-toolset-blocks-container=\"b8460dc948ec9674fef4ce21d4f70fb0\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-top\" data-toolset-blocks-grid-column=\"3034fbe886c11054e95b46b09d3e4112\">\n<p class=\"tb-heading\" data-toolset-blocks-heading=\"adef0d439dc185d9052242e930df1467\" data-last-update=\"1.4\">_wpml_import_source_language_code<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n<div class=\"wp-block-toolset-blocks-grid tb-grid help-box\" data-toolset-blocks-grid=\"17bf1139e8f2198e8868fad75e4e5f6f\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-center\" data-toolset-blocks-grid-column=\"6c529133ed853496f6832ff61ec74e40\">\n<div class=\"tb-fields-and-text\" data-toolset-blocks-fields-and-text=\"b9e2718d4e1eec994b4135a87b394371\"><p><a href=\"https:\/\/cdn.wpml.org\/wp-content\/uploads\/2024\/01\/product-categories-spreadsheet.png?_gl=1*1wyhxhx*_gcl_au*MjA0NTQxMzkyLjE3MTUwMDYxNjM.\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/cdn.wpml.org\/wp-content\/uploads\/2024\/01\/product-categories-spreadsheet.png?_gl=1*1wyhxhx*_gcl_au*MjA0NTQxMzkyLjE3MTUwMDYxNjM.\" alt=\"\" width=\"2316\" height=\"958\"\/><\/a><\/p><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-center\" data-toolset-blocks-grid-column=\"f586ff7bfe1d7317c63162ec7b7039ed\">\n<div class=\"tb-button mention-btn\" data-toolset-blocks-button=\"a8b957b37243a6041fc1d36ede662619\"><a class=\"tb-button__link\" href=\"https:\/\/cdn.wpml.org\/wp-content\/uploads\/2024\/01\/wpml-example-product-categories-import-file.csv?_gl=1*1allbj1*_gcl_au*MjA0NTQxMzkyLjE3MTUwMDYxNjM.\"><span class=\"tb-button__content\">Exemplo de arquivo CSV multil\u00edngue para <strong>categorias de produtos<\/strong><\/span><i class=\"tb-button__icon\"><\/i><\/a><\/div>\n<\/div>\n<\/div>\n\n<div class=\"wp-block-toolset-blocks-grid tb-grid help-box\" data-toolset-blocks-grid=\"90ad6699208be28c2254a52bebe21094\">\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-center\" data-toolset-blocks-grid-column=\"6c529133ed853496f6832ff61ec74e40\">\n<div class=\"tb-fields-and-text\" data-toolset-blocks-fields-and-text=\"cf5310fa04e4a995e5fa4a4a57fc9fb3\"><p><a href=\"https:\/\/cdn.wpml.org\/wp-content\/uploads\/2024\/01\/wpml-export-import-product-information-spreadsheet.png?_gl=1*rkb02j*_gcl_au*MjA0NTQxMzkyLjE3MTUwMDYxNjM.\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/cdn.wpml.org\/wp-content\/uploads\/2024\/01\/wpml-export-import-product-information-spreadsheet.png?_gl=1*rkb02j*_gcl_au*MjA0NTQxMzkyLjE3MTUwMDYxNjM.\" alt=\"\" width=\"2238\" height=\"1308\"\/><\/a><\/p><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-toolset-blocks-grid-column tb-grid-column tb-grid-align-center\" data-toolset-blocks-grid-column=\"f586ff7bfe1d7317c63162ec7b7039ed\">\n<div class=\"tb-button mention-btn\" data-toolset-blocks-button=\"8165350a44deb326390803164c16815e\"><a class=\"tb-button__link\" href=\"https:\/\/cdn.wpml.org\/wp-content\/uploads\/2024\/01\/wpml-example-products-import-file.csv?_gl=1*rkb02j*_gcl_au*MjA0NTQxMzkyLjE3MTUwMDYxNjM.\"><span class=\"tb-button__content\">Exemplo de arquivo CSV multil\u00edngue para <strong>informa\u00e7\u00f5es do produto<\/strong><\/span><i class=\"tb-button__icon\"><\/i><\/a><\/div>\n<\/div>\n<\/div>\n\n<p>Lembre-se de que IDs desempenham um papel muito importante em sua planilha:<\/p>\n\n<ul class=\"wp-block-list\">\n<li>Se voc\u00ea estiver adicionando novo conte\u00fado ao seu site, as colunas de ID ajudam os plugins de importa\u00e7\u00e3o a entender as rela\u00e7\u00f5es entre os itens. Eles identificam rela\u00e7\u00f5es pai-filho. <\/li>\n\n\n\n<li>Se voc\u00ea estiver atualizando o conte\u00fado que j\u00e1 existe no site, voc\u00ea precisa usar os IDs exatos que seus posts ou produtos t\u00eam atualmente. Isso garante atualiza\u00e7\u00f5es precisas e evita duplica\u00e7\u00e3o ou erros. Para conte\u00fado com rela\u00e7\u00f5es pai-filho, importe os itens pai e suas tradu\u00e7\u00f5es primeiro, ent\u00e3o use esses IDs na coluna &#8216;ID do pai&#8217; da sua planilha.  <\/li>\n<\/ul>\n\n<h3 class=\"wp-block-heading\" id=\"custom-attributes-column\">Coluna adicional para atributos personalizados do WooCommerce<\/h3>\n\n<p>Isto \u00e9 relevante quando voc\u00ea tem produtos vari\u00e1veis com atributos personalizados do WooCommerce. <\/p>\n\n<p>Neste caso, adicione a coluna <strong>_wpml_import_wc_local_attribute_labels<\/strong>. Para cada <strong>produto traduzido<\/strong>, adicione tradu\u00e7\u00f5es de atributos em JSON usando pares slug:tradu\u00e7\u00e3o. <\/p>\n\n<p><strong>Exemplo para um produto vari\u00e1vel com atributos de tamanho e cor em franc\u00eas<\/strong>: <em>{&#8220;size&#8221;:&#8221;Taille&#8221;,&#8221;color&#8221;:&#8221;Couleur&#8221;}.<\/em><\/p>\n\n<p>O slug \u00e9 o r\u00f3tulo higienizado. Basta converter o nome do atributo em letras min\u00fasculas e substituir os espa\u00e7os por tra\u00e7os. <\/p>\n\n<h2 class=\"wp-block-heading\" id=\"importing-multilingual-data\">2. Importe os Dados Multil\u00edngues<\/h2>\n\n<p>Depois de salvar suas planilhas como um arquivo CSV ou XML, v\u00e1 para seu novo site e configure o WPML com os idiomas que voc\u00ea planeja importar. Ent\u00e3o:<\/p>\n\n<ul class=\"wp-block-list\">\n<li><strong>Importe as taxonomias primeiro (se aplic\u00e1vel)<\/strong><\/li>\n<\/ul>\n\n<p> Ao importar categorias, tags ou quaisquer outras taxonomias primeiro, voc\u00ea estabelece as bases para organizar seu conte\u00fado no novo site.<\/p>\n\n<p>Cada plugin de importa\u00e7\u00e3o tem sua pr\u00f3pria interface e etapas, e seu plugin de importa\u00e7\u00e3o provavelmente exigir\u00e1 que voc\u00ea corresponda ou \u201cmapeie\u201d os nomes das colunas de categorias do seu CSV para os campos. Esta \u00e9 uma etapa cr\u00edtica para permitir que o WPML Export and Import atualize corretamente as informa\u00e7\u00f5es de idioma.   <\/p>\n\n<p>Por exemplo, se voc\u00ea estiver usando o <strong>WP All Import Pro<\/strong>:<\/p>\n\n<ol class=\"wp-block-list\">\n<li> Expanda a se\u00e7\u00e3o <strong>Term Meta<\/strong> na <strong>Etapa 3.<\/strong> <\/li>\n\n\n\n<li>Adicione tr\u00eas campos de metadados de termo e arraste as colunas de idioma para os campos <strong>Valor<\/strong>. Use os nomes das colunas da sua planilha, sem colchetes, para os campos <strong>Nome<\/strong>. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\" tb-image tb-image-dynamic tb-image-frame-none aligncenter\" data-toolset-blocks-image=\"48d2b4613878ba824efbaa97049f0747\"><a href=\"https:\/\/wpml.org\/wp-content\/uploads\/2024\/05\/wp-all-import-wpml-export-import-mapping-term-data.png\"><img decoding=\"async\" width=\"1024\" height=\"565\" loading=\"lazy\" src=\"https:\/\/wpml.org\/wp-content\/uploads\/2024\/05\/wp-all-import-wpml-export-import-mapping-term-data-1024x565.png\" alt=\"\" class=\"wp-image-15625740\" srcset=\"https:\/\/wpml.org\/wp-content\/uploads\/2024\/05\/wp-all-import-wpml-export-import-mapping-term-data-1024x565.png 1024w, https:\/\/wpml.org\/wp-content\/uploads\/2024\/05\/wp-all-import-wpml-export-import-mapping-term-data-300x166.png 300w, https:\/\/wpml.org\/wp-content\/uploads\/2024\/05\/wp-all-import-wpml-export-import-mapping-term-data-150x83.png 150w, https:\/\/wpml.org\/wp-content\/uploads\/2024\/05\/wp-all-import-wpml-export-import-mapping-term-data-768x424.png 768w, https:\/\/wpml.org\/wp-content\/uploads\/2024\/05\/wp-all-import-wpml-export-import-mapping-term-data-1536x848.png 1536w, https:\/\/wpml.org\/wp-content\/uploads\/2024\/05\/wp-all-import-wpml-export-import-mapping-term-data-2048x1131.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption><div class=\"tb-image-caption\">Mapeando as colunas de idioma na se\u00e7\u00e3o Term Meta<\/div><\/figcaption><\/figure>\n<\/div>\n<p>As etapas podem variar com outros plugins, mas \u00e9 muito importante mapear esses campos corretamente.<\/p>\n\n<ul class=\"wp-block-list\">\n<li><strong>Em seguida, importe seus tipos de post (posts, p\u00e1ginas, produtos e quaisquer outros tipos de conte\u00fado)<\/strong><\/li>\n<\/ul>\n\n<p>Mais uma vez, voc\u00ea precisar\u00e1 corresponder ou \u201cmapear\u201d os nomes das colunas para dados de produtos do seu CSV para os campos. <\/p>\n\n<p>Se voc\u00ea estiver usando o <strong>WP All Import Pro<\/strong>:<\/p>\n\n<ol class=\"wp-block-list\">\n<li>Na <strong>Etapa 3 <\/strong>do assistente do WP All Import, role para baixo at\u00e9 a se\u00e7\u00e3o <strong>Campos personalizados<\/strong>.<\/li>\n\n\n\n<li>Adicione tr\u00eas campos personalizados e arraste e solte as colunas de idioma da barra lateral direita para os campos <strong>Valor<\/strong>. Para os campos <strong>Nome<\/strong>, use os nomes das colunas sem os colchetes. Novamente, esta etapa pode parecer diferente se voc\u00ea usar outro plugin de importa\u00e7\u00e3o, mas voc\u00ea deve mapear esta informa\u00e7\u00e3o para que a importa\u00e7\u00e3o funcione.  <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\" tb-image tb-image-dynamic tb-image-frame-none aligncenter\" data-toolset-blocks-image=\"eeae49eab4c04876bea9d5409b76d6ca\"><a href=\"https:\/\/wpml.org\/wp-content\/uploads\/2024\/05\/wpml-export-import-all-import-mapping-custom-fields.png\"><img decoding=\"async\" width=\"1024\" height=\"451\" loading=\"lazy\" src=\"https:\/\/wpml.org\/wp-content\/uploads\/2024\/05\/wpml-export-import-all-import-mapping-custom-fields-1024x451.png\" alt=\"\" class=\"wp-image-15625777\" srcset=\"https:\/\/wpml.org\/wp-content\/uploads\/2024\/05\/wpml-export-import-all-import-mapping-custom-fields-1024x451.png 1024w, https:\/\/wpml.org\/wp-content\/uploads\/2024\/05\/wpml-export-import-all-import-mapping-custom-fields-300x132.png 300w, https:\/\/wpml.org\/wp-content\/uploads\/2024\/05\/wpml-export-import-all-import-mapping-custom-fields-150x66.png 150w, https:\/\/wpml.org\/wp-content\/uploads\/2024\/05\/wpml-export-import-all-import-mapping-custom-fields-768x338.png 768w, https:\/\/wpml.org\/wp-content\/uploads\/2024\/05\/wpml-export-import-all-import-mapping-custom-fields-1536x677.png 1536w, https:\/\/wpml.org\/wp-content\/uploads\/2024\/05\/wpml-export-import-all-import-mapping-custom-fields.png 1999w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption><div class=\"tb-image-caption\">Mapeando campos de idioma para campos personalizados no WP All Import Pro<\/div><\/figcaption><\/figure>\n<\/div>\n<p>At\u00e9 voc\u00ea executar o WPML Export and Import, todo o conte\u00fado importado ser\u00e1 agrupado em um \u00fanico idioma. Se voc\u00ea estiver <a href=\"https:\/\/wpml.org\/pt-br\/documentacao\/projetos-relacionados\/exportacao-e-importacao-wpml\/#supported-export-import-plugins\">usando um plugin de importa\u00e7\u00e3o compat\u00edvel<\/a>, o WPML Export and Import definir\u00e1 temporariamente o conte\u00fado importado como <strong>Rascunho<\/strong> para evitar a mistura de idiomas no front-end. Para plugins n\u00e3o compat\u00edveis, voc\u00ea precisa definir o status de publica\u00e7\u00e3o por conta pr\u00f3pria.    <\/p>\n\n<p>Saiba mais sobre <a href=\"https:\/\/wpml.org\/documentation\/related-projects\/wpml-export-and-import\/managing-the-visibility-of-imported-multilingual-content\/\">gerenciar a visibilidade do conte\u00fado importado<\/a>.<\/p>\n\n<h2 class=\"wp-block-heading\" id=\"running-wpml-export-and-import\">3. Execute o WPML Export and Import<\/h2>\n\n<p>Com seu conte\u00fado multil\u00edngue importado, acesse <strong>WPML \u2192 Export and Import<\/strong> e clique em <strong>Executar importa\u00e7\u00e3o do WPML. <\/strong>Pode levar alguns minutos para<strong> <\/strong>o WPML Export and Import passar pelas etapas de adicionar as informa\u00e7\u00f5es de idioma e conectar as tradu\u00e7\u00f5es.<\/p>\n\n<p>Ap\u00f3s o WPML Export and Import concluir o processo de atualiza\u00e7\u00e3o do conte\u00fado importado, revise seus posts, p\u00e1ginas, produtos e taxonomias.  <\/p>\n\n<p>Fa\u00e7a esta verifica\u00e7\u00e3o no backend e no front-end do seu site. Certifique-se de que cada item de conte\u00fado apare\u00e7a corretamente no idioma correto e que as tradu\u00e7\u00f5es estejam devidamente vinculadas. Se voc\u00ea encontrar alguma tradu\u00e7\u00e3o de taxonomia faltando ou n\u00e3o conectada corretamente ao termo de idioma padr\u00e3o, voc\u00ea precisar\u00e1 <a href=\"https:\/\/wpml.org\/faq\/how-can-i-reconnect-taxonomy-translations-to-their-default-language-terms\/\">conectar manualmente as tradu\u00e7\u00f5es de taxonomia<\/a>.  <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Saiba como adicionar colunas de idioma a planilhas para importar conte\u00fado multil\u00edngue para um novo site, permitindo que o WPML Export and Import atribua detalhes de idioma e conecte tradu\u00e7\u00f5es. Quando Voc\u00ea Precisa Preparar Manualmente Arquivos XML ou CSV Se voc\u00ea usar plugins compat\u00edveis para migrar conte\u00fado entre sites WordPress, o WPML Export and Import [&hellip;]<\/p>\n","protected":false},"author":538393,"featured_media":0,"parent":15228634,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"template-sidebar-3.php","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"ep_exclude_from_search":false,"footnotes":""},"related-projects-category":[],"class_list":["post-15990951","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/wpml.org\/pt-br\/wp-json\/wp\/v2\/pages\/15990951","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wpml.org\/pt-br\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/wpml.org\/pt-br\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/wpml.org\/pt-br\/wp-json\/wp\/v2\/users\/538393"}],"replies":[{"embeddable":true,"href":"https:\/\/wpml.org\/pt-br\/wp-json\/wp\/v2\/comments?post=15990951"}],"version-history":[{"count":8,"href":"https:\/\/wpml.org\/pt-br\/wp-json\/wp\/v2\/pages\/15990951\/revisions"}],"predecessor-version":[{"id":17854889,"href":"https:\/\/wpml.org\/pt-br\/wp-json\/wp\/v2\/pages\/15990951\/revisions\/17854889"}],"up":[{"embeddable":true,"href":"https:\/\/wpml.org\/pt-br\/wp-json\/wp\/v2\/pages\/15228634"}],"wp:attachment":[{"href":"https:\/\/wpml.org\/pt-br\/wp-json\/wp\/v2\/media?parent=15990951"}],"wp:term":[{"taxonomy":"related-projects-category","embeddable":true,"href":"https:\/\/wpml.org\/pt-br\/wp-json\/wp\/v2\/related-projects-category?post=15990951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}