-Shipping time weeks

[Jmanaplanner46]

Hi guys

I am trying to figure out how to populate the shipping time weeks line item from shipping method and the shipping metircs module.  I know there is a level mismatch and so I created a staging item PARENT(ITEM(P3 SKU) and attempted to do a lookup on that as well as the shipping method line item.  

[Misbah · Accepted solution]

@Jmanaplanner46 

We are not supposed to discuss certification related queries here on Community but let me try to help you by giving you an additional hint. You will have to use 2 Looks ups. One you figured out and there has to be another one. Think and apply.

Happy Planning

Misbah

[CommunityMember89477]

I have figured out one of the lookups formula I believe but I cant think about the second one. This is the formula I am using currently: 

'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks) '[LOOKUP: 'SYS08 SKU Details'.Product]