OLX Shipping Export v5.0

OLX Shipping Export v5.0

Info
Module: Imports/Exports
Path: Processing > Imports/Exports > Exports
Topic: OLX Shipping Export v5.0
Version(s):  5.1 & up
Editions: Standard, Commerce, Call Center

What Is OLX Shipping Export v5.0

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.

Making The Connection

Where Will I See This Within OLX?

This export will pick up orders that are in Ship Ready.

What Reports Can Be Pulled?

  1. Shipment Batch Report Definitions

What Imports/Exports Relate to OLX Shipping Export v5.0

  1. Knowledgebase | Imports Knowledge Base

Trouble Shooting

  1. Excluded Item (product offer name) on order# from the shipment batch because it appears to have a prior shipment.

    1. review fulfillment centers logs to see if order is showing there
      1. not showing - open a ticket request a batch rollback
        1. make sure to include a signed Batch Rollback Authorization Form
        2. list of orders needing rolled back
      2. showing - orders will move forward when ship confirm is imported
        1. if you do not have a ship confirm import you can mark the orders Shipped from the order screen or open a ticket requesting a list of orders to be marked shipped via Item Status Request Authorization Form

Setup

Export Configuration

Navigate to Processing > Import/Export > Exports


  1. Client = 
  2. Spec = OLX Shipping Export v5
  3. Please select a date range.
    1. Manual Run
      1. user selected mm/dd/yyyy
    2. Scheduled Run
      1. No Start Date
      2. Rundate (-2 weeks)
      3. Rundate (-7 days)
      4. Rundate (-6 days)
      5. Rundate (-5 days)
      6. Rundate (-4 days)
      7. Rundate (-3 days)
      8. Rundate (-2 days)
      9. Rundate (-1 days)
      10. Rundate 
      11. Rundate (+1 days)
      12. Rundate (+2 days)
      13. Rundate (+3 days)
      14. Rundate (+4 days)
      15. Rundate (+5 days)
      16. Rundate (+6 days)
      17. Rundate (+7 days)
      18. Rundate (+2 weeks)
      19. No End Date
  4. Partial Order Options
    1. Require payment of all other items on the order
      1. checked - will not allow any ship ready items into batch if all items are not ship ready regardless of product group(s) selected.
        1. This will keep orders with an item on backorder from being eligible for the remaining line items not in backorder.
      2. unchecked - will allow split ship of items in ship ready regardless of item status of other items on the same order
    2. Require that ALL shippable items on the order are included in this export
      1. checked - all ship ready items on order in product group(s) selected will ship in same batch
        1. If there are multiple shippable items on the order in different product groups and all product groups are not selected, none of the items will export with this option checked.
      2. unchecked - will allow split ship of items in ship ready regardless of products groups selected below

Selections Tab


Notes
Single arrows move highlighted column(s) to the other side
Double arrows move ALL columns to the other side

To select an option to be generated on the export:
  1. Highlight the option from the Available list 
    1. click the right single arrow to move it to the Selected list
  2. To select multiple options, click on the first option desired and press and hold the CTRL button on your keyboard while selecting additional options
    1. click the right single arrow to move it to the Selected list
  3. To move all options from Available to Selected click the right double arrows
To move out of the Selected list, repeat the steps above and click the left facing arrow(s).

Delivery Tab

    1. None

      2. This will create a .csv file that can be downloaded from Processing > Process History
    2. FTP
        1.  if the delivery method is email of ftp and the file contains sensitive data, an encryption method must be selected, or the file will not be delivered.
      2. Server Address - This is the host name of the server where files will be collected from. An IP address can also be used.
        1.  clicking this icon will test the connection to the server address

      3. Server Port - This indicates the specific FTP/SFTP port to use. This is an advanced feature and should be left at (default) unless the FTP operator indicates that it should be something different.
      4. Folder - This indicates the relative folder on the remote server where the files should be gathered from. If this is unknown, the default of “/” should be used.
      5. User Name - This is the user name for the remote server.
      6. Password - This is the password for the remote server.
      7. Pattern - Use the pattern field to specify which files are to be collected. Use the * (asterisk) as a wildcard to indicate any character or group of characters in the file name. For example, if the file to be collected is named “Acme_01-31-2012.PGP”, you could specify the pattern “Acme*.PGP”. This will attempt to collect all files that begin with “Acme” and end with “.PGP”. You may only use one * in the pattern field. The pattern must end in either .PGP or .GPG if the data being transferred is of a sensitive nature (as indicated by the selected imports specification)
    3. SFTP (SSH)

      2. Server Address - This is the host name of the server where files will be collected from. An IP address can also be used.
        1.  clicking this icon will test the connection to the server address

      3. Server Port - This indicates the specific FTP/SFTP port to use. This is an advanced feature and should be left at (default) unless the FTP operator indicates that it should be something different.
      4. Folder - This indicates the relative folder on the remote server where the files should be gathered from. If this is unknown, the default of “/” should be used.
      5. User Name - This is the user name for the remote server.
      6. Password - This is the password for the remote server.
      7. Pattern - Use the pattern field to specify which files are to be collected. Use the * (asterisk) as a wildcard to indicate any character or group of characters in the file name. For example, if the file to be collected is named “Acme_01-31-2012.PGP”, you could specify the pattern “Acme*.PGP”. This will attempt to collect all files that begin with “Acme” and end with “.PGP”. You may only use one * in the pattern field. The pattern must end in either .PGP or .GPG if the data being transferred is of a sensitive nature (as indicated by the selected imports specification)
    4. FTPS (SSL)

      2. Server Address - This is the host name of the server where files will be collected from. An IP address can also be used.
        1.  clicking this icon will test the connection to the server address

      3. Server Port - This indicates the specific FTP/SFTP port to use. This is an advanced feature and should be left at (default) unless the FTP operator indicates that it should be something different.
      4. Folder - This indicates the relative folder on the remote server where the files should be gathered from. If this is unknown, the default of “/” should be used.
      5. User Name - This is the user name for the remote server.
      6. Password - This is the password for the remote server.
      7. Pattern - Use the pattern field to specify which files are to be collected. Use the * (asterisk) as a wildcard to indicate any character or group of characters in the file name. For example, if the file to be collected is named “Acme_01-31-2012.PGP”, you could specify the pattern “Acme*.PGP”. This will attempt to collect all files that begin with “Acme” and end with “.PGP”. You may only use one * in the pattern field. The pattern must end in either .PGP or .GPG if the data being transferred is of a sensitive nature (as indicated by the selected imports specification)
    5. Email
      2.  if the delivery method is email of ftp and the file contains sensitive data, an encryption method must be selected, or the file will not be delivered.
      3. From Address
        1. The email used here should be setup in your system already
      4. Email Address
      5.  allows you to test connection from the system to the email address provided
      6. CC
      7. Subject
      8. Message
      9. Alias
        1. There may or may not be alias available to be inserted into the email template. Each report will be different.

Encryption Tab

  1. None
    1. no encryption method will be used


  2. Zip 
    1. File Name to set on outgoing file
    2. the password entered here is the password needed to zip the file 

  3. PGP
    1. File Name to set on outgoing file
    2. PGP Key Option - select the PGP from the drop down


Results Tab


The Results tab will display a summary of information exported or information about any potential error(s) to help you resolve and try again.

Spec

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


Export Definitions

  1. #
    1. position the field is required to be listed in when importing the file
  2. Field Names 
    1. A list of passable import fields, which can be transposed (viewed horizontally, instead of vertically) into the columns of a header row.
  3. Required 
    1. Defines if information must be provided for the field or not.  
  4. Type 
    1. Defines the character type (what keyboard characters are allowed in the field): 
      1. Alpha – letters, numbers and simple symbols (ex. @, -, / or &) 
      2. Numeric – numbers only 
      3. Date – format shown in Field Description (ex. MM/DD/YYYY) 
      4. Boolean – 1 for True or 0 for False
  5. Max
    1. The maximum amount of the Type characters that can be passed for the field. 
  6. Field Description
    1. Notes, examples and formatting
Position
Field Name
Req.
Type
Max
Description
01
RECORD TYPE
YES
Alpha
1
Record Type.  For Shipment Header Records, the type should be "O"
02
BATCH ID
YES
Numeric

OrderLogix Assigned Shipment Batch ID. 
03
BATCH DATE
YES
Alpha

Create stamp of Shipment Batch
04
SHIPMENT ID
YES
Numeric

OrderLogix Assigned Shipment ID. 

*** Note: This number needs to be passed back to OrderLogix in the Shipment Confirmation file.
05
ORDER ID
YES
Numeric

OrderLogix Assigned Order ID. 
06
ORDER DATE
YES
Alpha
8
The date is for the local time of the server to which the order came from.  Format: MM/DD/YYYY
07
ORDER NUMBER
YES
Alpha
255
This field contains the reference number assigned to this order at the time the order was placed.
08
CUSTOMER ID
YES
Numeric

OrderLogix Assigned Customer ID. 
09
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
01
RECORD TYPE
YES
Alpha
1
Record Type.  For Shipping Line Records, the type should be "L"
02
BATCH ID
YES
Numeric

OrderLogix Assigned Shipment Batch ID. 
03
BATCH DATE
YES
Date

Create stamp of Shipment Batch
04
SHIPMENT ID
YES
Numeric

OrderLogix Assigned Shipment ID.
05
ORDER ID
YES
Numeric

OrderLogix Assigned Order ID.
06
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
07
ORDER NUMBER
YES
Alpha
255
This field contains the reference number assigned to this order at the time the order was placed.
08
ITEM ID
YES
Numeric

OrderLogix Assigned Item ID.
09
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
01
RECORD TYPE
YES
Alpha
1
Record Type.  For Shipping Line Inventory Records, the type should be "I"
02
BATCH ID
YES
Numeric

OrderLogix Assigned Shipment Batch ID.
03
BATCH DATE
YES
Date

Create stamp of Shipment Batch
04
SHIPMENT ID
YES
Numeric

OrderLogix Assigned Shipment ID. 
05
ORDER ID
YES
Numeric

OrderLogix Assigned Order ID. 
06
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
07
ORDER NUMBER
YES
Alpha
255
This field contains the reference number assigned to this order at the time the order was placed.
08
ITEM ID
YES
Numeric

OrderLogix Assigned Item ID. 
09
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


Attachments

The attached documentation includes the Spec, Template, and Example.

Copyright 2019
Revised 2.03.2025

    • Related Articles

    • OLX Shipping Export V3.5

      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 ...

    • OLX Order Import/Export Spec

      Module: Order Import Path: Processing > Import/Export > Import Topic: OLX Order Import/Export Version(s): 3.5 & up Editions: All What Is OLX Order Import/Export The OLX Order Import/Export is compatible with OrderLogix versions 3.5 & up. It is the ...

    • OLX Order Import/Export V4 Spec

      Module: Order Import Path: Processing > Import/Export > Import Topic: OLX Order Import/Export V4 Version(s): 4.0 & up Editions: All What Is OLX Order Import/Export V4 The OLX Order Import/Export V4 is compatible with OrderLogix version 4.0 & up. It ...

    • OLX Telemarketing Import Spec

      Module: Order Import Path: Processing > Import/Export > Import Topic: OLX Telemarketing Import Version(s): 3.5 & up Editions: All What Is OLX Telemarketing Import The OLX Telemarketing Import Spec is a 121-column order import used to bring outside ...

    • OLX Telemarketing Import Spec

      The OLX Telemarketing Import Spec is a 121 column order import used to bring outside calls and orders into the OrderLogix application. This is accomplished by creating a CSV (a file with information fields, each separated by a single comma) with all ...