Skip to main content

​
Overview

Product rotation tracking ensures that inventory is used in the correct order to minimize waste, maintain product quality, and comply with industry regulations. Pro Stock Tool provides comprehensive tools for managing product rotation, tracking expiration dates, and identifying products requiring immediate attention.
Proper rotation management is critical for perishable goods, pharmaceuticals, electronics, and any products with limited shelf life or date-sensitive compliance requirements.

​
Rotation Methods

FIFO

First In, First OutProducts received first are sold or used first. Ideal for most inventory scenarios to prevent aging stock.

FEFO

First Expired, First OutProducts with earliest expiration dates are prioritized. Essential for perishables and dated products.

LIFO

Last In, First OutMost recently received products are used first. Used in specific accounting or material scenarios.

Lote Tracking

Batch/Lot TrackingTrack individual batches for quality control, recalls, and detailed traceability.

​
Expiration Date Management

​
Setting Up Expiration Tracking

Configure products with expiration monitoring:
1

Enable Expiration Tracking

In product configuration:
​
track_expiration
boolean
default:"false"
Enable expiration date tracking for this product
​
shelf_life_days
number
Default shelf life in days from receipt date
​
warning_days
number
default:"30"
Days before expiration to trigger warnings
​
critical_days
number
default:"7"
Days before expiration for critical alerts
2

Record Expiration Dates

When receiving products:
  • Scan or enter expiration date from packaging
  • System calculates expiration date if only manufacture date provided
  • Assigns lot/batch number for tracking
  • Links expiration to specific warehouse location
3

Monitor Alerts

System automatically generates:
  • Green: Products with >90 days until expiration
  • Yellow: Products within warning threshold (30 days)
  • Orange: Products nearing expiration (7-14 days)
  • Red: Products expiring within 7 days or expired

​
Expiration Date Entry

// Product Entry with Expiration Data
const productEntry = {
  product_id: 456,
  product_name: "Organic Milk 1L",
  quantity: 48,
  warehouse_id: 1,
  
  // Expiration tracking
  expiration_tracking: true,
  batch_number: "LOT-2026-0342-A",
  manufacture_date: "2026-02-28",
  expiration_date: "2026-03-21",  // 21 days shelf life
  
  // Auto-calculated
  days_until_expiration: 18,
  alert_level: "warning",  // Yellow alert
  
  // Rotation priority
  fifo_priority: 3,  // Third oldest batch in stock
  fefo_priority: 1,  // Earliest expiration - ship first
  
  // Storage location
  location: "Refrigerador-A-Shelf-2",
  rotation_enabled: true
}

​
Rotation Reports

​
Near Expiration Report

Identify products requiring immediate action:
Immediate Action Required
ProductBatchQtyExpiresDaysAction
Yogurt Natural 500gLOT-A342242026-03-052Urgent Sale
Queso Fresco 400gLOT-B156122026-03-063Discount 50%
Pan IntegralLOT-C789362026-03-085Promotional
Jugos NaturalesLOT-D234182026-03-096Bundle Deal
Critical items require immediate action: Apply aggressive discounts, create promotions, or prepare for disposal if unsold.

​
FIFO Compliance Report

Verify that oldest products are being sold first:
Overall FIFO Compliance: 94%Calculation based on:
  • Products shipped in correct age order
  • Violations (newer stock sold before older)
  • Exception rate for valid business reasons
Breakdown by Category:
  • Perecederos: 98% (Excellent)
  • Electrónicos: 91% (Good)
  • Textiles: 88% (Needs Improvement)
  • Otros: 85% (Review Required)
Recent FIFO Violations:
DateProductIssueImpactResolution
03/02Laptop X200Newer unit shippedLowTraining reminder
03/01Monitor 24”Location mix-upMediumProcess update
02/28Cable HDMIPicking errorLowStaff coaching
Review violations weekly and address patterns through training, process improvements, or warehouse layout optimization.
FIFO Compliance by Location:
  1. Bodega Central: 97% - Excellent process adherence
  2. Bodega Norte: 95% - Strong performance
  3. Bodega Sur: 92% - Good compliance
  4. Bodega Este: 89% - Needs attention
Success Factors:
  • Clear location labeling with dates
  • Staff training on rotation importance
  • Regular compliance audits
  • Efficient warehouse layout

​
Batch and Lot Tracking

​
Batch Management

Track products by manufacturing batch for quality and recall management:
​
Batch Record
{
  "batch_id": "LOT-2026-0342-A",
  "product_id": 789,
  "product_name": "Vitamina C 1000mg",
  "manufacturer": "PharmaCorp S.A.",
  
  "production_info": {
    "manufacture_date": "2026-02-15",
    "expiration_date": "2028-02-15",
    "production_facility": "Plant-03-Mexico"
  },
  
  "quantity_info": {
    "original_quantity": 500,
    "current_quantity": 342,
    "sold_quantity": 158,
    "warehouses": [
      {"warehouse_id": 1, "quantity": 200},
      {"warehouse_id": 3, "quantity": 142}
    ]
  },
  
  "quality_control": {
    "inspection_date": "2026-02-16",
    "inspector": "Quality Team",
    "status": "approved",
    "certificates": ["COA-2026-0342", "GMP-Certified"]
  },
  
  "traceability": {
    "supplier_reference": "SUP-INV-8934",
    "purchase_order": "PO-2026-0123",
    "customers_shipped_to": 23,
    "recall_status": "none"
  }
}

​
Recall Management

Quickly identify and isolate affected batches:
1

Initiate Recall

When a quality issue is identified:
  • Enter affected batch number(s)
  • System identifies all locations with the batch
  • Calculates total quantity in circulation
  • Lists all customers who received the batch
2

Isolate Product

Immediate actions:
  • Mark batch as “HOLD - Do Not Ship”
  • Generate quarantine labels for warehouse
  • Block affected inventory from sale
  • Alert warehouse staff via notification
3

Customer Notification

If product already shipped:
  • Generate customer contact list
  • Send recall notifications
  • Track customer responses
  • Arrange pickup or disposal instructions
4

Documentation

Record complete recall details:
  • Reason for recall
  • Quantity affected
  • Quantity recovered
  • Disposal method
  • Financial impact
  • Preventive measures implemented
Batch tracking is essential for regulated industries. Maintain complete traceability for pharmaceuticals, food products, medical devices, and other controlled items.

​
Rotation Optimization Strategies

​
Warehouse Layout for Rotation

Zone-Based Storage

Organization Method:Divide warehouse into rotation zones:
  • Zone A: Products expiring 0-30 days
  • Zone B: Products expiring 31-90 days
  • Zone C: Products expiring 91-180 days
  • Zone D: Products expiring >180 days
Benefits:
  • Visual identification of aging stock
  • Simplified picking procedures
  • Reduced rotation errors

Date-Based Shelving

Arrangement System:Organize products by receipt/expiration date:
  • Front positions: Oldest/earliest expiration
  • Back positions: Newest/latest expiration
  • Clear date labels on all positions
  • Colored markers for urgency levels
Benefits:
  • Intuitive FIFO compliance
  • Easy visual inspection
  • Quick expiration verification

​
Automated Rotation Alerts

Configure intelligent notifications:
Morning Rotation Checklist (sent at 8:00 AM):
  1. Expired Yesterday: Products that expired in last 24 hours
  2. Expiring Today: Items reaching expiration date
  3. Critical This Week: Products expiring in next 7 days
  4. FIFO Violations: Recent incorrect rotation incidents
  5. Low Rotation Items: Products not moving as expected
Recipients: Warehouse managers, inventory team

​
Waste Reduction Strategies

​
Preventing Expiration Waste

Implement automated discount schedules based on days until expiration:
Days to ExpirationDiscountDisplay
60-90 days0%Regular price
30-59 days10%“Fresh deals”
15-29 days20%“Quick sale”
8-14 days35%“Manager’s special”
1-7 days50%“Last chance”
Same day75%“Flash sale”
Automatic pricing adjustments encourage sales before expiration while maintaining profitability.
Use historical data to optimize order quantities:
  • Analyze sales velocity by product
  • Factor in seasonal patterns
  • Account for shelf life constraints
  • Adjust order quantities to match consumption
  • Coordinate with suppliers for smaller, more frequent deliveries
Impact: Reduce overstock and improve turnover rates
Create strategic bundles with near-expiration items:Bundle Strategies:
  • Pair fast-moving with slow-moving items
  • Combine complementary products
  • Create meal kits or project bundles
  • Offer “mystery boxes” at deep discounts
  • Design seasonal or themed combinations
Example: Bundle yogurt (expiring in 5 days) + granola (long shelf life) at attractive price
Partner with food banks and charities:
  • Identify products suitable for donation (still safe, approaching expiration)
  • Establish relationships with local organizations
  • Coordinate regular pickup schedules
  • Document donations for tax benefits
  • Track social impact metrics
Benefits: Reduce waste, support community, potential tax deductions

​
Rotation Analytics

​
Key Performance Indicators

Waste Rate

2.3% of inventory↓ 0.8% vs last monthTarget: <2%

Average Age

34 days average inventory age↓ 5 days vs last monthTarget: <45 days

FEFO Compliance

96% compliance rate↑ 2% vs last monthTarget: >95%

​
Rotation Velocity Analysis

Understand how quickly products move through inventory: 
// Product Rotation Metrics
const rotationMetrics = {
  product_id: 234,
  product_name: "Smartphone Model X",
  
  // Velocity metrics
  average_days_in_stock: 28,
  fastest_rotation: 14,  // Days for fastest-moving unit
  slowest_rotation: 62,  // Days for slowest-moving unit
  
  // Turnover
  monthly_turnover_rate: 3.2,  // Inventory turns over 3.2x per month
  annual_turnover_rate: 38.4,
  
  // Age distribution
  age_distribution: {
    "0-30_days": 65,    // 65% of stock is under 30 days old
    "31-60_days": 28,   // 28% is 31-60 days old
    "61-90_days": 5,    // 5% is 61-90 days old
    "90+_days": 2       // 2% is over 90 days old
  },
  
  // Recommendations
  status: "healthy",
  notes: "Good rotation velocity. Minor tail of aging stock to monitor."
}

​
Best Practices

Morning Routine (15 minutes):
  1. Review overnight expiration alerts
  2. Check products expiring in next 7 days
  3. Verify yesterday’s shipments followed FIFO
  4. Identify any new FEFO priority items
  5. Update rotation zone assignments if needed
  6. Brief picking team on priority items
Impact: Catches issues early and maintains awareness
Essential Training Topics:
  • Why rotation matters (waste, quality, compliance)
  • How to read date codes and expiration labels
  • FIFO vs FEFO: when to use each method
  • Proper picking procedures from shelves
  • How to use rotation alerts in the system
  • What to do when finding expired products
  • Batch/lot number importance for traceability
Training Schedule: Initial onboarding + quarterly refreshers
Design Principles:
  • Position high-rotation items near shipping area
  • Ensure clear visibility of expiration dates
  • Implement color-coded zones by expiration range
  • Create dedicated “urgent sale” area for near-expiration
  • Use gravity-feed shelving for automatic FIFO
  • Maintain clear aisle access for stock rotation
  • Install adequate lighting for date verification
System Enhancements:
  • Barcode scanning with automatic date capture
  • Handheld devices showing rotation priority
  • Visual dashboards in warehouse areas
  • Automated alerts sent to mobile devices
  • Integration with POS for dynamic pricing
  • RFID tags for automatic batch tracking
  • Mobile app for instant expiration checks

​
Regulatory Compliance

​
Industry-Specific Requirements

Compliance Requirements:
  • Maintain complete batch traceability
  • Record temperature monitoring data
  • Document FEFO compliance
  • Track “use by” vs “best before” dates
  • Maintain cleaning and sanitation logs
  • Implement allergen segregation
Regulations: FDA Food Safety Modernization Act (FSMA), local health codes

Inventory Reports

Generate comprehensive stock level and warehouse reports

Movement Tracking

Monitor product entries, exits, and transfers

Product Management

Configure products with expiration tracking settings

Warehouse Management

Optimize warehouse layout for rotation efficiency

Build docs developers (and LLMs) love

Get started for freeTalk to us