Order Import Service
The Order Import Service automates the process of inserting daily order files into our software. The service polls a user defined folder within your network for an order file (CSV or EXT) that has been exported from an ERP/WMS/OMS. The file is then processed by the service and automatically pushed to the database using web services. There are several benefits of using the Order Import Service, including
- Reduction of resources needed to engage in a full integration project.
- The ability to deploy route and dispatch tools quickly.
- No limit to the number of orders that can be sent in one call.
Order Import Service Data Elements
The use of ‘Required’ data fields is necessary ensure proper identification of records. The use of ‘Optional’ data fields improve the efficiency of the software’s reporting capabilities.
- Required Fields:
- Account Number
- Order Number
- Optional Fields:
- Action – Add, Modify, Delete, and Delete All
- Estimated Ship Date – If empty, default to current date with an option to offset days
- Quantity and/or Volume (User Defined Volume Type)
- User field(s) – (User Defined)
- Line Number – If empty, default to Order Number
- Address, Address2, City, State, Zip Code, and Lat/Long
- Time Window, EQCode, Fixed Time, EarlyBuffer, LateBuffer, EarliestDate, LatestDate, Penalty Cost, Zone
XML Order Import Table
The XML Order Import Table contains data for finalized routes that can be retrieved for use in ERP/WMS/OMS, and is laid out as follows:
- Field Name
- Field Type – Enumeration, String, Numeric, Duration, Date, Time, Boolean
- Field Width - Number of characters
- Required/Optional Field (R, O)
- Field Description
- Sample Field Value
|No||N||R||ID||A number increment from 1|
|Name||S||25||R||Name of the Qty Field.||Weight, Cube, Pallet|
|Volume||N||R||The amount of material to be delivered to this stop||2000|
|UnldRate||N||R||The amount of time it will take to unload material per hour. It will take 2 hours to deliver 2000 units at an unld rate of 1000 units/hr||(Pass 0 to ignore unload rates) 1000.|
Note: Service Time at delivery locations are calculated based upon Fixed Time and UnldRate (time). Setting the UnldRate to 0 will make the Fixed Time be the total service time.
|No||N||R||ID||A number incremented from 1|
|Name||S||25||R||Name of the UserField||SalesPerson|
|Value||S||255||R||Value of the UserField||Bob|