Close
item data import
WHAT IT IS

The Item Data Import Wizard can be used to update existing Edge items using an external data file. Use it in conjunction with the Item Data Export Wizard to export item data, update it, and then import it back in. It is also possible to import data from other sources, but your import file must be formatted to match our item template.

WHAT IT DOES

It can be used to update item details, pricing, descriptions, and website data. During the import process, you choose whether you want to match by Edge item number or by the vendor / vendor style.
Two things to note:
  • This can only update existing Edge items. It cannot be used to add new items.
  • The Edge should be closed on all other workstations during this process to avoid data conflicts.

HOW IT WORKS

To import item data:
  1. Click Inventory → Utilities → Item Data Import. The Wizard will appear.
  2. Choose how you want to import items.
  • Import by Item Key: Select this if you want to update items on a one-to-one basis by matching itKey.
  • Import by Vendor / Style: Select this if you want to update items on a one-to-many basis by matching itVendorID and itVendStyleCode.
  1. Use the Input File drop-down to select the file you want to import.
  2. Choose the Delimiter your file is using to separate data fields.
  3. Select your import option.
  • Import Item Data: Select this if you are only importing standard Edge data fields.
  • Import Item Data + Custom Details: Select this if you are importing any custom Edge details. Because custom details vary by category, this limits the import to a single category.
  1. After specifying import parameters click Next.
  2. A preview of your import will display. Verify that the preview has your expected data then click Next to proceed.
  3. You will receive a final confirmation that you want to import. Click Yes to proceed.
  4. The software will offer to make a backup of your database at this time. Because a bad import could result in data loss it is recommended you do this. Depending on the size of your database, this may take a few minutes.
  5. Once the import completes it will tell you how many items were updated. There is also a link provided if you wish to view the import log ItemDetailsImport.log.

EXPAND YOUR EDGE EDUCATION

Eager to know more about how you can use the Item Data Import Wizard? Click below or visit EdgerUser.com and search Item Data Import. You’ll also find information on how to format your item data file, as well as a tip sheet on using this wizard.