Introduction
Welcome back! In our last lesson, we focused on when to reorder stock by calculating reorder points and safety stock levels. This ensures you have a continuous flow of products coming in. Now, we'll turn our attention to managing the products you already have on your shelves.
For a beauty mini-market, this is not just about organization; it's about safety, quality, and financial health. Cosmetics have a limited shelf life, and selling an expired product can damage your reputation and, more importantly, harm a customer. This lesson directly addresses the learning outcome: to manage product shelf life and expiration dates for beauty and cosmetic products.
We'll cover three key areas:
- Understanding the different types of expiration dates on cosmetics.
- Implementing the core physical strategy for stock rotation.
- Building a digital system to track expiry dates proactively.
This will equip you with a comprehensive process to minimize waste and ensure every product you sell is fresh, safe, and effective.
1. Understanding Cosmetic Expiration Dates
Before you can manage expiration dates, you need to know how to read them. Unlike food, cosmetics often have two types of "best by" dates, which are governed by specific regulations.
Let's start by reading an article that clearly explains these concepts.
The article 'Understanding Cosmetic Shelf Life' from Taobe Consulting provides an excellent overview of the regulatory and practical aspects of cosmetic expiration.
Please read the first two main sections of the article, from the start down to the heading 'The Period After Opening (PAO): Ensuring Consumer Safety and Compliance'. Focus on understanding the difference between: Date of Minimum Durability (DMD): This is the mandatory expiration date for products with a shelf life of less than 30 months. It's often indicated by an hourglass symbol or the words 'Best before...'. Period After Opening (PAO): This applies to products with a shelf life longer than 30 months. It indicates how long the product is safe to use after it has been opened.
As the article explains, the PAO is indicated by a symbol of an open jar with a number followed by an "M". This is crucial information, especially for testers or products that customers might open in-store.
Here are examples of what those PAO symbols look like:
While DMD and PAO are the official markers, it's also helpful to have a general idea of the typical shelf life for different product categories. This infographic provides a useful quick reference.
2. The Core Strategy: First-In, First-Out (FIFO)
Now that you understand the dates, the single most important strategy for managing them is First-In, First-Out (FIFO). This principle is simple: the first products you receive (the oldest stock) should be the first ones you sell. This ensures that you are constantly rotating your inventory and selling items long before they reach their expiration date.
The article "5 tips to optimize the management of its stock in a beauty..." introduces this concept clearly.
5 tips to optimize the management of its stock in a beauty ...
Let's quickly review the FIFO principle in the context of a beauty business.
Please read the point on 'First input, first output (FIFO)' under the 'Basic principles' heading, and then skim the section 'Organization and storage of products', paying attention to point #4, 'Stock rotation system (FIFO)'. This will reinforce the concept.
Reading about FIFO is one thing, but seeing it in action makes it click. This is a fundamental physical task in retail that will be new to you given your digital background. The following video gives a perfect demonstration of how to physically rotate stock on a shelf.
This video, 'Stocking Products & Rotation' from the Down to Earth Team Members channel, shows the practical application of FIFO when restocking shelves.
Watch the sections from 00:35-01:18 and 03:44-04:18. Observe how the staff member checks the dates on the new stock and the existing stock, and then places the new items with the later expiration date behind the older ones. This is FIFO in practice.
This simple process—pulling older items forward and placing new items in the back—is the foundation of effective shelf-life management.
3. Building a System to Track Expiration Dates
Physical rotation is essential, but it's reactive. To be truly in control, you need a proactive system that alerts you to products approaching their expiration date. While advanced Point of Sale (POS) systems can do this, you can build a powerful and free tool yourself using a spreadsheet.
Given your digital experience, you'll find this approach both familiar and effective. The following video provides a detailed, step-by-step guide to creating an expiry tracking sheet in Excel.
How to manage expired items in Excel
This detailed tutorial 'How to manage expired items in Excel' by retailhow will walk you through creating a dynamic expiry management tool.
I recommend watching this video from start to finish (00:00 - 08:47). It's dense but very practical. Follow along to understand the key steps: Setting up your data tables for your main inventory list and the expiry list. Adding essential columns: Pay close attention to the 'Expiry Date' and the calculated 'Day Remaining' columns. Using Conditional Formatting (04:11): This is the most powerful part. Learn how to automatically color-code products that are expired (red), expiring soon (yellow), or safe (green). Creating a Summary Dashboard (05:55): Use COUNTIF functions to see at-a-glance how many items fall into each category.
By building a sheet like this, you create an early warning system. Each week, you can sort your list by "Day Remaining" to see which products need attention. This allows you to plan promotions or special offers to sell through items before they expire, turning potential losses into revenue.
4. A Checklist for Daily Practice
To bring everything together, here is a practical checklist you can adapt for your store's daily and weekly operations. These points are summarized from the "Management of expiration dates" section of the Green Spa article.
- [ ] Label Everything: When you receive a shipment, use a label maker or marker to put the expiration date (DMD) clearly on the outer case or on a designated back-stock shelf tag.
- [ ] Practice FIFO Always: Train yourself and any future staff to always place new stock behind old stock, both on the sales floor and in the stockroom.
- [ ] Update Your Tracker: As new inventory arrives, add the products and their expiration dates to your Excel tracking sheet.
- [ ] Weekly Expiry Review: Once a week, review your tracking sheet. Identify any products with less than 30-60 days until expiration.
- [ ] Create an "Expiring Soon" Strategy: For products identified in your weekly review, take action:
- Create a small "Sale" or "Last Chance" section in your store.
- Bundle them with other products.
- Use them as a free gift with a minimum purchase.
- [ ] Train Your Team: As you hire staff, make training on FIFO and expiration date checks a mandatory part of their onboarding.
Conclusion
Congratulations! You've just learned one of the most critical operational skills for running a successful beauty store. By mastering this, you protect your customers, comply with regulations, and prevent your profits from expiring on the shelf.
Key Takeaways:
- Know Your Dates: Differentiate between the Date of Minimum Durability (DMD) for sealed products and the Period After Opening (PAO) for opened ones.
- Embrace FIFO: The "First-In, First-Out" method is your primary physical strategy. Always stock new products behind older ones.
- Build a System: Use a tool like an Excel spreadsheet with conditional formatting to proactively track expiry dates and get early warnings.
- Make it a Routine: Integrate regular expiry checks and action plans into your weekly store management tasks.
Preview of the Next Lesson:
Now that you know how to manage the quality and lifecycle of your inventory, the next logical step is to ensure your records match reality. In our next lesson, we will cover how to conduct a physical inventory count and reconcile discrepancies. This process, known as a stock take, is essential for maintaining accurate records, identifying theft or loss, and ensuring the data in your tracking systems is reliable.