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.
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.