Skip to main content
Updates / How To Import WooCommerce Products With Custom Fields Data
← All updates
 
Blog

How To Import WooCommerce Products With Custom Fields Data

Are you trying to figure out how to import WooCommerce products with custom fields into your store?

Custom fields are created to share or collect additional information about your products beyond the standard fields that WooCommerce provides.

Several WooCommerce product add-on plugins are available to enable you to add custom fields to your products easily. An example of this is the Advanced Custom Fields or Advanced Product Fields (Product Add-ons) for WooCommerce plugins. But if you need to bulk-import data into these custom fields, you may get stuck because WooCommerce’s native importer does not support importing data into these fields.

In this guide, I’ll show you how to use WP All Import to import products with custom fields into WooCommerce using its automated field mapping and custom value translation.

What Are Custom Fields in WooCommerce Products

Custom fields are additional WooCommerce product data fields for storing more detailed product information to enhance a product’s listing and drive increased conversions. 

You can create custom fields for virtually any additional information about your product that will be useful to customers, e.g. instructions for caring for the product, materials used, product dimensions, or even to collect customer order customization details.

Custom Fields can also be used to collect additional information from customers about a product. 

WooCommerce does provide the ability to add product attribute details by default, however, the customization options are limited. This is where custom field plugins become useful. Once you install a WooCommerce custom field plugin, you can use it to add additional custom fields to your WooCommerce products.

In the next section, we will explore how to import custom field data to WooCommerce using the WP All Import plugin.

How To Import WooCommerce Products With Custom Fields Data

WP All Import is the top choice among WooCommerce product import plugins in the WordPress ecosystem. It offers users the smoothest import experience with its Automatic Setup that automatically handles catalog analysis and custom meta detection on upload. This makes importing complex product data straightforward for users at any experience level

WP All Import plugin to import WooCommerce product data

The WP All Import plugin provides add-ons to import standard custom fields, as well as those added using plugins like the Advanced Custom Fields (ACF), Meta Box, JetEngine, and more. The plugin also offers many other great import features, including:

  • Support for importing products with custom field data from CSV, XML, Excel, and Google Sheets.
  • Advanced filtering capabilities to import only a subset of products.
  • Import scheduling to automate the import of products into your WooCommerce store.
  • Support for importing all WooCommerce product types, including variable products.
  • Support for importing all WooCommerce data types.
  • Support for importing all WordPress post types, and more.

To start your WooCommerce import of products with custom fields, purchase and download the WP All Import plugin and its WooCommerce Add-On.

First, install the WP All Import plugin by going to your WordPress admin dashboard and navigating to Plugins ›  Add New Plugin › Upload Plugin › Choose File ›  Install Now › Activate Plugin. The plugin will be installed and ready for use.

install wp all import

Follow the same steps to install and activate the WooCommerce Import Add-On. Once this is completed, you are ready to create an import for your WooCommerce products with custom fields.

1. Start a New Product Import With Custom Field Data

To start importing your WooCommerce products with custom field data, go to All Import › New Import from your WordPress dashboard menu.

At the top of the screen, click the Set up automatically banner to launch the automated import wizard.

WP All Import automatic setup banner

WP All Import allows you to load your data in four ways: uploading the import file from your PC, downloading the file from a URL, importing a file from an FTP/SFTP server, or using a file that you have previously uploaded.

wp all import automatic setup file selection

Once your file is uploaded, select WooCommerce, then choose Products (Simple, Variable, Grouped).

Expand the optional Add Setup Instructions field. If your spreadsheet contains unique metadata or custom attributes created by plugins like Advanced Custom Fields (ACF), Meta Box, or JetEngine, you can give the setup wizard specific guidance on how to treat those columns. For example, you can enter instructions like “Map the material_composition column to the ACF Material field” or “Treat warranty_period as a product custom field”. This ensures that WP All Import recognizes non-standard column headers and pairs them with the correct custom fields right from the start.

WooCommerce product import add instructions for custom fields

Once ready, click Start Automatic Setup. WP All Import analyzes your spreadsheet, detects custom field columns and product attributes, and configures field mappings automatically.

2. Review Uploaded Product Data and Confidence Score

Once analysis completes, WP All Import presents the Your Import Is Ready summary card, displaying the detected product type, total record count, number of fields mapped, and an overall confidence score.

Your Import is ready WP All Import Automatic Setup

Below the summary card, scroll through the Field Mappings list to verify that standard product attributes and custom field columns mapped accurately.

WP All Import Automatic Setup field mapping

If your spreadsheet uses standard column headers, your setup is complete: you can run the import immediately or click Manual Setup to inspect auto-mapped custom fields in the template editor.

If you need to filter your import, click Review Import Configuration, scroll to the bottom of the screen, and click Back to Create Filters to access the Manage Filtering Options panel. Within this panel, you can set rules based on any element in your file (including custom fields) to filter which products are imported.

apply filters to WooCommerce product data

After reviewing your uploaded product data and adding filters as you see fit, click Continue to Setup Import.

3. Review Auto-Mapped Custom Fields in the Template Editor (Optional)

Because Automatic Setup pairs your spreadsheet columns to WooCommerce fields on upload, manual mapping is completely optional. If you click Review Import Configuration, the template editor opens with all fields pre-filled from your file.

Your incoming product data is listed in a tree on the right, while the target WooCommerce fields are organized into panels on the left.

Title & Description

Automatic Setup pre-fills the Title and Description fields from your file. You can adjust text formatting or drag additional elements into these fields if you want to include extra details in your listings.

map incoming product data to WooCommerce fields

WooCommerce Add-On

Open the WooCommerce Add-On panel to review the standard fields for your WooCommerce products. The wizard automatically sets the Product Type (simple, variable, grouped, or external/affiliate) and pre-populates the SKU, Regular Price, and Sale Price fields.

map woocommerce standard fields

You can also check the Inventory, Shipping, and Attributes tabs to ensure product dimensions, stock quantities, and variation attributes are mapped properly.

Review Product Custom Fields

Open the Custom Fields panel to inspect your auto-mapped metadata.

Custom field panel in WP All Import to map WooCommerce product data

WP All Import lets you auto-detect and populate existing custom fields. If you have previously published products with custom field data, you will see the See Detected Fields button. Click the button to enable WP All Import to present and populate the existing custom fields.

Custom field panel in WP All Import

You should see the Name and Value of each detected custom field. Each field’s value can either be literal text or a selection list. 

If the custom field value you want to import to your site differs from what’s in your import file, you can select Mapping under Field Options to configure the correct values. 

For example, let’s assume you own a sportswear store with a custom field for storing information about its colors. Say the field name is sprtwears_color and the possible values are Red, Blue, White, and Black. If your import file has a {colors} element with hex code values, i.e. #FF0000 (Red), #0000FF (Blue), #FFFFFF (White), and #000000 (Black), you cannot simply drag and drop the element into the custom field Value input box without mapping them. This is because the value will not be recognized.

additional custom field options in WP All Import

To remedy this, after dragging and dropping the value, you must click Field Options and select Mapping to reveal the dialog box that enables you to specify the mapping rules. For our example, under In Your File, we will enter the hex value for each color from our input file, and under Translated To, we will enter the corresponding existing text values. 

translate custom field data in WooCommerce

This ensures that when the import is run, #FF0000 in our import file will be translated to Red, #0000FF will be translated to Blue, etc.

If you don’t have existing custom fields, you can create new fields by specifying the Name and dragging and dropping the relevant elements that contain the custom field Value.

Other Panels

WP All Import provides other panels to map additional product data relevant to your import. These panels include Images, Taxonomies, Categories, Tags, Function Editor, etc. However, we will not discuss these other panels in this article.

4. Preview Live WooCommerce Products

Before committing data to your live store, click Preview at the bottom to inspect how your products and their custom fields would look on a real store:

  • WP Admin View: This lets you confirm that your custom fields, ACF panels, and attribute values populate the correct backend database fields.
  • Frontend View: Renders an interactive product page, allowing you to confirm that custom specifications, tabs, and photo galleries display properly for shoppers.

If everything looks accurate, click the Continue to Import Settings button.

5. Configure Advanced Product Import Options

The Import Settings screen lets you configure additional settings for how your product import should run.

Start by confirming the Unique Identifier, as it ensures that WP All Import correctly links records in your current file to existing products in your database. This prevents duplicates and allows you to update custom field values on existing products without creating new entries. 

set unique identifier of the import

Other settings are provided within the panel to specify how WP All Import should handle each record in the import file every time the import runs. Leave them as is, or change them if necessary.

Scroll down the screen to reveal the Scheduling Options and Configure Advanced Settings panels. The Scheduling Options panel provides settings to schedule your import to run automatically on specific days and times of the week. You can learn more about the panel in the Run WordPress Imports on a Schedule guide.

import scheduling option in WP All Import

In the Configure Advanced Settings panel, you have options to optimize the speed of your import. Leave the default settings or adjust as you see fit.

Click Continue to proceed.

6. Run Product Import Containing Custom Field Data

The Confirm & Run screen is the final step of the WooCommerce import of products with custom fields process. 

review import settings before running the import

WP All Import provides a summary of all the import settings you have applied so you can check to ascertain that everything is as it should be for your import to run smoothly. If you notice any issues, go back and fix them before running the import.

However, if everything is as expected, click the Confirm & Run Import button to start the import process. Your import will be completed within a few minutes, and you will see an Import Complete notification.

product import complete with custom field

Check your imported products by navigating to Products › All Products to see the list of products. Review a few products randomly to check that all the data, including the custom fields, were imported correctly.

As you can see, importing WooCommerce products with custom fields is easy with the WP All Import plugin. If you want to start seamlessly importing your products with custom field data, download and install the WP All Import plugin today!

FAQs on Importing WooCommerce Products With Custom Fields

How Do I Add Custom Fields to WooCommerce Products?

To add custom fields to WooCommerce products at once, download and install the WP All Import plugin and its WooCommerce Import Add-On.

  1. Navigate to All Import › New Import and click the Set up automatically banner.
  2. Upload your file (CSV, XML, Excel, or Google Sheets URL) and select WooCommerce, then Products as the import type.
  3. Click Start Automatic Setup to let WP All Import analyze your file and detect custom fields automatically.
  4. Check the summary card, or click Manual Setup to open the Custom Fields panel and fine-tune your metadata.
  5. Click Run Import to publish your products and custom field data to your WooCommerce store.

How Do I Import Products Into WooCommerce?

You can import products into WooCommerce with the WP All Import plugin and its WooCommerce Import Add-On. Once you have downloaded and installed them on your site:

  1. Go to All Import › New Import and click the Set up automatically banner.
  2. Upload your product data file.
  3. Choose WooCommerce, then Products as the import type.
  4. Click Start Automatic Setup to let the plugin detect product types and map pricing, stock, and attributes automatically.
  5. Review the summary card and click Run Import to add the products to your store.

How Do I Import Product Attributes in WooCommerce?

To import product attributes in WooCommerce, get the WP All Import plugin and its WooCommerce Add-On. 

  1. Go to All Import › New Import and click the Set up automatically banner.
  2. Upload your product data file containing attribute columns.
  3. Select WooCommerce, then Products as the import type.
  4. Click Start Automatic Setup to analyze variation attributes (such as color or size) and map global taxonomy attributes automatically.
  5. Run the import to publish your products with their matching attributes.

How To Import Variable Products in WooCommerce?

You can import variable products in WooCommerce with the WP All Import plugin and its WooCommerce Import Add-On. 

  1. Navigate to All Import › New Import and click the Set up automatically banner.
  2. Upload your variable product spreadsheet and select WooCommerce, then Products.
  3. Click Start Automatic Setup to automatically link child variations to parent products via SKU or group ID.
  4. Review the auto-mapped variation attributes on the summary card.
  5. Click Run Import to import your variable products in a single pass.

Get Oxygen

Build it your way with Oxygen.

$199.50 once — unlimited sites, no renewal

Not per year, not per site, not per seat. 60 day money back guarantee.