How to Perform WooCommerce Excel Import
WooCommerce web-store managers preferring working with excel files might feel too tired of converting them into .csv file every time before performing product import. Store Manager for WooCommerce can become a great helper in this regard.
Store Manager is a universal tool bringing the possibility to accomplish WooCommerce import from excel, .csv, xml, .txt, .ods or .zip file with no need to waste time on format conversions. The procedure is executed via Import wizard, so you will just need to click through a few steps selecting suitable import options.
How to Import WooCommerce Products From Excel?Step 1
- Open 'Catalog' tab and go to 'Products' section.
- Launch Import Wizard by pressing 'Import' button.
- Select import source and choose the file to upload.
- Configure File Settings
- Select identification fields and map database fields to the ones contained in your excel file.
- Select product import method and press 'Import'.
To see how to select correct delimiters and configure other import settings, watch this 5-minute tutorial:
If you want Store Manager to skip certain conditions during the import, you can use the 'Skip rules' tool. Press plus and use 'Value type' drop-downs to configure the conditions.
In order to save the import settings, press 'Save configuration' button. Thus, you will be able to use it next times when performing the import with no need to configure the settings again.
Bear in mind that WooCommerce admin does not support bulk products import and you might need to install some additional extensions to perform the procedure. The big benefit brought by Store Manager is that you can upload files of a bunch of formats without any additional configurations.