Importing a New Purchased Item
  • 18 Jun 2024
  • 1 Minute to read
  • Dark
    Light
  • PDF

Importing a New Purchased Item

  • Dark
    Light
  • PDF

Article summary

This article is part of adding a New Purchased Item.

Users can add new purchased item(s) by using the Import Tool. This article details the Purchased Item Record import process.

The import process requires users to first download the appropriate template, complete the template, then upload the file. Read below to learn more.


Importing a Purchased Item

In Smart Ops, click Import under Admin in the left navigation menu.

Or, in the classic experience, select Import from under Administration in the top ribbon tab.

The import tool will open in a new tab.

Select Purchased Item as the Import Option.

Select Create New as the Type. 

Click Download Template to download the purchased item import template. 

This will add the file named Purchased Item New to the download folder on the device. Open the file.

Users should complete each column of information for the purchased item(s) they want to import. This includes the following:

  • Name

  • Measure Type

  • Reporting UofM

  • Item Category 1

  • Number

  • Cost Account

  • Inventory Account

  • Inventory UofM

  • Cost Update Method

  • Key Item

To learn more information about these Purchased Item Record fields, click here

Click to enlarge.

Once the file is completed, save the file. Then, return to the Import Tool and click Upload File

From the pop-out, click Select Files. Then, select the correct file to upload. 

The file will show as uploaded.

Once uploaded, click one of the Next buttons.

This will prompt users to map the fields,if necessary. Review the fields and the template columns. Make adjustments as needed.

Once all is reviewed, click Next to continue to the next step.

Click Import.

If the import was successful, users will be notified that the file imported successfully, and the import tool will list the items that were imported.


Purchased Item Import Error

Users may receive an import error upon import. If this is the case, the page will reload with a file named PurchasedItem_Correction List. Click the file to open it.

This file will be a copy of the imported file with an additional column named Problem, which will list the error that occurred. In the example below, the user left out a required field: Inventory UofM.

To resolve the error, fix any problems on the file, save the file, then complete the import process once again by returning to Step 1: Upload File.

Review our Import Tool Article if you have additional questions about importing a file or addressing issues surrounding an unsuccessful import.


Was this article helpful?