From NewHaven Software Wiki

Overview

Using the built-in product import tool, you can set product URL names in bulk rather than going into each product individually.

File Setup

1. Open a new worksheet in Excel.
2. In the top row, put these two fields (naming must be exact and is case-sensitive):
   • SKU
   • ProductURLName
3. In the SKU column, list out your eCMS SKU codes (make sure the case is correct).
4. In the next column over, put the text you want for the product portion of the URL ("product-url-name", without the quotes).
5. Click File->Save As... and select Comma-delimited values.
   • Click Yes to any prompts that come up.

Importing to eCMS

1. Inside the admin, open Inventory->Product Import.
2. Click Choose File and browse for the text file you created above.
3. Change the Type to comma-delimited in the top section of the page.
4. Enter your address in the Email Notification field.
5. Click the Submit button at the end of the top section.
6. You should receive an email in a few minutes informing you that the import has been processed.