WooCommerce: How to Export and Import PODS Custom Fields

Let’s learn how to export and import PODS custom fields in WooCommerce products.

If you’re managing a WooCommerce store and using the PODS plugin to add custom fields to your products, you might need to export that product data to a spreadsheet, or import changes back into your store. Whether you’re updating prices, editing descriptions, or migrating product info between sites, doing it manually can be slow and frustrating.

Related: Bulk Edit WooCommerce PODS Custom Fields

In this tutorial, we’ll show you how to easily export and import PODS custom fields in WooCommerce products, using the WP Sheet Editor plugin. This plugin gives you a powerful spreadsheet inside WordPress where you can view, edit, and manage your product data, including custom fields from PODS. You can download the data to a CSV file, make changes in Excel or Google Sheets, and upload everything back with just a few clicks.

NOTE. We assume you already installed the PODS plugin on your WordPress site and have added some custom fields to your products.

Install WP Sheet Editor

You need to install WP Sheet Editor on your WordPress site in order to export and import PODS custom fields.

Besides the WP Sheet Editor plugin, you need to install the free WP Sheet Editor – PODS extension, which adds compatibility between PODS and WP Sheet Editor so that you can manage custom fields easily.

After installing the plugin and the extension, you can follow the steps in the sections below in order to bulk export and import PODS custom fields in WooCommerce products.

Open the products spreadsheet

To view and manage your WooCommerce products in a spreadsheet, go to WP Sheet Editor > Edit products in the WordPress admin dashboard.

You’ll see all your products displayed in the spreadsheet as rows, and all product fields as columns.

Display PODS custom fields in the spreadsheet

To make sure all custom fields added with PODS appear in the spreadsheet, you need to refresh the database.

To do this, click Settings > Scan DB to find fields.

Export WooCommerce PODS custom fields

If you want to export the data of your PODS custom fields to a CSV file, you can do it with the Export tool.

This is great because you can edit PODS data on WooCommerce products using Excel, Google Sheets, or any other CSV editor.

Optional – Search for the products you want to export

The Search tool allows you to filter your WooCommerce products using any field as a search filter.

You can search for products by keyword, category, tag, attribute, visibility, shipping class, etc.

You can also use PODS custom fields as search filters. In this example, we will use three custom fields added with the PODS plugin.

Tick the Enable advanced filters checkbox and add the custom fields as search filters.

We will search for all the products that have these values:

• Support email = [email protected]
• Expiry Date = 2025-06-30.
• Product video = Empty.

Once you have selected the search filters, click on Run search.

You will see all the WooCommerce products matching the search terms displayed in the spreadsheet.

Also, you’ll see the active search filters above the spreadsheet.

Open the Export tool, which allows you to download products’ data to a CSV file.

Now select these values to download a CSV containing your products data:

• What columns do you want to export: In this example, we will export the PODS custom fields only.
• Which rows do you want to export: We will export all the rows from our current search.
• What app will you use to edit this file: We will select Google Sheets for this example.
• Name of this export. This is optional and allows you to save these export settings for future exports.
• Click on Start new export.

Edit PODS custom fields in a CSV file

After downloading the CSV file containing your WooCommerce products with PODS fields, you can edit values from the custom fields in Excel, Google Sheets or any other CSV editor.

Import WooCommerce PODS custom fields

After editing custom fields in the CSV file, you can import the values into WooCommerce to bulk update product custom fields.

First, open the Import tool.

Second, select the CSV file that you will import:

• Source: CSV file from my computer
• Click on Choose File.
• Locate the CSV file on your computer.
• Click on Next.

Third, click on Import all the columns or Select individual columns to import.

Fourth, configure how you want to import the PODS custom fields data:

• Do you want to update or create items: We will update existing items and ignore new items because we’re not creating new products in this import.
• Since we’re updating existing products, we need to match the data in the CSV with the data on WordPress, for which we will use the product IDs:
  • CSV Field: record_id
  • WordPress Field: ID
  • Click on Next.

Finally, you’ll see a preview. If everything is OK, click on The preview is fine, start import.

As you can see, exporting and importing PODS custom fields in WooCommerce products is easy with WP Sheet Editor. You can save a lot of time downloading your products to a CSV file, editing products in Excel or Google Sheets, and importing the changes back into WooCommerce. You can do this with a few simple steps.