How to bulk import products into WooCommerce 3.1+ with a CSV file | The Web Warriors

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


Share this post

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest
Share on print
Share on email

How much does a new website cost?

Are you researching costs for your new website?
Try our complementary calculator that helps you uncover how much your new website will cost…