Search Orders based on Timestamp Format in Wave Selection Rules

Ecommerce fulfilment cut-off times often change day to day based on warehouse capacity. Generally, Wave Planners and Warehouse Supervisors require a simple way to quickly select the right set of orders for a wave without applying complex rules or relying on workarounds.

To improve operational agility and to Increases on-time shipment performance, we have enhanced our Dynamic Wave Search Rule to support order selection using  “From” and “To” date/time range based on the Order Create Timestamp. You can also adjust this range often because cut-off times change day to day.

For example:

• On weekends, orders created up to 2:00 PM qualify for next day picking and shipping.
• On weekdays, orders created up to 6:00 PM qualify for next day picking and shipping.

Now, you can define time-based selection criteria in a consistent: d+/-(value), h=(value), m=(value), where  d+/- (value) is for days and m+/- (value) is for minutes. See the Steps to Enable section below for an example.

Wave selection rules support time-of-day precision in formats like mm/dd/yyyy or dd/mm/yyyy. Today, users across different regions run wave with different formats. Configuring selection rules using specific “From” and “To” date formats might lead to rejecting the rule or throwing an error at wave execution. To avoid such barriers, we’ve extended existing relative date syntax so you can specify hours and minutes in addition to days.

Steps to enable and configure

1. Go to Wave Template > Wave template selection > Dynamic Wave search 
2. Click Selection Criteria and select the operation per your requirement (refer the example)
3. Click Save when done

Example: For Order Selection created today from 12:00 AM to 3:00 PM, you can configure the rule as:

• Order Create ts >= d+0,h=0

Order Selection (Greater than or Equal to)

• Similarly, Order Create ts <= d+0,h=15

Order Selection (Less than or Equal to)