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. Select import source and choose the file to upload.



  4. Step 2

  5. Configure File Settings


  6. Step 3

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


  8. 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

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


  10. 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.

Privacy Preference Center

Strictly Necessary

These cookies are necessary fro the site ot function.

woocommerce_cart_hash, woocommerce_items_in_card, wp_woocommerce_session_{hash}

Performance

These are used to track user interaction and detect potential problems. These help us improve our services by providing analytical data on how users use this site.

_ga, _gid, _gat-_UA-326982215-25, LaSID, LaVisitorId, __utma, __utmc, __utmv, __utmz

Close your account?

Your account will be closed and all data will be permanently deleted and cannot be recovered. Are you sure?