Assortment Planning for Shopify: Decide Which Products Deserve More Exposure, Reorders, or Removal

Assortment planning is the process of choosing which products to carry, how many variants to offer, and where those SKUs get visibility so the mix matches demand. On a Shopify store, that work comes down to three decisions: which products get more exposure, which get reorders, and which get removed or demoted.

A catalog that grows by habit creates three revenue leaks. Bestsellers run out before a reorder lands. Ad budget hits products that get clicks and no orders. High converters sit on page three of a collection while slow movers occupy the first row.

What assortment planning covers

Product assortment (the merchandise mix) is the range of items you offer. Breadth is how many product lines you carry. Depth is how many sizes, colors, materials, or other variants sit inside each line.

Planning the mix is the thought process behind that range at a given time of year. You decide what stays in the catalog, how much stock each SKU deserves, and which items earn homepage, collection, and campaign slots.

Most Shopify catalogs split into three roles. Core SKUs sell year-round. Seasonal SKUs spike around weather, holidays, or events. Trend SKUs move now and may not repeat. The mix of those roles should change as demand changes, not only when a new product is added.

The three assortment decisions

Treat every SKU as a decision, not a permanent listing. Score it on sales, conversion, stock cover, and collection position, then pick one action.

Decision	Signals to look for	What to do in Shopify
More exposure	Strong sales or conversion, healthy stock, low collection position	Move it into the first rows of high-traffic collections and paid landing pages
Reorder	A-grade or B-grade sales, solid sell-through, few days of inventory remaining	Place a purchase order before cover falls inside supplier lead time
Remove or demote	C-grade sales, weak conversion, aging stock, high sessions with few orders	Drop it from featured collections, clear remaining units, then archive after sell-out

A bestseller running low and a product getting clicks but no orders belong in the same assortment review.

Pull these Shopify reports before you change the mix

Do not rebuild a collection from last week's gut feel. Pull the same four views for one product type or one high-traffic collection, then score SKUs.

ABC grade and sales by product

Shopify's ABC analysis by product grades variants on revenue share over the last 28 days. A-grade products collectively account for around 80% of revenue, B-grade products the next 15%, and C-grade products the last 5%. Item cost is not part of the grade. The window cannot be changed and updates daily.

Pair that grade with Total sales by product and Total sales by product variant for net quantity, net sales, and discounts. Shipping is excluded from the product report because one order can hold several products and a single shipping charge. An ABC analysis pass tells you which SKUs fund the store and which ones only occupy space.

Sell-through and days of inventory remaining

On the Products page, Shopify's product inventory analytics bar shows sell-through rate, days of inventory remaining, and inventory value by ABC grade. Click a tile to open the related inventory report.

Shopify calculates sell-through rate as quantity sold divided by (quantity sold + quantity still in inventory). The sell-through tile uses the most recent 30-day period available, usually with about a two-day processing delay. Days of inventory remaining is ending quantity divided by average units sold per day over the last 28 days. High sell-through with few days remaining is a reorder candidate. Low sell-through with a large ending quantity is a cut or clearance candidate.

Collection position versus product conversion

Sales volume alone hides two problems. A SKU can sell because it sits in the first row, not because shoppers prefer it. Another SKU can convert well and still stay buried. Review product conversion rate next to sessions, revenue, and available units. Then check whether that SKU lifts or drags the parent collection.

Shopify collection sort options include most relevant (sales performance), best selling (all-time order count), title, price, created date, and manual order. Best selling rewards lifetime volume. It will keep yesterday's winner on top after conversion falls or stock thins. Manual order plus current conversion is the usual fix for a featured collection. See Shopify collection optimization for how to score products inside a grid.

A practical assortment planning workflow

Run this on one collection or one product type first. A full-catalog rewrite in one sitting hides which change worked.

Pick one collection that already gets traffic, such as a category page or a bestsellers grid.
Open Total sales by product and ABC analysis by product. Note A, B, and C grades for every SKU in that collection.
Add sell-through rate and days of inventory remaining for the same SKUs.
Flag underexposed winners: strong conversion or A-grade sales, healthy stock, weak collection position.
Flag reorder risks: A-grade or B-grade SKUs whose days of cover sit inside supplier lead time.
Flag cuts: C-grade SKUs with weak conversion, aging stock, or high sessions and few orders.
In the Shopify admin, open the collection, set Default sort to Manually, and place promote SKUs in the first two rows.
Move cut SKUs below the fold or out of the featured collection. Keep a reorder SKU in a prime slot only if you can replenish before it sells out.
Recheck the same collection after 7 to 14 days. Keep a promoted SKU only if conversion and stock still hold.

Change two or three positions at a time. If you reshuffle the whole grid, you cannot tell which move paid.

Breadth, depth, and the job of each collection

Assortment planning is also merchandising architecture. Each collection should have a job, and the SKU mix should match that job. Ecommerce merchandising is the practice of deciding which products a shopper sees first so more of the catalog converts.

Core category collections (shoes, serums, mugs) carry the working breadth of the line. Keep in-stock, in-season SKUs here.
Hero or bestsellers collections should be tight. First-row slots go to converters with stock, not every product that ever sold.
Seasonal collections need a buy deadline, a live window, and an exit plan for leftover units.
Paid landing collections should be narrower than browse-all pages. Send ads only to SKUs that convert.
New-arrival collections are a test slot. Give a new SKU a trial position, then promote or demote on conversion, not launch date.

Deepen a line when shoppers already buy that type and ask for more sizes or colors. Widen the catalog only when you can name the customer job the new line serves and the collection that will hold it. Extra SKUs without a collection job become dead weight.

How to apply the plan inside Shopify collections

If your store is on the Basic plan or higher, you can group products into collections and control which items appear. You can add products automatically with conditions, add them by hand, and exclude products with exclusion conditions. After the mix is set, change how the grid displays.

Shopify documents collection sort in Editing collection details and layout. New collections default to Most relevant. For a featured collection you are actively planning, switch Default sort to Manually, drag promote SKUs to the top, and save.

From Shopify admin, go to Products, then Collections.
Open the collection you scored.
In Collection items, set Default sort to Manually.
Move promote SKUs to the beginning. Move cut SKUs to the end, or exclude them from this collection.
Save, then check the storefront on mobile. Most shoppers only see the first rows.

Keep unavailable products out of featured collections so shoppers do not click into empty inventory. A thin or out-of-stock SKU in position 1 still burns the session. That is a merchandising error, not a traffic problem.

When a SKU earns more exposure, a reorder, or removal

More exposure

Give more exposure to SKUs that already convert and still have stock. Move them into the first eight positions of a high-traffic collection, add them to the homepage module that collection feeds, and point campaigns at that URL instead of a weak PDP.

Do not buy more traffic for a high-session, low-conversion SKU until the product page, price, or creative is fixed. Extra exposure multiplies a leak. Product analytics that break conversion, revenue, and traffic down per SKU make that call faster than a sales-only report.

Reorders

Shopify's ABC guidance is direct: always have A-grade inventory on hand, and reorder well before you expect to run out. B-grade SKUs should arrive shortly before cover hits zero. C-grade SKUs should be ordered less often, or not at all, unless they serve another job (a required accessory, a complete size run).

Use days of inventory remaining against supplier lead time. If cover is inside that window, the SKU needs a purchase order now, or it needs to leave featured slots so you do not advertise a stockout. A reorder formula plus stock intelligence keeps A-grade units from disappearing while you are still debating the collection grid.

Removal

Removal is a sequence, not a delete on day one. Drop the SKU from hero collections and ads. Discount or bundle remaining units. Stop replenishing. After sell-out, archive the product if it has no remaining job in the catalog.

Shopify notes that C-grade products often cost more to warehouse than they return, and that selling them off then removing them from the catalog is often the more profitable path. Check an inventory aging report before you reorder a slow mover "just in case." Age plus C-grade plus weak conversion is enough evidence to cut.

A cadence that keeps the mix honest

Assortment planning fails when it is a once-a-year spreadsheet. Demand, stock, and collection conversion move weekly. Use a short loop.

Weekly: review days of cover on the top revenue SKUs. Pull any unit inside lead time out of featured positions, or place the reorder.
Weekly: in each high-traffic collection, promote one underexposed winner and demote one low converter.
Before a season: set the buy deadline, the live window, and the exit plan for seasonal SKUs. Keep core SKUs in place while seasonal depth changes.
After 14 days: compare collection conversion and product conversion on the SKUs you moved. Keep the change only if the numbers hold.
When the catalog outgrows the calendar: review only collections that already get traffic. Ignore empty grids.

Manual sort works until you have more collections than hours. At that point, collection optimization that ranks products by conversion, stock, and revenue impact is the practical next step. You still make the merchandising call. You stop rebuilding the same export every Monday.

Mistakes that keep the wrong products in play

Sorting a featured collection only by best selling. That locks in lifetime volume and ignores current conversion and stock.
Pinning every new arrival in row one. New SKUs need a test slot, not the whole fold.
Leaving low-stock or unavailable SKUs in campaign collections. Shoppers click, bounce, and the collection conversion rate falls.
Adding breadth because a competitor launched a line, without a collection that will hold it or a reorder plan if it hits.
Deepening every colorway of a C-grade style. Extra variants of a weak seller multiply aging stock.
Changing ten products at once, then guessing which move worked.
Treating ABC grade as a personality test. Grades are a 28-day revenue split. Recheck them. B-grade SKUs move up and down.

Open one high-traffic collection today. Score each SKU as promote, reorder, hold, or cut. Move two products. Place one reorder for an A-grade SKU that is inside lead time. That is an assortment plan you can run again next week.