Set Up and Manage Store Orders
This document provides detailed information about creating and populating data input files for WCT Transportation Solutions' Route Optimization product.
Route Optimization creates optimized routes by using data input files that you upload into the system. You set up and manage store orders by entering a base data set into these files.
This document describes the data input files and fields that you use, as well as the data that you gather and enter into them. This document also provides links to template files to help you get started.
The base data files include the following:
All the fields of the base data files are mandatory.
Location Information
The Location Information.xlsx file includes basic information about your location. You provide this information only one time, with your first optimization. This file includes the following fields in the order given.
| Field | Description |
|---|---|
| Location no. | The unique identifier of the location. Example |
| Location type | The type of location. This can be a DC or a store. Example |
| Country code | The country code of the location. Example |
| Street address | The street address of the location. Example |
| City | The city of the location. Example |
| State | The state or region of the location. Example |
| Postal code | The USPS postal code or "zip" code of the location. Example |
| Country | The abbreviated name of the country of the location. Example |
| Latitude | The latitude of the location. Example |
| Longitude | The longitude of the location. Example |
Destination Constraints
The Destination Constraints.xlsx file includes information about the constraints of the location. The file includes the following fields in the order given.
| Field | Description |
|---|---|
| Location no. | The unique identifier of the delivery location. Example |
| Location type | The type of the delivery location. Example |
| Country code | The country code of the location. Example |
| Commodity | The type of commodity to be delivered Example |
| Group (ride together) | The commodity types that can be grouped into the same load. Example |
| Delivery lead time | The lead time for receipt of the delivery. Set this field to “0” if the delivery must be received within 24 hours of order acceptance. Set this field to “1” if the delivery must be received within 24 to 48 hours of order acceptance. Example |
| Delivery window begins (Sunday) | The beginning of the allocated window for Sunday delivery. Example |
| Delivery window ends (Sunday) | The end of the allocated window for Sunday delivery. Example |
| Delivery window begins (Monday) | The beginning of the allocated window for (Monday delivery. Example |
| Delivery window ends ((Monday) | The end of the allocated window for (Monday delivery. Example |
| Delivery window begins (Tuesday) | The beginning of the allocated window for Tuesday delivery. Example |
| Delivery window ends (Tuesday) | The end of the allocated window for Tuesday delivery. Example |
| Delivery window begins (Wednesday) | The beginning of the allocated window for Wednesday delivery. Example |
| Delivery window ends (Wednesday) | The end of the allocated window for Wednesday delivery. Example |
| Delivery window begins (Thursday) | The beginning of the allocated window for Thursday delivery. Example |
| Delivery window ends (Thursday) | The end of the allocated window for Thursday delivery. Example |
| Delivery window begins (Friday) | The beginning of the allocated window for Friday delivery. Example |
| Delivery window ends (Friday) | The end of the allocated window for Friday delivery. Example |
| Delivery window begins (Saturday) | The beginning of the allocated window for Saturday delivery. Example |
| Delivery window ends (Saturday) | The end of the allocated window for Saturday delivery. Example |
| Service duration | The time allocated to unload the trailer, in minutes. Example |
| Equipment restriction | The equipment restrictions that are listed for the location. |
Equipment Information
The Equipment Information.xlsx file includes information about the type of trailer and its configuration. The file includes the following fields in the order given.
| Field | Description |
|---|---|
| Trailer ID | The unique identifier for the trailer. The ID is specified by the client. Example |
| Trailer name | The client-specified name of the trailer. Example |
| Trailer type | Select DRY (ambient goods, or dry goods that do not require temperature control) or REFER (refrigerated). Example |
| Trailer height (in) | The height of the trailer, in inches. Example |
| Trailer length (in) | The length of the trailer, in inches. Example |
| Trailer width (in) | The width of the trailer, in inches. Example |
| Maximum trailer weight (lb) | The maximum weight that the trailer can carry, in pounds. Example |
| Position of the front axle in inches. | The distance from the nose of the trailer to the front axle, in inches. Example |
| Maximum weight on front axle (pounds) | The maximum weight permitted on the front axle, in pounds. Example |
| Position of the rear axle in inches. | The distance from the nose of the trailer to the rear axle, in inches. Example |
| Maximum distance to rear axle | The maximum distance of the rear axle from the nose of the trailer, in inches. Example |
| Minimum distance to rear axle | The minimum distance of the rear axle from the nose of the trailer, in inches. Example |
| Maximum weight on rear axle (pounds) | The maximum weight allowed on the rear axle, in pounds. Example |
| Minimum distance to front bulkhead (inches) | The minimum distance between the trailer nose and the bulkhead that is positioned at the front axle, in inches. Example |
| Maximum distance to front bulkhead (inches) | The maximum distance between the trailer nose and the bulkhead that is positioned at the front axle, in inches. Example |
| Minimum distance to rear bulkhead (inches) | The minimum distance between the trailer nose and the bulkhead that is positioned at the rear axle, in inches. Example |
| Maximum distance to rear bulkhead (inches) | The maximum distance between the trailer nose and the bulkhead that is positioned at the rear axle, in inches. Example |
Store Order
The Store Order.xlsx file includes information about the type of trailer and its configuration. The file includes the following fields in the order given.
| Field | Description |
|---|---|
| Source | The type of the origin location. Example |
| Destination | The location type of the destination. Example |
| Pallet type | The stacking restrictions that are applied to the pallet. A pallet that can be stacked has a type of PALLET. A pallet that cannot be stacked has a type of FIXED_COMBINE. Example |
| Weight | The weight of the pallet, in pounds. Example |
| Cubic feet | The size of the pallet, in cubic feet (cf). Example |
| Cases | The number of cases. Example |
| Product type | The type of the product. Example |
| Container ID | The unique identifier of the container. Example |
| Pallet length | The length of the pallet, in inches. Example |
| Pallet width | The width of the pallet, in inches. Example |
| Pallet stack group | The stack group specified for the pallet. Example |
| Bulkhead restriction | Restrictions that must be applied to the bulkhead. Example |
| Do not distribute | Whether distribution of the pallet contents is permitted. Example |
| Minimum temperature | The minimum temperature allowed for the goods. Example |
| Maximum temperature | The maximum temperature allowed for the goods. Example |
Updated 2 months ago