You are here: Inventory Management > Product Maintenance > Manage Product Information > Import Inventory Item Data

Import Inventory Item Data

Complete the following procedure to import item data into the inventory by creating, populating, and importing a formatted Excel file.

  1. ClosedNavigate to the Excel Import screen.

    1. Log In to the Data Center Application to display the Data Center ribbon menu.

    2. Select Inventory Management > Excel Import from the main menu to display the Excel Import screen.

  2. Complete the following for each tax type listed in the Tax Name column:

    Note: If an item being imported already exists in the database, the item's tax settings will be updated to reflect the tax options selected here.

  3. Complete one of the following procedures to export a template format to an Excel file.

  4. Populate the Excel file with item information.

    Note: The file must adhere to the validation requirements indicated in row 1 and may not contain duplicate UPCs.

  5. Save the Excel file.

  6. Click the Select Excel File to Import button on the Excel Import screen to display the Load Excel Import window.

  7. Browse to the desired location.
  8. Double-click the saved Excel file to select it and start the import process.
  9. If the system detects any errors, it displays the Import Complete with Errors window.

    Note: If an item in the Excel file has the same UPC as a system-generated, non-stock product (e.g., Gift Card), the item will be identified as an error.

    Complete any of the following as needed:

  10. When the import is complete, the system displays the Upload Complete window.

  11. Click the Close button to close the window.
  12. Click the tab's Close button to close the screen.

 

 

 

 

© 2016 AcuSport Corporation
All rights reserved