Browse All

Get Every Style into Your Assortment Plan Without Retyping the Line

Get Every Style into Your Assortment Plan Without Retyping the Line

Written by

Danielle Gregoire

Solutions Consultant

Table of contents

Category

Learning Series

Get Every Style into Your Assortment Plan Without Retyping the Line



Why Planners Rebuild the Line by Hand

Before you can plan the line, you have to retype it.

The styles already exist. Product development built them in PLM. Every style number, every color, every attribute is sitting right there. But when you open your assortment plan, none of it is in front of you. So you go get it. You export the line to a spreadsheet. You rebuild it in the plan, choice by choice. You type or paste style numbers. You re-enter names and attributes one row at a time. A hundred styles means a hundred passes. None of it is planning. It is data entry standing between you and the work that matters.

Call it the rekeying tax. Every team that plans off PLM without a bridge pays it.

Why the Rekeying Compounds Mid-Development

The line isn’t static; styles get added, they get cut. Colors change. Names change. Every shift sends you back to reconcile by hand and re-key the deltas against a moving target. You are maintaining a copy of someone else's data instead of building a plan.

Rekeying Style Data is Costly

And it lands in three places.

Time: The Burden Spikes Right Before Line Review

The burden scales with style count and drop cadence, so it spikes right before line review, when the calendar is tightest and you can least afford it. And it is not a once-a-year event. Every drop brings a new wave of styles, so the same manual intake repeats season after season.

Accuracy: One Typo at Intake Moves Money Downstream

Manual transcription introduces errors. A mismatched style ID. A wrong attribute. These do not stay contained. A typo at intake feeds your size curves, your buy quantities, and your allocation. You catch it three steps later, after money’s already moved.

One typo at intake · the blast radius
Intake
One wrong style ID
A single mistyped character
Feeds
Size curves
Wrong sizes, scaled up
Feeds
Buy quantities
You order against them
Feeds
Allocation
Pushed to every store
Three steps later
$ moved
Where you finally catch it

The error doesn’t stay contained. One wrong ID at intake feeds every number downstream — and by the time you see it, it has already moved money.

Drift: You End Up Planning Against a Line That No Longer Exists

While you work off a static export, development keeps going. Your plan gradually becomes a snapshot of a line that doesn’t exist anymore. You make decisions against a ghost.

Create Style Data Once, Then Move It from PLM to Your Plan

The fix starts with one principle: style data should be created once and moved, vs. maintained in two places. PLM is the system of record for what the line is. Your plan should read from that record directly. It should not depend on a person retyping it.

That principle has a few practical parts.

From PLM to the plan · two ways
By hand Rebuild the line choice by choice
1
PLM
System of record
2
Export to spreadsheet
3
Retype row by row
100 styles, 100 passes
4
Reconcile by hand
5
Assortment plan
Every add, cut, or color change sends you back to re-key the deltas
One pass The plan reads the line directly
1
PLM
System of record
2
Pick the subset
Only what belongs
3
Assortment plan
Scoped & dated on arrival

Same starting point. The extra steps — and the loop — disappear.

Move Styles in Bulk — and Choose Which Ones

You rarely want the entire line in a single plan. You want a category, a delivery, a subset that matters right now. Say a fall delivery just landed in PLM with sixty styles across three categories. You should be able to pull only the ones that belong in the plan in front of you, in one pass, and leave the rest. Not all or nothing. Not one at a time.

Bring the Planning Context With the Styles

Bring the planning context with the styles. When a style lands in your plan, it should arrive already scoped to the view you are working in and the timeframe you have set. If you re-apply filters and re-enter dates after the styles show up, you have not removed the manual step. You have only kicked the can down the road.

Make the PLM-to-Plan Move Transparent

Show What Loaded and What Failed — and Why

Bulk operations sometimes fail in part. A few records will not make it across for one reason or another. When that happens, you need to know. A good intake shows you what came across and what did not, and why. A silent partial load is worse than no load. It looks complete and is not.

Keep Exceptions in Their Place

Most styles will come across cleanly. A handful might not. The process should surface those few without making the whole batch feel fragile. You review the exceptions, fix them, and move on.

The behavior change underneath all of this is simple. Stop treating the handoff between product development and planning as a manual job that lives with the planner. Replace it with a repeatable flow that keeps you in one place. Your job is to decide breadth, depth, flow, and margin. The data should already be there when you sit down to do it.

No Platform Yet? Make PLM the One Record You Trust

Maybe your plan can't read from PLM automatically, as most can't yet. You can still act on the principle today, because the expensive part was never the retyping. It was maintaining two live copies that both claim to be right.

Pick one direction. PLM is the record. Your export is a read-only snapshot vs. second place to plan. When the line changes, you re-pull the deltas from PLM instead of hand-editing both sides and reconciling later. You’ll still spend time on intake. You’ll spend less time on reconciliation, and the drift that comes from two versions pulling apart. It’s a discipline, not a feature, and it is the closest thing to the fix you can put in place before the tooling catches up.

How Toolio Moves Styles from PLM into Your Assortment Plan

When the technology does the work, this is what it looks like. This is what Create Choices from PLM does in Toolio. You pick the PLM styles you want in the Style Bank, right-click to Create New Choice, and each one becomes a new choice in the current assortment plan, carrying the filter overrides from your current view and the date range you set for choice creation, plus a clear list of any that failed and why.

The handoff stops being your job. The line shows up in the plan the way product development built it, and the hour before line review goes back to breadth, depth, flow, and margin. The job you were hired to do.

Relevant Blog Posts