How to import and export Products using Excel

Introduction

  • This guide describes how to import and export Products using Excel

In Configuration->Product:

Export Products to Excel

To export the existing Products, click the "Export to Excel" button: 
(This is also useful to get the Excel template used here to import Products)

Now you have an Excel file with the Products:

Import Products from Excel

If you wish to import new Products, first export Products and then just remove all the rows below the first row with the headers from the file:

And provide the new Product information in the file:

Use the "Import from Excel" button to import your new Products, and select the Excel file in the file selector:

And the Products has now been created: