The short answer: There is no way of mass uploading Item Attributes and Item Attribute Values for Items into Dynamics 365 at this time.
Here is some explanation of how the system holds this data in the background:
To be able to import data into Dynamics 365 for Financials at this time, we must either find the table in the RapidStart Configuration Package area, or there must be an Edit in Excel option on the page. Or at least, there must me a Page associated with the table that we can publish using a Web Service (and then use a tool to publish data into Dynamics 365). None of these exist at this time for the Item Attribute functionality.
The way Item Attributes are related to Items is complex, and Microsoft has not exposed the requisite pages for us to be able to directly upload data to them.
Your Item records are stored in the Item table, and the item attributes (Color, Depth, Width, Size, Package, Brands, etc.) are stored in a table called Item Attribute (Table ID 7500).
The actual values of these attributes (i.e., the various values for Size, the various types of Packages, Colors, Brands, etc. are stored in yet another table called Item Attribute Value (Table ID 7501).
And finally, Microsoft Dynamics 365 stores which Items have which Item Attributes and Item Attribute Values in a table called Item Attribute Value Mapping (Table ID 7505).
I hope this helps. If my response has answered your question, please verify by clicking Yes next to "Did this answer your question?"
