We use cookies to ensure you can get the best experience on our site. If you keep using this site we assume that you agree to our use of cookies. Privacy Policy OK

How to Import Products in WooCommerce?

by | June 18, 2019

Import Products in WooCommerce

Importing products in WooCommerce can be a time-consuming task to perform when you have many products that you want to sell. When it comes to WooCommerce, you can take care of this task by using the built-in import tool. As a result, you can import, export, or update hundreds or thousands of products in your WooCommerce store with a single CSV. Furthermore, this tool supports all product types, including variations.

In this tutorial, you will get an in-depth look at the WordPress import tool with the explanation of all of its features for making your import process easy.

When can you Import Products in WooCommerce?

You can use the WordPress Import tool in the following situations:

  • First-time storekeepers can begin all the more rapidly by importing products during the setup process of WooCommerce.
  • Existing storekeepers can update many items at once with new data, set them at a discount, or update quantities.
  • Using this tool, you can import items when migrating your store. Migration requires a bulk import of products to the new store. Utilizing the WordPress import instrument is the best arrangement, as it incorporates various item information and pictures.
  • To bulk update item information such as stock, pictures, and so on. Item import incorporates import of item name, ID, item pictures, stock details, and so on. This tool makes it simple to do the bulk update of the information in your WooCommerce store.

What is required to Import Products in WooCommerce?

To import new items or update existing items, you need a CSV containing your item data. To make the CSV, you can:

  • Export a CSV of items from a current store.
  • Create a CSV of items utilizing this clear and arranged CSV document.
  • Download a CSV document with test information from GitHub and supplant it.
  • Use your very own CSV. Any data you wish to incorporate ought to pursue the arranging and sections of the Product CSV Import Schema.

If you use the built-in WooCommerce Product CSV Importer and Exporter tool to export a CSV, it already uses the schema, and it is ready to be used. On the other hand, if you use a blank and formatted CSV file, it follows the schema just as well. With this in mind, what you need to do is make sure to enter the data as structured at Product CSV Import Schema.

You can learn more about how to create your CSV file in the documentation on the official WooCommerce website. https://docs.woocommerce.com/document/product-csv-importer-exporter/

Import Products in WooCommerce.

Import New Products in WooCommerce

First-time and existing store owners using WooCommerce can use the CSV to add new products with one upload.
Importing WooCommerce Products

  1. In the WordPress Dashboard, navigate to WooCommerce > Products.
  2. At the top select Import. The Upload CSV File screen shows.
    Import products from a CSV file
  3. Select Choose File and navigate to the CSV you wish you use.
    A thing to note is the CSV delimiter (Advanced option): Generally, CSV components are isolated by a comma. Instead, if you wish to use an alternative delimiter in your file, you can set it here.
  4. Continue
    On this page, The Column Mapping screen shows and WooCommerce automatically tries to match or map the Column Name from your CSV to Fields.
    Map CSV fields to products
  5. Use dropdown menus on the right side to alter fields or select Do not import.
    A thing to note is that any unrecognized sections won’t be imported by default.
    Run the Importer
  6. Select Run the Importer.
    Importing Products in WooCommerce
  7. Wait until the Importer is complete. Furthermore, do not to interrupt or reload the browser while it is in progress, as this may cause the import process to fail.
    WooCommerce product Importing Complete

Update Existing Products in WooCommerce.

Store managers can utilize the CSV Importer tool to update existing items with new information, e.g., adding a brand, changing a tax class, bulk update for a special sale, and so forth.

Importing WooCommerce Products

  1. First of all, make a CSV record, utilizing the IDs or SKUs of items you wish to update.
    In this way, the merchant utilizes the ID as well as SKU to auto-match and auto-update whatever information you enter on each line.
  2. Navigate to: WooCommerce > Products.
  3. Select Import at the top. The Upload CSV File screen shows.
    Import products from a CSV file in WooCommerce
  4. Next, select Choose File and the CSV you wish you to use.
  5. Tick the checkbox for Update Existing Products.
    Update Existing Products in WooCommerce
  6. Continue.
    The Column Mapping screen shows, and WooCommerce automatically tries to match or map the Column Name from your CSV to Fields.
    Map CSV fields to products in WooCommerce
  7. Use dropdown menus on the right side to change fields or select Don’t import.
    Keep in mind, that any unrecognized segments won’t be imported aby default.
    Run the importer
  8. Select Run the Importer.
    Importing Products in WooCommerce
  9. Wait until the Importer is done.
    Moreover, do not interrupt the browser while in progress.
    WooCommerce products Import complete
Related Posts

How to Display WooCommerce Products by Category

Displaying WooCommerce Products by Category is an essential way to enhance the navigation of your store. Clear browsing is critical when it gets to...

WooCommerce Hosting Requirements

The woocommerce hosting requirements are the features you need to look for when selecting a hosting plan for your ecommerce store. The first step in...

woocommerce security

WooCommerce Security: First steps

While security measures are incorporated by default with WordPress and WooCommerce, there are a couple of essential recommendations you as a store manager...

awardspace logo
Where Ideas Turn Into Websites