Skip to main content
It stores the customers’ order information.
Field NameData TypeDescriptionNested Fields
_idobjectIdUnique identifier for the document0
order_idstringUnique identifier for the order.0
order_numberstringHuman-readable order number0
customer_idstringUnique identifier for the customer.0
business_entity_idstringUnique identifier for the business entity.0
sales_channelobjectObject containing sales channel details4
sales_channel.channel_idstringUnique identifier of channel0
sales_channel.namestringContains channel name0
sales_channel.typestringDescribes the method used to sell a product/service to customers0
sales_channel.statusstringStatus of channel channel0
statusstringCurrent status of the order.0
currencystringField for currency0
totalsobjectSum of data5
totals.subtotalfloatSum of line items prices in an order0
totals. shippingfloatSum of shipping an order0
totals.taxfloatSum of taxes applied to a transaction0
totals.discountsfloatAmount reduced from the subtotal0
totals.grand_totalfloatFinal price of an order0
order_itemsarray_of_objectsField for order items.10
order_items.variant_idstringUnique identifier for variant0
order_items.product_idstringUnique identifier for product0
order_items.skustringField for sku0
order_items.name_at_salestringName of specific order item.0
order_items.quantityintegerQuantity of order items.0
order_items.price_per_unitintegerPrice information for price per unit0
order_items.line_item_totalintegerField for line item total0
order_items.variationsobjectObject containing variations details1
order_items.variations.colorstringField for color0
order_items.physical_attributesobjectObject containing physical attributes details6
order_items.physical_attributes.weightintegerField for weight0
order_items.physical_attributes.weight_unitstringField for weight unit0
order_items.physical_attributes.lengthintegerField for length0
order_items.physical_attributes.widthintegerUnique identifier for width0
order_items.physical_attributes.heightintegerField for height0
order_items.physical_attributes.dimension_unitstringField for dimension unit0
order_items.fulfillment_typestringField for fulfillment type0
paymentsarray_of_objectsField for payments6
payments.payment_idstringUnique identifier for payment0
payments.payment_method_idstringUnique identifier for payment method0
payments.amountintegerField for amount0
payments.statusstringField for Status of Payment0
payments.transaction_idstringUnique identifier for transaction0
payments.payment_datedateTimestamp for when payment date was created/updated0
shipmentsarray_of_objectsField for shipments.11
shipments.shipment_idstringUnique identifier for shipment0
shipments.statusstringCurrent status of shipments0
shipments.carrierstringField for carrier0
shipments.tracking_numberstringField for tracking number0
shipments.shipped_datedatetimeTimestamp for when shipped date was created/updated0
shipments.estimated_delivery_datedatetimeTimestamp for when shipped when shipped date was created/updated0
shipments.itemsarray_of_objectField for items3
shipments.items.variant_idstringUnique identifier for variant0
shipments.items.quantityintegerQuantity of Shipments0
shipments.items.item_namestringName of item0
shipments.shipping_addressobjectAddress information for shipping6
shipments.shipping_address.receiver_namestringName of receiver0
shipments.shipping_address.streetstringField for street0
shipments.shipping_address.citystringField for city0
shipments.shipping_address.statestringField for state0
shipments.shipping_address.zip_codestringField for Zip code0
shipments.shipping_address.countrystringField for country0
shipments.carrier_idstringUnique identifier for carrier0
shipments.fulfillment_locationobjectObject containing fulfillment location details2
shipments.fulfillment_location.idstringUnique identifier for id0
shipments.fulfillment_location.namestringName of name0
shipments.shipping_costintegerField for shipping cost0
applied_promotionsarray_of_objectsField for applied promotions.3
applied_promotions.promotion_idstringUnique identifier for promotion0
applied_promotions.codestringField for code0
applied_promotions.discount_amountobjectObject containing discount amount details2
applied_promotions.discount_amount.amountintegerField for amount0
applied_promotions.discount_amount.currencystringField for currency0
external_referencesarray_of_objectsField for external references.2
external_references.source_systemstringField for source system0
external_references.identifierstringUnique identifier for external referencesidentifier0
notesstringField for notes.0
created_atdatetimeTimestamp when the record was created.0
updated_atdatetimeTimestamp when the record was updated0
order_created_datedatetimeTimestamp when the order was created.0
last_updateddatetimeTimestamp when the record was updated0
lifecycle_eventsarray_of_objectsField for lifecycle events.4
lifecycle_events.event_idstringUnique identifier for event0
lifecycle_events.statusstringStatus of lifecycle event0
lifecycle_events.timestampdatetimeField for timestamp0
lifecycle_events.notesstringField for notes0
order_cancelled_datedatetimeTimestamp for when the order was cancelled0
order_shipped_datedatetimeTimestamp for when the order was shipped.0
 
{
    "_id": {
        "$oid": "685022ef83fa0050b8d06b6d"
    },
    "order_id": "b094c65a-8ab5-4acd-9c31-44d22aaa6d77",
    "order_number": "ORD-2AAA6D77",
    "customer_id": "f75decb1-d722-4a09-b105-5784765a31c5",
    "business_entity_id": "7e820970-ce75-4ddd-94a7-f2ddaf9e5ad4",
    "sales_channel": {
        "channel_id": "b8a3e7e4-3e4d-4f1a-9c6f-8e4d3e4d3e4d",
        "name": "ecommerce_website_us",
        "type": "DTC",
        "status": "active"
    },
    "status": "CANCELLED",
    "currency": "USD",
    "totals": {
        "subtotal": 207.0,
        "shipping": 10.5,
        "tax": 16.56,
        "discounts": 19.68,
        "grand_total": 214.38
    },
    "order_items": [
        {
            "variant_id": "7e957009-a9eb-49d8-b202-c7a463e1a42b",
            "product_id": "5093d15b-760e-4ec0-9a60-5e9298b58995",
            "sku": "GFRM-RQ",
            "name_at_sale": "Glowing Facial Roller Massager - Rose Quartz",
            "quantity": 3,
            "price_per_unit": 69.0,
            "line_item_total": 207.0,
            "variations": {
                "color": "Rose Quartz"
            },
            "physical_attributes": {
                "weight": 120,
                "weight_unit": "g",
                "length": 15,
                "width": 5,
                "height": 2,
                "dimension_unit": "cm"
            },
            "fulfillment_type": "standard"
        }
    ],
    "payments": [
        {
            "payment_id": "d987dc9e-e260-4579-abe3-73e2b37f9f0d",
            "payment_method_id": "31e50a5d-2502-4c45-8585-a29a2b976730",
            "amount": 194.7,
            "status": "succeeded",
            "transaction_id": "txn_c89d530a-3f27-49",
            "payment_date": {
                "$date": "2025-06-30T14:00:13Z"
            }
        }
    ],
    "shipments": [
        {
            "shipment_id": "ae8944cf-471f-4d0b-9f97-ebd9999a9dfb",
            "status": "shipped",
            "carrier": "DHL Express",
            "tracking_number": "TRK236905C8-A99",
            "shipped_date": {
                "$date": "2025-06-30T14:00:13Z"
            },
            "estimated_delivery_date": {
                "$date": "2025-07-05T14:00:13Z"
            },
            "items": [
                {
                    "variant_id": "7e957009-a9eb-49d8-b202-c7a463e1a42b",
                    "quantity": 3,
                    "item_name": "None - Glowing Facial Roller Massager - Rose Quartz"
                }
            ],
            "shipping_address": {
                "receiver_name": "John Doe",
                "street": "123 Main St",
                "city": "New York",
                "state": "NY",
                "zip_code": "10001",
                "country": "US"
            },
            "carrier_id": "8de0766d-672e-4c84-9138-605d81888525",
            "fulfillment_location": {
                "id": "53aefc8d-4665-496a-b289-965a2db67efa",
                "name": "Central Warehouse - New York"
            },
            "shipping_cost": 10.5
        }
    ],
    "applied_promotions": [
        {
            "promotion_id": "8bb1181c-3224-4831-94a0-d70fa35a9639",
            "code": "",
            "discount_amount": {
                "amount": 19.68,
                "currency": "USD"
            }
        }
    ],
    "external_references": [
        {
            "source_system": "OMS_Salesforce",
            "identifier": "ORD-SF-CC8B69CA"
        }
    ],
    "notes": "",
    "created_at": {
        "$date": "2025-03-28T00:00:00Z"
    },
    "updated_at": {
        "$date": "2025-06-30T21:15:50Z"
    },
    "order_created_date": {
        "$date": "2025-03-28T12:34:52.276Z"
    },
    "last_updated": {
        "$date": "2025-08-13T20:46:41.943Z"
    },
    "lifecycle_events": [
        {
            "event_id": "d2659d94-6644-4ba6-842b-aaff8a2b665b",
            "status": "placed",
            "timestamp": {
                "$date": "2025-03-28T00:00:00Z"
            },
            "notes": "Order created"
        },
        {
            "event_id": "32a1b828-3f04-4304-83dd-dc274b0b0930",
            "status": "processing",
            "timestamp": {
                "$date": "2025-03-28T01:00:00Z"
            },
            "notes": "Order confirmed and inventory allocated"
        },
        {
            "event_id": "d7f1b6da-9aa7-499f-becb-34a07baa0524",
            "status": "shipped",
            "timestamp": {
                "$date": "2025-03-28T07:00:00Z"
            },
            "notes": "Order shipped via standard shipping"
        },
        {
            "event_id": "496b32f9-5dfc-4ec7-a8f4-5d1db9115b3f",
            "status": "cancelled",
            "timestamp": {
                "$date": "2025-03-28T08:00:00Z"
            },
            "notes": "Order cancelled by customer"
        }
    ],
    "order_cancelled_date": {
        "$date": "2025-03-28T08:00:00Z"
    },
    "order_shipped_date": {
        "$date": "2025-03-28T21:00:00Z"
    }
}