The OLX Ship Confirmation Import v5.0 is the file layout used to receive shipment
confirmation for orders from fulfillment companies into the OrderLogix application. This is
accomplished by creating a CSV (a file with information fields, each separated by a single comma)
comprised of up to 3 different records types, with all required information, leaving the unused fields
blank. This document will cover in detail, the specifications needed to parse a valid file generated by
a 3rd party fulfillment vendor for import into the OrderLogix system. The OLX Ship Confirmation Import v5.0 supports 3 different shipment confirmation scenarios:
1) Shipment complete for all items ordered
The OLX system will: - Reconcile the shipment transaction by applying the Tracking number(s) passed, the warehouse Shipping ID, the ship date and shipping carrier
- Update the Item Status of all Order Items attached to the shipment transaction
- These order items will be considered shipped and will have their status updated from “Item Awaiting Ship Confirm” to “Item Shipment Delivered” or “Shipped Awaiting Settlement”, depending on the way payments are/have collected for the given order.
- If Inventory records are assigned to the order items, those inventory items will be updated from, “Committed” to “Shipped”.
- If SHIPPING LINE INVENTORY RECORDS are present and they contain Lot # / Serial Number data
- Update the inventory item records to store the Lot # or Serial # and Expiration Date.
2) Shipment of one or more, but not all items The OLX system will: - Reconcile the shipment transaction by apply the Tracking number(s) passed, the warehouse Shipping ID, the ship date and shipping carrier
- Update the Item Status of all Order Items
- For those that were specified to have the QUANTITY SHIPPED equal to the QUANTITY ORDERED in the SHIPPING LINE RECORD
- These order items will be considered shipped and will have their status updated from “Item Awaiting Ship Confirm” to “Item Shipment Delivered”or “Shipped Awaiting Settlement”, depending on the way payments are collected for the given order.
- If Inventory records are assigned to the order items, those inventory items will be updated from, “Committed” to “Shipped”.
- For those that were specified to have the QUANTITY SHIPPED equal to 0 in the SHIPPING LINE RECORD
- These order items will have their item status set back to “ITEM SHIP READY”.
- They will be removed from the reconciled shipment transaction and they will be eligible to be reshipped in a future shipment batch export.
- A note will be added to the customer record that a Shipment was “Short Shipped”.
- If SHIPPING LINE INVENTORY RECORDS are present and they contain Lot # / Serial Number data
- Update the inventory item records to store the Lot # or Serial # and Expiration Date.
3) Shipment of none of the items ordered
The OLX system will: - DELETE the shipment transaction in OrderLogix
- Update the Item Status of all Order Items
- These order items will be considered not shipped and will have their status updated from “Item Awaiting Ship Confirm” to “Item Ship Ready”. Inventory, if used will be released and reallocated. If that process results in a backorder, the Item Status will be set to “Item Backorder”
- These items will be eligible to be reshipped in a future shipment batch export.
- If Inventory records are assigned to the order items, those inventory items will be released and then re-reserved, which might potentially put this item on backorder.
- A note will be added to the customer record that a Shipment was “Killed”.
|
File Format: ASCII text (standard US-English letters, numbers and keyboard characters). The
file must contain one line per record type, with each field enclosed in double
quotes and comma separated, ending with a Carriage Return (↵) <CR>. All
unused fields will be left blank and remain separated by a single comma. File Naming: OLX_Ship_Confirmations_<YYYMMDD>.csv Import Definitions: Shipping Order Record Layout Position | Field Name | Req. | Type | Max | Description | 1 | RECORD TYPE | YES | Alpha | 1 | Record Type. For Shipment Confirmation Header Records, the type should be "O" | 2 | OLX SHIPMENT ID | YES | Numeric | | OrderLogix Assigned Shipment ID. | 3 | WMS SHIPMENT ID | YES* | Alpha | 255 | Warehouse Assigned Shipment ID. * Leave Blank for Killed/Cancelled Shipments | 4 | SHIPMENT DATE | YES* | Alpha | 255 | The date of the shipment. Format: MM/DD/YYYY * Pass Cancel Date for Killed/Cancelled Shipments | 5 | CARRIER | YES* | Alpha | 50 | Shipping Carrier * Leave Blank for Killed/Cancelled Shipments | 6 | TRACKING NUMBER | YES* | Alpha | 255 | Carrier assigned package tracking number(s) for the entire shipment. For multiple tracking numbers, list them all with a pipe character “|” between each tracking number. * Leave Blank for Killed/Cancelled Shipments | 7 | CLASS OF SERVICE | YES* | Alpha | 30 | Carrier Class of Service * Leave Blank for Killed/Cancelled Shipments | 8 | TOTAL ORDER LINES | YES | Numeric | | Number of Order Lines for the Shipment | 9 | TOTAL SHIPPED LINES | YES | Numeric | | Number of Order Lines that fully shipped for the Shipment ** NOTE: If TOTAL SHIPPED LINES = TOTAL ORDER LINES, the order shipped complete. If TOTAL SHIPPED LINES < TOTAL ORDER LINES but >= 1, the order partial shipped If TOTAL SHIPPED LINES = 0, the order did not ship. | 10 | SHIPPING COST | NO | Numeric | | Shipping Cost | 11 | SHIPPING NOTE | NO | Alpha | 255 | Shipping notes |
Shipping Line Record Layout Position | Field Name | Req. | Type | Max | Description | 1 | RECORD TYPE | YES | Alpha | 1 | Record Type. For Shipping Line Inventory Records, the type should be "L" | 2 | OLX SHIPMENT ID | YES | Numeric | | OrderLogix Assigned Shipment ID. | 3 | WMS SHIPMENT ID | YES* | Alpha | 255 | Warehouse Assigned Shipment ID. * Leave Blank for Killed/Cancelled Shipments | 4 | SHIPMENT DATE | YES* | Alpha | 255 | The date of the shipment. Format: MM/DD/YYYY * Pass Cancel Date for Killed/Cancelled Shipments | 5 | ITEM ID | YES | Numeric | | OrderLogix Assigned Item ID (OrderDetailID). | 6 | ORDER QUANTITY | YES | Numeric | | Quantity Ordered of the Order Line | 7 | SHIPPED QUANTITY | YES | Numeric | | Quantity Shipped of the Order Line ** NOTE: SHIPPED QUANTITY must be either ORDER QUANTITY or 0. Cannot reconcile partial ORDER LINE Shipments. Passing 0 will indicate that this order line did not ship. | 8 | TRACKING NUMBER | YES* | Alpha | 255 | Carrier assigned package tracking number(s) for the shipping line. For multiple tracking numbers, list them all with a pipe character “|” between each tracking number. * Leave Blank for Killed/Cancelled Shipments |
Shipping Line Inventory Record Layout Position | Field Name | Req. | Type | Max | Description | 1 | RECORD TYPE | YES | Alpha | 1 | Record Type. For Shipping Line Inventory Records, the type should be "I" | 2 | OLX SHIPMENT ID | YES | Numeric | | OrderLogix Assigned Shipment ID. | 3 | WMS SHIPMENT ID | YES* | Alpha | 255 | Warehouse Assigned Shipment ID. * Leave Blank for Killed/Cancelled Shipments | 4 | SHIPMENT DATE | YES* | Alpha | 255 | The date of the shipment. Format: MM/DD/YYYY * Pass Cancel Date for Killed/Cancelled Shipments | 5 | ITEM ID | YES | Numeric | | OrderLogix Assigned Item ID (OrderDetailID). | 6 | ITEM INVENTORY ID | YES | Numeric | | OrderLogix Assigned Item Inventory ID. | 7 | SKU | YES | Alpha | 255 | SKU of inventory component | 8 | ORDER QUANTITY | YES | Numeric | | Quantity Ordered of the inventory component | 9 | SHIPPED QUANTITY | YES | Numeric | | Quantity Shipped of the inventory component. ** NOTE: SHIPPED QUANTITY must equal either ORDER QUANTITY or 0. Cannot reconcile partial ORDER LINE Shipments. Passing 0 will indicate that this inventory component did not ship. All records containing the same ITEM ID must either ship complete or not ship at all. | 10 | TRACKING NUMBER | YES* | Alpha | 255 | Carrier assigned package tracking number(s) for the inventory component. For multiple tracking numbers, list them all with a pipe character “|” between each tracking number. * Leave Blank for Killed/Cancelled Shipments | 11 | LOT NUMBER | NO | Alpha | 255 | Lot # of inventory component | 12 | SERIAL NUMBER | NO | Alpha | 255 | Serial # of inventory component | 13 | EXPIRATION DATE | NO | Date | | Expiration/Warrantee date of inventory component Format: MM/DD/YYYY |
The attached documentation includes the OLX Ship Confirmation Import v5.0 Spec, Template, and Example. |