How to bulk import products into WooCommerce 3.1+ with a CSV file – The Web Warriors
WooCommerce csv bulk product uploader

How to bulk import products into WooCommerce 3.1+ with a CSV file

Do you have a new website that you’re displaying or selling products off of? You might need a quick method to bulk import products into the website.

In this article, you’ll learn:

How to download a sample WooCommerce CSV file for bulk import of products

To bulks import products into your WooCommerce online store, you will need a CSV file. This file can be downloaded to your local computer and edited in a spreadsheet program like Microsoft Excel.

The sample WooCommerce CSV file can be downloaded here.

What each of the columns mean in the sample CSV file

Once you have downloaded the CSV file, you’ll want to start adding your products. The easiest way to do this is to open the CSV file in a spreadsheet program like Microsoft Excel.

Once you’ve opened, the file, you’ll see a bunch of columns. You can choose from either of these options:

Your web agency is uploading the file for your

You’re luck that we’ll look after a few of the columns, so only focus on the following columns:

  • sku: This a the unique identifier for this product. 
  • name: This is the name of the product
  • status:
    • 1 = the product is active
    • 0 = the product is not active, e.g. it’s been discontinued 
  • featured:
    • 1 = the product will show in a featured products listing if there’s one on your website
  •  

You’ll be doing the whole lot yourself

  •  

Leave a Comment