How to import ACF custom field with multiple values comma separated , using excel

Name: extendWP
Rating: 5 (51 reviews)

This is a step by step tutorial on how to import ACF custom fields with multiple values separated by commas along with your product, using WordPress Product Import Export with Excel for WooCommerce plugin.

1. Install and Activate the Plugin

Start by installing the “WordPress Product Import Export with Excel for WooCommerce” plugin.

2. Set Up ACF Fields

Ensure you have Advanced Custom Fields (ACF) installed and activated on your WordPress site. Create a custom field group and add a field ie checkbox where you expect to have multiple values separated by commas.

3. Prepare Excel Sheet

Use any of the sample excel files found within the WordPress Product Import Export with Excel for WooCommerce plugin settings page.

Add the data you want to import. Include a column for the ACF custom field with multiple values separated by commas.

4. Save Excel File

Save the Excel file with the changes.

5. Configure Products Import Settings

Now, configure the import settings in the “WordPress Product Import Export with Excel for WooCommerce” plugin:

In the WordPress admin, go to Product Import Export menu tab and navigate to Import / Update Products screen
Upload your modified Excel file.
Map the columns to the appropriate fields.

import ACF custom field with multiple values comma separated , using excel

6. Map ACF Custom Field

Ensure that you map the ACF custom field correctly. Locate the excel column ( section EXCEL COLUMNS ) with the multiple values separated by commas and map it to the corresponding ACF field ( section CUSTOM FIELDS).

7. Run the Product Import

After configuring the settings, initiate the import process by pressing the Upload Button. The plugin will read the Excel file and update the ACF custom fields with multiple values for the specified products.