Categories: eCommerce

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

  •  

Recent Posts

How to wake every morning with new sales leads for your coaching business

Have you started getting a few runs on the board with your coaching business? It feels great doesn't it?Do you…

7 months ago

How do I make a startup website in 2019?

So, you've just kicked off your startup business and you've been told you need a website. Sounds expensive and you'll…

8 months ago

What to do when someone else has your domain name?

Have you ever locked down your business name only to find that someone already has your domain name? This can…

9 months ago

WordPress 5.2 Update – should you upgrade yet?

WordPress recently released version 5.2 with some impressive new features. We've setup a dummy website to test the new features…

9 months ago

The five step process to set and achieve goals for your website

Have you ever wondered whether your website is producing the right results for your business? How do even measure something…

10 months ago

How to get on page 1 of Google

Have you ever wondered how other businesses get onto page 1 when you search for something on Google? This topic…

11 months ago