Choose a catalog source

WP All Import Pro with its WooCommerce add-on imports product data from XML, CSV, Excel, Google Sheets, and URL sources. It can download data from Google Sheets or external websites that require HTTP authentication. FTP and SFTP sources are also available. CSV files do not need fixed column names, and XML files can use various structures. Excel files can be uploaded directly, while Google Sheets can be supplied by URL.

Map data to WooCommerce products

The drag-and-drop screen places WooCommerce fields beside a table of source data. Map incoming values to product fields, then run the import and review the products. The add-on includes mapping for product pictures, attributes, categories, tags, and other taxonomies. Its Attributes tab connects incoming attribute values to WooCommerce product attribute fields.

• Import simple, variable, simple subscription, grouped, and external or affiliate products.
• Import variations from properly formatted XML.
• Add new variations to existing variable products through the WooCommerce Products import process.

Schedule catalog updates

Recurring imports can check a file periodically through cron jobs. Depending on the incoming data, they can add, edit, or delete imported products and update their stock status.

Large files are split automatically into chunks. The importer works with practically unlimited file sizes, including product catalogs over 200 MB on shared hosting. CSV files can be edited when column names need to change, though specific column names are not required. UTF-8 encoding is recommended if special characters cause import problems.

Process values with custom PHP

The Pro edition can run custom PHP functions on imported data. A value from an XML field can be passed to a function in the import template, and the function's returned value can be used in the mapped data.

Run the import

1. Go to All Import > New Import.
2. Upload the import file or select an available URL or FTP/SFTP source.
3. Choose WooCommerce Products as the import type.
4. Map incoming data to product fields with the drag-and-drop interface.
5. Run the import and review the imported products.

Install and get help

Install WP All Import Pro and the WooCommerce add-on on the WordPress website where the catalog will be managed. The Pro edition includes access to a customer portal with documentation and tutorials, premium support, and email technical support.