Order Detail
Order ID: 899125806 • Order #: FPB7TYVSM9
Order Summary
Order Date
12/5/2025
Create Date
12/5/2025 11:31pm
Ship Date
Store
Source
faire
Batch
Recipient
Email
Gift
No
Totals
6 items • Qty 6
Order Total
$612.00
Amount Paid
$0.00
Tax
$0.00
Shipping
$0.00
Insurance

IDs
order_id: 899125806
Addresses
Address
Bri Oldham
,
Address
Bri Oldham
Mr. S Clothing
48 West Main St.
Vernal, UT 84078
US
☎ 4356215520
Items
6 lines
SKU Item Name Qty Unit Price Line Total Notes / Options
M282SK-03-38R Light Weight Stretch Suits, 3-PC Skinny Fit,Charcoal Grey 1 $102.00 $102.00
M282SK-03-40R Light Weight Stretch Suits, 3-PC Skinny Fit,Charcoal Grey 1 $102.00 $102.00
M282SK-03-42R Light Weight Stretch Suits, 3-PC Skinny Fit,Charcoal Grey 1 $102.00 $102.00
M282SK-05-38R Light Weight Stretch Suits, 3-PC Skinny Fit,Indigo 1 $102.00 $102.00
M282SK-05-40R Light Weight Stretch Suits, 3-PC Skinny Fit,Indigo 1 $102.00 $102.00
M282SK-05-42R Light Weight Stretch Suits, 3-PC Skinny Fit,Indigo 1 $102.00 $102.00
Raw Payload
{
    "orderId": 899125806,
    "orderNumber": "FPB7TYVSM9",
    "orderKey": "bo_fpb7tyvsm9",
    "orderDate": "2025-12-05T22:37:30.0000000",
    "createDate": "2025-12-05T23:31:37.8770000",
    "modifyDate": "2025-12-08T10:14:43.1300000",
    "paymentDate": null,
    "shipByDate": null,
    "orderStatus": "shipped",
    "customerId": 391219478,
    "customerUsername": "Bri.Oldham",
    "customerEmail": null,
    "billTo": {
        "name": "Bri Oldham",
        "company": null,
        "street1": null,
        "street2": null,
        "street3": null,
        "city": null,
        "state": null,
        "postalCode": null,
        "country": null,
        "phone": null,
        "residential": null,
        "addressVerified": null
    },
    "shipTo": {
        "name": "Bri Oldham",
        "company": "Mr. S Clothing",
        "street1": "48 West Main St. ",
        "street2": null,
        "street3": null,
        "city": "Vernal",
        "state": "UT",
        "postalCode": "84078",
        "country": "US",
        "phone": "4356215520",
        "residential": false,
        "addressVerified": "Address not yet validated"
    },
    "items": [
        {
            "orderItemId": 1687748063,
            "lineItemKey": null,
            "sku": "M282SK-03-38R",
            "name": "Light Weight Stretch Suits, 3-PC Skinny Fit,Charcoal Grey",
            "imageUrl": null,
            "weight": null,
            "quantity": 1,
            "unitPrice": 102,
            "taxAmount": 0,
            "shippingAmount": 0,
            "warehouseLocation": null,
            "options": [],
            "productId": 55971300,
            "fulfillmentSku": null,
            "adjustment": false,
            "upc": null,
            "createDate": "2025-12-05T23:31:37.83",
            "modifyDate": "2025-12-05T23:31:37.83"
        },
        {
            "orderItemId": 1687748064,
            "lineItemKey": null,
            "sku": "M282SK-03-40R",
            "name": "Light Weight Stretch Suits, 3-PC Skinny Fit,Charcoal Grey",
            "imageUrl": null,
            "weight": null,
            "quantity": 1,
            "unitPrice": 102,
            "taxAmount": 0,
            "shippingAmount": 0,
            "warehouseLocation": null,
            "options": [],
            "productId": 55971301,
            "fulfillmentSku": null,
            "adjustment": false,
            "upc": null,
            "createDate": "2025-12-05T23:31:37.83",
            "modifyDate": "2025-12-05T23:31:37.83"
        },
        {
            "orderItemId": 1687748065,
            "lineItemKey": null,
            "sku": "M282SK-03-42R",
            "name": "Light Weight Stretch Suits, 3-PC Skinny Fit,Charcoal Grey",
            "imageUrl": null,
            "weight": null,
            "quantity": 1,
            "unitPrice": 102,
            "taxAmount": 0,
            "shippingAmount": 0,
            "warehouseLocation": null,
            "options": [],
            "productId": 63135172,
            "fulfillmentSku": null,
            "adjustment": false,
            "upc": null,
            "createDate": "2025-12-05T23:31:37.83",
            "modifyDate": "2025-12-05T23:31:37.83"
        },
        {
            "orderItemId": 1687748066,
            "lineItemKey": null,
            "sku": "M282SK-05-38R",
            "name": "Light Weight Stretch Suits, 3-PC Skinny Fit,Indigo",
            "imageUrl": null,
            "weight": null,
            "quantity": 1,
            "unitPrice": 102,
            "taxAmount": 0,
            "shippingAmount": 0,
            "warehouseLocation": null,
            "options": [],
            "productId": 55944524,
            "fulfillmentSku": null,
            "adjustment": false,
            "upc": null,
            "createDate": "2025-12-05T23:31:37.83",
            "modifyDate": "2025-12-05T23:31:37.83"
        },
        {
            "orderItemId": 1687748067,
            "lineItemKey": null,
            "sku": "M282SK-05-40R",
            "name": "Light Weight Stretch Suits, 3-PC Skinny Fit,Indigo",
            "imageUrl": null,
            "weight": null,
            "quantity": 1,
            "unitPrice": 102,
            "taxAmount": 0,
            "shippingAmount": 0,
            "warehouseLocation": null,
            "options": [],
            "productId": 59294302,
            "fulfillmentSku": null,
            "adjustment": false,
            "upc": null,
            "createDate": "2025-12-05T23:31:37.83",
            "modifyDate": "2025-12-05T23:31:37.83"
        },
        {
            "orderItemId": 1687748068,
            "lineItemKey": null,
            "sku": "M282SK-05-42R",
            "name": "Light Weight Stretch Suits, 3-PC Skinny Fit,Indigo",
            "imageUrl": null,
            "weight": null,
            "quantity": 1,
            "unitPrice": 102,
            "taxAmount": 0,
            "shippingAmount": 0,
            "warehouseLocation": null,
            "options": [],
            "productId": 59782568,
            "fulfillmentSku": null,
            "adjustment": false,
            "upc": null,
            "createDate": "2025-12-05T23:31:37.83",
            "modifyDate": "2025-12-05T23:31:37.83"
        }
    ],
    "orderTotal": 612,
    "amountPaid": 0,
    "taxAmount": 0,
    "shippingAmount": 0,
    "customerNotes": null,
    "internalNotes": null,
    "gift": false,
    "giftMessage": null,
    "paymentMethod": null,
    "requestedShippingService": null,
    "carrierCode": null,
    "serviceCode": null,
    "packageCode": null,
    "confirmation": "none",
    "shipDate": null,
    "holdUntilDate": null,
    "weight": {
        "value": 0,
        "units": "ounces",
        "WeightUnits": 1
    },
    "dimensions": null,
    "insuranceOptions": {
        "provider": "parcelguard",
        "insureShipment": true,
        "insuredValue": 612
    },
    "internationalOptions": {
        "contents": null,
        "customsItems": null,
        "nonDelivery": null
    },
    "advancedOptions": {
        "warehouseId": 177607,
        "nonMachinable": false,
        "saturdayDelivery": false,
        "containsAlcohol": false,
        "mergedOrSplit": false,
        "mergedIds": [],
        "parentId": null,
        "storeId": 266078,
        "customField1": null,
        "customField2": null,
        "customField3": null,
        "source": "faire",
        "billToParty": null,
        "billToAccount": null,
        "billToPostalCode": null,
        "billToCountryCode": null,
        "billToMyOtherAccount": null
    },
    "tagIds": null,
    "userId": null,
    "externallyFulfilled": false,
    "externallyFulfilledBy": null,
    "externallyFulfilledById": null,
    "externallyFulfilledByName": null,
    "labelMessages": null
}
DB Row (orders)
ColumnValue
order_id 899125806
order_number FPB7TYVSM9
order_key bo_fpb7tyvsm9
order_status shipped
order_date 2025-12-05 22:37:30
create_date 2025-12-05 23:31:37
modify_date 2025-12-08 10:14:43
payment_date
ship_by_date
ship_date
hold_until_date
customer_id 391219478
customer_username Bri.Oldham
customer_email
order_total 612.00
amount_paid 0.00
tax_amount 0.00
shipping_amount 0.00
gift 0
confirmation none
carrier_code
service_code
package_code
requested_shipping_service
warehouse_id
store_id
source faire
weight_value 0.000
weight_units ounces
raw_json {"orderId":899125806,"orderNumber":"FPB7TYVSM9","orderKey":"bo_fpb7tyvsm9","orderDate":"2025-12-05T22:37:30.0000000","createDate":"2025-12-05T23:31:37.8770000","modifyDate":"2025-12-08T10:14:43.1300000","paymentDate":null,"shipByDate":null,"orderStatus":"shipped","customerId":391219478,"customerUsername":"Bri.Oldham","customerEmail":null,"billTo":{"name":"Bri Oldham","company":null,"street1":null,"street2":null,"street3":null,"city":null,"state":null,"postalCode":null,"country":null,"phone":null,"residential":null,"addressVerified":null},"shipTo":{"name":"Bri Oldham","company":"Mr. S Clothing","street1":"48 West Main St. ","street2":null,"street3":null,"city":"Vernal","state":"UT","postalCode":"84078","country":"US","phone":"4356215520","residential":false,"addressVerified":"Address not yet validated"},"items":[{"orderItemId":1687748063,"lineItemKey":null,"sku":"M282SK-03-38R","name":"Light Weight Stretch Suits, 3-PC Skinny Fit,Charcoal Grey","imageUrl":null,"weight":null,"quantity":1,"unitPrice":102,"taxAmount":0,"shippingAmount":0,"warehouseLocation":null,"options":[],"productId":55971300,"fulfillmentSku":null,"adjustment":false,"upc":null,"createDate":"2025-12-05T23:31:37.83","modifyDate":"2025-12-05T23:31:37.83"},{"orderItemId":1687748064,"lineItemKey":null,"sku":"M282SK-03-40R","name":"Light Weight Stretch Suits, 3-PC Skinny Fit,Charcoal Grey","imageUrl":null,"weight":null,"quantity":1,"unitPrice":102,"taxAmount":0,"shippingAmount":0,"warehouseLocation":null,"options":[],"productId":55971301,"fulfillmentSku":null,"adjustment":false,"upc":null,"createDate":"2025-12-05T23:31:37.83","modifyDate":"2025-12-05T23:31:37.83"},{"orderItemId":1687748065,"lineItemKey":null,"sku":"M282SK-03-42R","name":"Light Weight Stretch Suits, 3-PC Skinny Fit,Charcoal Grey","imageUrl":null,"weight":null,"quantity":1,"unitPrice":102,"taxAmount":0,"shippingAmount":0,"warehouseLocation":null,"options":[],"productId":63135172,"fulfillmentSku":null,"adjustment":false,"upc":null,"createDate":"2025-12-05T23:31:37.83","modifyDate":"2025-12-05T23:31:37.83"},{"orderItemId":1687748066,"lineItemKey":null,"sku":"M282SK-05-38R","name":"Light Weight Stretch Suits, 3-PC Skinny Fit,Indigo","imageUrl":null,"weight":null,"quantity":1,"unitPrice":102,"taxAmount":0,"shippingAmount":0,"warehouseLocation":null,"options":[],"productId":55944524,"fulfillmentSku":null,"adjustment":false,"upc":null,"createDate":"2025-12-05T23:31:37.83","modifyDate":"2025-12-05T23:31:37.83"},{"orderItemId":1687748067,"lineItemKey":null,"sku":"M282SK-05-40R","name":"Light Weight Stretch Suits, 3-PC Skinny Fit,Indigo","imageUrl":null,"weight":null,"quantity":1,"unitPrice":102,"taxAmount":0,"shippingAmount":0,"warehouseLocation":null,"options":[],"productId":59294302,"fulfillmentSku":null,"adjustment":false,"upc":null,"createDate":"2025-12-05T23:31:37.83","modifyDate":"2025-12-05T23:31:37.83"},{"orderItemId":1687748068,"lineItemKey":null,"sku":"M282SK-05-42R","name":"Light Weight Stretch Suits, 3-PC Skinny Fit,Indigo","imageUrl":null,"weight":null,"quantity":1,"unitPrice":102,"taxAmount":0,"shippingAmount":0,"warehouseLocation":null,"options":[],"productId":59782568,"fulfillmentSku":null,"adjustment":false,"upc":null,"createDate":"2025-12-05T23:31:37.83","modifyDate":"2025-12-05T23:31:37.83"}],"orderTotal":612,"amountPaid":0,"taxAmount":0,"shippingAmount":0,"customerNotes":null,"internalNotes":null,"gift":false,"giftMessage":null,"paymentMethod":null,"requestedShippingService":null,"carrierCode":null,"serviceCode":null,"packageCode":null,"confirmation":"none","shipDate":null,"holdUntilDate":null,"weight":{"value":0,"units":"ounces","WeightUnits":1},"dimensions":null,"insuranceOptions":{"provider":"parcelguard","insureShipment":true,"insuredValue":612},"internationalOptions":{"contents":null,"customsItems":null,"nonDelivery":null},"advancedOptions":{"warehouseId":177607,"nonMachinable":false,"saturdayDelivery":false,"containsAlcohol":false,"mergedOrSplit":false,"mergedIds":[],"parentId":null,"storeId":266078,"customField1":null,"customField2":null,"customField3":null,"source":"faire","billToParty":null,"billToAccount":null,"billToPostalCode":null,"billToCountryCode":null,"billToMyOtherAccount":null},"tagIds":null,"userId":null,"externallyFulfilled":false,"externallyFulfilledBy":null,"externallyFulfilledById":null,"externallyFulfilledByName":null,"labelMessages":null}
updated_at 2025-12-23 04:39:28
created_at 2025-12-23 04:39:28