Looking for the v10 manual? Visit our new user's guide!
Search Descriptions Version
This article applies to: MultiStore

Excel Product Import

From Products Menu, click Import/Export → Excel Product Import

On this page (as well as this one), products can be imported in bulk from a separate inventory list. This page requires those products to be in an Excel file, formatted like this sample file for, and this sample file for and this sample for MSx9.4.0.0+.

When an import file is processed, the software looks at each entry and compares it to existing products in the storefront. If the SKU of a product in the import file matches an existing product, that existing product is updated with the information from the new file. If there is no SKU match, then a new product is created with that information.

To import a new product list, use the 'Browse' button to locate the import file:

Once the file has been processed (this can take a while if it is a large import file), the screen below will be shown. It is a good idea to click the 'View Import Log' link and make sure that there are no errors showing. If everything looks ok, click the 'Accept Import' button to complete the process. If there are problems showing in the log file, or you wish to cancel the import, click the 'Undo Import' button.

NOTE: If you are requiring t​o import more than 10,000 rows of product data at once, you will need to add an AppConfig (Settings): ImportMaxRowsExcel with the value of your maximum row count.