How to export/import all products?

WARNING!!!

We highly recommend that you make a backup of your database before doing this

Before you begin

If you are looking to update your woocommerce product pricing, add new products, or would like to just make a backup of your products this is a great option. This option will allow you to download a CSV file with all of your product info. You can edit your products info within this file using excel or a similar program.

However, if you plan on importing it back into your website DO NOT edit or change any of the Column names. If you do your import will not work.

If you edit any of your product info with excel or a similar program make sure to save it as a CSV file.

Before you upload and import and CSV file you will need to add the below line of code to your wp-config.php file

define(‘ALLOW_UNFILTERED_UPLOADS’, true);

NOTE: If you are going to copy and paste this line of code paste it into a .TXT file first and then copy and paste it into your file. 

It’s important to note that this allows all file types to be uploaded by administrator-level users. It’s best practice to add file types as needed.

How to export your products to a CSV file

Below you will find step by step instructions on how to export your products to a CSV file

woocommerce export-import products
1. Go to Products => Export
2. Click on Generate CSV button
2. Click on Generate CSV button

Download

Once your download is done you can open it up in Excel or a similar program and begin updating your product info. However, if you plan on importing it back into your website DO NOT edit or change any of the Column names. If you do your import will not work.

Make sure to save it as a CSV file. 

Importing your products from a CSV file

Below you will find step by step instructions on how to import your updated CSV file

1. Go to Products => Import
1. Go to Products => Import
2. Choose File and check the box that says "Update existing products"
2. Choose File and check the box that says “Update existing products”
3. Scroll to the bottom and click on "Run the importer"
3. Scroll to the bottom and click on “Run the importer”
The importer will begin once done review your changes and make sure that your products are displayed correctly
The importer will begin once done review your changes and make sure that your products are displayed correctly