#
| Field Name | Req. | Type | Max | Field Description |
1 | RESERVED | | | 0 | This field will be blank. |
2 | CUSTOMER NUMBER | YES | Alpha | 50 | Call center customer number. Please add your assigned call center code and a hyphen ("-") to beginning of all customer #s.
(Ex. CCCODE-123456789) |
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 | For ACH | Alpha | 255 | Automated Clearing House bank name.
(CK, PC pay methods only) |
14 | NO SOLICITING | NO | Boolean | 1 | No soliciting (1) or soliciting OK (0). |
15 | RESERVED | | | 0 | This field will be blank. |
16 | PAYMENT TYPE | See notes | Alpha | 4 | For paid credit card orders, this field must either be 'AUTH' for pre-authorizations or 'SALE' for settled transactions; for unpaid orders leave this blank. |
17 | RESERVED | | | 0 | This field will be blank. |
18 | RESERVED | | | 0 | This field will be blank. |
19 | CC TYPE | For CC | Alpha | 2 | Credit card type. (Must be valid credit card codes in OLX) Format: V = Visa, MC = MasterCard, D = Discover, A = American Express |
20 | CC NUMBER | For CC | Alpha | 30 | Credit card number |
21 | EXP DATE | For CC | Alpha | 50 | Credit card expiration date. Format: MM/YY |
22 | DNIS | YES | Alpha | 50 | The source for this order. Please enter the DNIS of the telephone # dialed by customer, or your assigned call center code. |
23 | KEY CODE | NO | Alpha | 25 | Key code or promo code. |
24 | EMP NUMBER | YES | Alpha | 50 | The employee number the order belongs to or the employee number setup in OLX. |
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 NOTE: Codes other than REG or RSH must be setup in OLX as a Ship Charge Profile. |
28 | ORDER ALREADY FULLFILLED | NO | Alpha | 1 | This field will be blank for unshipped orders, and filled in with either "X" or "Y" for orders which have already shipped.
NOTE: You must enter values in fields 90-92 (TRACKING_NUM, SHIPPING_CARRIER, SHIPPING_DATE) if you are passing "X" or "Y" in this field. |
29 | AMOUNT ALREADY PAID | NO | Numeric | 9 | This field will be blank for unpaid orders, and filled in with the total amount charged for settled/paid or pre-authorized orders.
IMPORTANT: If you pass 0.00, OLX will assume the order was paid for prior to importing and it will ship without payment processing. |
30 | CONTINUED | NO | Alpha | 1 | Indicate 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 data is being posted. For example, if the server is in PST (-8:00) and the order is coming from EST (-5:00), the time should be adjusted by subtracting 3 hours. There can also be an optional time stamp added to this field by placing a space between the year and the time formatted below. Date Format: MM/DD/YYYY Time Format: HH/MM/SS NOTE: This must be the current date or a date before the current date. |
32 | ORDER NUMBER | YES | Alpha | 50 | Call center order number. Please add your assigned call center code and a hyphen ("-") to beginning of all order #s. This will be stored in the Web Order #. (Ex. CCCODE-987654321) |
33 | PRODUCT01 | YES | Alpha | 255 | The 1st product code on the order. (Must be exact product offer match in OLX) |
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. (Must be exact product offer match in OLX) |
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. (Must be exact product offer match in OLX) |
38 | QUANTITY03 | NO | Numeric | 8 | The quantity of the 3rd product being ordered. This field is required by field PRODUCT02. Must be a whole number, no decimals. |
39 | PRODUCT04 | NO | Alpha | 255 | The 4th product code on the order. (Must be exact product offer match in OLX) |
40 | QUANTITY04 | NO | Numeric | 8 | The quantity of the 4th product being ordered. This field is required by field PRODUCT02. Must be a whole number, no decimals. |
41 | PRODUCT05 | NO | Alpha | 255 | The 5th product code on the order. (Must be exact product offer match in OLX) |
42 | QUANTITY05 | NO | Numeric | 8 | The quantity of the 5th product being ordered. This field is required by field PRODUCT02. 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 | NO | Date | 8 | For hold orders, enter the release date here. Order will not be go through payment processing until this date. This must be a date in the future if passed.
Format: MM/DD/YYYY |
52 | PAYMENT METHOD | YES | Alpha | 2 | Method of payment. Format: "CC" for credit card, "CK" for Telecheck/check by phone, "PC" for paper check, "IN" for invoice or "MO" for money order. |
53 | ACH ROUTING NUMBER | For ACH | Numeric | 50 | Routing # (CK, PC pay methods only) |
54 | ACH ACCOUNT NUMBER | For ACH | Alpha | 50 | Account # (CK, PC pay methods only) |
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. NOTE: USE_PRICES and USE_SHIPPING must be set to N for installment orders. |
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. NOTE: USE_PRICES and USE_SHIPPING must be set to N for installment orders. |
68 | SHIPPING | NO | Numeric | 9 | The shipping charges to assign to the order if the USE_SHIPPING field is used. Note that this amount will only be applied to the 1st line item in the order. |
69 | EMAIL | NO | Alpha | 255 | Customer email address. |
70 | MERCHANT TRANSACTION ID | NO | Alpha | 50 | For approved pre-authorized or settled orders, enter the Transaction ID received from the merchant processor; leave blank if order is unpaid. This value will be used for settlement of pre- authorized or crediting of settled orders when applicable. |
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 | NO | Alpha | 255 | The coupon code for PRODUCT01. |
85 | COUPON CODE02 | NO | Alpha | 255 | The coupon code for PRODUCT02. |
86 | COUPON CODE03 | NO | Alpha | 255 | The coupon code for PRODUCT03. |
87 | COUPON CODE04 | NO | Alpha | 255 | The coupon code for PRODUCT04. |
88 | COUPON CODE05 | NO | Alpha | 255 | The coupon code for PRODUCT05. |
89 | RESERVED | | | 0 | This field will be blank. |
90 | TRACKING NUM | NO | Alpha | 35 | If the order is fulfilled then provide the tracking number, otherwise, leave blank. |
91 | SHIPPING CARRIER | NO | Alpha | 35 | If the order is fulfilled then provide the shipping carrier, otherwise, leave blank. |
92 | SHIPPING DATE | NO | Date | 8 | If the order is fulfilled then provide the transaction date, otherwise, leave blank.
Format: MM/DD/YYYY |
93 | CLIENT TRANSACTION ID | NO | Alpha | 35 | If the order is fulfilled then provide the client transaction id from the fulfillment software, otherwise, leave blank. |
94 | CVV CODE | NO | Alpha | 4 | Credit Card CVV code. |
95 | VOICE RECORDING ID | NO | Alpha | 50 | Voice Log ID or number. |
96 | ACH CHECK NUMBER | For ACH | Numeric | 50 | Check number (CK, PC pay methods only) |
97 | ORDER STATE SALES TAX | NO | Numeric | 9 | State Tax (when applicable). OLX can be configured to allow tax to be split over the items or to put all the tax on the first item. 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 | NO | Numeric | 1 | For CK/ACH orders, pass a "1" if the account is a savings account. |
101 | CUSTOMER AGE | NO | Numeric | 4 | Conditionally required based on DNIS. |
102 | CUSTOMER DOB | NO | Date | 8 | Conditionally required based on DNIS. Format: MM/DD/YYYY |
103 | CUSTOMER GENDER | NO | Alpha | 50 | Conditionally required based on DNIS, Format: "male" or "female" |
104 | CUSTOMER SSN | NO | Alpha | 50 | Conditionally required based on DNIS, Format: ###-##-#### |
105 | PACKING SLIP COMMENTS | NO | Alpha | 4000 | Packing slip comments. |
106 | ORDER COMMENTS | NO | Alpha | 4000 | Order comments. |
107 | LOCATION CODE | NO | Alpha | 10 | Location code for order. |