---
title: "How to Import Affiliate (External) Products into WooCommerce"
url: "https://wpimportexport.com/import-affiliate-external-products-woocommerce/"
description: "Import WooCommerce external/affiliate products from CSV with buy links, button text, images and categories, then update partner prices daily by SKU."
type: post
published: 2026-11-08T17:39:34+00:00
modified: 2026-11-18T13:09:22+00:00
categories: ["Import Guides", "Tutorials", "WooCommerce"]
tags: ["CSV import", "Import Export by RockStarLab", "WooCommerce", "WordPress import"]
docs_topics: ["Import guides", "WooCommerce"]
---

# How to Import Affiliate (External) Products into WooCommerce

An affiliate store does not ship anything itself. Each product page shows the item, its price and a button that sends the visitor to the partner’s shop with your affiliate tag in the link. WooCommerce has a product type for this, **External/Affiliate product**, but creating hundreds of them by hand is slow, and the partner’s prices change all the time. Below: importing them from a CSV with the buy link, button text, images and categories, and updating their prices later without breaking them.

We tested it with [Import Export by RockStarLab](https://wordpress.org/plugins/import-export-by-rockstarlab/) 2.1.27 and the **PRO** add-on 2.1.7, WooCommerce 11.2 and WordPress 7.1. Importing WooCommerce products is a PRO feature.

## Short Answer

1. Make a CSV with **Type** = `external`, **External URL** (the partner page with your affiliate tag) and **Button text**, plus SKU, name, prices, categories and images.
2. Back up the site.
3. Go to **Import Export → Import → WooCommerce Products**, upload the file and click **Auto Map**.
4. Match by **SKU**, keep **Automatically Import Media Files** on and import.
5. For daily price changes, import a file with only **SKU**, **Regular price** and **Sale price**.

## The CSV

Most affiliate networks and partner programs give you a product export or a feed. Whatever its format, the file you import needs these columns:

![affiliate-products.csv: SKU, Type external, Name, Regular price, Sale price, External URL with ?ref=examplestore, Button text Buy at Partner Store or Check price, Categories, Images for Sherpa Zip Hoodie, Washed Trucker Cap, Canvas Web Belt and Polarized Sunglasses](https://wpimportexport.com/wp-content/uploads/2026/11/01-affiliate-products-csv-scaled.webp)

_Partner products with type external, buy link and button text._

- **SKU**: the partner’s product ID or any unique code. It lets you update the product later.
- **Type**: `external`. This makes the product an External/Affiliate product with a buy button instead of an add-to-cart button.
- **External URL**: the page the button opens, with your affiliate parameter (`?ref=examplestore` in our example).
- **Button text**: the label of the button, such as “Buy at Partner Store” or “Check price”. Leave it empty to use WooCommerce’s default “Buy product”.
- **Regular price** and **Sale price**: shown on your page; the visitor pays on the partner’s site.
- **Categories**: `Clothing > Hoodies` creates Hoodies under Clothing if needed.
- **Images**: image links; the first is the product image, others go to the gallery. Check that your program allows you to show the partner’s images.

If you don’t put a Type column in the file, a row that has an External URL is still created as an external product.

## Step 1: Back Up the Site

The import creates products and downloads images. Make a backup first: UpdraftPlus **Backup Now**, your host’s backup, or ask an AI agent to run `rsl-ie/updraftplus-backup-start`. See [How to Create a WordPress Website Backup and Restore It](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/).

## Step 2: Upload and Map

Open **Import Export → Import**, choose **WooCommerce Products**, upload the CSV and click **Auto Map**. The column names of WooCommerce’s own CSV format are recognized, so all 10 columns were mapped, including **External URL** to `product_url` and **Button text** to `button_text`:

![Field Mapping after Auto Map: 10 of 10 fields mapped; SKU, Type to product_type, Name to post_title, External URL to product_url, Button text to button_text, Categories to product_cat, Images to product_images, Short description to post_excerpt](https://wpimportexport.com/wp-content/uploads/2026/11/02-auto-map-external-url-button-scaled.webp)

_External URL and Button text are matched automatically._

On **Import Options**, set **Check for Existing Items by Field** to **SKU**, keep **If Match Found: Update** and **If No Match Found: Create**, and leave **Automatically Import Media Files** on. Start the import:

![Import Completed Successfully: Successful 4, Created 4, Failed 0](https://wpimportexport.com/wp-content/uploads/2026/11/03-import-result-4-created.webp)

_Four affiliate products created._

## Step 3: Check the Products

Open one of the products. **Product data** shows **External/Affiliate product** with the URL, the button text and the prices from the file:

![Product data External/Affiliate product: Product URL https://partner-store.example.com/p/sherpa-..., Button text Buy at Partner Store, Regular price 64.00, Sale price 54.00](https://wpimportexport.com/wp-content/uploads/2026/11/04-external-affiliate-product-data.webp)

_The imported product is an External/Affiliate product._

On the product page, the visitor sees the sale price and the button, which opens the partner’s page with your tag:

![Sherpa Zip Hoodie product page: sale badge, price $54.00 instead of $64.00, short description and a Buy at Partner Store button](https://wpimportexport.com/wp-content/uploads/2026/11/05-product-page-buy-button-scaled.webp)

_The button sends visitors to the partner with your tag._

External products have no cart, stock or shipping in your store. Click the button on one product to make sure the link is right and your tag is in it.

## Step 4: Update Prices Every Day

Partner prices and sales change often. You don’t need to import the whole file again; a file with the SKU and the two price columns is enough:

![affiliate-prices.csv with SKU, Regular price, Sale price: hoodie 64.00 with empty sale price, cap 21.00, belt 26.00, sunglasses 79.00 with sale 59.00](https://wpimportexport.com/wp-content/uploads/2026/11/06-daily-price-update-csv.webp)

_A price update: SKU and the two price columns._

Import it as before, with **If Match Found: Update** and **If No Match Found: Skip**, so a SKU that is not in your store is ignored. In our update:

- The hoodie’s sale ended: its **Sale price** cell is empty, which removes the sale price.
- The cap costs $21 instead of $19.
- The sunglasses have a new sale price, $59.

![Products after the price update: Sherpa Zip Hoodie $64.00, Washed Trucker Cap $21.00, Canvas Web Belt $26.00, Polarized Sunglasses $79.00 crossed out $59.00](https://wpimportexport.com/wp-content/uploads/2026/11/07-products-after-price-update.webp)

_Prices follow the partner; the products stay external._

The products stay External/Affiliate products with their links, buttons, images and categories, because the file has no columns for those. Only the prices changed.

If the partner publishes this file at a fixed address, you can let the plugin download it every day and run the update on its own; see [Automatic Supplier Feed Import for WooCommerce](https://wpimportexport.com/automatic-supplier-feed-import-woocommerce/).

## Common Mistakes

- **The affiliate tag missing from the URL.** Without it the partner cannot credit you. Check the External URL column before importing, and click a few buttons afterwards.
- **Type “simple” for affiliate items.** Then the product gets an add-to-cart button and visitors try to buy it from you. Use `external`, or leave the Type column out and keep the External URL.
- **Removing a sale by leaving out the column.** A file without a Sale price column keeps the current sale prices. To end a sale, include the column and leave the cell empty.
- **Prices in another currency.** The import saves the numbers as they are. Convert them to your store currency in the file first.
- **Duplicates when the partner changes product IDs.** A new SKU creates a new product. Delete or redirect the old one, or keep your own stable SKUs.

## FAQ

### Can I add “nofollow” or “sponsored” to the buy buttons?

The button is output by WooCommerce and your theme. Search engines expect affiliate links to be marked; use a small snippet or a plugin that adds `rel="sponsored"` to external product buttons.

### Can I mix affiliate and normal products in one file?

Yes. The Type column decides per row: `external` for affiliate items, `simple` or `variable` for products you sell yourself.

### Will updates overwrite descriptions I wrote myself?

Only if the update file has a description column. Leave it out and your texts stay.

### Do I need PRO?

Yes, importing WooCommerce products is part of the PRO add-on.

## Related Guides

- [How to Import WooCommerce Products from CSV or Excel](https://wpimportexport.com/how-to-import-woocommerce-products-from-csv-or-excel/)
- [How to Import WooCommerce Product Images from URLs](https://wpimportexport.com/import-woocommerce-product-images-from-urls/)
- [Automatic Supplier Feed Import for WooCommerce](https://wpimportexport.com/automatic-supplier-feed-import-woocommerce/)
- [How to Update WooCommerce Prices and Stock by SKU from CSV](https://wpimportexport.com/how-to-update-woocommerce-prices-stock-by-sku-csv/)

Get the free plugin on [WordPress.org](https://wordpress.org/plugins/import-export-by-rockstarlab/).
