#
ImpEx
#
Introduction
We would like to point out the import & export tool from Commercetools.
ImpEx is a user interface application for several IMPort and EXport tools accessible from the Commands menu. ImpEx tools are used for
- importing and exporting details related to products, category, customer, etc .. from one project to another or
- to be used with other tools of your choice, like a spreadsheet editor, etc.
- to publish or unpublish products
- to bulk update or delete products
#
ImpEx Product Export
The ImpEx Product Export is a tool to export products from Commercetools to a csv, xlsx or json file. These files can be used to import the products into another Commercetools project or to edit the products in a spreadsheet editor like Excel or Google Sheets.
Visit the ImpEx Product Export page to use the tool. Also check out the ImpEx Tutorial to learn how to use the tool. Beside the documentation of commercetools, this page a simple explanation about the tool.
#
Export all products
#
Step 1: Select the commercetools project
Select the Commercetools project you want to export the products from. You can select the project by clicking on the project name in the top right corner of the page.
#
Step 2: Select the export format
Select the export format you want to use. You can choose between csv, xlsx and json. The default format is csv. To use the ImpEx Product Import tool, you should use the csv format.
When you select the csv format, you can also select the delimiter. The default delimiter is a comma (,). You can also use a semicolon (;) or a tabulator (\t).
This will export all published and unpublished products from the Commercetools project.
#
Export specific products
If you want to export only specific products, you can use the filter options.
#
ImpEx Product Import
The ImpEx Product Import is a tool to import products from a csv or xlsx into Commercetools. The csv or xlsx file can be created with the ImpEx Product Export tool or manually.
For example, you can use the ImpEx Product Export tool to export all products from a Commercetools project, edit the products in a spreadsheet editor like Excel or Google Sheets and import the products back into the commercetools project. Also have a look at the Github example files to see how the csv file could look like. You also can upload a zip file for multiple files.
Visit the ImpEx Product Import page to use the tool.
#
Import products
#
Step 1: Select the Commercetools project
Select the Commercetools project you want to import the products into. You can select the project by clicking on the project name in the top right corner of the page.
#
Step 2: Upload the file
Drop the file you want to import into the dropzone or click on the dropzone to select the file from your file system. For the import, you can use a csv or xlsx file. The file should contain the products you want to import. You can use the ImpEx Product Export tool to export the products from a commercetools project.
#
Other ImpEx tools
Visit the ImpEx page to see all available ImpEx tools.