How to import and export products in WooCommerce with ease

Since version 3.1 you have incorporated in your online store a native utility to import and export products in WooCommerce [19659003]something that has always been essential.

In addition, doing it is very simple so let's see the process to import and export products in WooCommerce.

Import products in WooCommerce

With WooCommerce you can import products from a CSV file from two sites mainly.

Already in the same installation wizard, on its last screen, you have a button from which to start the process of importing products.

Has everything the sense because there are many occasions in which you create an online store but you already have a catalog of products to upload, and what better moment than nothing else to install WooCommerce?

Tambi én, in the product window, you have a button to import products from a CSV in case you forgot in the installation process or if you have to upload or update a large catalog of products.

The WooCommerce product import wizard

No matter which place you choose to import, the process is the same, and WooCommerce offers us a simple wizard steps to perform the import of products .

In the first step you have to select the CSV file where you can check a box so that, in case there are already existing products that could match with those included in the CSV they are updated instead of creating duplicates.

This is especially important if you upload inventory updates for example.

Also, you have a link from which and show the advanced options in which you can choose to upload the CSV from a folder on your server, and also specify the delimiter of the columns, normally and by default the comma.

[19659004] In the next screen you have to perform the assignment of columns to make sure that the import of the CSV columns delimited by commas will coincide with the fields available in your WooCommerce store, being able to change the field to which corresponds each assignment.

The following captures show the possible fields in a real import, with lots of product fields, attributes, etc.

Once you review all the fields press the button to " Execute the importer ". The import will start, usually very fast, which will take more or less depending on the number of products, variations, etc.

If everything goes well on the next screen you will have the result of the process, and now you can go to see your products to check that everything is well imported.

If there was an error in the import you can review them.

For this you will see a link for review the import record and thus see the bugs and their reasons most of the times because the product already existed and no change has been made.

Exporting products in WooCommerce

Exporting products is even simpler and you access the export utility from the product screen, where you have a button to start the process.

[19659004] Just open the utility export you will have to decide the following:

  1. Which columns to export being able to choose among all or several of all available ones. Here it refers to the data of the products, which will be exported as column headers. That is, title, description, if reduced, etc., etc.
  2. What types of product and there you choose if all or only simple, grouped, variable, what you prefer.
  3. If you want to export Custom meta fields . If so, simply check the existing box.

This capture would be an example of selecting only a few product types and variations. ]

Once the decisions are made, you only have to press the button " Generate CSV ", which will be downloaded to your computer.

The generated file you will be able to open it with your favorite spreadsheet application taking care to make the import of data from the delimitation by commas so that they become columns.

In MS Excel it is done in 3 steps . In the first you must choose " Delimited ".

Next, in the second step, it is important that in the delimiters you choose " Other " and there put a comma, as in the following capture.

Finally, check in the last step that in the preview the columns were created correctly.

If everything has gone well you can manage your products from the application of spreadsheets to add, modify or whatever you want, and if you want to import it again with the import utility once the changes are made.

If you use Google Docs it's even easier . Just create a new spreadsheet and go to the menu File> Import .

On the next screen you just have to upload the file.

[19659004] And once it's uploaded (it's very fast) you just have to choose the comma as the delimiter.

That's it, you'll also have your products to edit them to your liking, or Just store them.

Do not believe, when you have many products, it is much more effective and quick to make changes in a spreadsheet and then import it than to edit each product from WooCommerce.

Of course, always do tests until you feel sure you are doing exports and imports correctly.

Conclusions, do you doubt?

As you may have seen it is really easy to export and import products in WooCommerce . What is incomprehensible is how such a fundamental utility took so long to join the plugin.

This is a basic utility that WooCommerce lacked and for which we always had to install an additional plugin.

when it also incorporates the invoice generator and shipping notes and we will save another plugin for another basic functionality that every online store should have.

With this and the inclusion of negative taxes (withholdings) it would be practically perfect, do not you think?

Loading …

It might help you too: