new
Merchandise Plan
📋 Deep Copy & Paste in Merchandise Planning
What's new
Regular copy/paste in MFP works at the top level: you copy a parent value, paste it onto another parent, and the value spreads down based on the destination's existing child penetration. With deep copy/paste, you copy the actual values at every level of the hierarchy, including the children, and paste them onto the destination so that the destination takes on the source's penetration instead of its own.
Example: in a Division > Department > Class hierarchy, if you copy a Division and regular paste it onto another Division, the destination keeps its own class-level penetrations and the new Division total spreads across them. If you deep copy that Division and deep paste, the destination's classes take on the source's class-level penetrations instead.
What you can do
- Deep copy a hierarchy– Select a parent row and press Cmd/Ctrl+Shift+C to copy that row plus the values of every descendant underneath it.
- Deep paste a hierarchy– Pick a target parent and press Cmd/Ctrl+Shift+V to apply the source's values, including children, onto the destination. The destination's penetration ends up matching the source's.
- Use the right-click menu– Right-click in the grid and pick "Advanced copy & paste" if you'd rather use the menu than the shortcut.
- Paste across columns– Paste onto any week or column. The values shift relative to where you paste, just like normal copy/paste.
Why it helps
- Carry a source's child penetration into the destination instead of having the destination re-spread based on its own existing penetration.
- Reuse a fully built-out plan across departments, categories, or classes without losing the underlying mix.
- Keep regular copy/paste exactly the way it is for everyday top-level edits.