Announcement: You can find the guides for Commerce 7.5 and later on the new Elastic Path Documentation site. The Developer Center continues to support Commerce 6.13.0 through 7.4.1.Visit new site

Elastic Path Commerce data points

Elastic Path Commerce data points

Elastic Path Commerce provides the following data points:

Name Data location Data key
Customer Billing Address Street1 CUSTOMER_BILLING_ADDRESS STREET_1
Customer Billing Address First Name CUSTOMER_BILLING_ADDRESS FIRST_NAME
Customer Billing Address Last Name CUSTOMER_BILLING_ADDRESS LAST_NAME
Customer Billing Address Phone Number CUSTOMER_BILLING_ADDRESS PHONE_NUMBER
Customer Billing Address Street2 CUSTOMER_BILLING_ADDRESS STREET_2
Customer Shipping Address Street1 CUSTOMER_SHIPPING_ADDRESS PHONE_NUMBER
Customer Shipping Address Street1 CUSTOMER_SHIPPING_ADDRESS FIRST_NAME
Customer Shipping Address Last Name CUSTOMER_SHIPPING_ADDRESS LAST_NAME
Customer Shipping Address Street 1 CUSTOMER_SHIPPING_ADDRESS STREET_1
Customer Shipping Address Street 2 CUSTOMER_SHIPPING_ADDRESS STREET_2
Order Billing Address Last Name ORDER_BILLING_ADDRESS LAST_NAME
Order Billing Address First Name ORDER_BILLING_ADDRESS FIRST_NAME
Order Billing Address Phone Number ORDER_BILLING_ADDRESS PHONE_NUMBER
Order Billing Address Street 1 ORDER_BILLING_ADDRESS STREET_1
Order Billing Address Street 2 ORDER_BILLING_ADDRESS STREET_2
Order IP Address ORDER_IP_ADDRESS ORDER_IP_ADDRESS
Order Payment Card Holder Name ORDER_PAYMENT_CARD_HOLDER_NAME ORDER_PAYMENT_CARD_HOLDER_NAME
Order Gift Certificate ORDER_GIFT_CERTIFICATE See ORDER_GIFT_CERTIFICATE Data Keys.
Cart Gift Certificate CART_GIFT_CERTIFICATE See CART_GIFT_CERTIFICATE Data Keys.
Customer Profile CUSTOMER_PROFILE See CUSTOMER_PROFILE Data Keys.
Order Data ORDER_DATA See ORDER_DATA Data Keys.
Order Payment Gift Certificate Recipient Name ORDER_PAYMENT_GIFT_CERTIFICATE RECIPIENT_NAME
Order Payment Gift Certificate Sender Name ORDER_PAYMENT_GIFT_CERTIFICATE SENDER_NAME
Order Payment Gift Certificate Recipient Email ORDER_PAYMENT_GIFT_CERTIFICATE RECIPIENT_EMAIL

CUSTOMER_PROFILE Data Keys

CUSTOMER_PROFILE data keys are found in the TCUSTOMER database table, prefixed with CP_:

  • CP_FIRST_NAME
  • CP_LAST_NAME
  • CP_EMAIL
  • CP_PREF_LOCALE
  • CP_PREF_CURR
  • CP_ANONYMOUS_CUST
  • CP_PHONE
  • CP_FAX
  • CP_GENDER
  • CP_COMPANY
  • CP_DOB
  • CP_HTML_EMAIL
  • CP_BE_NOTIFIED
  • CP_BUSINESS_NUMBER
  • CP_TAX_EXEMPTION_ID

Additionally, any custom customer profile attribute added in the Elastic Path Admin Console can be used as a data key.

All data points values can be removed, but removing the following data key values can result in HTTP errors presented to the end user. If you need to remove the following data key values, ensure that any errors are properly handled:

  • CP_FIRST_NAME
  • CP_LAST_NAME
  • CP_EMAIL

CART_GIFT_CERTIFICATE Data Keys

CART_GIFT_CERTIFICATE data keys are found in the TCARTITEMMODIFIER database table, prefixed with KEY_:

  • KEY_RECIPIENT_EMAIL
  • KEY_RECIPIENT_NAME
  • KEY_SENDER_NAME
  • KEY_CODE
  • KEY_SENDER_EMAIL
  • KEY_PRODUCT_TYPE
  • KEY_GUID

ORDER_GIFT_CERTIFICATE Data Keys

ORDER_GIFT_CERTIFICATE data keys are found in the TCARTITEMMODIFIER database table. Any value in this table can be used as a data key.

ORDER_DATA Data Keys

ORDER_DATA is provided as a data location for additional data required by your business that needs to be associated with the order.

To provide a data key value to the ORDER_DATA data location, call the com.elasticpath.domain.order.Order interface's Order.setFieldValue() method. The values provided to this method are stored in the TORDERDATA table. Any value in the ITEM_KEY column can be used as a data key.