Loading of Bookings into White Glove module
Bookings both inbound and outbound can be loaded into the White Glove module by the following means:
API (from third party via JSON) using iHub
CSV (using swagger) directly
API Load
Validation messages are provided, however there are some issues with the API currently, as detailed in this ticket WG-591 - Getting issue details... STATUS . This may help with the diagnosis. How to Fix Object Reference Not Set to an Instance of an Object? (minitool.com)
API Testing
For testing using API this URL can be used: https://api-whiteglove-uat.seko360.com/swagger/index.html
A live tool also exists with a similar URL.
CSV Load
For a CSV load the file is in fixed field sequence. This means that the column label has no bearing, it is simply to make the file human-readable.
Load Inbound Booking
Column Heading | Column Row Value |
|---|---|
Document Number | TO1238JS |
Item | AA00NCA2SAA |
Display Name | |
Quantity | 100 |
To Location | DCAAV01 |
Estimated Ship Date | ######## |
Carrier | Savino |
Location | JASPER IND (US) |
Internal ID | 857626 |
Expected Receipt Date | ######## |
Load Outbound Booking
Document Number | SO-US077781 |
Transfer Order Reference # | TO305 |
Shipping Instructions | Aleid |
Company Name | Bloomreach |
Shipping Address 1 | Oosteinde 11 |
Shipping Address 2 | |
Shipping City | Amsterdam |
Shipping State/Province | |
Shipping Zip | 1017 WT |
Shipping Country | Netherlands |
First Name | Aleid |
Last Name | Stroomer |
Phone Number | (888) 263-3917 |
Delivery Contact Email | |
Quantity | 2 |
Item | PR20WOE1EJ0 |
KIT BOX 1 | PR21WOE1SJ0 |
KIT BOX 2 | PR22WOWOSJ0 |
KIT BOX 3 | PR23WOEU6J0 |
KIT BOX 4 | PR25WOWOSJ0 |
KIT BOX 5 | PR24WOE1EJ0 |
KIT BOX 6 | |
KIT BOX 7 | |
KIT BOX 8 | |
KIT BOX 9 | |
KIT BOX 10 | |
KIT BOX 11 | |
KIT BOX 12 | |
KIT BOX 13 | |
KIT BOX 14 | |
KIT BOX 15 | |
KIT BOX 16 | |
KIT BOX 17 | |
KIT BOX 18 | |
KIT BOX 19 | |
KIT BOX 20 | |
KIT BOX 21 | |
KIT BOX 22 | |
KIT BOX 23 | |
Estimated Ship Date | ######## |
Customer Deliver by Date | ######## |
Carrier | SEKO |
Internal ID | 909225 |
Order Type | Sales Order |
Location | DCAAV01 |
Assembly? | N |
TransitMode | ROAD |
QuantityUnit | PCS |