Import any XML or CSV File to WordPress

Descripción

WP All Import – Plugin de importación de XML / CSV simple y potente

«Es un plugin increíble que hace tanto y tan bien que es difícil enumerar todas sus características. Pero te diré algo, pude importar el contenido de un par de webs sobre ModX CMS a una instalación de WordPress en menos de 30 minutos. ¡No es broma!»
Alex Vasquez – Cofundador de DigiSavvy y organizador de la WordCamp Los Angeles

WP All Import incorpora un proceso de importación de cuatro pasos y una interfaz de arrastrar y soltar intuitiva que hace que las tareas de importación complicadas sean simples y rápidas.

No hay requisitos especiales que obliguen a que los elementos en tu archivo deban estar colocados de una cierta manera. WP All Import puede importar cualquier archivo XML o CSV.

WP All Import se puede usar para todo, desde la migración de contenido de un CMS antiguo a WordPress, la construcción de una tienda con un feed de datos de afiliados, la visualización de cotizaciones de acciones o clasificaciones deportivas en directo, o la construcción de un portal inmobiliario.

Visita nuestra documentación y videotutoriales para aprovechar WP All Import al máximo.

WP All Import se integra con nuestro plugin complementario, WP All Export. Puedes exportar entradas, productos de WooCommerce, pedidos, usuarios o cualquier otra cosa con WP All Export. A continuación, puedes editar con Excel y volver a importar al mismo sitio o migrar los datos a otro sitio con WP All Import.

Para obtener soporte técnico de los desarrolladores, valora comprar WP All Import Pro.

Edición profesional de WP All Import

WP All Import Pro es una actualización de pago que incluye soporte premium y añade las siguientes características:

  • Importa datos a campos personalizados – usados por muchos temas, especialmente aquellos que usan tipos de contenido personalizados, para almacenar datos asociados con las entradas.

  • Importa imágenes a la librería multimedia – WP All Import puede descargar imágenes desde URLs en archivos XML o CSV y colocarlas en la librería multimedia.

  • Cron Job/Recurring Imports – WP All Import pro can check periodically check a file for updates, and add, edit, and delete to the imported posts accordingly.

  • Importa archivos desde una URL – Descarga e importa archivos desde webs externas, incluso si están protegidas por contraseña mediante autenticación HTTP. Las importaciones de URL se integran con la función de importaciones recurrentes/mediante cron, de modo que WP All Import puede volver a descargar periódicamente los archivos y añadir, editar y eliminar entradas en consecuencia.

  • Ejecución de funciones PHP personalizadas en los datos, por ejemplo, usa algo como [my_function({xpath/to/a/field[1]})] en tu plantilla, para pasar el valor de {xpath/to/a/field[1]} a my_function y mostrar lo que sea que devuelva.

  • Soporte técnico garantizado vía correo electrónico.

Actualiza a la edición profesional de WP All Import.

Need to import XML and CSV to WooCommerce? Check out our WooCommerce add-on.

Importaciones CSV de WordPress

Sigue leyendo para obtener más información sobre la funcionalidad de importación CSV de WP All Import. La importación de CSVs con WP All Import es exactamente igual que la importación de archivos XML porque, internamente, WP All Import convierte tu archivo CSV en un archivo XML sobre la marcha. Puedes usar las mismas opciones de filtrado XPath y las mismas características de las que dispones cuando importas archivos XML.

Las importaciones CSV no requieren que el archivo CSV tenga una estructura específica. Tu archivo CSV puede usar cualquier nombre o encabezado para las columnas. Puedes asignar las columnas de tu archivo CSV a las ubicaciones apropiadas en WordPress durante el proceso de importación.

Al importar archivos CSV, tu CSV debe tener una codificación UTF-8 si tienes problemas para importar caracteres especiales.

En el paso 2 de una importación CSV, puedes especificar un delimitador alternativo si no estás usando una coma. WP All Import puede importar CSVs que estén delimitados por barras verticales, por #, o delimitados/separados por cualquier otro carácter.

Para ver tutoriales de importación de CSV y archivos de ejemplo, visita nuestra documentación. Por favor, ten en cuenta que las importaciones CSV con WP All Import son como las importaciones XML – tienes las mismas funcionalidades, y el proceso es exactamente el mismo. Cualquiera de nuestros video-tutoriales dedicados a archivos XML también sirven para la importación de archivos CSV, así que si ves un tutorial nuestro importando un archivo XML, que sepas que puedes seguir exactamente los mismos pasos para una importación CSV.

Extensiones

Hay una serie de extensiones premium disponibles para añadir funcionalidades al importador y facilitar las tareas de importación de archivos XML y CSV a plugins complejos.

  • Extensión de Advanced Custom Fields – Importador de XML y CSV de ACF
  • Extensión de WooCommerce – Importador XML y CSV para cualquier tipo de productos de WooCommerce.
  • Extensión de importación de usuarios – Importador XML y CSV de usuarios, incluido el user_meta
  • Extensión de camuflaje de enlaces – Creación automática de redirecciones para los enlaces presentes durante una importación XML o CSV

Obtén más información sobre nuestras extensiones en http://www.wpallimport.com/add-ons

También existe una API de desarrollo (ganchos de acción).

Related Plugins

Export any WordPress data to XML/CSV
Import Products from any XML or CSV to WooCommerce
Export Products to CSV/XML for WooCommerce
Custom Product Tabs for WooCommerce WP All Import Add-on
Export Orders to CSV/XML for WooCommerce
Export WordPress Users to CSV/XML

Soporte de pago

Support for the free version of WP All Import is handled through the WordPress.org community forums.

Support is not guaranteed and is based on ability. For premium support over email, purchase WP All Import.

Importar a WooCommerce

¿Necesitas importar archivos XML y CSV a WooCommerce? Echa un vistazo a nuestra extensión de WooCommerce.

Versión profesional de WooCommerce XML & CSV Import

Capturas

  • Elegir archivo.
  • Opciones de filtrado.
  • Elige a dónde importar tus datos.
  • Gestionar importaciones.

FAQ

How do I import WordPress data?

  1. Go to All Import › New Import.
  2. Upload the import file.
  3. Choose the import post type.
  4. Map the incoming data elements to the WordPress fields.
  5. Complete the import and verify the imported data.

Can I import any WordPress post type?

Yes. You can import any standard WordPress post type, including posts, pages, categories, tags, users, comments, and images. You can also import custom data from third-party themes and plugins.

How does WordPress import work?

The default WordPress import tool uses a brute-force approach that often imports all or nothing. WP All Import is a lot more flexible and lets you filter, modify, and map incoming data elements so that you can import your data exactly as you want it.

Does my data have to be specially organized for WordPress imports?

Not when you use our plugins. Our Drag & Drop interface lets you map incoming data elements to any WordPress fields. You can even modify the incoming data as part of the import process, so we can handle a wide variety of import layouts.

How do I import a CSV file into WordPress?

To import a CSV file into WordPress, just specify the CSV file as your import source. WP All Import will automatically recognize the file type and adjust accordingly. You don’t need to do anything special to handle the CSV format.

How do I import XML data into WordPress?

To import XML data into WordPress, just specify the XML file as your import source. WP All Import will automatically recognize the file type and adjust accordingly. You don’t need to do anything special to handle an XML file.

How do I import large files into WordPress?

To import large files into WordPress, you can use our advanced settings to split the import into manageable chunks, modify the batch processing size, and take several other steps to either speed up the import or reduce its impact on the server.

How do I import data into a WordPress custom plugin?

Our plugin automatically recognizes many WordPress custom plugins and themes, so just select the custom post type and away you go. If a custom plugin stores its data in an unconventional manner, just contact our support staff for further guidance.

Can I use WP All Import on all of my WordPress sites?

Yes. Our plugins come with unlimited licenses, so you can install them on all of your own websites.

Can I import WooCommerce customers, products, and orders?

We have special add-ons for all types of WooCommerce data, so you can import WooCommerce customers, orders, products, reviews, and anything else WooCommerce has to offer.

How do I import WordPress posts as a draft?

In Step 3 of the import process, under Other Post Options, change the Post Status to Draft. This ensures that all imported posts will be created as drafts.

How do I import images into WordPress?

In the Drag & Drop screen, map the incoming image elements to the appropriate fields in the Images section. The tricky part about images is that they can have many different sources, including URLs, images that are on your computer, images that are already on your server, and even images that are already in your media library. To understand how to handle each of these scenarios, see our documentation.

How do I import a featured image into WordPress?

  1. Create a standard WordPress import.
  2. In Step 3, add the images element in the Images section.
  3. Check the Set the first image to the Featured Image (_thumbnail_id) option.
  4. Complete the import.
  5. Verify that the featured image(s) were correctly imported.

How do I migrate WordPress data to another website?

  1. Export the WordPress data that you wish to migrate.
  2. Download the Bundle option, which includes import instructions.
  3. Import the bundle file on the target site.
  4. WP All Import will use the bundle file to automatically configure itself.
  5. Run the import and review your migrated data.

How do I bulk edit WordPress data?

  1. Export the WordPress data that you wish to edit.
  2. Edit the export file in your favorite spreadsheet app.
  3. Use the Import with WP All Import option to configure your import.
  4. Run the import.
  5. Review the affected data to make sure the changes were applied.

How do I get support?

If you are using the free version of the plugin, you can obtain support through the WordPress.org community forums. If you have purchased the premium version, you can email us directly and we will respond as quickly as we can, typically in less than one business day.

Reseñas

19 de marzo de 2024
This suite is essential for a WordPress eShop, but the best part of all is the specialized responses I receive from the support team. Well done to you!!
18 de marzo de 2024
I want to import an excel file or csv file into Wordpress. I want each post to have a specific date which can be in past or future. The records will contain a posting date column. If the date pertains to the past, the record is imported and posted with the date stamp as mentioned in the excel sheet. If the date pertains to the future, the posts are scheduled based on the posting date mentioned in each record. I could not find this functionality so far in WP ALL Import. Overall the software is found to be good and useful. It can become the best if the above functionality is added to the same.
15 de marzo de 2024
Honestly this is the best plugin for importing data into WordPress. With the free version you can import CPTs and Custom Fields, and if you need extra features you can get the Pro version. It works as expected, get the things done and you can even resume the import process in case the server fails.
7 de marzo de 2024 1 respuesta
"WP All Import is an extremely powerful importer that makes it easy to import any XML or CSV file to WordPress."This is untrue. You must pay for a different plugin to import most files.
Leer todas las 1.846 reseñas

Colaboradores y desarrolladores

«Import any XML or CSV File to WordPress» es un software de código abierto. Las siguientes personas han colaborado con este plugin.

Colaboradores

«Import any XML or CSV File to WordPress» está traducido en 4 idiomas. Gracias a los traductores por sus contribuciones.

Traduce «Import any XML or CSV File to WordPress» a tu idioma.

¿Interesado en el desarrollo?

Revisa el código , echa un vistazo al repositorio SVN o suscríbete al registro de desarrollo por RSS.

Registro de cambios

3.7.4

  • security improvement
  • API: added ‘wp_all_import_is_post_to_change_missing’ filter

3.7.3

  • security improvement
  • improvement: add ‘Do not create new terms’ setting on Edit Template page
  • improvement: better PHP 8.2 support
  • improvement: remove deprecated ‘get_page_by_title’ function calls

3.7.2

  • improvement: refine various UI elements
  • bug fix: PHP 8.1 warning on Step 3

3.7.1

  • bug fix: unable to install on Windows environments
  • improvement: increased timer accuracy on import processing page

3.7.0

  • improvement: UI styling improvements

3.6.9

  • security improvement
  • improvement: resolve PHP 8 Deprecated notice

3.6.8

  • security improvement

3.6.7

  • security improvement
  • improvement: changed Manage Imports page button labels to be more precise
  • improvement: assign ‘Uncategorized’ term to posts imported without a category assigned
  • improvement: add support for taxonomies that return objects instead of IDs
  • improvement: remove commented code that could cause false positives for security scans
  • bug fix: jQuery error related to ‘destroy’ method
  • bug fix: rare issue that prevented content image URLs from being updated during import
  • bug fix: taxonomies section drag and drop doesn’t save after rearranging fields
  • bug fix: conflict with Advanced Ads plugin
  • bug fix: ‘Instead of deletion, set missing records to out of stock’ still deleting products

3.6.6

  • bug fix: jQuery nestedSortable compatibility with WordPress 5.9

3.6.5

  • improvement: better sanitization and escaping of data in WP All Import interface

3.6.4

  • improvement: better sanitization and escaping of data in WP All Import interface
  • improvement: use libraries included in WordPress Core

3.6.3

  • security fix
  • bug fix: images not updated for existing products when using WooCommerce Import Add-On

3.6.2

  • improvement: add ability to control taxonomy mapping case sensitivity via filter wpai_is_case_insensitive_taxonomy_mapping
  • improvement: add ability to control uploads directory for single file/image via filters wp_all_import_single_image_uploads_dir and wp_all_import_single_attachment_uploads_dir
  • improvement: add missing options on confirm import step
  • bug fix
  • improvement: initial PHP 8 support
  • bugfix: manage_options capability check

3.6.1

  • bug fix: categories were imported despite the taxonomy option being disabled
  • improvement: add ability to filter csv escape symbol via wp_all_import_csv_parser_settings filter

3.6.0

  • maintenance: compatibility with Elementor v3.3 JavaScript changes

3.5.9

  • bug fix: call to the non existing function wp_all_import_sanitize_url

3.5.8

  • bug fix: import of taxonomies hierarchy didn’t work properly

3.5.7

  • improvement: git rid if deprecated join query on manage imports screen
  • improvement: add is_update_post_format option
  • improvement: add wp_all_import_manual_matching filter
  • improvement: add wp_all_import_logger filter
  • bug fix: records were removed from pmxi_posts table when activating WPAI on multisite installation
  • bug fix: get rid of unused deprecated function add_contextual_help()

3.5.6

  • bug fix: PMXI_Hash_Record class doesn’t exist error appears when deleting missing records

3.5.5

  • improvement: get rid of deprecated setting ‘High Speed Small File Processing’
  • bug fix: chromium scroll anchoring caused screen jumping effect
  • bug fix: pagenum query argument caused broken link on import complete screen

3.5.4

  • improvement: compatibility with WordPress 5.5
  • API: added helper function wp_all_import_get_import_id()
  • API: added helper function wp_all_import_get_import_post_type($import_id)

3.5.3

  • bug fix: switch to CodeMirror implementation shipped in WordPress core
  • bug fix: unable to double click to insert XPath in some cases
  • bug fix: unable to apply pmxi_is_images_to_update filter to featured images
  • bug fix: unable to match existing images when suffix is added to file name during import

3.5.2

  • improvement: match existing images by filename with underscores
  • API: add new action wp_all_import_before_preserve_post_data
  • API: add new filter wp_all_import_specified_delimiters
  • bug fix: attachment author not imported for API image imports

3.5.1

  • improvement: add support for importing WebP images
  • bug fix: images in content not being imported when creating new simple WooCommerce products

3.5.0

  • improvement: add support for .tsv format
  • API: add current XML variable to pmxi_article_data filter
  • bug fix: post terms incorrect after import complete, must be recounted
  • bug fix: empty attachments created when attachment import fails
  • bug fix: matching posts by ID matches and imports into attachments with the same ID

3.4.9

  • bug fix: import using stream reader
  • bug fix: generation temporary files in system temporary folder

3.4.8

  • improvement: various import speed optimizations
  • bug fix: remove deprecated function calls for PHP 7.2 compatibility
  • bug fix: delete db tables when mu blog deleted
  • bug fix: remove BOM from import templates
  • bug fix: saving CSV delimiter when changing import file

3.4.7

  • improvement: skip to the first specified record when importing only part of a file
  • new filter: wp_all_import_is_render_whole_xml_tree
  • new filter: wp_all_import_images_uploads_dir (add-on api)
  • bug fix: patch XSS exploit
  • bug fix: conflict with InfiniteWP
  • bug fix: update notification for Link Cloaking Add-On
  • bug fix: load functions before pmxi_before_xml_import
  • bug fix: do not re-count category terms when post imported as draft
  • bug fix: import base64 encoded images in add-ons
  • security fix – XSS exploit (Special thanks to Yuji Tounai for reporting)

3.4.6

  • improvement: added timestamp to import log lines
  • improvement: added support for bmp images
  • improvement: added new action pmxi_before_post_import_{$addon}
  • security fix: patch XSS exploit
  • bug fix: import pages hierarchy
  • bug fix: error in pclzip.lib.php with php 7.1
  • bug fix: import taxonomies hierarchy
  • bug fix: json to xml convertation
  • bug fix: removed SWFUpload
  • security fix – XSS exploit (Special thanks to Mardan Muhidin for reporting)

3.4.5

  • improvement: custom fields delection
  • improvement: new action wp_all_import_post_skipped
  • improvement: updated history page title
  • improvement: optimize large imports deletion
  • improvement: added import friendly name to confirm screen
  • improvement: sql query optimization on manage imports screen
  • bug fix: generation image filename
  • bug fix: wp_all_import_specified_records filter

3.4.4

  • bug fix: import template not worked when downloaded via Import Settings
  • bug fix: updating user login
  • bug fix: import images with encoded quotes
  • improvement: added hungarian translation

3.4.3

  • improvement: new filter ‘wp_all_import_phpexcel_delimiter’
  • improvement: new filter ‘wp_all_import_is_trim_parsed_data’
  • improvement: added new filter ‘wp_all_import_skip_x_csv_rows’
  • improvement: added csv delimiter setting to import options screen
  • bug fix: import duplicate tags

3.4.2

  • bug fix: conflict with the event calendar plugin
  • bug fix: import images for newly created products

3.4.1

  • improvement: Stop parsing data which is not going to be updated
  • improvement: added new filter wp_all_import_phpexcel_object to modify excel data before import
  • bug fix: search for images ending with underscores in media
  • bug fix: import hierarchical posts/pages
  • bug fix: import cpt page templates

3.4.0

  • improvement: compatibility with PHP 7.x

3.3.9

  • improvement: new re-import option ‘is update post type’
  • bug fix: hierarchy taxonomies preview
  • bug fix: empty logs folder generation
  • bug fix: ‘Keep images currently in Media Library’ option for add-ons
  • bug fix: import bundles with gz files
  • bug fix: custom functions for attachments

3.3.8

  • improvement: ‘Force Stream Reader’ setting
  • improvement: new filter ‘wp_all_import_auto_create_csv_headers’
  • improvement: new filter ‘wp_all_import_is_base64_images_allowed’
  • improvement: new filter ‘wp_all_import_set_post_terms’ to leave a specific category alone when a post is being updated
  • bug fix: nodes navigation for xpath like /news/item
  • bug fix: frozen import template screen for cyrillic XML feeds
  • bug fix: conflict between taxonomies & user import
  • bug fix: creating users with the same email
  • bug fix: enable keep line breaks option by default
  • bug fix: composer namespace conflict
  • bug fix: images preview when wp is in subdirectory
  • bug fix: ‘Instead of deletion, set Custom Field’ option for users import

3.3.7

  • added new option ‘Use StreamReader instead of XMLReader to parse import file’ to fix issue with libxml 2.9.3
  • execute ‘pmxi_article_data’ filter for all posts ( new & existing )

3.3.6

  • added de_CH translation
  • added support for .svg images
  • added possibility for import excerpts for pages
  • added new filter ‘wp_all_import_specified_records’
  • added new filter ‘wp_all_import_is_post_to_delete’
  • disable XMLReader stream filter for HHVM
  • improve search for existing images in media gallery

3.3.5

  • fixed ‘Use images currently in Media Library’ option

3.3.4

  • fixed error messages on step 1 in case when server throws fatal error e.q. time limit exception
  • fixed option «Delete posts that are no longer present in your file», now it works with empty CSV files which has only one header row
  • fixed custom php functions in images preview
  • fixed detecting root nodes with colons in names
  • added es_ES translation
  • added de_DE translation
  • added iterative ajax delete process ( deleting associated posts )
  • added feature to download template/bundle from import settings
  • added new option for importing images «Use images currently in Media Library»
  • added new action ‘pmxi_missing_post’

3.3.3

  • fixed duplicate matching by custom field
  • fixed converting image filenames to lowercase
  • fixed import html to image description
  • fixed import _wp_old_slug
  • added Post ID to manual record matching
  • added ‘Comment status’ to ‘Choose data to update’ section

3.3.2

  • fixed fatal error on saving settings

3.3.1

  • fixed parsing CSV with empty lines
  • fixed parsing multiple IF statements
  • fixed preview in case when ‘Disable the visual editor when writing’ is enabled
  • fixed conflict with WooCommerce – Store Exporter Deluxe
  • added notifications for required addons
  • added support for wp all export bundle
  • added support for manual import bundle
  • added feature ‘click to download import file’
  • added validation for excerpt and images sections
  • added auto-detect a broken Unique ID notification
  • added import template notifications
  • removed support for importing WooCommerce Orders
  • changed absolute paths to relative in db

3.3.0

  • added new options to taxonomies import ‘Try to match terms to existing child Product Categories’ & ‘Only assign Products to the imported Product Category, not the entire hierarchy’
  • added support for Excel files ( .xls, .xlsx )

3.2.9

  • load ini_set only on plugin pages
  • fixed saving import template

3.2.8

  • fixed Apply mapping rules before splitting via separator symbol for manual hierarchy
  • fixed path equal or less than
  • fixed changing unique key when moving back from confirm screen
  • fixed override page template
  • updated wp_all_import_is_post_to_update filter with second argument XML node as array
  • added a second argument to pmxi_saved_post action ( SimpleXML object ) of current record

3.2.7

  • fixed enum fields mapping rules feature

3.2.6

  • Compatibility with 3rd party development: http://www.wpallimport.com/documentation/addon-dev/overview/

3.2.5

  • Important security fixes – additional hardening, prevention of blind SQL injection and reflected XSS attacks

3.2.4

  • critical security fix – stopping non-logged in users from accessing adminInit

3.2.3

  • fixed re-count record when a file has been changed at an import setting screen
  • fixed unlink attachment source when posts updated/deleted
  • added a limit 10 to the existing meta values

3.2.2

  • fixed database schema
  • uploading large files

3.2.1

  • fixed updating import settings

3.2.0

  • IMPORTANT: WP All Import v4 (3.2.0) is a MAJOR update. Read this post before upgrading: http://www.wpallimport.com/2014/11/free-version-wordpress-org-update-information
  • speed up the import of taxonomies/categories
  • added taxonomies/categories mapping feature
  • added custom fields auto-detection feature
  • added custom fields mapping feature
  • added images/taxonomies preview feature
  • added unofficial support for more file formats – json & sql
  • added new setting (secure mode) to protect your files
  • better import logs
  • updated design

3.1.5

  • fixed pmxi_delete_post action
  • fixed import menu order & post parent for pages
  • fixed import log for continue import feature
  • added is update author option
  • fixed post formats
  • fixed UTC dates on manage imports page

3.1.4

  • changed support email

3.1.3

  • fixed import pages

3.1.2

  • added compatibility with WP 3.9
  • added autodetect session mode
  • updated convertation CSV to XML with XMLWriter
  • fixed import *.zip files
  • fixed xpath helper on step 2
  • fixed showing zeros in XML tree
  • fixed deleting history files
  • fixed autodetect image extensions
  • fixed increasing SQL query length
  • allow post content to be empty on step 3
  • delete deprecated settings «my csv contain html code» and «case sensitivity»

3.1.1

  • Fixed compatibility with addons
  • Fixed «download image» option for import products
  • Fixed CSS for WP 3.8
  • Fixed dismiss links

3.1.0

  • Compatibility with WP 3.8
  • Compatibility with WPAI WooCommerce add-on (paid) 1.2.4
  • Performance Improvements
  • Improved UI
  • Lots of bug fixes
  • New Record Matching section
  • Added option to set Post Status with XPath (the value of presented XPath should be one of the following: publish, draft, trash)
  • Preview navigation

3.0.4

  • Fixed import categories;
  • Updated UI/UX;
  • Added import/export templates feature;
  • Added enhanced session functionality;
  • Added option to set post status with XPath;
  • Added feeds encoding feature;

3.0.2

  • Added support for the WooCommerce add-on

3.0

  • Free edition of 3.0 pro release

2.14

  • Category list delimiter bug fix

2.13

  • Tons of bug fixes, updates, and additional features.

2.12

  • Initial release on WordPress.org.