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!

Documentation Assistant

This assistant uses AI to generate responses based on Sitecore documentation. While it has access to official sources, answers may be incomplete or inaccurate and should not be considered official advice or support.
Powered by
k
kapa.ai
Protected by reCAPTCHA

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

Privacy policySitecore Trust CenterTerms of use