The OLX Shipping Export v5.0 is the file layout used to send orders to fulfillment companies from the OrderLogix application. This is accomplished by creating a CSV (a file with information fields, each separated by a single comma) comprised of 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 the OrderLogix system for export to a 3rd party fulfillment vendor. 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. Export Definitions: Shipping Order Record Layout Position | Field Name | Req. | Type | Max | Description | 1 | RECORD TYPE | YES | Alpha | 1 | Record Type. For Shipment Header Records, the type should be "O" | 2 | BATCH ID | YES | Numeric | | OrderLogix Assigned Shipment Batch ID. | 3 | BATCH DATE | YES | Date | | Create stamp of Shipment Batch | 4 | SHIPMENT ID | YES | Numeric | | OrderLogix Assigned Shipment ID. *** Note: This number needs to be passed back to OrderLogix in the Shipment Confirmation file. | 5 | ORDER ID | YES | Numeric | | OrderLogix Assigned Order ID. | 6 | ORDER DATE | YES | Date | 8 | The date is for the local time of the server to which the order came from. Format: MM/DD/YYYY | 7 | ORDER NUMBER | YES | Alpha | 255 | This field contains the reference number assigned to this order at the time the order was placed. | 8 | CUSTOMER ID | YES | Numeric | | OrderLogix Assigned Customer ID. | 9 | BILL COMPANY | NO | Alpha | 255 | Billing company. | 10 | BILL LAST NAME | YES | Alpha | 50 | Billing last name. | 11 | BILL FIRST NAME | YES | Alpha | 30 | Billing first name. | 12 | BILL ADDRESS1 | YES | Alpha | 255 | Billing street address. | 13 | BILL ADDRESS2 | NO | Alpha | 255 | Billing street address continued. | 14 | BILL CITY | YES | Alpha | 50 | Billing city. | 15 | BILL STATE | YES | Alpha | 20 | Billing state or province abbreviation. | (Ex. ME for Maine) | 16 | BILL ZIPCODE | YES | Alpha | 20 | Billing zip code or postal code. | Format for US: ##### or #####-#### | Format for Canada: XXX XXX | 17 | BILL COUNTRY | YES | Alpha | 3 | Country code for the billing address on an order. Country codes "001" for US, "034" for Canada. | 18 | BILL PHONE NUMBER | YES | Alpha | 30 | Billing phone number. | Format: (###) ###-#### | 19 | BILL PHONE NUMBER2 | NO | Alpha | 30 | 2nd Billing phone number. | Format: (###) ###-#### | 20 | EMAIL | NO | Alpha | 255 | Customer email address. | 21 | NO SOLICITING | NO | Boolean | 1 | No soliciting (1) or soliciting OK (0). | 22 | SHIP TO COMPANY | NO | Alpha | 255 | Shipping company | 23 | SHIP TO LAST NAME | YES | Alpha | 50 | Shipping last name | 24 | SHIP TO FIRST NAME | YES | Alpha | 50 | Shipping first name | 25 | SHIP TO ADDRESS1 | YES | Alpha | 255 | Shipping street address | 26 | SHIP TO ADDRESS2 | NO | Alpha | 255 | Shipping street address continued | 27 | SHIP TO CITY | YES | Alpha | 50 | Shipping city | 28 | SHIP TO STATE | YES | Alpha | 50 | Shipping state or province | 29 | SHIP TO ZIP | YES | Alpha | 50 | Shipping zip code or postal code. | Format for US: ##### or #####-#### | Format for Canada: XXX XXX | 30 | SHIP TO COUNTRY | YES | Alpha | 3 | Country code for the shipping address on an order. Country codes "001" for US, "034" for Canada. | 31 | SHIP PHONE NUMBER | YES | Alpha | 30 | Shipping phone number. | Format: (###) ###-#### | 32 | SHIP PHONE NUMBER2 | NO | Alpha | 30 | 2nd Shipping phone number. | Format: (###) ###-#### | 33 | SHIP METHOD | YES | Alpha | 255 | Shipping method for order | 34 | SOURCE CODE | YES | Alpha | 50 | Source code for order | 35 | SOURCE NAME | YES | Alpha | 255 | Description of source code for order | 36 | CAMPAIGN | YES | Alpha | 255 | Campaign for order | 37 | SOLD BY | YES | Alpha | 255 | Person or entity that sold the order | 38 | PAYMENT METHOD | YES | Alpha | 255 | Payment Method of order | 39 | CARD TYPE | NO | Alpha | 255 | Credit Card Type (If Payment Method is “CREDIT CARD”) | 40 | ORDER SUBTOTAL | YES | Numeric | | The sum of all products on the order using formula quantity * (unit price – discount). | 41 | ORDER SHIPPING | YES | Numeric | | Shipping Amount for entire Order | 42 | ORDER TAX | YES | Numeric | | Tax Amount for entire Order | 43 | ORDER TOTAL | YES | Numeric | | The sum of all products, shipping and tax on the order using formula (quantity * (unit price – discount)) + shipping + tax. | 44 | ORDER COMMENTS | NO | Alpha | 4000 | Order Comments | 45 | PACKING SLIP COMMENTS | NO | Alpha | 4000 | Packing Slip Comments |
Shipping Line Record Layout Position | Field Name | Req. | Type | Max | Description | 1 | RECORD TYPE | YES | Alpha | 1 | Record Type. For Shipping Line Records, the type should be "L" | 2 | BATCH ID | YES | Numeric | | OrderLogix Assigned Shipment Batch ID. | 3 | BATCH DATE | YES | Date | | Create stamp of Shipment Batch | 4 | SHIPMENT ID | YES | Numeric | | OrderLogix Assigned Shipment ID. | 5 | ORDER ID | YES | Numeric | | OrderLogix Assigned Order ID. | 6 | ORDER DATE | YES | Date | 8 | The date is for the local time of the server to which the order came from. Format: MM/DD/YYYY | 7 | ORDER NUMBER | YES | Alpha | 255 | This field contains the reference number assigned to this order at the time the order was placed. | 8 | ITEM ID | YES | Numeric | | OrderLogix Assigned Item ID. | 9 | OFFER NAME | YES | Alpha | 255 | Sales offer name | 10 | WAREHOUSE CODE | YES | Alpha | 255 | Warehouse code for the shipping line. This is usually a kit header code | 11 | DESCRIPTION | NO | Alpha | 255 | Description | 12 | UNIT PRICE | YES | Numeric | | Unit Price of the Shipping Line | 13 | QUANTITY | YES | Numeric | | Quantity of the shipping line | 14 | DISCOUNT | NO | Numeric | | Discount for the Shipping Line | 15 | COUPON CODE | NO | Alpha | 255 | Coupon Code for the shipping line | 16 | SHIPPING | YES | Numeric | | Shipping Amount for shipping line | 17 | TAX | YES | Numeric | | Tax Amount for shipping line |
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 | BATCH ID | YES | Numeric | | OrderLogix Assigned Shipment Batch ID. | 3 | BATCH DATE | YES | Date | | Create stamp of Shipment Batch | 4 | SHIPMENT ID | YES | Numeric | | OrderLogix Assigned Shipment ID. | 5 | ORDER ID | YES | Numeric | | OrderLogix Assigned Order ID. | 6 | ORDER DATE | YES | Date | 8 | The date is for the local time of the server to which the order came from. Format: MM/DD/YYYY | 7 | ORDER NUMBER | YES | Alpha | 255 | This field contains the reference number assigned to this order at the time the order was placed. | 8 | ITEM ID | YES | Numeric | | OrderLogix Assigned Item ID. | 9 | ITEM INVENTORY ID | YES | Numeric | | OrderLogix Assigned Item Inventory ID. | 10 | SKU | YES | Alpha | 255 | SKU of inventory component | 11 | DESCRIPTION | NO | Alpha | 255 | Description | 12 | QUANTITY | YES | Numeric | | Quantity of the inventory component | 13 | UOM | YES | Alpha | 255 | UOM of inventory component | 14 | UOM COUNT | YES | Numeric | | UOM Count of inventory component |
The attached documentation includes the OLX Shipping Export v5.0 Spec, Template, and Example.
|