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
  1. Open 'Catalog' tab and go to 'Products' section.
  2. Launch Import Wizard by pressing 'Import' button.

  3. WooCommerce Products Import Wizard Launch
    WooCommerce Products Import Wizard Launch

  4. Select import source and choose the file to upload.

  5. File Source Selection for WooCommerce Excel Products Import
    File Source Selection for WooCommerce Excel Products Import


    Step 2

  6. Configure File Settings

  7. WooCommerce Excel Product Import File Delimiters
    WooCommerce Excel Product Import File Delimiters

    Step 3

  8. Select identification fields and map database fields to the ones contained in your excel file.

  9. Field Links Step During WooCommerce Excel Product Import
    Field Links Step During WooCommerce Excel Product Import

    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.


    Step 4

  10. Select product import method and press 'Import'.

  11. WooCommerce Excel Product Import Options
    WooCommerce Excel Product Import Options

    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.


Accomplish WooCommerce Excel Import for 14 days FREE

Try Now

COMMENTS
Be the first to comment.