How to fix it
- Write taxable, shipping or none on each listed row.
- Put tax class names such as "Reduced rate" in the "Tax class" column instead.
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,visible,standard,1,5,12.00,,,,,
What the checker says about it
- Line 2: "Mug": Tax status "standard" is not allowed, so the row fails with "Invalid product tax status." Use taxable, shipping or none.
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 product tax status." mean in WooCommerce?
- The "Tax status" column only accepts taxable, shipping or none (true and false are read as taxable and none). Words such as "yes", "VAT" or "standard" make WooCommerce fail the row. A tax rate name belongs in "Tax class", not here.
- How do I fix it?
- Write taxable, shipping or none on each listed row. Put tax class names such as "Reduced rate" in the "Tax class" column instead.
Other WooCommerce import errors
- Unable to use image
- Accents and special characters garbled after a WooCommerce CSV import
- WooCommerce CSV import: variations or attribute options not showing
- WooCommerce CSV import: wrong prices, or products out of stock
- WooCommerce CSV import: columns show "Do not import" on the mapping screen
- File is empty. Please upload something more substantial.
- 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
- WooCommerce 11.2.2 source: class-wc-product-csv-importer.php: https://github.com/woocommerce/woocommerce/blob/11.2.2/plugins/woocommerce/includes/import/class-wc-product-csv-importer.php
Based on WooCommerce 11.2.2's import code and documentation. Not tested on a live store.