WordPress plugin
WP All Import Pro
WP All Import Pro works with the WooCommerce add-on to import product data from XML, CSV, Excel, and Google Sheets. Source documents can use various layouts: CSV files do not need fixed column names, and XML files can have complex structures. Excel columns are detected automatically. For Google Sheets, provide a public sheet URL through the “Download a file” option.
Sources and file formats
WP All Import Pro works with the WooCommerce add-on to import product data from XML, CSV, Excel, and Google Sheets. Source documents can use various layouts: CSV files do not need fixed column names, and XML files can have complex structures. Excel columns are detected automatically. For Google Sheets, provide a public sheet URL through the “Download a file” option.
You can download data from a URL, including from external sites protected by HTTP authentication. Product feeds can also come from FTP or SFTP. If special characters cause trouble in a CSV import, UTF-8 encoding is recommended; you can edit the CSV column names when needed.
Map fields and product types
The import screen places WooCommerce product fields beside a table of source data. Drag incoming values into the fields they belong in, run the import, and verify the resulting products. The add-on includes mapping for product pictures, attributes, categories, tags, and other taxonomies. Include image data in the field mapping, and use the Attributes tab to connect incoming values to WooCommerce product attribute fields.
- Import simple, variable, simple subscription, grouped, and external or affiliate products.
- For variable products, import variations from properly formatted XML. You can also add new variations to existing variable products through the WooCommerce Products import workflow.
File size and recurring catalog updates
The importer splits large files into chunks and works with files of practically unlimited size. It can import product catalogs larger than 200 MB, including on shared hosting.
WP All Import Pro can check a file periodically through cron job or recurring imports. Depending on the incoming data, it can add, edit, or delete imported products and update their stock status.
Custom data and import steps
The Pro edition can run custom PHP functions on imported data. For example, an XML field value can be passed to a function in the import template with [my_function({xpath/to/a/field[1]})]; the function’s returned value can then be used in the mapped data.
- Go to All Import > New Import.
- Upload the import file or choose an available URL or FTP/SFTP source.
- Choose WooCommerce Products as the import type.
- Map incoming data to product fields with the drag-and-drop interface.
- Run the import and verify the imported products.
Installation and support
Install WP All Import and the WooCommerce add-on on the WordPress website where you manage the catalog. The add-on appears in Step 4 of WP All Import. The Pro edition includes a customer portal with documentation and tutorials, premium support, and email technical support.