Customize the Transaction File Format

Customize the field order, separator character, and encapsulation character used in your transaction files.
The Upload Transaction File feature enables you to customize the format and field order of transaction files, matching the format used by your business to collect or manage transaction information and eliminating the need for data conversion.
Use the Upload Transaction File Format settings in the
Merchant Interface
to designate which fields the payment gateway requires, the order of those fields, the character that separates the fields, and the encapsulation character that encloses data within a field. These settings also specify which security filters the gateway applies to the file and whether customers get an email receipt of the transaction.
To customize your transaction file:
  1. Log in to the
    Merchant Interface
    at https://login.authorize.net.
  2. Choose
    Payments
    Upload Transactions
    .
  3. Click
    Click or tap
    Tap
    View/Edit Upload Settings
    .

    ADDITIONAL INFORMATION

    The Upload Transaction File Settings page appears and includes these settings:
    Email Customer
    Specifies whether customers in the transaction file receive an email receipt for their transaction. If Email Customer is set to
    Yes
    , the gateway sends an email receipt to each customer in the transaction file when a valid email address is included in the uploaded file.
    Apply AVS Filter
    Specifies whether to apply the AVS filter to transaction files. The AVS filter compares the billing address information provided by the customer to the billing address on file at the customer's card issuing bank.
    Apply Card Code Filter
    Specifies whether to apply Card Code Verification to transaction files. The Card Code filter compares the Card Code provided by the customer to the Card Code on file at the customer's credit card issuing bank. If you apply Card Code Verification to your transaction files, include the Card Code field in your Upload Transaction File settings. The card code is not included in the default file format.
    Default Field Separator
    Specifies the character that separates the fields in the transaction file. The separator character marks the end of one field and the beginning of the next. If the character you want to use is not in the Default Field Separator drop-down list, choose
    Other
    and enter the desired separator character in the box to the right of the drop-down list.
    Field Encapsulation Character
    Specifies the character that encloses data within a single field. Defaults to double-quotes (
    "
    ). Typically, transaction files do not need encapsulation characters. However, transactions that use a separator character that also appears in the content of a field, such as a comma (
    ,
    ) in an address, need encapsulation characters around the field content to distinguish the comma as data and not part of the file formatting. If the character you want to use is not in the Field Encapsulation Character drop-down list, choose
    Other
    and enter the desired character in the box to the right of the drop-down list.
    Field Inclusion and Order Settings
    Specifies which fields are included in the transaction file, and the order in which they appear. Choose the field name for each position from the corresponding drop-down boxes. Choose
    Exclude
    for each of the fields that you do not want to include in the transaction file.
    IMPORTANT
    List all included fields in sequence starting at Position 1. Choose
    Exclude
    for all unused field positions. Specify excluded fields only after all included fields are listed.
  4. Click
    Click or tap
    Tap
    Save
    to save your settings.