How To Import External or Affiliate Products Into WooCommerce
Selling affiliate or external products on WooCommerce means adding listings to a store that doesn’t hold the inventory itself. Each one still needs a product page, an affiliate link, and pricing entered individually, which can be a rather slow process when working with more than a handful of items.
WP All Import solves this by mapping affiliate and external product data from an import file into WooCommerce automatically using its Automatic Setup feature. I upload a file, and Automatic Setup fills in the field mapping without any manual configuration. WP All Import also offers a manual Drag & Drop setup for imports that need direct control over specific fields.
In this guide, I’ll walk through both methods: Automatic Setup, the faster path most imports need, and manual setup, for cases that call for more precision.
What Are WooCommerce External or Affiliate Products
External or affiliate products are a type of WooCommerce product hosted on your WooCommerce website but sold or fulfilled by a third-party merchant.

Unlike simple and variable products, which are set up to enable customers to pay for products directly on your site, affiliate products require inputting an affiliate link for each product during the product creation process. This ensures that when customers want to purchase affiliate products, they are redirected to the merchant’s store to place their order instead of checking out on your site. This earns you a commission percentage or fee without needing to do the extra work of fulfilling the order.
Adding these products one at a time is cumbersome once you’re working with more than a handful, and manual entry leaves room for pricing errors and mismatched affiliate links. Not every WordPress import plugin supports WooCommerce’s External/Affiliate product type specifically, which rules out importing this product type in bulk with those tools.
WP All Import supports WooCommerce’s External/Affiliate product type, mapping each product’s affiliate link, button text, and pricing directly from your import file. That’s what I’ll use for this guide.
WP All Import – The Best WooCommerce Import Plugin
I use WP All Import for this guide because it maps affiliate product data automatically, without requiring a fixed file structure or a set number of manual steps. Its Automatic Setup feature reads an uploaded file, detects the product data it contains, and fills in the WooCommerce field mapping on its own; I only need to review the result before running the import. For imports that need direct control over specific fields, WP All Import’s manual Drag & Drop setup is still available.

WP All Import imports thousands of affiliate products from CSV, XML, Excel, or Google Sheets files in minutes. It doesn’t matter what structure your file uses or whether your products contain custom data; WP All Import maps it regardless.
WP All Import also:
- Filters an import to specific affiliate products using rules you define before the import runs.
- Imports affiliate product custom fields alongside standard product data.
- Schedules affiliate product imports to run automatically on set days and times.
- Handles simple and variable WooCommerce products in addition to affiliate products.
- Modifies import data on the fly using PHP functions.
- Imports other WooCommerce data types, including orders, coupons, customers, and reviews.
- Extends to other WordPress post types, including pages and users.
- Includes advanced settings for optimizing import speed on large files.
These features are why I choose WP All Import as my go-to plugin for importing affiliate products into WooCommerce.
How To Import Affiliate Products Into WooCommerce
In this section, I will show you how to use the WP All Import plugin to import your affiliate products into WooCommerce quickly.
However, before I jump into it, the first step in setting up an import of your affiliate products is to purchase and download the WP All Import plugin and its WooCommerce Import Add-On on your site. The WooCommerce Import Add-On is needed to enable importing all WooCommerce products and data types.
Once the plugin and add-on have been downloaded to your PC, head over to your WordPress admin dashboard. From the menu, go to Plugins › Add New Plugin.
On the screen that appears, start by installing the WP All Import plugin by clicking Upload Plugin › Choose file › Install Now. The installation process will start and complete within seconds. Next, click Activate Plugin and the plugin will be installed and activated on your site.

The same steps should be followed to install and activate the WooCommerce Import Add-On.
Using Automatic Setup to Import Affiliate Products into WooCommerce
WP All Import’s Automatic Setup feature maps your affiliate product data to WooCommerce’s fields without a manual field-by-field setup. Here’s how to use it.
1. Start a New Automatic Setup
From your WordPress dashboard, go to All Import › New Import, then click Set up automatically. On the Select Your Import File screen, you can choose to either: upload your affiliate product file, download it from a URL, use an existing file, or connect via FTP/SFTP. WP All Import accepts XML, CSV, JSON, TXT, and compressed ZIP or GZ files up to 256MB.

2. Choose What to Import
Select WooCommerce, then choose Products as the import type. You can optionally add setup instructions to guide how WP All Import interprets your file before clicking Start Automatic Setup.

3. Review Your Automatic Field Mapping
WP All Import analyzes your file and maps its columns to the corresponding WooCommerce fields, including your affiliate products’ product URLs, button text, and pricing. The Your Import Is Ready screen shows your import type, status, the number of fields mapped, and how many records will be imported, along with the full field mapping for you to review.

4. Run the Import
Click Review Import Configuration to preview or adjust the mapping first, or click Run Import to start immediately. WP All Import shows the import running in real time, then confirms how many records were created, updated, or skipped once it finishes.

Manually Importing Affiliate Products with Field Mapping
Automatic Setup handles most affiliate product imports on its own, but some files need more direct control, such as those with a non-standard column layout, extra custom fields, or specific values that need adjusting during import. For those cases, WP All Import’s manual Drag & Drop setup lets you map every field yourself.
1. Start a New WooCommerce Affiliate Product Import
Go to All Import › New Import from your WordPress dashboard menu to access the New Import screen.

On this screen, you will see three options for importing your affiliate product data. You can Upload a file (from your PC), Download a file (from a URL or FTP/SFTP), or Use an existing file (if you have previously uploaded an import file).
Since this is your first import with the WP All Import plugin, you can select the option to either Upload a file or Download a file and then load your product import file.
Once your file is loaded, select WooCommerce Products as the import type under New Items. Next, click Continue to Step 2 to proceed.
3. Review Loaded Affiliate Product Data
On the Review Import File screen, you can review your import file to ensure that WP All Import correctly detects all the records in the file. Use the gray arrows on the left and right of the screen to navigate between records and confirm that there are no data inconsistencies.

To add filters to your import, scroll down to see the Manage Filtering Options panel. This panel contains WP All Import’s powerful filtering settings that enable you to import only desired products to your WooCommerce store based on defined specifications.
To add a filter, select any Element from your import file, define a filter Rule, and enter a Value. Next, click Add Rule and then Apply Filter to XPath. Your filter will be created and applied to your import.

You can also create multiple filters if necessary and combine them using the AND and OR conditions.
After you are done on this screen, click Continue to Step 3.
4. Map Affiliate Product Data to WooCommerce Fields
Data mapping, the most important step in the product import process, happens on the Drag & Drop screen.
WP All Import provides an easy-to-use drag-and-drop interface that makes mapping easy, even for beginners. The data from your import file is displayed in a table on the right side of the screen, while the product fields to be mapped are on the left.
Title & Description
The Title & Description panel provides fields to map your product title and description elements. Drag and drop the corresponding elements from your incoming data file into the fields to map them.

WooCommerce Add-On
From the WooCommerce Add-On panel, you can map all the standard WooCommerce product data fields for your affiliate products.
First, set the Product Type to External/Affiliate product. Doing this automatically changes the set of product tabs on the left that are available to be mapped.
The General tab is opened by default and provides input fields for mapping the SKU, Product URL, Button Text, Regular Price, and Sale Price. Map these fields with the elements from your incoming data file.

Below the fields, there are extra settings with default selections. The selections are ideal for most affiliate product imports. However, you can change them if necessary.
Open the Linked Products tab to map the Up-Sells and Cross-Sells for your affiliate products, if applicable.
From the Attributes tab, you can map the Name and Values of your product attributes. Advanced settings are provided to specify how WP All Import should handle the import of the product attributes. I recommend keeping the default settings.
Images
In the Images panel, you will see options to decide how you would like to import your affiliate product images. You can Download images hosted elsewhere, Upload images currently in Media Library, or Use images currently uploaded in wp-content/uploads/wpallimport/files/.

Since affiliate product images are often hosted on the merchant’s server, keep the default selection to Download images hosted elsewhere. Next, drag and drop the image URL element(s) from the incoming data into the provided field.
Below the mapping field, there are Image Options settings. Again, I recommend keeping the default selections since they work great for most imports.
Custom Fields
WP All Import also lets you map your affiliate products’ custom data in the Custom Fields panel.
If you already have products with custom fields in your WooCommerce store, WP All Import can auto-detect them. If any fields are detected, a notification and a See Detected Fields button are displayed at the top of the panel.

However, if you don’t have existing custom fields or would rather create them during the import, drag and drop the Name and Value elements for your products’ custom fields.

Use the Add Custom Field option to add as many as needed for your import.
WP All Import provides other panels to map additional data for your affiliate products and modify the import data. These include panels for Taxonomies, Categories, Tags, Function Editor, Other Product Options, and more. I won’t go into detail on those panels in this article.
Once you have fully mapped all the relevant fields, scroll to the bottom of the screen and click Continue to Step 4.
5. Apply Additional External Product Import Settings
On the Import Settings screen, you can configure additional settings to optimize how your import should run.
Start by setting a Unique Identifier for your import. To do this, you can drag and drop unique elements (such as IDs or SKUs) from your import file into the provided field, or click the Auto-detect button. The Unique Identifier helps WP All Import prevent product duplicates if you re-run the import in the future.

You will see some settings within the panel to dictate how WP All Import should handle records in the import file if the import is re-run. The default settings are fine for most imports.
The next panel is the Scheduling Options panel. This panel contains WP All Import’s powerful scheduling options that allow you to run your affiliate product imports automatically on specific days and times of the week or month. Check out the Run WordPress Import on a Schedule guide to learn more about the scheduling feature.
The panel to Configure Advanced Settings provides settings for optimizing the speed of your import. WP All Import selects the most optimal settings by default, so you can leave the selections as is. However, if you encounter issues while running the import, you can tweak the settings to better fit your import needs.

At the bottom of the screen, click Continue to move to the last step.
6. Run the WooCommerce Affiliate Product Import
The Confirm & Run screen is the final step of importing affiliate products into WooCommerce with WP All Import.

Here, you will see a summary of all the import settings you have applied. Review the settings to be sure your import will run without issues. If you notice any errors, you can go back and fix them before proceeding.
To run the import, click the Confirm & Run Import button.
Once the import is completed, you will see the Import Complete notification.

Navigate to Products › All Products to see the imported products. Open the product tabs for a few of them to cross-check that all the data was imported successfully.

Import Affiliate Products Into WooCommerce – FAQs
How Do I Add an External Product in WooCommerce?
To add an external product in WooCommerce, navigate to Products › Add New, change Product data to External/Affiliate product, then fill in the product details and click Publish. For adding multiple external or affiliate products at once, WP All Import’s Automatic Setup feature maps your product data to WooCommerce’s fields automatically, without manual field-by-field entry.
How Can I Import Products From Any Website to My WooCommerce Website?
You can import products from any website to your WooCommerce website using WP All Import’s Automatic Setup feature. Upload your product file, select WooCommerce › Products as what you’re importing, and WP All Import maps your file’s data to WooCommerce’s product fields automatically. For imports that need direct control over specific fields, WP All Import’s manual Drag & Drop setup lets you map each field yourself.
How Do I Import Data Into WooCommerce?
To import data into WooCommerce, install WP All Import and its WooCommerce Import Add-On, then follow these steps:
- Go to All Import › New Import and select Automatic Setup.
- Upload your data file.
- Select the WooCommerce data type you’re importing: Products, Orders, Coupons, Reviews, or Customers.
- Review the field mapping WP All Import generates automatically.
- Run the import to add your data to WooCommerce.
How Do I Add Digital Products to WooCommerce?
To add digital products to WooCommerce, go to Products › Add New, check the Virtual and Downloadable boxes under Product data, then fill in the product fields and click Publish. To import many digital products at once, WP All Import’s Automatic Setup feature maps your file’s data to WooCommerce’s fields without manual setup.
Get Oxygen
Build it your way with Oxygen.
Not per year, not per site, not per seat. 60 day money back guarantee.