Importing Item Data


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.

     
  3. Use the Input File drop-down to select the file you want to import.
  4. Choose the Delimiter your file is using to separate data fields.
  5. 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.

     
  6. After specifying import parameters click Next.
  7. A preview of your import will display.  Verify that the preview has your expected data then click Next to proceed.

     
  8. You will receive a final confirmation that you want to import.  Click Yes to proceed.
  9. 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.
  10.  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.

 

Updated on Fri, 20 Oct 2023 by Angela Chiaravalle

Glad we could be helpful. Thanks for the feedback.

Sorry we couldn't be helpful. Your feedback will help us improve this article.

How helpful was this page?