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
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
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