The Walmart OTIF compliance program has many nuances and can cause significant hits to your bottom line if it’s not met. It’s all about delivering your products On Time and In Full to Walmart distribution centers. A key part of meeting the OTIF requirements for all prepaid suppliers is scheduling delivery appointments within the must arrive by date (MABD) window of the PO.
What is MABD?
Walmart will include a Must Arrive by Date on each purchase order. This date indicates when your product must be delivered to Walmart to meet Walmart’s on time requirements for that PO.
If an order is delivered outside of this MABD delivery window, that order will be seen as either early or late and your OTIF score will be affected, potentially incurring fines from Walmart.
What are the Delivery Windows?
MABD is only a single date, however, the window that the product must be delivered will vary based on the department of the product being purchased. As of this writing, there are 3 types of delivery windows:
- 1-day window
- 2-day window
- 11 AM – 11 AM
1-day window means the product must be delivered on the exact MABD date.
A 2-day window means the product must be delivered the day before or the day of the MABD date.
11 AM – 11 AM means the product must be delivered between 11 AM the day before the MABD date and 11 AM of the MABD date.
Delivery Windows by Department*
*as of 6/12/2019
|Merchandising Alignment||Departments||Delivery Windows|
|General Merchandise||3, 5, 6, 9, 10, 11,|
12, 14, 16, 17, 18,
19, 20, 21, 22, 23,
24, 25, 26, 27, 28,
29, 30, 31, 32, 33,
34, 35, 36, 56, 67,
71, 72, 74, 77, 85,
|Food (excludes “fresh food”)||1, 80, 81, 82, 90,|
91, 92, 95, 96, 97,
|Consumables||2, 4, 8, 13, 40, 46,|
|Health & Wellness||38, 49||1-day window|
|Fresh Foods||93, 94||11 AM – 11 AM|
When combining POs onto single shipments, your transportation team should take extra care to ensure that the shipment will arrive within the MABD windows of every PO on the shipment.
Keep track of these delivery windows when scheduling appointments or rescheduling appointments to ensure that your appointment time falls within the MABD delivery window, or else your OTIF score, and your fines will be affected.