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. Data lake export service
  2. Data entities reference
  3. Order items

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.

Attribute

Description

Type

Example

meta_ref

A unique ID of the order item generated by Sitecore CDP.

string

"FECBB7ED-6DFE-4E8C-85A9-B894B17EF4F3"

core_currency_code

Your organization’s currency code for the order item price.

3 letter ISO 4217

"EUR", "NZD", "USD"

core_item_id

An ID generated by Sitecore CDP to reference the order item.

string

["FLIGHT_1", "FLIGHT_2", "BAG_1", "SEAT_1", "HOTEL_1"]

core_name

The name of the order item. A free text value defined by your organization.

string

"PARKING"

core_ordered_at

The date and time the order item was made.

ISO 8601 Date/Time UTC

"2020-01-01T16:17:16.000Z"

core_price

Your organization’s price for the order item.

integer

50, 30.6, -45

core_product_id

The ID of the product code.

string

"DUB-LAS"

core_quantity

The number or quantity of the order item.

integer

3

core_reference_id

An ID generated by your organization to reference the order item.

string

"B94TXY-1"

core_status

The status of the order item.

string

"PURCHASED", "PAYMENT_PENDING", "CONFIRMED", "REFUNDED", "CANCELLED", "UNKNOWN"

ext

A collection of name/value pairs that store your organization's order item data extensions.

map

{colour=blue, size=M}

meta_client_key

The unique client reference that identifies your organization.

string

"mhbWwbHYfhpheu86hp60oR76S4jQMmZr"

meta_created_at

Date and time when the order item record was created in Sitecore CDP.

ISO 8601 Date/Time UTC

"2020-01-01T16:17:16.000Z"

meta_order_ref

The unique order reference, associated with the order item.

string

"056621C2-C955-492D-B7EE-C77C6BDDFDEE"

type

The type of order item.

string

"MORTGAGE", "FLIGHT"

raw_json

The overall order item representation as raw JSON.

string

N/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