Import Item Attributes

(0) Share

Report

Posted on by Greg Kujawa

627

I am starting to delve into importing around 25K items from our existing POS/Inventory system into NAV. I have the routine down for the basic data fields, with only the item images and attributes being stragglers. I have asked the question about new image imports in a separate post. As for item attributes, I realize there is a more complex table relationship behind the scenes --- attributes, their possible attribute values, and those links to the items themselves. This post I ran across on here is from 2017, so it might be dated --> But it sounds as if it's not possible to import in these attributes via the API, OData, or SOAP. Is this still the case?

What I'm picturing is already having the item attributes and their possible values pre-defined in NAV. So that when I'm importing in new items I can then cross-reference things. Anyone have any insight into how to make this happen?

All responses (4)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Import Item Attributes

Greg,

I read your second forum message. Hopefully a developer can assist you.

Steve
Greg Kujawa 627 on at

Like (0)

Report

RE: Import Item Attributes

If you read my original question, I am referring to using the OData API in order to import in 25K items with their attributes. I'm aware of how to assign item attributes through the standard web client.
Community Member Microsoft Employee on at

Like (0)

Report
RE: Import Item Attributes

Greg,

Here is an overview from my handout:

To create item attributes

Choose the  icon, enter Item Attributes, and then choose the related link.

In the Item Attributes window, choose the New action.

In the Item Attribute window, fill in the fields as necessary. Choose a field to read a short description of the field or link to more information.

Note: If you select Option in the Type field, then you can choose the Item Attribute Values action to create values for the item attribute.

To create values for item attributes of type Option

Choose the  icon, enter Item Attributes, and then choose the related link.

In the Item Attributes window, select an item attribute of type Option that you want to create values for, and then choose the Item Attribute Values action.

In the Item Attribute Values window, fill in the fields as necessary. Choose a field to read a short description of the field or link to more information.

To assign item attributes to items

Choose the  icon, enter Items, and then choose the related link.

In the Items window, select the item that you want to assign item attributes to, and then choose the Attributes action.

In the Item Attribute Values window, choose the New action.

Choose the lookup button in the Attribute field and select an existing item attribute. Alternatively, choose the New action to first create a new item attribute as explained in the "To create item attributes" section.

In the Value field, enter the item attribute value, such as "2010" for the Model Year attribute.

For item attributes of type Option, choose the lookup button in the Value field and select an item attribute value. Alternatively, choose the New action to first create a new item attribute value as explained in the "To create values for item attributes of type Option" section.

Repeat steps 4 through 6 for all item attributes that you want to assign to the item.

To assign item attributes to item categories

Choose the  icon, enter Item Categories, and then choose the related link.

In the Item Categories window, select the item category that you want to assign item attributes to, and then choose the Edit action.

In the Item Category Card window, on the Attributes FastTab, choose the New action.

Choose the lookup button in the Attribute field and select an existing item attribute. Alternatively, choose the New action to first create a new item attribute as explained in the "To create an item attribute" section.

In the Default Value field, choose the lookup button and select an item attribute value.

Repeat steps 4 and 5 for all item attributes that you want to assign to the item category.

Note: Item attributes for parent item categories will be inherited to child item categories. This is indicated by the Inherited From field on the Attributes FastTab.

Hope this helps.

Thanks,

Steve
Greg Kujawa 627 on at

Like (0)

Report

RE: Import Item Attributes

Now that I'm nearing the end of the Item Image upload challenge, on to the Item Attributes/Item Attribute Value association needed for importing new Items into NAV. I assume that each Item Attribute and its associated Item Attribute Value will need to be pre-defined in NAV. So that I can reference them when associating with a newly-created Item.

Can anyone speak to this area or point me to a working example?