Assortment worksheet
Turn a long C-beauty catalog into a focused retail assortment.
Use a product-role worksheet to build an opening assortment that is understandable to customers and manageable for the buying team.
Short answer
Give every proposed SKU a commercial role, such as traffic, everyday routine, visual discovery, margin support, gift, or add-on. Record the customer, channel, retail band, exact version, opening quantity, pack requirement, lead time, and reorder trigger before approving the range.
- Reviewed by
- Anmua sourcing team
- Last reviewed
SKU role and customer mission
Category and price architecture
Opening quantity
Reorder trigger
Assign a role to every SKU
Traffic products attract discovery, repeat-use products support routine purchases, visually distinctive products improve merchandising, and tools or compact add-ons can increase basket value. Avoid adding products with no clear role.
Balance breadth and depth
A wide range creates choice but divides stock across more SKUs. A narrow range is simpler but may miss customer needs. Use sample feedback and channel data to decide which lines deserve shade or quantity depth.
Connect assortment planning to replenishment
Record pack quantities, current lead time, stock assumptions, expected review date, and reorder point. This turns a launch list into an operating plan rather than a one-time purchase.
Download and adapt the working files.
No account is required. Review every field against the current product, supplier, quotation date, and destination market.
What buyers usually ask
How many SKUs should a new store launch?
There is no universal number. It depends on channel, customer, budget, category coverage, pack requirements, merchandising space, and replenishment capacity.
Should assortment planning use bestseller claims?
Use verified channel data when available. Otherwise describe the planned product role and test with samples or a controlled opening quantity rather than presenting assumptions as sales facts.
Can the worksheet cover several brands?
Yes. Record one row per SKU and use the brand, category, role, pack, and reorder columns to manage a mixed assortment.