The best import export plugin for WordPress & WooCommerce.
Import Types Available in WP All Import
WP All Import handles two distinctive import types: Create new and Match existing. This is defined in the Import Settings after mapping the import fields. This article provides clear guidance on what each type is intended for.
A Description of Import Types
We use WooCommerce products as an example, but the same definitions apply when importing other post types or custom post types via WP All Import.
'Create new' Import
This is primarily used to create and manage products. It keeps internal track of the products that it imports, which means that it can later update/create/delete products as they're changed/added/removed in your import file (see: Recurring Imports). It's also the only import type that can add/remove variations to variable products.
One limitation of Create new imports is that it cannot detect/update products that it didn't previously create. If you need to use a Create new import with a file that contains existing products, you can use WP All Import's API and custom code to prevent duplicates from being imported: Do Not Create Products With Duplicate SKU.
'Match existing' Import
This is primarily used to update specific data (e.g., stock/price) for products that already exist (created manually or by other imports). This import type can't maintain the relationship between parent products and their variations, so it can't be used to add variations to existing products.
If you are updating product variations with this import type, you must match them by Post ID or a unique Custom Field value (as Title/Content won't work). Also, you should make extra sure that these data points are not being updated in the import settings:
Import Any CSV, XML, or Excel to WordPress
- Any theme or plugin
- Images & galleries
- Custom fields
- Categories & tags
- Woo, ACF, Meta Box, JetEngine
Examples of What Each Import Type Can or Can't Do
A 'Create new' Items import can:
- Create products.
- Update products that it created itself.
- Delete products (that it created itself previously) when they don't exist in the import file that is in use for the import
- Delete all products from your site that aren't present in the import file (even when created manually or by a different import).
- Set out of stock status for missing products (that it created itself previously).
- Add new variations to existing products that were previously created by the import.
- Add new variations to products created manually or by other imports (using the option: I'm importing new variations to existing products in the WooCommerce Add-On › Variations tab. See image below under Advanced Topics).
A 'Create new' import can't:
- Update products that it did not create (whether they were manually created or created by another import).
- Reference the Unique Identifier for another Create new import.
An 'Match existing' import can:
- Create new products (note: we do not recommend creating variable products with this import type as it's unreliable and can produce odd results. See the import type description above).
- Update products that it did not create itself (since it does not reference an identifier of its own, but rather, matches records by Title, Content, Custom Field, or Post ID).
- Delete products (that it created or updated itself previously) when they don't exist in the import file that is in use for the import.
- Delete all products from your site that aren't present in the import file (using the Remove or modify all WooCommerce products on this site that are not present in this import file option).
An 'Match existing' import can't:
- Reference the Unique Identifier for another Create new import (it is meant to match records by one of the four options mentioned above).
- Add new variations to existing WooCommerce Variable Products.
Advanced Topics
I'm importing new variations to existing products
This option allows adding new variations to products created manually or by other imports by using the option: I'm importing new variations to existing products in the WooCommerce Add-On › Variations tab.
Related Docs
Learn how to import any CSV or XML file to WordPress using WP All Import.
Learn how to delete records that are missing from your import file.
Learn more about how to set up and use recurring import processes.
Step-by-step instructions on how to target and update data using an Existing Items import.
