Importing your products can be as nice and simple as creating a CSV file and importing that into WooCommerce.
To get you started, you can find a sample.csv in the plugin folder, or download one here. This has many of the common fields used for selling products. For a complete list of fields available, see the column header reference.
If you’re planning to import product images, please be sure to read this FAQ.
If you want to make sure you’re including all of the fields that are required for your online store, you can add one product via WordPress and then export that CSV to create your basic template.
Go to: WooCommerce > CSV Import Suite.
Click the Import Products button.
Select Choose File, and upload a file from your computer or from wherever your CSV is located.
The delimiter is the character that separates the values, in this case a comma.
Select Upload file and import.
Before completing the import, you can ensure that your column headers are mapped to the correct field in WordPress. This acts as a final check to make sure everything is will be imported correctly. Check the list to make sure that your fields are being mapped to the right place.
When you’re happy, click Submit.
Your Products will be imported, and you’ll be provided with a real-time view of what is successfully imported and what products, if any, fail.