Skip to main content
Sitecore Documentation
  • Learn
  • Downloads
  • Changelog
  • Roadmap
CDPCloud Portal
Sitecore CDP Developer Documentation
  • Developing with Sitecore CDP
    • Access your data
    • Writing SQL queries
        • Guests
        • Orders
        • Order items
        • Experience definitions
        • Events
        • Sessions
  1. Data entities reference
  1. Sitecore CDP Developer Documentation
  2. Data lake export service

Order items

The following table includes only a portion of attributes that are available in the order items entity.

Your organization will have additional attributes.

AttributeDescriptionTypeExample
meta_refA unique ID of the order item generated by Sitecore CDP.string"FECBB7ED-6DFE-4E8C-85A9-B894B17EF4F3"
core_currency_codeYour organization’s currency code for the order item price.3 letter ISO 4217"EUR", "NZD", "USD"
core_item_idAn ID generated by Sitecore CDP to reference the order item.string["FLIGHT_1", "FLIGHT_2", "BAG_1", "SEAT_1", "HOTEL_1"]
core_nameThe name of the order item. A free text value defined by your organization.string"PARKING"
core_ordered_atThe date and time the order item was made.ISO 8601 Date/Time UTC"2020-01-01T16:17
.000Z"
core_priceYour organization’s price for the order item.integer50, 30.6, -45
core_product_idThe ID of the product code.string"DUB-LAS"
core_quantityThe number or quantity of the order item.integer3
core_reference_idAn ID generated by your organization to reference the order item.string"B94TXY-1"
core_statusThe status of the order item.string"PURCHASED", "PAYMENT_PENDING", "CONFIRMED", "REFUNDED", "CANCELLED", "UNKNOWN"
extA collection of name/value pairs that store your organization's order item data extensions.map{colour=blue, size=M}
meta_client_keyThe unique client reference that identifies your organization.string"mhbWwbHYfhpheu86hp60oR76S4jQMmZr"
meta_created_atDate and time when the order item record was created in Sitecore CDP.ISO 8601 Date/Time UTC"2020-01-01T16:17
.000Z"
meta_order_refThe unique order reference, associated with the order item.string"056621C2-C955-492D-B7EE-C77C6BDDFDEE"
typeThe type of order item.string"MORTGAGE", "FLIGHT"
raw_jsonThe overall order item representation as raw JSON.stringN/A
If you have suggestions for improving this article, let us know!

© Copyright , Sitecore A/S or a Sitecore affiliated company.
All rights reserved.

Privacy policySitecore Trust CenterTerms of use
CDPCloud Portal