Level 1 Model Building - Importing Data

[Star]

Hi

In going through the import data files (e.g. Products), I came to understand that although the parent-child hierarchy is defined in the Lists, 

1)  the data for the parent (Product Family - Chocolate, Sours, Taffy, Fudge)  still have to be defined in the import file.  

2)  the mapping for the parent (Product Family) still have to be defined during import.

I would have thought that since the parent-child (Product Family and Product) hierarchy was already defined, then parent (Product Family - Chocolate, Sours, Taffy, Fudge)  would automatically be filled up but it does not seem to be so.

Is the above understanding correct?

[Sorna Raja Prabhu · Accepted solution]

Hi @Star,

You are doing really well.

1 thing you should change.

in the Sys06 Product Details Module, you should write a formula for Code and Product Family as CODE(ITEM('P2 Products')) and PARENT(ITEM('P2 Products')) respectively.

while setting the action you should do these

[abhisheksai13]

hello 

can you elaborate on why you chose to map like this 

[CommunityMember128166]

I agree with your answer. One question I have is:

When using the formula mentioned, for Product Family, I am getting Chocolate and so on, but ideally I think we should get the code of this Chocolate. Is that correct understanding