Write visible (shop and search), catalog (shop only), search (search only) or hidden on each listed row. Leave the column out entirely if every product should be visible.

WooCommerce import error: "Invalid catalog visibility option."

What it means: The "Visibility in catalog" column only accepts visible, catalog, search or hidden. Other words, such as "yes", "shown" or "public", make WooCommerce fail the row.

Find the rows in your file

WooCommerce product import

Choose file

The product CSV you are about to import into WooCommerce (Products, Import), or the one that just failed.

Your file stays on this device

It is read and converted by this page, inside your browser. Nothing from the file is uploaded, and the tool keeps working offline once the page has loaded.

No file handy? or download the sample to look at it first.

The products in the sample are invented. It is checked on this device, the same way your own file would be.

Loading the converter...

How to fix it

Write visible (shop and search), catalog (shop only), search (search only) or hidden on each listed row.
Leave the column out entirely if every product should be visible.

Example

A file with this problem

Type,SKU,Name,Published,Visibility in catalog,Tax status,In stock?,Stock,Regular price,Images,Parent,Attribute 1 name,Attribute 1 value(s...
simple,MUG-1,Mug,1,public,taxable,1,5,12.00,,,,,

What the checker says about it

Line 2: "Mug": Visibility in catalog "public" is not allowed, so the row fails with "Invalid catalog visibility option." Use visible, catalog, search or hidden.

Once the listed rows are fixed, check the file again; the checker also looks for the other problems in WooCommerce's import code, so you do not trade one error for the next.

Questions

What does "Invalid catalog visibility option." mean in WooCommerce?: The "Visibility in catalog" column only accepts visible, catalog, search or hidden. Other words, such as "yes", "shown" or "public", make WooCommerce fail the row.
How do I fix it?: Write visible (shop and search), catalog (shop only), search (search only) or hidden on each listed row. Leave the column out entirely if every product should be visible.

Other WooCommerce import errors

Sources

WooCommerce 11.2.2 source: abstract-wc-product.php: https://github.com/woocommerce/woocommerce/blob/11.2.2/plugins/woocommerce/includes/abstracts/abstract-wc-product.php

Based on WooCommerce 11.2.2's import code and documentation. Not tested on a live store.