00
:
00
:
00
LIMITED TIME OFFER: Act now to lock in a 50% discount!
Risk free, backed by our 90-Day Money Back Guarantee.
Get Started

You may have seen some references on our site to annual licensing or renewals.

All plugins currently come with a lifetime license, no matter what the site says.

We’re currently running tests before we make the switch to annual pricing. Check the Discounts tab to purchase our other plugins and get a lifetime license before they’re gone.

I Understand I Have a Lifetime License

Lifetime licenses are only available for a short time!

SPECIAL OFFER 
Save 50% OFF For a Limited Time!
Now is your last chance to buy a lifetime license before we switch to annual pricing. Existing lifetime licenses will be unaffected so get in while you can!
  • 90-Day Money-Back Guarantee
  • Fast World Class Support
  • Unlimited Sites
  • Free Lifetime Updates
  • Easy to Use
  • Developer Friendly
Risk free! Cancel at any time with our 90-day guarantee.
"All Import/Export is an awesome suite of tools. It gets me out of some tough challenges."
Eric Karkovack, Freelance Writer
"WP All Import - Versatile, and I have saved so much time with it over the years."
Matt Andrews, Full Stack Web Developer
"@WPAllImport just let me import 3000 products from some arbitrary Excel to WooCommerce w/ a few clicks, including images and categories."
Joris Witteman, Developer / Designer

Wait, Don’t Miss Your Chance for a Lifetime License!

@glitzformals
"This plugin is a game changer for my situation. I’m stunned at how fast and effortless the import process is."
@adatfalo
"I have never experienced such a quick and helpful support experience with any plugin, and by the way, the knowledge of the support colleagues is professional!"
@jessedw44
"Even if you just use this plugin once, it will save you time. If you work on several sites its invaluable. Constantly developed, and continuously supported. Great job."

90-Day Guarantee

Not 100% happy? Let us know and we’ll promptly send you a refund.

Free Updates For Life

Pay once for unlimited installs, even client sites. No renewal fees.

World Class Support

Over 9 years experience with WordPress imports and exports.

Your Last Chance for a Lifetime License!

We are soon moving to yearly licenses only. Once lifetime licenses are gone, they're gone forever.
@adatfalo
"I have never experienced such a quick and helpful support experience with any plugin, and by the way, the knowledge of the support colleagues is professional!"
@jessedw44
"Even if you just use this plugin once, it will save you time. If you work on several sites its invaluable. Constantly developed, and continuously supported. Great job."

90-Day Guarantee

Not 100% happy? Let us know and we’ll promptly send you a refund.

Free Updates For Life

Pay once for unlimited installs, even client sites. No renewal fees.

World Class Support

Over 9 years experience with WordPress imports and exports.
Now is your last chance to buy a lifetime license before we switch to annual pricing. Existing licenses will be unaffected.
Read More

How to Import WooCommerce Products from CSV and XML

To import WooCommerce products, navigate to All Import › New Import, choose your import file, and select WooCommerce Products from the list. Use the Drag & Drop interface to build your import template, then run your import.

This documentation covers how to import WooCommerce products using WP All Import. For a broader look at importing WooCommerce products, check out:

Step 1: Create a New WooCommerce Product Import

Go to All Import › New Import and select/upload your import file. In the dropdown list, choose to import WooCommerce Products.

Import WooCommerce Products Create New Import

Click Continue to Step 2.

Step 2: Review Data to Import WooCommerce Products

You now see the Review Import File screen, where you can validate that the import data looks correct.

Import WooCommerce Products Review Import File

If you're importing a CSV file, you can set a different delimiter for the CSV fields. If you're importing an XML or Excel file, you can choose which parent node to use in the import process.

Near the bottom, you can use the Manage Filtering Options section to add filters to your import.

To proceed to the next step, click Continue to Step 3.

Step 3: Map Incoming Data to WooCommerce Product Fields

The Drag & Drop interface now appears, where you can build the template to import WooCommerce products. To map the required fields, drag and drop the data elements from the panel on the right to their appropriate import fields on the left.

Title & Description Section

Here, you map the WooCommerce product title and description.

Import WooCommerce Products Title and Description

Next, expand the WooCommerce Add-On section.

WooCommerce Add-On Section

In this section, you can define the import Product Type. By default, it's set as Simple product but this can be changed to a different product type. You can also choose the option Set Product Type With XPath and use an import element with an accepted product type (i.e., simple, grouped, external, variable).

Product Import General Tab

Right below the product type, you will see several tabs to configure the import. General, the first tab, is selected by default:

Import WooCommerce Products General Tab

Here, you can set up the following fields:

  • SKU: stock keeping unit, used internally by WooCommerce to keep track of your products.
  • Regular Price: the amount to use as the normal product price.
  • Sale Price: the amount to use as the discounted product price.
  • Adjust Prices: a section where you can adjust the prices imported by percentages or fixed amounts.
  • Remove currency symbols from price: attempts to remove currency symbols from the imported price. Enabled by default.
  • Convert decimal separator to a period: converts any commas to periods in the price. Enabled by default.
  • Attempt to convert incorrectly formatted prices to WooCommerce format: self-explanatory. Disabled by default.

You also have a Preview Prices button that will show an example of how the prices are imported for that record.

Below this, you can see different sections allowing you to configure if the product is Virtual or Not Virtual, if it's a Downloadable or a Not Downloadable product, and to define the Tax Status and the Tax Class.

If you don't want to select a specific option for these four settings, you can dynamically set them using the Set with XPath option. This allows you to map the settings to incoming data elements.

Product Import Inventory Tab

This tab contains settings related to stock availability:

Import WooCommerce Products Inventory Tab

The four settings available are:

  • Manage stock?: You can select Yes and then import a Stock Qty or select No to avoid managing stock. No is set by default. To import dynamically, select Set with XPath and import either yes or no.
  • Stock status: You can assign a stock status to the imported product, either In stock or Out of stock. By default, Set automatically is set, which uses the stock quantity to assign the stock status. To import dynamic data, select Set with XPath and import any of the accepted values: instock, outofstock, onbackorder.
  • Allow Backorders?: Used to enable or disable backorders in the product. Do not allow is set by default. You can also select Allow, but notify customer and Allow. The Set with XPath option accepts the values: no, notify, and yes.
  • Sold Individually?: By default, No is set. You can also select Yes. The Set with XPath option accepts yes or no.

Product Import Shipping Tab

Next up is the Shipping tab, where you can import the product's weight and dimensions along with the Shipping Class.

Import WooCommerce Products Shipping Tab

The Set product shipping class with XPath option accepts the name, ID, or slug for the shipping class.

Linked Products tab

In this tab, you can define Up-Sells, Cross-Sells, and also group products with Manual Grouped Product Matching.

Import WooCommerce Products Linked Products Tab

Product Attributes

The Attributes tab enables you to import product attributes, which you can use to better sort products. You can add as many attributes as needed.

Import WooCommerce Products Attributes Tab

The name used will be converted to a slug that is matched to any existing attributes.

You can also use the attribute slug, instead of the name, to directly match with any existing attribute. For example, if your attribute slug is color-slug, you match with it like so:

Import Products Match Attribute Slug

Product Import Advanced Tab

The Advanced tab has the Purchase Note and Menu order import fields.

Import WooCommerce Products Advanced Tab

This tab contains the following settings:

  • Enable reviews: By default, No is set. You can also select Yes. The Set with XPath option accepts yes or no.
  • Featured: By default, No is set. You can also select Yes. The Set with XPath option accepts yes or no.
  • Catalog visibility: By default, Shop and search results is set. You can also select:
    • Shop only
    • Search results only
    • Hidden
    • Set with XPath: accepts any of the following values: visible, catalog, search, hidden.

Add-On Options

The last tab is Add-On Options.

Import WooCommerce Products Add On Options Tab

Here, you have the following import options:

  • Disable auto SKU generation: This option is disabled by default. When checked and the SKU is empty, it won't generate a random SKU using the md5 algorithm.
  • Don't check for duplicate SKUs: This option is enabled by default. When unchecked, WP All Import will try to find duplicate SKUs. Any match found will be imported with a blank SKU.

Other Sections

There are other sections available when you import WooCommerce products, such as Images, Custom Fields, Other Product Options, etc. However, we won't cover them here.

After you map all product data elements, click Continue to Step 4 at the bottom (not shown).

Step 4: Configure Import Settings to Import WooCommerce Products

Now the Import Settings interface appears, where you change or modify the import configurations. First, proceed to click on Auto-detect to automatically generate a unique identifier for your product's import.

Import WooCommerce Products Import Settings

In the subsequent panel, you can tell WP All Import how to behave whenever this import runs again. For example, you can select whether to create new products or not, modify existing products with new data, or delete existing products that are no longer found in the import file.

Below that, you can find panels to define Scheduling Options and Configure Advanced Settings. Leave these alone for now, as these settings can typically use their default selections.

Click Continue at the bottom to move on to the next step.

Step 5: Run the Import and Verify the Imported Products

Before running the import, you will see the Confirm & Run screen, where you can review the import summary:

Import WooCommerce Products Confirm and Run

If all looks in place, click Confirm & Run Import to continue and run the import. Once the import completes, you will see the following screen:

Import Complete

Navigate to Products › All Products in the WordPress menu to confirm that all WooCommerce products were correctly imported:

Import WooCommerce Products List of Products

Import WooCommerce Products – Advanced Topics

Import Variable WooCommerce Products

To import WooCommerce variable products, you can follow the steps above but choose Variable product as the Product Type. This will enable the Variations tab, which allows you to configure and import variable products.

Import WooCommerce Products Variable Product Type

To learn more about this and see file examples, please see How To Import Variable WooCommerce Products.

Import External/Affiliate WooCommerce Products

To import WooCommerce external or affiliate products, follow the steps above but choose External/Addiliate product as the Product Type. Enabling this product type will hide the Inventory and Shipping tabs.

Import WooCommerce Products External Affiliate Product Type

This product type uses a Product URL and a Button text.

Import Grouped WooCommerce Products

To import WooCommerce grouped products, follow the steps from this guide but instead select Grouped product as the Product Type. This action will hide the Shipping tab.

Grouped Product Type

This import type requires a way to group all imported products together, such as a group ID.

The first imported image will be set as the Featured Image as long as the option Set the first image to the Featured Image (_thumbnail_id) is enabled. Any additional images will be added as a part of the Product Gallery.

If the option described above is not enabled, all images are added as part of the Product Gallery.

If you're importing images into a different plugin, you may need to use custom code and our API to add the images as required.

Sync Stock and Price for Imported WooCommerce Products

Syncing WooCommerce product's stock and price is fairly simple. Here's what to do when using a different file than the one used to import the products:

  • Create a new Existing Items import with the data to update.
  • Set up the import to update only price and/or stock.
  • Schedule that import so that it runs automatically.

To learn more, please see:

If you're using the same import source used to import these products (such as a file from an URL), you can modify the existing import and set it up to only update stock/price when the import is re-run.

Import WooCommerce Products – Frequently Asked Questions

How Do I Import a CSV File Into Products?

To import a CSV file into products, just specify the CSV file as your import source in the All Import > New Import screen. Our plugin will recognize the file format and will automatically adjust its interface accordingly.

How Do I Import a Product Spreadsheet into WooCommerce?

To import a product spreadsheet into WooCommerce, save or export the spreadsheet data as a CSV file. You can then load the CSV file as your import source, and our plugin will take it from there.

How Do I Import Products From XML?

To import products from XML, just specify the XML file as your product source. WP All Import will automatically recognize the file type, parse the XML, and adjust its interfaces as required. It doesn't matter if the XML is simple or complex — we've got you covered!

How Do I Import a Product Feed into WooCommerce?

A product feed is usually organized around a URL or FTP/SFTP import source. Our plugin will handle either. Just select Download a File > From URL or Download a File > From FTP/SFTP and provide the information required by the interface.

Can I Import Any WooCommerce Product Type?

Yes. You can import any standard product type such as simple, variable, grouped, affiliate, simple subscription, etc. To do this, just set the product type during the import process. WP All Import will adjust the panels, fields, and options accordingly.

How Do I Import WooCommerce Products With Images?

We provide complete support for importing products with images. You can use images already in the media library, download them from another website, or import images that you uploaded to your server in advance. You can also avoid duplicates by having our software check for existing images during the import process.

How Do I Import Products to WooCommerce for Free?

To import products to WooCommerce for free, you can use our Import Products from any XML or CSV to WooCommerce free add-on. Note, however, that to get full support for Grouped, External/Affiliate, and Variable products, you will need to upgrade to our premium version.

How to Schedule and Automate WooCommerce Products' Import?

You can schedule and automate your WooCommerce product's import using these options:

  • Cron Jobs, which are set up via cPanel or Plesk. See Manual Scheduling.
  • Automatic Scheduling Service, which is an optional monthly subscription that allows scheduling an import directly from within WP All Import's interface. See Automatic Scheduling.

Keep in mind that to schedule an import, you must download the import file (from an URL or FTP) or use the Use existing file option in the Settings interface.

How Do I Export WooCommerce Products?

  1. Navigate to All Export New Export in the WordPress main menu.
  2. Choose WooCommerce Products as your export post type.
  3. Set filters, if applicable.
  4. Use our Drag & Drop interface to select your export columns.
  5. Run the export.
  6. Download your product file.

For a full list of import features, see Export WooCommerce Products.

How Do I Migrate WooCommerce Products?

  1. Use WP All Export to output your WooCommerce products.
  2. Choose the Bundle option when downloading your export file. The bundle file contains an import template in addition to the product data.
  3. Upload the bundle file on the target site.
  4. Based on the information contained in the bundle file, WP All Import will import the products with very little additional user input.
  5. Check your imported products.

For additional information, see Migrate WooCommerce Products.

Learn how to export WooCommerce products.

Describes how to export WooCommerce variable products.

Describes how to import WooCommerce variable products.

Learn how to export WooCommerce products with images.

Learn how to import WooCommerce products with images.

Describes how to bulk edit WooCommerce products.

Describes how to migrate WooCommerce products from one website to another.

Lifetime support. Lifetime updates. Pay once.

Packages
Standalone
Import
Pro Package
$249
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Pro Package
$299
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
WooCommerce Import Package
$149
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Standalone
$169
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Export Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee

Unlimited Installs. World-class Support.
Money Back Guarantee.

Packages
Standalone
Import
Pro Package
  normally $499.00  
$249.00
/year
Save $250, 50% Discount
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Pro Package
  normally $599.00  
$299.00
/year
Save $300, 50% Discount
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
WooCommerce Import Package
  normally $299.00  
$149.00
/year
Save $150, 50% Discount
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import Standalone
  normally $199.00  
$99.00
/year
Save $100, 50% Discount
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Standalone
  normally $339.00  
$169.00
/year
Save $170, 50% Discount
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Export Standalone
  normally $199.00  
$99.00
/year
Save $100, 50% Discount
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
cross