Using Import and Export Products

If you want to use the Import and Export Products feature to create or edit products you must first export a blank template or the product data you want to edit. Once you are done entering or editing data in the spreadsheet you must import that spreadsheet into the system for your new products to be created or your changes to take effect. To learn more about how the Import and Export feature works, see About Import and Export Products.

Learn how to export a blank template
Learn how to export product data
Learn to import new products or changed product data

Exporting a Blank Template

Required Role: Catalog ManagerA user role that allows the user access to the catalog and product features. Search this file for the "user role definitions" topic for more information.

On the Catalog menu, select Products, and click Import and Export Products. The Products Import and Export page appears.
In the Export Products area, from the Catalog list, select the catalog you want to create products for.
For the Export Option, select Blank Template.
For the Locale option, select the locales in which you want to create products (see the information about how locales are handled in the spreadsheet for more information).
- All Locales – Exports a template with all the locales supported by the site.
- Default Locale – Exports a template with only the default locale.
- Specify Locale(s) – Exports a template with only those locales you select.
For the Format Option, select the version/format you want to export. You should choose the option that matches the version of Microsoft® Excel® you have on your computer or will use with the template.
Click Export. When prompted, open or save the template on your computer. Once the template is opened or saved you can begin adding the product data you want to it. Use the instructions and information in the spreadsheet to help you create new products. When you are done, make sure you save the template in a place where you can find it when you are ready to import.

Exporting Product Data

Required Role: Catalog ManagerA user role that allows the user access to the catalog and product features. Search this file for the "user role definitions" topic for more information.

On the Catalog menu, select Products, and click Import and Export Products. The Products Import and Export page appears.
In the Export Products area, from the Catalog list, select the catalog you want to create products for or the catalog with the products you want to export.
For the Export Option, select what you want to export:
- All Products – Exports all products in the selected catalog (regardless of status/state), including non-localized products.
- Design and Deployed Products – Exports all active products (products with either a "design" or "deploy" state/status) in the selected catalog.
- Specify Product IDs – Exports specific products for the default locale or a specific locale you select. After you select this option you must search for or enter the product IDs of the products you want to export.
For the Locale option, select the locales you want to export.
- All Locales – Exports the products you indicated above for all locales your store is set up to support.
- Default Locale – Exports the products you indicated above for your store's default locale only.
- Specify Locale(s) – Exports the products you indicated above for the locales you select. When you select this option, a box appears listing all the locales your store supports. You should select the locales you want to include in the export.
For the Format Option, select the spreadsheet format you want to export. You should choose the option that matches the version of Microsoft® Excel® you have on your computer or will use with edit the products data in the spreadsheet.
In the Job Name field, enter a name for the export job. This name will be used to identity the import in the Job Queue.
Click Export. You are taken to the Job Queue and the export begins processing. You do not have to remain in the Job Queue until your export completes; you can go to other areas of the Command Console and perform other tasks as needed. When you are ready you can visit the Job Queue, download the spreadsheet and edit the products (use the information and instructions in the spreadsheet to help you edit the products). When you are done you can then import your changes.

Importing Product Data

Required Role: Catalog ManagerA user role that allows the user access to the catalog and product features. Search this file for the "user role definitions" topic for more information.

On the Catalog menu, select Products, and click Import and Export Products. The Products Import and Export page appears.
In the Import Products area, in the Job Name field, enter a name for the import job. This name will be used to identity the import in the Job Queue.
Click Browse next to the File field and then locate and select the spreadsheet file you want to import. This should be the blank template you exported above with the new product data you want to add, or the existing products you exported and then changed.
Click Import. You are taken to the Job Queue and the import begins processing. You do not have to remain in the Job Queue until your import completes; you can go to other areas of the Command Console and perform other tasks as needed. When you are ready you can visit the Job Queue and check the status of your import job. If there were any errors or warnings during the import they will be listed on the Job Detail page (click on the Job Name in the Job Queue to see details of the job).