Overview The OLX Shipping Export v3.5 is the original (or legacy) 107 column 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) 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 addition, 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_Orders_<YYYMMDD>.csv Spec Key Field Names A list of fields, which can be transposed (viewed horizontally, instead of vertically) into the columns of a header row. Required Defines if information must be provided for the field or not. Type Defines the character type (what keyboard characters are allowed in the field): - Alpha – letters, numbers and simple symbols (ex. @, -, / or &)
- Numeric – numbers only
- Date – format shown in Field Description (ex. MM/DD/YYYY)
- Boolean – 1 for True or 0 for False
Max The maximum amount of the Type characters that can be passed for the field. Field Description Notes, examples and formatting. Export Definitions For visual purposes the spec is broken into 4 separate colored groups. Blue is customer information, green is order information, purple is product information and red is important fields; A 5th field type is colored in grey, and each of these fields should be left blank and remain separated by a single comma (see Examples section). Note that there are a number of fields which should be left blank as this file layout shares the same number of columns and relative positions as another order export that includes more detailed payment information for each order. This table should be viewed in reference with the OLX Shipping Export Example.csv
#
| Field Name | | Type | Max | Field Description | 1 | RESERVED | | | 0 | This field will be blank. | 2 | CUSTOMER NUMBER | YES | Alpha | 50 | OrderLogix Assigned Customer Number. | 3 | BILL LAST NAME | YES | Alpha | 50 | Billing last name. | 4 | BILL FIRST NAME | YES | Alpha | 30 | Billing first name. | 5 | BILL COMPANY | NO | Alpha | 255 | Billing company. | 6 | BILL ADDRESS1 | YES | Alpha | 255 | Billing street address. | 7 | BILL ADDRESS2 | NO | Alpha | 255 | Billing street address continued. | 8 | BILL CITY | YES | Alpha | 50 | Billing city. | 9 | BILL STATE | YES | Alpha | 20 | Billing state or province abbreviation.
(Ex. ME for Maine) | 10 | BILL ZIPCODE | YES | Alpha | 20 | Billing zip code or postal code. Format for US: ##### or #####-#### Format for Canada: XXX XXX | 11 | RESERVED | | | 0 | This field will be blank. | 12 | BILL PHONE NUMBER | YES | Alpha | 30 | Billing phone number. Format: (###) ###-#### | 13 | ACH BANK NAME | | Alpha | 255 | This field will be blank. | 14 | NO SOLICITING | NO | Boolean | 1 | No soliciting (1) or soliciting OK (0). | 15 | RESERVED | | | 0 | This field will be blank. | 16 | PAYMENT TYPE | | Alpha | 4 | This field will be blank. | 17 | RESERVED | | | 0 | This field will be blank. | 18 | RESERVED | | | 0 | This field will be blank. | 19 | CC TYPE | | Alpha | 2 | This field will be blank. | 20 | CC NUMBER | | Alpha | 30 | This field will be blank. | 21 | EXP DATE | | Alpha | 50 | This field will be blank. | 22 | DNIS | YES | Alpha | 50 | The source code for this order. | 23 | KEY CODE | | Alpha | 25 | This field will be blank. | 24 | EMP NUMBER | YES | Alpha | 50 | The employee number the order belongs to in the OLX system. | 25 | RESERVED | | | 0 | This field will be blank. | 26 | RESERVED | | | 0 | This field will be blank. | 27 | SHIPPING METHOD | YES | Alpha | 10 | Shipping method for order. "REG" = Standard or "RSH" = Rush | 28 | ORDER ALREADY FULLFILLED | | Alpha | 1 | This field will be blank. | 29 | AMOUNT ALREADY PAID | NO | Numeric | 9 | This field will be filled in with the total amount charged for settled/paid or pre-authorized orders. | 30 | CONTINUED | NO | Alpha | 1 | Indicates with a “Y” if this record is a continuation of the prior record. This is used when more than 5 products are required for a given order, otherwise it will be "N". | 31 | 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 | 32 | ORDER NUMBER | YES | Alpha | 50 | This field contains the reference number assigned to this shipment in the OrderLogix System. Note: When confirming shipments, this value needs to be passed back to OrderLogix to reference this shipment. | 33 | PRODUCT01 | YES | Alpha | 255 | The 1st product code on the order. | 34 | QUANTITY01 | YES | Numeric | 8 | The quantity of the 1st product being ordered. This field is required by field PRODUCT01. Must be a whole number, no decimals. | 35 | PRODUCT02 | NO | Alpha | 255 | The 2nd product code on the order. | 36 | QUANTITY02 | NO | Numeric | 8 | The quantity of the 2nd product being ordered. This field is required by field PRODUCT02. Must be a whole number, no decimals. | 37 | PRODUCT03 | NO | Alpha | 255 | The 3rd product code on the order. | 38 | QUANTITY03 | NO | Numeric | 8 | The quantity of the 3rd product being ordered. This field is required by field PRODUCT03. Must be a whole number, no decimals. | 39 | PRODUCT04 | NO | Alpha | 255 | The 4th product code on the order. | 40 | QUANTITY04 | NO | Numeric | 8 | The quantity of the 4th product being ordered. This field is required by field PRODUCT04. Must be a whole number, no decimals. | 41 | PRODUCT05 | NO | Alpha | 255 | The 5th product code on the order. | 42 | QUANTITY05 | NO | Numeric | 8 | The quantity of the 5th product being ordered. This field is required by field PRODUCT05. Must be a whole number, no decimals. | 43 | SHIP TO LAST NAME | YES | Alpha | 50 | Shipping last name | 44 | SHIP TO FIRST NAME | YES | Alpha | 50 | Shipping first name | 45 | SHIP TO COMPANY | NO | Alpha | 255 | Shipping company | 46 | SHIP TO ADDRESS1 | YES | Alpha | 255 | Shipping street address | 47 | SHIP TO ADDRESS2 | NO | Alpha | 255 | Shipping street address continued | 48 | SHIP TO CITY | YES | Alpha | 50 | Shipping city | 49 | SHIP TO STATE | YES | Alpha | 50 | Shipping state or province | 50 | SHIP TO ZIP | YES | Alpha | 50 | Shipping zip code or postal code. Format for US: ##### or #####-#### Format for Canada: XXX XXX | 51 | ORDER HOLD DATE | | Date | 8 | This field will be blank. | 52 | PAYMENT METHOD | | Alpha | 2 | This field will be blank. | 53 | ACH ROUTING NUMBER | | Numeric | 50 | This field will be blank. | 54 | ACH ACCOUNT NUMBER | | Alpha | 50 | This field will be blank. | 55 | RESERVED | | | 0 | This field will be blank. | 56 | USE PRICES | YES | Alpha | 1 | This field will have a "Y" indicating that the prices are to follow for each of the products starting at field position 57.
IMPORTANT: USE_PRICES and USE_SHIPPING must be set to the same value. If one is Y then both must be Y. | 57 | PRICE01 | NO | Numeric | 9 | The price of the 1st product being ordered. This field is required by field PRODUCT01. NOTE: This is the price before any discount is applied. | 58 | DISCOUNT01 | NO | Numeric | 9 | The discount of the 1st product being ordered. This field is required by field PRODUCT01.
NOTE: Must be less than or equal to the product price or set to blank or zero if not applicable. | 59 | PRICE02 | NO | Numeric | 9 | The price of the 2nd product being ordered. This field is required by field PRODUCT02. NOTE: This is the price before any discount is applied. | 60 | DISCOUNT02 | NO | Numeric | 9 | The discount of the 2nd product being ordered. This field is required by field PRODUCT02.
NOTE: Must be less than or equal to the product price or set to blank or zero if not applicable. | 61 | PRICE03 | NO | Numeric | 9 | The price of the 3rd product being ordered. This field is required by field PRODUCT03. NOTE: This is the price before any discount is applied. | 62 | DISCOUNT03 | NO | Numeric | 9 | The discount of the 3rd product being ordered. This field is required by field PRODUCT03.
NOTE: Must be less than or equal to the product price or set to blank or zero if not applicable. | 63 | PRICE04 | NO | Numeric | 9 | The price of the 4th product being ordered. This field is required by field PRODUCT04. NOTE: This is the price before any discount is applied. | 64 | DISCOUNT04 | NO | Numeric | 9 | The discount of the 4th product being ordered. This field is required by field PRODUCT04.
NOTE: Must be less than or equal to the product price or set to blank or zero if not applicable. | 65 | PRICE05 | NO | Numeric | 9 | The price of the 5th product being ordered. This field is required by field PRODUCT05. NOTE: This is the price before any discount is applied. | 66 | DISCOUNT05 | NO | Numeric | 9 | The discount of the 5th product being ordered. This field is required by field PRODUCT05.
NOTE: Must be less than or equal to the product price or set to blank or zero if not applicable. | 67 | USE SHIPPING | YES | Alpha | 1 | This field will have a “Y” to indicate that the shipping charges for the order are to follow in field 68.
IMPORTANT: USE_PRICES and USE_SHIPPING must be set to the same value. If one is Y then both must be Y. | 68 | SHIPPING | NO | Numeric | 9 | The shipping charges to assign to the order if the USE_SHIPPING field is used. | 69 | EMAIL | NO | Alpha | 255 | Customer email address. | 70 | MERCHANT TRANSACTION ID | | Alpha | 50 | This field will be blank. | 71 | COUNTRY | YES | Alpha | 3 | Country code for the billing address on an order. Country codes "001" for US, "034" for Canada. | 72 | SCOUNTRY | YES | Alpha | 3 | Country code for the shipping address on an order. Country codes "001" for US, "034" for Canada. | 73 | BILL PHONE 2 | NO | Alpha | 20 | Billing PM phone number.
Format: (###) ###-#### | 74 | SHIP TO PHONE | YES | Alpha | 30 | The shipping phone number. Format: (###) ###-#### | 75 | RESERVED | | | 0 | This field will be blank. | 76 | RESERVED | | | 0 | This field will be blank. | 77 | RESERVED | | | 0 | This field will be blank. | 78 | RESERVED | | | 0 | This field will be blank. | 79 | CUSTOM 1 | NO | Alpha | 50 | Custom text field. | 80 | CUSTOM 2 | NO | Alpha | 50 | Custom text field. | 81 | CUSTOM 3 | NO | Alpha | 50 | Custom text field. | 82 | CUSTOM 4 | NO | Alpha | 50 | Custom text field. | 83 | CUSTOM 5 | NO | Alpha | 50 | Custom text field. | 84 | COUPON CODE01 | | Alpha | 255 | This field will be blank. | 85 | COUPON CODE02 | | Alpha | 255 | This field will be blank. | 86 | COUPON CODE03 | | Alpha | 255 | This field will be blank. | 87 | COUPON CODE04 | | Alpha | 255 | This field will be blank. | 88 | COUPON CODE05 | | Alpha | 255 | This field will be blank. | 89 | RESERVED | | | 0 | This field will be blank. | 90 | TRACKING NUM | | Alpha | 35 | This field will be blank. | 91 | SHIPPING CARRIER | | Alpha | 35 | This field will be blank. | 92 | SHIPPING DATE | | Date | 8 | This field will be blank. | 93 | CLIENT TRANSACTION ID | | Alpha | 35 | This field will be blank. | 94 | CVV CODE | | Alpha | 4 | This field will be blank. | 95 | VOICE RECORDING ID | NO | Alpha | 50 | Voice Log ID or number. | 96 | ACH CHECK NUMBER | | Numeric | 50 | This field will be blank. | 97 | ORDER STATE SALES TAX | NO | Numeric | 9 | State Tax (when applicable). This is a dollar value and not a percentage. | 98 | ORDER FEDERAL SALES TAX | NO | Numeric | 9 | Secondary tax amount to add to the order. This is a dollar value and not a percentage. | 99 | CUSTOMER COMMENTS | NO | Alpha | 4000 | Customer notes. | 100 | ACH IS SAVINGS ACCOUNT | | Numeric | 1 | This field will be blank. | 101 | CUSTOMER AGE | NO | Numeric | 4 | Conditionally passed | 102 | CUSTOMER DOB | NO | Date | 8 | Conditionally passed Format: MM/DD/YYYY | 103 | CUSTOMER GENDER | NO | Alpha | 50 | Conditionally passed Format: "male" or "female" | 104 | CUSTOMER SSN | NO | Alpha | 50 | Conditionally passed Format: ###-##-#### | 105 | PACKING SLIP COMMENTS | NO | Alpha | 4000 | Packing slip comments. | 106 | ORDER COMMENTS | NO | Alpha | 4000 | Order comments. | 107 | LOCATION CODE | | Alpha | 10 | This field will be blank. |
Example Below is an example of valid comma separated data, surrounded by double quotes (NOTE: surrounding fields in double quotes is not required, but highly recommend). The example shows a header row and two shipments. "RESERVED","CUSTOMER_NUMBER","BILL_LAST_NAME","BILL_FIRST_NAME","BILL_COMPANY","BILL_ADDRESS1","BILL_ADDRESS2","BILL_CITY","BILL_STATE","BILL_ZIPCODE","RESERVED","BILL_PHONE_NUMBER","ACH_BANK_NAME","NO_SOLICITING","RESERVED","PAYMENT_TYPE","RESERVED","RESERVED","CC_TYPE","CC_NUMBER","EXP_DATE","DNIS","KEY_CODE","EMP_NUMBER","RESERVED","RESERVED","SHIPPING_METHOD","ORDER_ALREADY_FULLFILLED","AMOUNT_ALREADY_PAID","CONTINUED","ORDER_DATE","ORDER_NUMBER","PRODUCT01","QUANTITY01","PRODUCT02","QUANTITY02","PRODUCT03","QUANTITY03","PRODUCT04","QUANTITY04","PRODUCT05","QUANTITY05","SHIP_TO_LAST_NAME","SHIP_TO_FIRST_NAME","SHIP_TO_COMPANY","SHIP_TO_ADDRESS1","SHIP_TO_ADDRESS2","SHIP_TO_CITY","SHIP_TO_STATE","SHIP_TO_ZIP","ORDER_HOLD_DATE","PAYMENT_METHOD","ACH_ROUTING_NUMBER","ACH_ACCOUNT_NUMBER","RESERVED","USE_PRICES","PRICE01","DISCOUNT01","PRICE02","DISCOUNT02","PRICE03","DISCOUNT03","PRICE04","DISCOUNT04","PRICE05","DISCOUNT05","USE_SHIPPING","SHIPPING","EMAIL","MERCHANT_TRANSACTION_ID","COUNTRY","SCOUNTRY","BILL_PHONE_2","SHIP_TO_PHONE","RESERVED","RESERVED","RESERVED","RESERVED","CUSTOM_1","CUSTOM_2","CUSTOM_3","CUSTOM_4","CUSTOM_5","COUPON_CODE01","COUPON_CODE02","COUPON_CODE03","COUPON_CODE04","COUPON_CODE05","RESERVED","TRACKING_NUM","SHIPPING_CARRIER","SHIPPING_DATE","CLIENT_TRANSACTION_ID","CVV_CODE","VOICE_RECORDING_ID","ACH_CHECK_NUMBER","ORDER_STATE_SALES_TAX","ORDER_FEDERAL_SALES_TAX","CUSTOMER_COMMENTS","ACH_IS_SAVINGS_ACCOUNT","CUSTOMER_AGE","CUSTOMER_DOB","CUSTOMER_GENDER","CUSTOMER_SSN","PACKING_SLIP_COMMENTS","ORDER_COMMENTS","LOCATION_CODE" "","101568","Doe","John","","123 Main St","Suite 1","Schenectady","NY","12345","","(518) 555-1234","","0","","","","","","","","TEST","","998","","","REG","","129.9","N","1/7/2003","622046","Blue","1","Red","1","","0","","0","","0","Smith","Jack","","123 Broadyway","Apt 1","Schenectady","NY","12345","","","","","","Y","119.95","0","0","0","89.95","0","199.95","0","29.95","0","Y","9.95","JohnDoe@email.com","","001","001","","","","","","","Custom","","","","","","","","","","","","","","","","572335","","0","0","","","","","","","","Comments","" "","101569","Doe","Jane","","124 Main St","Suite 2","Schenectady","NY","12346","","(518) 555-1235","","0","","","","","","","","TEST","","998","","","REG","","119.95","N","1/7/2003","522046","Red","1","Blue","1","","0","","0","","0","Smith","Jill","","124 Broadyway","Apt 2","Schenectady","NY","12346","","","","","","Y","59.9","0","149.95","0","89.95","0","199.95","0","29.95","0","Y","64.75","JaneDoe@email.com","","001","001","","","","","","","Custom","","","","","","","","","","","","","","","","572335","","0","0","","","","","","","","Comments","" |