Manage your store buying like a top brand
The purpose of this file is to provide a clear budget and a total number of pieces to buy in order to reach a realistic sell-out target for the season. It is designed as an educational and practical tool for small business owners, emerging designers and anyone who is not yet familiar with the basic principles of buying and merchandising.
How is the fashion buying excel template structured
The main inputs used in the model are:
– Purchase data from the previous season (cost/retail price, quantities, sell-through).
– Purchase and sales data from the current season (sell-in and sell-out by category).
– Assumptions about future performance, such as changes in average selling price and expected sales growth or decrease by category.
Starting from these historical data points, the file helps you:
-Understand how many pieces you should plan to sell (sell-out) by category, based on realistic performance rather than wishful thinking.
-Translate those sell-out targets into a budgeted sell-in (how many pieces you need to buy) that takes into account price levels, sell-through and stock risk.
-Break down the total buy into detailed quantities per sku and size, keeping consistency with the global budget of the store.
In simple terms, the model guides you through the core logic of buying:
-Look at what really happened in past seasons (what you bought, what you sold, at which prices).
– Decide your sales and pricing objectives for the next season.
– Calculate how many units you should purchase to support those objectives without overbuying.
– Distribute those units across categories, styles and sizes in a structured way.
By following this flow, the file does not just give you numbers, but also teaches the fundamental buying mindset: start from data, define a clear sell-out goal, and then build your buy to support that goal in a controlled and professional way.”
Meet the author
Fashion Buying and Merchandising instructor: Mirko Buccianti
Collection merchandising manager with experience in Gucci, Brunello Cucinelli, Furla, Bally, Thom Browne.
- Merchandising Manager with extensive experience in the fashion and luxury industry, working at the intersection of creativity, data and strategy to shape strong, relevant and commercially successful collections.
- With a solid background across men’s and women’s collections, I translate brand vision, market insights and performance data into clear product strategies, effective range plans and coherent assortments.
- My work bridges creative and commercial teams, helping brands turn intuition into structure and product decisions into long-term value.
FAQs
Can I download the template?
Yes, you can download the template on your own computer.
Can I ask questions about the usage of the template?
Yes, you can ask us questions via email or through the contact form
Is it compatible with Google Sheet?
Yes, the file is compatible with Google Sheet, you need to upload the file to Google Drive or Google Workspace to use it.
Is there a refund policy?
There is no refund available for this template. The sale is final.
In which language is the file available?
The file is available in English, if you need translations please let us know before you buy.
How long do I have access to the buying template for?
You will have access forever.
Is there a course to learn fashion buying?
Yes. there is an online course you can attend to learn professional fashion buying.
How can I enrol on this course?
To enrol on this course, click the button Enrol and complete the checkout. You can pay by credit card, PayPal or bank transfer. Credit cards and PayPal offer also the option to pay by instalments. After completing the checkout you’ll receive the username and password to access out e-learning platform and begin the course.
I need an invoice form my company, can I have it?
Yes, you can receive an invoice and pay by bank transfer if you prefer, please contact us from the form below.