Planning for Route Sort Rules

Route sort rules are a great way to send on demand orders to the routed side of the Operations App. When an order is placed using an order type with a sort rule configured (on the pickup, delivery, or both addresses), the zip code for the address is used to find a route match, moving the order onto a route. Route sort rules can also be used for importing route stops through an integration to allow route assignment based on the time of day or day of the week.

Example

A customer is unable to support an integration to create route stops and prefers to have orders placed online. When the client places an order online, the order is automatically assigned to a route using route sort rules, based on the order type and address details.

 

Step 1: Identify which orders need to be sorted to a route

List the criteria of the orders that need to be sorted to a route.

Example

  • All orders for specific zip code(s) placed after 11pm need to be placed on tomorrow’s routes.

  • Orders that come in before 8am will need to be placed on AM routes, orders that come in after 12pm but before 4pm will need to be placed on PM routes. Orders that come in after 4pm will need to be placed on tomorrow’s AM route.

  • Every order using a specific order type that comes in during a set time period needs to be assigned to a specific route each day (override route).

Step 2: Identify the order type(s) that need to be sorted to a route

Route sort rules are determined by order types and are not customer specific.

Step 3: Identify the attribute that will differentiate the stops that will be sorted

Route sort rules are based on the zones/zip codes and the day(s) of the week and time(s) of the stops. Attributes to sort stops can be categorized as the following:

  • Zip codes

  • Zip codes plus 4

  • Street addresses

  • Geozones

  • Time windows

  • Days of the week

  • Pickup, delivery, or both - Whether the order should be placed on a route based on the pickup and/or delivery information.

  • Route - The route that the stops should be sorted to.

Example

Attribute

ID

Time From

But Time To

Weekdays

Weekends

Pickup

Delivery

Order Type

Route

Attribute

ID

Time From

But Time To

Weekdays

Weekends

Pickup

Delivery

Order Type

Route

Zip

85004

08:00

12:00

Every Weekday

 

X

 

Same Day

ROUTE1A

Zip

85004

12:01

16:00

Every Weekday

 

X

 

Same Day

ROUTE1B

Street

N Central

17:00

23:59

Every Weekday

Every Weekend

X

X

Standard

ROUTE2

All Orders

(order type)

08:00

16:00

 

Sunday

 

X

Rush

Overflow

Quick Tip: Make sure the zones (zip and street) are looking at the same column.

Step 4: Identify how many route sort rules are needed

The number of route sort rules needed depends on the days and times of your route sort rules. You will need a route sort rule for the pickup and/or delivery for each order type but, you can use the same order type if the time windows and the routes they should sort to are the same.

If the route sort rules have timeframes that overlap, the first row that matches the order’s time window will be used. Any additional rows will that match the time window will not be used.

Example

Order Types

I want the “Same Day” order type to sort only on pickup, the “Standard” order type to sort on both pickup and delivery, and the “Rush” order type to sort on delivery.

Order Type

Pickup

Delivery

Order Type

Pickup

Delivery

Same Day

X

 

Standard

X

X

Rush

 

X

Route Sort Rules

  • Orders that come in before 8am will need to be placed on AM routes, orders that come in after 12pm but before 4pm will need to be placed on PM routes.

  • All orders for specific zip code(s) placed after 11pm need to be placed on tomorrow’s routes.

  • Every order that comes in (for a specific order type) during a set time period needs to be assigned to a specific route each day (override route).

Route Sort Rule

Start Day(s)

Start Time

Stop Day(s)

Stop Time

Pickup Time

Delivery Time

Lookup Column

Route Sort Rule

Start Day(s)

Start Time

Stop Day(s)

Stop Time

Pickup Time

Delivery Time

Lookup Column

Weekday Split

Every Weekday

08:00

Every Weekday

12:00

From

To

1

Weekday Split

Every Weekday

12:01

Every Weekday

16:00

From

To

2

After Business Hours

Every Day

17:00

Every Day

23:59

To

To

1

Overflow

Sunday

08:00

Sunday

16:00

From

To

(Override Route: Overflow)

Zones

I want the orders for zip code zone 85004 that come in before 8am to be on ROUTE1A and orders after 12pm but before 4pm to be on ROUTE 1B. Orders that are in the N Central street zone should be on ROUTE2. If the order type is the same, only one route sort rule would be needed.

Zone Type

Zone

Lookup Column

Route ID

Zone Type

Zone

Lookup Column

Route ID

Zip

85004

1

ROUTE1A

Zip

85004

2

ROUTE1B

Street

N Central

1

ROUTE2