Rating 0 stars - 0 votes

WooCommerce CSV Import

When all configurations of your WooCommerce store are done, the first thing you may consider will probably be product import. If you want to avoid adding items one by one, prepare a WooCommerce CSV import file containing all necessary product data and import it to your shop.

Currently, WooCommerce admin does not provide the possibility of uploading goods to a store without installing additional extensions, though you may resort to Store Manager for WooCommerce. Using this application you can import product data flawlessly by clicking through a few steps via special import wizard.

Use the following guide to import goods to your WooCommerce in a couple of clicks.

  1. Before starting the import process, you should first prepare a .csv file containing all important product information. Here is a WooCommerce CSV import sample:

  2. To start the import wizard, tap the 'Import data' button on the 'Products' toolbar.

  3. Press the browse button and double-click on the local .csv import file. Select the file charset or let it be auto detected.

  4. Select delimiter type and specify whether to quote string values. In case you want the first raw to contain the field names, check the corresponding box.

  5. In case, you need to add an own SQL query, tap 'Add custom SQL' and use the extended expression editor to generate the query.

  6. Now you have to assign file columns to appropriate fields from your store database:
    • Select a suitable identification field to identify the products being imported (if the product already exists in the database, it will be modified, if it is a new item, it will be added to the store);

    • Use the drop-downs with the source fields to link them to the database fields.

  7. Proceed to import options and select necessary one:
    • Modify only (update existing products without adding new goods)
    • Just add

    Tap 'Preview Import Data' button to check if everything is ok.

  8. Press 'Import' button and view the import results.
  9. Current import configuration can be saved to Store Manager archive or to file and used when performing product upload next times.

  10. As you see, importing WooCommerce products via Store Manager is very compact and comprises just few clicks. Although, you should take your time to prepare the CSV file properly to provoke no errors during the process.

Perform WooCommerce CSV import for 14 days free Try now

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}


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?