If you are running an online store powered by WooCommerce, you may need to import products from a CSV file. CSV files can be created with spreadsheet programs like Microsoft Excel or Google Sheets. Once you have your CSV file ready, there are two ways to import it into WooCommerce:
The first way is to use the built-in importer tool. To do this, go to WooCommerce > Products > Import. On the next screen, select “CSV” from the “Format” dropdown and click the “Upload file and import” button.
You will be taken to a screen where you can map the columns in your CSV file to the appropriate fields in WooCommerce. Once you have done this, click the “Run importer” button and your products will be imported.
The second way to import products from a CSV file is to use a plugin. There are several plugins that can help you with this, but we recommend using the Product CSV Import Suite plugin. This plugin has a free and a paid version.
Once you have installed and activated the plugin, go to WooCommerce > Products > ImportSuite. On the next screen, select “CSV” from the “File format” dropdown and click the “Upload file” button. Once you have done this, click the “Import now” button and your products will be imported.
The built-in importer tool is located under WooCommerce > Products > Import, while most plugins will give you an option under WooCommerce > Products.
We recommend using a plugin for importing products as it gives you more options and flexibility.
The Product CSV Import Suite is one of our favourites as it has both a free and paid version.
Conclusion
Importing products into your WooCommerce store via a CSV file is easy once you know how. We hope that this article has helped clear things up for anyone who was unsure about how it all worked.
