We are going to help you to export and import your WooCommerce products.

 

Step 1

 

When you are logged into your WordPress site, locate the "Products" tab then hover over it and you will see a popup that says "All Products"

Proceed to click on "All Products"

 

 

 

Step 2 

 

When you've clicked on "All Products" you will be prompted with this screen.

When you look at the right side of your screen, you will see "Screen Options", proceed to click on the arrow.

 

 

 

Step 3

 

When the "Screen Options" tab is open, locate the "Export" button and proceed to click on it.

You will then be prompted with a block.

 

 

 

Step 4

 

Now you will start the export of all your products. You can choose do you want the "Export custom meta" by clicking the check box.

When you are all done with that proceed to click on "Generate CSV"

 

 

 

Step 5

 

Now your products will begin to Export, all you have to do is get a cup of coffee and just wait for the export to finish.

 

 

 

Step 6

 

When your Export is finished you will see it will be downloaded as a Excel file at the bottom left of your screen.

 

 

 

Step 7

 

Now you need to go to Excel and open a new Excel blank document. We are almost there.

 

 

 

 

Step 8

 

When you have opened a new Excel document, proceed to find the "Data" button at the top of your editor bar.

 

 

 

Step 9

 

When you have clicked on "Data" you will be prompted with a new editor field. 

Proceed to go to "Get Data" - "From File" - "From Text/CSV"

Just follow that path and click on "From Text/CSV"

 

 

 

 

Step 10

 

Now you just need to select the file you just Exported from your website, it should be in your downloads folder.

 

 

 

 

Step 11

 

You will be prompted with this screen, proceed to click on the load button.

Your spreadsheet will then be loaded.

 

 

You will be able to make your changes here on the Excel spreadsheet, when you are all done then proceed to our next step.

 

 

 

Step 12

 

When you are all done proceed to "Save As" your document.

 

 

 

Step 13

 

When you click "Save As" you will be prompted with how you want to save it. 

You will need to save your document as a "CSV UTF-8"

When you have selected that option you can just save it.

 

 

 

Step 14

 

You need to navigate back to your website now and proceed to click on the "Import" button under "All Products"

It will be next to the "Export" button you were at in the beginning

 

 

 

Step 15

 

You will now be prompted with with this block. All you need to do is click on "Choose File" then you choose the Excel file you just saved.

When you selected your file proceed to click "Continue"

 

 

 

Step 16

 

You will then be prompted with this block, just proceed to click "Run the Importer"

 

 

 

Step 17

 

The last step, all you need to do now is wait for your import to finish and then you are all done.

 

 

 

 

 

 

 

 

 

Was this answer helpful? 0 Users Found This Useful (0 Votes)