Notes about Items Imports

The following information may apply to your items imports:

Import of Inventory Detail Data Currently Not Supported
Unique Item Lookups by Internal ID and External ID
Updating Inventory with Imported Items Data
Updating Vendors on Items
Updating Locations on Items

Import of Inventory Detail Data Currently Not Supported

When the Advanced Bin / Numbered Inventory Management feature is enabled, the following types of items include an Inventory Detail subrecord in the user interface: Assembly/BOM Item (when Use Bins is set to True), Lot Numbered Assembly/BOM Item, Serialized Assembly/BOM Item, Inventory Item (when Use Bins is set to True), Lot Numbered Inventory Item, and Serialized Inventory Item.

The Inventory Detail subrecord includes quantity on hand and quantity available values per bin number and per serial/lot number. Import of this subrecord's data is not currently supported. If you enable the Advanced Bin / Numbered Inventory Management feature, CSV import of the types of items listed above may result in incomplete data. For details about this feature, see Advanced Bin / Numbered Inventory Management.

Unique Item Lookups by Internal ID and External ID

To help eliminate ambiguous or missed lookups, the Import Assistant lets you reference an Item's Internal ID or External ID.

The Internal ID can be obtained by performing an Item saved search and exporting the results to CSV.
The External ID is similar to handle, and can be set to any string during add, but must be unique across all items.

For more information, see Select Reference Types.

Updating Inventory with Imported Items Data

After you have completed an import of items, you can use the Adjust Inventory Worksheet to update inventory levels. For more information, see Inventory Adjustments.

Updating Vendors on Items

You can use the Import Assistant to update Vendor sublist information for items. For these updates, depending on your setting for the Overwrite Sublists option, you can overwrite items' existing vendors sublists, or you can selectively update based on a key of Vendor name.

You also can use an alternate method to set preferred vendors for items through a CSV import. The Import Assistant supports the addition of a Preferred Vendor column to an Items CSV file. If the vendor specified in this field currently is on the vendor list, the import marks it as preferred; if it is not on the list, the import adds it. This method is available even if the Multiple Vendors feature is not enabled.

Important:

If your CSV file defines more than one vendor as preferred for an item, the last vendor listed is the one that is marked as preferred by the import.

Updating Locations on Items

You can use the Import Assistant to update location sublist information for items, when the Multi-Location Inventory feature is enabled. The fields that are updatable per location are Preferred Stock Level, Quantity on Hand, and Reorder Point. Also, if the Demand Planning feature is enabled, additional demand planning fields are available for items where the Time Phased replenishment method is used. See Selecting General Ledger Accounts for Item Imports.

After you have completed an import of items for multiple locations, you can use the Transfer Inventory form or Transfer Orders to move inventory among locations as necessary. For information, see Transferring Inventory.

The Location sublist is a keyed sublist, based on Internal ID, External ID, or Location name. Updates of this sublist vary depending on your setting for the Overwrite Sublists option.

Importing Default ATP Method Data

As of 2017.1, you can use the Import Assistant to import default available to promise (ATP) methods when you import inventory items, and you have the Available to Promise feature enabled in your account. For information about the Available to Promise feature, see Available to Promise.