How to Set Days to Expire for Categories & Products
Software Plan: Growth & Enterprise
Account Type: Seller Account, 3PL Aggregator
Inventory Type: Non-Serialized & Serialized
Feature description
This new feature offers flexible control over how you track product freshness:
- Set it for a whole category: If everything in a category expires around the same time, just set one "Days to Expire" value for that category.
- Set it for individual products: For products with different days to expire, easily override the category default and set a custom "Days to Expire" value. The system then automatically calculates and displays the remaining days until each product expires, helping you optimize inventory, reduce waste, and ensure customer satisfaction.
Use Case
Scenario: An e-commerce business that specializes in selling vitamins, supplements, and protein powders. These products have varying shelf lives, typically ranging from 12 months to 36 months. Managing expiration dates is crucial for this business due to:
- Regulations and Compliance: Selling expired supplements can lead to legal issues and damage the company's reputation.
- Product Efficacy: Expired vitamins and supplements may lose their potency, leading to ineffective products and dissatisfied customers.
- Inventory Control: Keeping track of expiration dates for a large variety of products with different shelf lives is a complex task.
How "Days to Expire" Helps:
- Category Defaults: The seller organizes products into categories like "Vitamins," "Protein Powders," and "Herbal Supplements." They set default "Days to Expire" values for each category based on the typical shelf life of the products within them. For example:
- Vitamins: 730 days (approximately 24 months)
- Protein Powders: 912 days (approximately 30 months)
- Individual Product Overrides: Certain products, like probiotics with a shorter shelf life, require special attention. The seller overrides the category default and sets a specific "Days to Expire" value for these individual items.
- Automated Tracking and Display: The system automatically calculates and displays the remaining days until expiry for each product in the inventory. This information is visible in the seller's inventory management dashboard.
Workflow
Step 1: Go to Masters (main menu) > Category Master
Step 2: Choose your category > Click "Action" > Change Expiry/ Manufacturing Date
Step 3: Enable the Inward Expiry Mode > Choose Manufacturing Date & Days to Expire > Set the "Days to Expire" for this category > Save the changes.
If LOT is configured for a particular category, you can update the "days to expire" by following the steps mentioned below:
Step 1: Go to Masters (main menu) > Category Master
Step 2: Choose your category > Click "Action" > Update Shelf Life
Step 3: Mention the Days to Expire for this category and save the changes.
This feature also allows you to set custom "Days to Expire" for individual products. To manually adjust the "Days to expire," follow these steps.
Step 1: Go to Masters (main menu) > Product Master
Step 2: Click on the SKU code for which you wish to set the "Days to Expire" manually.
Step 3: Mention the "Days to Expire" for the product
In the above image, the "Days to Expire" of the category is also mentioned.
Important Note-
- When updating a product, if the 'Days to Expire' field is left blank, the system will automatically apply the corresponding "Days to Expire" defined in the category
- If an individual product has a manually assigned "Days to Expire" value, this value will override the "Days to Expire" value given at the category level
Days to Expire: GRN through UI
Upon creation of a GRN, the relevant "Days to Expire" value (either from the product or category setting) will be displayed.
In cases where both the category and the product have a defined "days to expire" value, the system will prioritize the product's "days to expire" value.
Days to Expire: GRN through Sheet
Important Note-
- When generating GRN using sheet, the system does not automatically populate the "Days to Expire" value. Manual entry is required for each GRN.
- If a "Days to expire" value is already set at the category or product level, it will override any value entered in the sheet.
- If a "Days to expire" value is already set at the category or product level, the sheet column can be left blank.
Days to Expire: GRN through Android
Other Related Articles
Related Articles
Create Goods Receiving Note - GRN (Growth Plan)
Software Plan: Growth & Enterprise Account Type: Seller Account, Aggregator, 3PL Inventory Type: Serialized & Non- Serialized What is a Good Receiving Note (GRN)? A Goods Receiving Note (GRN) is an internal document produced by the warehouse team ...How to Configure GRN Screen
Introduction To run efficiently, warehouse operations must start with an organized receiving process. Upon receiving, the SKUs/items are collected and stored based on certain criteria/parameters like pricing, manufacturing date, expiry date, etc. ...Inventory Planning by Days Report
What is the “Inventory Planning by Days” Report? The "Inventory Planning by Days" report is a comprehensive analysis that provides data to help plan the inventory using historical data over a specified time period. This report is designed to assist ...HHT - Start inwarding items - GRN
GRN: GRN is recorded against purchase orders. To know more on how to create purchase orders, refer to the article 'Creating Purchase Orders'. You can create GRN using both web and android. In this article, we will discuss on how to use android to ...What is a Digital Product ? How to create it?
Software Plan : Starter, Growth & Enterprise Account Type : Seller Account Inventory Type : Serialized & Non-Serialized Feature description A digital product is a good or service that is created, distributed, and consumed entirely in electronic form. ...