FTP Warehouse Setup: Field Formatting

The warehouse configuration screen offers flexibility when it comes to how the data is formatted in the purchase order.

By default, each column should contain the field name for what information you’d like in that column. However, you can also choose adjust the order header, control which column the data appears in, add a character limit, and more!

You can also click here for a list of avialable field names.

Let’s look at an example:

  • column 1 is the purchase order number
  • column 2 is the first name on the shipping label
  • both items have the field name list in the appropriate field

default order field

Column Headers

If an order field needs to have a specific column header, you can add the header to the front of the value and surround with parenthesis.

Let’s look at an example:

  • column 1 is the purchase order number with a column header of ‘OrderNumber’
  • column 2 is the first name on the shipping label with a column header of ‘ShipToName’
  • both items have the field name list in the appropriate field

column header

If you need to set a column header, but do not want any data in the actual field, place header text in parenthesis and “” for the field text. In the example below, the third column will have a header of ‘Currency’ but no value in the order.

header with no value


Static Values

Some fields may need to have the same value in the column, no matter what. To do this, you will enter the value you want to show up and surround it by double quotes. For example, the Account ID will show the same value in every order going to this warehouse

static value

Specifying the Exact Column Order

By default, HubLogix will list the columns in the order they appear in the warehouse screen (Order field 1 = column 1, and order field 2 = column 2, etc). However, some warehouses require information to go in specific locations. The Warehouse Config screen only allows for 40 fields to be present, so what if you need to put information in the 52nd column?

To specify the column, you’ll add something that looks like this [pos:#]. The number entered will specify the position of the column.

Let’s use the following example:

  • Sku will go in column 16 with a column header of ‘Product ID’
  • The Shipping method will go in column 26 with no column header

field position

Character Limits

When a field has a limitation of how many characters can be accepted by the warehouse, you can set the limit by adding the character limit parameter in the field. This parameter looks like [char_limit:<17>]. When an order comes through that violates this limit, the order will error and the field will need to be adjusted before the order can successfully send.

Character Limits

However, there are times when a customer wants to trim down the field automatically (think company name). In this case, we use this in the order field

substr([field],0,[character cut off]).

ie. (BillingCompany)substr(billing_company,0,50)< shows the column header is ‘Billing Company,’ we will use the database field ‘billing_company,’ and we will only send the first 50 characters of this field.

Removing Special Characters

If you have a warehouse that will not accept special characters, you can make this adjustment in the Warehouse Configuration screen. Unlike many settings on this page, this is not adjustable at the individual field level, but instead will apply to all information on the purchase order. When set to yes, the warehouse will do the following:

  • convert ampersand (&) to ‘and’
  • downgrade any accented characters to the corresponding letter
  • anything that is not alpha-numeric will be completely removed

special characters