List Orders

Retrieves a paginated list of orders created between the specified start and end dates. Supports filtering by customer email.

Endpoint Details

GET /orders

Query Parameters

Name	Type	Description	Required
startDate	string	Start date for filtering orders.
endDate	string	End date for filtering orders.
customerEmail	string	Filter orders by customer email address
page	number	Page number for pagination. Defaults to 1.
limit	number	Number of orders per page. Defaults to 10.

Query Limitations

• Date range cannot exceed 31 days

• Limit cannot exceed 100 orders per page

Headers

Header	Value
Content-Type	application/json
Authorization	Bearer <YOUR_ACCESS_TOKEN>

Response Details

Field	Type	Description
statusCode	number	HTTP status code of the response
message	string	A brief message describing the result of the API call
metadata	metaDataObject	Contains metadata about the API call
data	ordersList	Order object

Sample Request and Response

curl --location 'https://staging.api.liquidcommerce.cloud/orders/order_number'
--header 'Authorization: Bearer <YOUR_ACCESS_TOKEN>'

{
    "statusCode": 200,
    "message": "Orders fetched successfully.",
    "metadata": {
        "languages": ["en"],
        "timestamp": 1735329600000,
        "timezone": "UTC",
        "requestId": "f47ac10b-58cc-4372-a567-0e02b2c3d479",
        "path": "/orders",
        "version": "1.8.4"
    },
    "data": {
        "startDate": "2025-12-01",
        "endDate": "2025-12-31",
        "page": 1,
        "limit": 10,
        "total": 2,
        "orders": [
            {
                "referenceId": "RESV_25120100001",
                "legacyOrderNumber": "1232323232321",
                "partnerId": "507f1f77bcf86cd799439011",
                "partnerName": "Liquor Partners Inc",
                "promoCode": null,
                "createdAt": "2025-12-24T21:12:05.000Z",
                "updatedAt": "2025-12-24T21:14:23.000Z",
                "isHybrid": false,
                "customer": {
                    "id": "a1b2c3d4-1111-2222-3333-444455556666",
                    "firstName": "John",
                    "lastName": "Smith",
                    "email": "[email protected]",
                    "phone": "[phone]",
                    "birthdate": "1990-06-15"
                },
                "addresses": {
                    "shipping": {
                        "one": "123 Main Street",
                        "two": null,
                        "city": "Newark",
                        "state": "NJ",
                        "zip": "07001",
                        "country": "US",
                        "firstName": "John",
                        "lastName": "Smith",
                        "email": "[email protected]",
                        "phone": "[phone]",
                        "company": "Acme Corp"
                    },
                    "billing": {
                        "one": "123 Main Street",
                        "two": null,
                        "city": "Newark",
                        "state": "NJ",
                        "zip": "07001",
                        "country": "US",
                        "firstName": "John",
                        "lastName": "Smith",
                        "email": "[email protected]",
                        "phone": "[phone]",
                        "company": null
                    }
                },
                "options": {
                    "isGift": false,
                    "giftMessage": null,
                    "giftRecipient": {
                        "name": null,
                        "email": null,
                        "phone": null
                    },
                    "hasVerifiedAge": true,
                    "allowsSubstitution": true,
                    "billingSameAsShipping": true,
                    "deliveryInstructions": null,
                    "marketingPreferences": {
                        "email": true,
                        "sms": true
                    }
                },
                "amounts": {
                    "subtotal": 6799,
                    "shipping": 999,
                    "platform": 599,
                    "tax": 516,
                    "engraving": 0,
                    "service": 0,
                    "delivery": 0,
                    "discounts": 0,
                    "giftCards": 0,
                    "tip": 0,
                    "total": 8913,
                    "taxDetails": {
                        "products": 450,
                        "shipping": 66,
                        "delivery": 0,
                        "bag": 0,
                        "bottleDeposits": 0,
                        "retailDelivery": 0
                    },
                    "discountDetails": {
                        "products": 0,
                        "shipping": 0,
                        "delivery": 0,
                        "engraving": 0,
                        "service": 0
                    }
                },
                "paymentMethods": [
                    {
                        "type": "CREDIT_CARD",
                        "card": "Visa",
                        "last4": "4242",
                        "holder": "John Smith",
                        "code": null
                    }
                ],
                "retailers": [
                    {
                        "id": "507f1f77bcf86cd799439022",
                        "legacyId": "10001",
                        "name": "Downtown Wines & Spirits",
                        "system": "ReserveBar OMS",
                        "timezone": "America/New_York",
                        "address": {
                            "one": "100 Wine Road",
                            "two": null,
                            "city": "Lincoln Park",
                            "state": "NJ",
                            "zip": "07035",
                            "country": "US",
                            "latitude": 40.123456,
                            "longitude": -74.654321
                        },
                        "fulfillments": [
                            {
                                "id": "507f1f77bcf86cd799439033",
                                "type": "shipping",
                                "status": "canceled",
                                "scheduledFor": null,
                                "updatedAt": "2025-12-24T21:14:23.000Z",
                                "expectationFormatted": {
                                    "detail": "Ships in 2-3 days",
                                    "engraving": "Ships in 10 days"
                                },
                                "cancellation": {
                                    "category": "Other",
                                    "subcategory": null,
                                    "notes": "Customer requested cancellation"
                                },
                                "itemIds": [
                                    "b2c3d4e5-2222-3333-4444-555566667777"
                                ],
                                "packages": [],
                                "timeline": [
                                    {
                                        "status": "created",
                                        "timestamp": "2025-12-24T21:12:08.351Z"
                                    },
                                    {
                                        "status": "canceled",
                                        "timestamp": "2025-12-24T21:14:22.635Z"
                                    }
                                ]
                            }
                        ],
                        "amounts": {
                            "subtotal": 6799,
                            "shipping": 999,
                            "platform": 599,
                            "tax": 516,
                            "engraving": 0,
                            "service": 0,
                            "delivery": 0,
                            "discounts": 0,
                            "giftCards": 0,
                            "tip": 0,
                            "total": 8913,
                            "taxDetails": {
                                "products": 450,
                                "shipping": 66,
                                "delivery": 0,
                                "bag": 0,
                                "bottleDeposits": 0,
                                "retailDelivery": 0
                            },
                            "discountDetails": {
                                "products": 0,
                                "shipping": 0,
                                "delivery": 0,
                                "engraving": 0,
                                "service": 0
                            }
                        }
                    }
                ],
                "items": [
                    {
                        "id": "b2c3d4e5-2222-3333-4444-555566667777",
                        "fulfillmentId": "507f1f77bcf86cd799439033",
                        "retailerId": "507f1f77bcf86cd799439022",
                        "variantId": "507f1f77bcf86cd799439044",
                        "liquidId": "507f1f77bcf86cd799439055",
                        "legacyGrouping": "100001",
                        "legacyPid": "200001",
                        "expectation": "Ships in 2-3 days",
                        "customerPlacement": "standard",
                        "isPresale": false,
                        "estimatedShipBy": null,
                        "product": {
                            "name": "Premium Bourbon Whiskey",
                            "brand": "Kentucky Reserve",
                            "upc": "012345678901",
                            "sku": "LQPROD_ABC123",
                            "mskus": [],
                            "category": "SPIRITS > WHISKEY > BOURBON",
                            "size": "750 ML",
                            "volume": "750",
                            "uom": "MILLILITRE",
                            "proof": "80",
                            "attributes": {
                                "pack": false,
                                "packDescription": null,
                                "abv": "40",
                                "container": "Glass",
                                "containerType": "Glass"
                            }
                        },
                        "image": "https://example.com/images/bourbon.png",
                        "pricing": {
                            "price": 6799,
                            "unitPrice": 6799,
                            "quantity": 1,
                            "tax": 450,
                            "bottleDeposits": 0
                        },
                        "attributes": {
                            "engraving": {
                                "hasEngraving": false,
                                "fee": 5000,
                                "location": "Side of the Bottle",
                                "lines": []
                            },
                            "giftCard": {
                                "sender": null,
                                "message": null,
                                "recipients": [],
                                "sendDate": null
                            }
                        }
                    }
                ]
            },
            {
                "referenceId": "RESV_25120100002",
                "legacyOrderNumber": "1232323232322",
                "partnerId": "507f1f77bcf86cd799439011",
                "partnerName": "Liquor Partners Inc",
                "promoCode": "SAVE30",
                "createdAt": "2025-12-12T15:37:13.000Z",
                "updatedAt": "2025-12-15T22:08:41.000Z",
                "isHybrid": false,
                "customer": {
                    "id": "c3d4e5f6-3333-4444-5555-666677778888",
                    "firstName": "Sarah",
                    "lastName": "Johnson",
                    "email": "[email protected]",
                    "phone": "[phone]",
                    "birthdate": "1985-10-17"
                },
                "addresses": {
                    "shipping": {
                        "one": "456 Oak Avenue",
                        "two": "Apt 16E",
                        "city": "Hoboken",
                        "state": "NJ",
                        "zip": "07030",
                        "country": "US",
                        "firstName": "Sarah",
                        "lastName": "Johnson",
                        "email": "[email protected]",
                        "phone": "[phone]",
                        "company": "Tech Solutions"
                    },
                    "billing": {
                        "one": "456 Oak Avenue",
                        "two": "Apt 16E",
                        "city": "Hoboken",
                        "state": "NJ",
                        "zip": "07030",
                        "country": "US",
                        "firstName": "Sarah",
                        "lastName": "Johnson",
                        "email": "[email protected]",
                        "phone": "[phone]",
                        "company": null
                    }
                },
                "options": {
                    "isGift": false,
                    "giftMessage": null,
                    "giftRecipient": {
                        "name": null,
                        "email": null,
                        "phone": null
                    },
                    "hasVerifiedAge": true,
                    "allowsSubstitution": false,
                    "billingSameAsShipping": true,
                    "deliveryInstructions": null,
                    "marketingPreferences": {
                        "email": true,
                        "sms": true
                    }
                },
                "amounts": {
                    "subtotal": 13598,
                    "shipping": 999,
                    "platform": 599,
                    "tax": 631,
                    "engraving": 0,
                    "service": 0,
                    "delivery": 0,
                    "discounts": 5677,
                    "giftCards": 10000,
                    "tip": 0,
                    "total": 150,
                    "taxDetails": {
                        "products": 631,
                        "shipping": 0,
                        "delivery": 0,
                        "bag": 0,
                        "bottleDeposits": 0,
                        "retailDelivery": 0
                    },
                    "discountDetails": {
                        "products": 4079,
                        "shipping": 999,
                        "delivery": 0,
                        "engraving": 0,
                        "service": 599
                    }
                },
                "paymentMethods": [
                    {
                        "type": "CREDIT_CARD",
                        "card": "Visa",
                        "last4": "1234",
                        "holder": "Sarah Johnson",
                        "code": null
                    },
                    {
                        "type": "GIFT_CARD",
                        "card": null,
                        "last4": null,
                        "holder": null,
                        "code": "GC******XY"
                    }
                ],
                "retailers": [
                    {
                        "id": "507f1f77bcf86cd799439066",
                        "legacyId": "10002",
                        "name": "Uptown Wine & Spirits",
                        "system": "ReserveBar OMS",
                        "timezone": "America/New_York",
                        "address": {
                            "one": "200 Vine Street",
                            "two": null,
                            "city": "Jersey City",
                            "state": "NJ",
                            "zip": "07302",
                            "country": "US",
                            "latitude": 40.654321,
                            "longitude": -74.123456
                        },
                        "fulfillments": [
                            {
                                "id": "507f1f77bcf86cd799439077",
                                "type": "shipping",
                                "status": "delivered",
                                "scheduledFor": null,
                                "updatedAt": "2025-12-15T22:08:41.000Z",
                                "expectationFormatted": {
                                    "detail": "Ships in 2-3 days",
                                    "engraving": "Ships in 10 days"
                                },
                                "cancellation": {
                                    "category": null,
                                    "subcategory": null,
                                    "notes": null
                                },
                                "itemIds": [
                                    "d4e5f6a7-4444-5555-6666-777788889999"
                                ],
                                "packages": [
                                    {
                                        "id": "100001",
                                        "carrier": "fedex",
                                        "trackingNumber": "123456789012",
                                        "trackingUrl": "https://tracking.example.com/123456789012",
                                        "status": "delivered",
                                        "dateShipped": "2025-12-15T22:08:40.066Z"
                                    }
                                ],
                                "timeline": [
                                    {
                                        "status": "created",
                                        "timestamp": "2025-12-12T15:37:14.528Z"
                                    },
                                    {
                                        "status": "processing",
                                        "timestamp": "2025-12-13T01:05:56.352Z"
                                    },
                                    {
                                        "status": "delivered",
                                        "timestamp": "2025-12-15T22:08:40.089Z"
                                    }
                                ]
                            }
                        ],
                        "amounts": {
                            "subtotal": 13598,
                            "shipping": 999,
                            "platform": 599,
                            "tax": 631,
                            "engraving": 0,
                            "service": 0,
                            "delivery": 0,
                            "discounts": 5677,
                            "giftCards": 10000,
                            "tip": 0,
                            "total": 150,
                            "taxDetails": {
                                "products": 631,
                                "shipping": 0,
                                "delivery": 0,
                                "bag": 0,
                                "bottleDeposits": 0,
                                "retailDelivery": 0
                            },
                            "discountDetails": {
                                "products": 4079,
                                "shipping": 999,
                                "delivery": 0,
                                "engraving": 0,
                                "service": 599
                            }
                        }
                    }
                ],
                "items": [
                    {
                        "id": "d4e5f6a7-4444-5555-6666-777788889999",
                        "fulfillmentId": "507f1f77bcf86cd799439077",
                        "retailerId": "507f1f77bcf86cd799439066",
                        "variantId": "507f1f77bcf86cd799439088",
                        "liquidId": "507f1f77bcf86cd799439099",
                        "legacyGrouping": "100002",
                        "legacyPid": "200002",
                        "expectation": "Ships in 2-3 days",
                        "customerPlacement": "standard",
                        "isPresale": false,
                        "estimatedShipBy": null,
                        "product": {
                            "name": "Tuscan Red Wine Blend",
                            "brand": "Villa Toscana",
                            "upc": "098765432109",
                            "sku": "LQPROD_DEF456",
                            "mskus": [
                                "SKU001",
                                "SKU002"
                            ],
                            "category": "WINE > RED WINE > RED BLEND",
                            "size": "750 ML",
                            "volume": "750",
                            "uom": "MILLILITRE",
                            "proof": "30",
                            "attributes": {
                                "pack": false,
                                "packDescription": null,
                                "abv": "15",
                                "container": "Glass",
                                "containerType": "Glass"
                            }
                        },
                        "image": "https://example.com/images/red-wine.png",
                        "pricing": {
                            "price": 13598,
                            "unitPrice": 6799,
                            "quantity": 2,
                            "tax": 631,
                            "bottleDeposits": 0
                        },
                        "attributes": {
                            "engraving": {
                                "hasEngraving": false,
                                "fee": 5000,
                                "location": "Below the Label",
                                "lines": []
                            },
                            "giftCard": {
                                "sender": null,
                                "message": null,
                                "recipients": [],
                                "sendDate": null
                            }
                        }
                    }
                ]
            }
        ]
    }
}