Iconic Attribute Swatches – How to Import Product Swatches

If you use the Iconic Show Single Variations plugin, you know how useful it is for displaying specific product variations directly in your WooCommerce catalog or search results. However, managing these visibility settings for hundreds or thousands of variations can become a massive data entry task.

In a previous guide, we showed you how to bulk edit Show Single Variations settings directly inside WordPress using a spreadsheet interface.

But what if you need to share this data with a team member, update your catalog offline, or migrate settings between stores? In these cases, the most efficient method is to export your variations to a CSV file, manage the visibility settings in Excel or Google Sheets, and import the data back into WooCommerce.

In this tutorial, you will learn how to export and import Iconic Show Single Variations data in bulk.

Video Tutorial

Prerequisites

To follow this workflow, you need two tools installed on your WordPress site:

1. WP Sheet Editor – WooCommerce Products
This plugin allows you to manage your entire WooCommerce catalog, including all variation data, using a frontend spreadsheet interface.

2. WP Sheet Editor – Iconic Show Single Variations Extension
This specific extension acts as a bridge, ensuring that all the custom fields generated by the Iconic plugin (like “Show in Catalog” and “Disable Add to Cart”) are fully compatible with the spreadsheet.

Once both are activated, go to WP Sheet Editor > Edit Products to open your spreadsheet.

Step 1. Export Show Single Variations Data to a CSV

Instead of exporting your entire WooCommerce database, we will filter the spreadsheet so that we only export the product variations and their specific visibility settings.

Filter for Variations

First, open the Search tool located on the top toolbar.

To isolate the variations from your simple and parent products:

• Tick the Search on variations checkbox.
• Click Run Search.

The spreadsheet will now display all variable products with their respective variations listed below them. You can confirm the active search filters above the data grid.

Configure the Export

Now that you have filtered the exact rows you need, click the Export tool on the top toolbar.

Configure the export settings to download only the relevant columns:

• What columns do you want to export: Click Select active columns and choose the following:
  • Name
  • SSV: Show in Search Results
  • SSV: Show in Catalog
  • SSV: Show in Filtered Results
  • SSV: Listings Only
  • SSV: Disable Add to Cart
• Tick the checkbox for I understand it will export all the rows from my current search.
• What app will you use to edit this file: Select your preferred software (Excel, Google Sheets, etc.).
• Name of this export: (Optional) Give it a name to save this exact configuration for future exports.
• Click Start new export.

Step 2. Edit the CSV File (Formatting Rules)

Once the CSV file downloads to your computer, open it in your chosen spreadsheet application.

When updating the visibility rules in the CSV, you must use precise binary values to ensure WooCommerce reads the data correctly during the import.

To manage settings like showing variations in the catalog or disabling the add-to-cart button, use these exact values in the cells:

• To Enable a setting: Enter 1
• To Disable a setting: Enter 0 (or leave the cell empty)

Step 3. Import Show Single Variations Data from a CSV

After you have applied your bulk changes and saved your CSV file, return to the WP Sheet Editor interface to push the updates live.

Click on the Import tool.

Configure the upload by selecting your file:

• Source: CSV file from my computer
• CSV File: Click Choose File and locate your updated document.
• Click Next.

On the next screen, click Import all the columns to proceed with mapping the data.

To ensure the new visibility settings are applied to the exact variations, configure the data mapping as follows:

• Do you want to update or create items: Create new items and update existing items
• CSV Field: record_id
• WordPress Field: ID

Click Next.

Finally, the plugin will display a preview of the data it is about to update. Review the rows to ensure the columns align properly.

If the preview looks correct, click The preview is fine, start import.

Once the process finishes, your spreadsheet will refresh, and you will see that all the Show Single Variations settings have been successfully updated across your catalog.

Manage WooCommerce Variations Efficiently

Managing specific visibility rules for variable products does not have to be a slow, manual process. By exporting your variations to a CSV, you can take advantage of the speed and flexibility of spreadsheet applications like Google Sheets or Excel to plan your catalog display logic.

With WP Sheet Editor, importing that data back into WooCommerce takes just a few clicks, ensuring your store is always up to date without wasting hours on data entry.