Rating 0 stars - 0 votes

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 'Store' tab and go to 'Products' section.
  2. Launch import wizard by pressing 'Import Data' button.

  3. How to Perform WooCommerce Excel Import
    How to Perform WooCommerce Excel Import

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

  5. How to Perform WooCommerce Excel Import
    How to Perform WooCommerce Excel Import


    Step 2

  6. Configure File Settings

  7. How to Perform WooCommerce Excel Import
    How to Perform WooCommerce Excel Import

    Step 3

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

  9. How to Perform WooCommerce Excel Import
    How to Perform WooCommerce Excel 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. How to Perform WooCommerce Excel Import
    How to Perform WooCommerce Excel Import

    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.