This document outlines the changes to exporting orders in support of the PayPal Checkout integration. There are two types of export:

• File exports - clicking the Export button within the Order Manager
• Real time POST export - one automatically for merchants with real-time order feature enabled, or by manually resending orders with a post to link

File Exports

• CSV,MS Excel, MS Access (all same CSV format)
• MOM (Mail Order Manager)
• QuickBooks (old)
• QuickBooks (new)
• IC Verify
• PC Charge
• XML
• Plain Text

CSV - The CSV format is changed as follows. Appending to the right end of each record in the Orders.csv file:

• CVV Code - contains the CVV response code for the transaction, not the actual CVV #
• PayPal Auth - contains the original PayPal authorization # for this order
• PayPal TxID - PayPal transaction ID for this order
• PayPal Merchant Email - displays the Merchant's PayPal email address for this order
• PayPal Payer Status - displays the PayPal buyer's status (verified/not verified)
• PayPal Address Status - displays the PayPal buyer's address verification status (confirmed/not confirmed)

These field header s will ALWAYS be present. If there is no data there, the field will not display. This is necessary behavior because from time to time new fields are added to these CSV files, and are always placed at the end of each record. This means the CVV Code field (formerly a conditional field for merchants with Risk Tools enabled) will always appear due to the need to add the PayPal related data to the end of the file.

MOM (Mail Order Manager) - The MOM format is changed as follows. Field 26 "REFERENCE" will contain the original PayPal Auth ID for an order if it is present. This is in line with the current use of this field and with the MOM file specification with regards to credit cards. No additional PayPal data exported to other fields

QuickBooks (old and new) - No changes related to PayPal checkout integration.

IC Verify/PC Charge - No change is necessary. These file exports are specifically for external credit card processing software, not for general order processing.

Plain Text - Changes already made to order display in Order Manager are in effect here since plain text reflects the display of the order as it would appear when viewing in the Order Manager.

XML - Refer to the updated OrderList.dtd for changes.

Note: Turbify has updated the location of the OrderList2.dtd file associated with the XML order format. If you are using any third-party applications that reference this file, please update any references to use the new location: http://store.luminate.com/doc/dtd/OrderList2.dtd

Real Time Order Posting

• Turbify format
• XML
• ECML
• OBI

Turbify Format - Added the following key-value pairs if there is a PayPal Authorization ID attached to the original order data:

• PayPal-Auth - Contains the original PayPal Authorization # for this order
• PayPal-TxID - Contains the PayPal Transaction ID for this order
• PayPal-Merchant-Email - represents the Merchant's PayPal email address for this order
• PayPal-Payer-Status - displays the PayPal buyer's status (verified/not verified)
• PayPal-Address-Status - Displays the PayPal buyer's address verification status (confirmed/not confirmed)

XML - Refer to the updated OrderList.dtd for changes.

ECML/OBI - No changes related to PayPal checkout integration.