How to fix it
- Save the file again as CSV from your spreadsheet program, so the name ends in .csv and the content is plain text.
- If the file came from another platform as .xlsx, open it and save as CSV; do not just rename it.
- If a correct .csv file is still refused, a security plugin or your host may be blocking CSV uploads; ask them, or use "Show advanced options" to import a file already on the server.
Example
A file with this problem (named products.numbers)
Name,SKU,Regular price Mug,MUG-1,12.00
What the checker says about it
- The file is called "products.numbers". WooCommerce only accepts .csv and .txt files. On a normal upload WordPress refuses it with "Sorry, you are not allowed to upload this file type."; with a file path on the server WooCommerce says "Invalid file type. The importer supports CSV and TXT file formats." Save or download it as CSV first.
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
- 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.
- Invalid product type.
- All checks
Sources
- WooCommerce 11.2.2 source: CSVUploadHelper.php: https://github.com/woocommerce/woocommerce/blob/11.2.2/plugins/woocommerce/src/Internal/Admin/ImportExport/CSVUploadHelper.php
- WordPress source: wp-admin/includes/file.php: https://github.com/WordPress/wordpress-develop/blob/trunk/src/wp-admin/includes/file.php
Based on WooCommerce 11.2.2's import code and documentation. Not tested on a live store.