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.
Other WooCommerce import errors
- Sorry, you are not allowed to upload this file type.
- Invalid file type. The importer supports CSV and TXT file formats.
- The file is empty or using a different encoding than UTF-8, please try again with a new file.
- The uploaded file exceeds the upload_max_filesize directive in php.ini.
- A product with this SKU already exists.
- A product with this ID already exists.
- All checks
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.