Lees eerst het artikel ‘Geavanceerde filters toepassen op inkomende webwinkel orders‘. Hieronder kan je een voorbeeld terugvinden van een Lightspeed order object.
{
"id": 1623550,
"createdAt": "2019-08-21T17:15:00+00:00",
"updatedAt": "2019-09-16T19:46:01+00:00",
"number": "ORD00018",
"status": "processing_awaiting_shipment",
"customStatusId": null,
"channel": "main",
"remoteIp": "75.119.244.186",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.100 Safari/537.36",
"referralId": false,
"priceCost": 0,
"priceExcl": 47.95,
"priceIncl": 50.35,
"weight": 0,
"volume": 0,
"colli": 0,
"gender": "female",
"birthDate": false,
"nationalId": "",
"email": "info@lightspeedhq.com",
"firstname": "Lightspeed",
"middlename": "",
"lastname": "Test",
"phone": "+1 5555555555",
"mobile": "",
"newsletterSubscribed": false,
"isCompany": false,
"companyName": "",
"companyCoCNumber": "",
"companyVatNumber": "",
"addressBillingName": "Lightspeed Test",
"addressBillingStreet": "123 viger",
"addressBillingStreet2": "",
"addressBillingNumber": "",
"addressBillingExtension": "",
"addressBillingZipcode": "h4a2r2",
"addressBillingCity": "montreal",
"addressBillingRegion": "Quebec",
"addressBillingCountry": {
"id": 38,
"code": "ca",
"code3": "can",
"title": "Canada"
},
"addressBillingRegionData": {
"id": 548,
"name": "Quebec",
"code": "QC"
},
"addressShippingCompany": false,
"addressShippingName": "Lightspeed Test",
"addressShippingStreet": "123 viger",
"addressShippingStreet2": "",
"addressShippingNumber": "",
"addressShippingExtension": "",
"addressShippingZipcode": "h4a2r2",
"addressShippingCity": "montreal",
"addressShippingRegion": "Quebec",
"addressShippingCountry": {
"id": 38,
"code": "ca",
"code3": "can",
"title": "Canada"
},
"addressShippingRegionData": {
"id": 548,
"name": "Quebec",
"code": "QC"
},
"paymentId": "invoice",
"paymentStatus": "paid",
"paymentIsPost": true,
"paymentIsInvoiceExternal": false,
"paymentTaxRate": 0,
"paymentTaxRates": [
{
"name": "VAT",
"rate": 0,
"amount": 0
}
],
"paymentBasePriceExcl": 0,
"paymentBasePriceIncl": 0,
"paymentPriceExcl": 0,
"paymentPriceIncl": 0,
"paymentTitle": "Pay by invoice",
"paymentData": {
"method": "invoice"
},
"shipmentId": "core|33265|55707",
"shipmentStatus": "not_shipped",
"shipmentIsCashOnDelivery": false,
"shipmentIsPickup": false,
"shipmentTaxRate": 0.05,
"shipmentTaxRates": [
{
"name": "GST",
"rate": 0.05,
"amount": 0.2975
}
],
"shipmentBasePriceExcl": 5.95,
"shipmentBasePriceIncl": 6.2475,
"shipmentPriceExcl": 5.95,
"shipmentPriceIncl": 6.25,
"shipmentDiscountExcl": 0,
"shipmentDiscountIncl": 0,
"shipmentTitle": "Default Shipping",
"shipmentData": {
"method": "default",
"shipment_id": 33265,
"shipping_value_id": 55707
},
"shippingDate": null,
"deliveryDate": null,
"isDiscounted": false,
"discountType": "amount",
"discountAmount": 0,
"discountPercentage": 0,
"discountCouponCode": "",
"taxRates": [
{
"name": "GST",
"rate": 0.05,
"amount": 2.1
}
],
"isNewCustomer": false,
"comment": "",
"memo": "",
"allowNotifications": true,
"doNotifyNew": false,
"doNotifyReminder": false,
"doNotifyCancelled": false,
"language": {
"id": 18,
"code": "us",
"locale": "en_US",
"title": "English (US)"
},
"customer": {
"resource": {
"id": 2026523,
"url": "customers/2026523",
"link": "https://api.shoplightspeed.com/us/customers/2026523.json",
"embedded": {
"id": 2026523,
"createdAt": "2019-06-12T15:11:26+00:00",
"updatedAt": "2019-09-16T19:45:03+00:00",
"isConfirmed": false,
"type": "registered",
"lastOnlineAt": "2019-08-21T17:23:38+00:00",
"remoteIp": "75.119.244.186",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.100 Safari/537.36",
"referralId": false,
"gender": "female",
"birthDate": false,
"nationalId": "",
"email": "info@lightspeedhq.com",
"firstname": "Lightspeed",
"middlename": "",
"lastname": "Test",
"phone": "+1 5555555555",
"mobile": "",
"isCompany": false,
"companyName": "",
"companyCoCNumber": "",
"companyVatNumber": "",
"addressBillingName": "Lightspeed Test",
"addressBillingStreet": "123 viger",
"addressBillingStreet2": "",
"addressBillingNumber": "",
"addressBillingExtension": "",
"addressBillingZipcode": "h4a2r2",
"addressBillingCity": "montreal",
"addressBillingRegion": "Quebec",
"addressBillingCountry": {
"id": 38,
"code": "ca",
"code3": "can",
"title": "Canada"
},
"addressShippingCompany": false,
"addressShippingName": "Lightspeed Test",
"addressShippingStreet": "123 viger",
"addressShippingStreet2": "",
"addressShippingNumber": "",
"addressShippingExtension": "",
"addressShippingZipcode": "h4a2r2",
"addressShippingCity": "montreal",
"addressShippingRegion": "Quebec",
"addressShippingCountry": {
"id": 38,
"code": "ca",
"code3": "can",
"title": "Canada"
},
"memo": "",
"doNotifyRegistered": false,
"doNotifyConfirmed": false,
"doNotifyPassword": false,
"groups": {
"resource": {
"id": false,
"url": "groups/customers?customer=2026523",
"link": "https://api.shoplightspeed.com/us/groups/customers.json?customer=2026523"
}
},
"invoices": {
"resource": {
"id": false,
"url": "invoices?customer=2026523",
"link": "https://api.shoplightspeed.com/us/invoices.json?customer=2026523"
}
},
"language": {
"id": 18,
"code": "us",
"locale": "en_US",
"title": "English (US)"
},
"orders": {
"resource": {
"id": false,
"url": "orders?customer=2026523",
"link": "https://api.shoplightspeed.com/us/orders.json?customer=2026523"
}
},
"reviews": {
"resource": {
"id": false,
"url": "reviews?customer=2026523",
"link": "https://api.shoplightspeed.com/us/reviews.json?customer=2026523"
}
},
"shipments": {
"resource": {
"id": false,
"url": "shipments?customer=2026523",
"link": "https://api.shoplightspeed.com/us/shipments.json?customer=2026523"
}
},
"tickets": {
"resource": {
"id": false,
"url": "tickets?customer=2026523",
"link": "https://api.shoplightspeed.com/us/tickets.json?customer=2026523"
}
},
"metafields": {
"resource": {
"id": false,
"url": "customers/2026523/metafields",
"link": "https://api.shoplightspeed.com/us/customers/2026523/metafields.json"
}
},
"login": {
"resource": {
"id": false,
"url": "customers/2026523/login",
"link": "https://api.shoplightspeed.com/us/customers/2026523/login.json"
}
}
}
}
},
"invoices": {
"resource": {
"id": false,
"url": "invoices?order=1623550",
"link": "https://api.shoplightspeed.com/us/invoices.json?order=1623550",
"embedded": [
{
"id": 1741975,
"createdAt": "2019-08-21T17:15:00+00:00",
"updatedAt": "2019-09-16T19:46:02+00:00",
"number": "INV00033",
"status": "paid",
"isVatShifted": false,
"priceExcl": 47.95,
"priceIncl": 50.35,
"doNotifyNew": false,
"doNotifyPaid": false,
"invoice": false,
"isCreditNote": false,
"creditNote": false,
"order": {
"resource": {
"id": 1623550,
"url": "orders/1623550",
"link": "https://api.shoplightspeed.com/us/orders/1623550.json"
}
},
"customer": {
"resource": {
"id": 2026523,
"url": "customers/2026523",
"link": "https://api.shoplightspeed.com/us/customers/2026523.json"
}
},
"items": {
"resource": {
"id": false,
"url": "invoices/1741975/items",
"link": "https://api.shoplightspeed.com/us/invoices/1741975/items.json"
}
},
"metafields": {
"resource": {
"id": false,
"url": "invoices/1741975/metafields",
"link": "https://api.shoplightspeed.com/us/invoices/1741975/metafields.json"
}
},
"events": {
"resource": {
"id": false,
"url": "orders/events?invoice=1741975",
"link": "https://api.shoplightspeed.com/us/orders/events.json?invoice=1741975"
}
}
}
]
}
},
"shipments": {
"resource": {
"id": false,
"url": "shipments?order=1623550",
"link": "https://api.shoplightspeed.com/us/shipments.json?order=1623550",
"embedded": [
{
"id": 1599522,
"createdAt": "2019-08-21T17:15:00+00:00",
"updatedAt": "2019-08-21T17:15:00+00:00",
"number": "SHIP00018",
"status": "not_shipped",
"trackingCode": "",
"doNotifyShipped": false,
"doNotifyTrackingCode": false,
"customer": {
"resource": {
"id": 2026523,
"url": "customers/2026523",
"link": "https://api.shoplightspeed.com/us/customers/2026523.json"
}
},
"order": {
"resource": {
"id": 1623550,
"url": "orders/1623550",
"link": "https://api.shoplightspeed.com/us/orders/1623550.json"
}
},
"products": {
"resource": {
"id": false,
"url": "shipments/1599522/products",
"link": "https://api.shoplightspeed.com/us/shipments/1599522/products.json"
}
},
"metafields": {
"resource": {
"id": false,
"url": "shipments/1599522/metafields",
"link": "https://api.shoplightspeed.com/us/shipments/1599522/metafields.json"
}
},
"events": {
"resource": {
"id": false,
"url": "orders/events?shipment=1599522",
"link": "https://api.shoplightspeed.com/us/orders/events.json?shipment=1599522"
}
}
}
]
}
},
"products": {
"resource": {
"id": false,
"url": "orders/1623550/products",
"link": "https://api.shoplightspeed.com/us/orders/1623550/products.json",
"embedded": [
{
"id": 3515302,
"supplierTitle": "Clay Cactus",
"brandTitle": "ClayCactus",
"productTitle": "anacampseros",
"variantTitle": "anacampseros",
"taxRate": 0.05,
"taxRates": [
{
"name": "GST",
"rate": 0.05,
"amount": 2.1
}
],
"quantityOrdered": 6,
"quantityInvoiced": 6,
"quantityShipped": 6,
"quantityRefunded": 0,
"quantityReturned": 0,
"articleCode": "anacampseros",
"ean": "",
"sku": "",
"weight": 0,
"volume": 0,
"colli": 0,
"sizeX": 0,
"sizeY": 0,
"sizeZ": 0,
"priceCost": 0,
"customExcl": 0,
"customIncl": 0,
"basePriceExcl": 7,
"basePriceIncl": 7.35,
"priceExcl": 42,
"priceIncl": 44.1,
"discountExcl": 0,
"discountIncl": 0,
"customFields": false,
"product": {
"resource": {
"id": 20967262,
"url": "products/20967262",
"link": "https://api.shoplightspeed.com/us/products/20967262.json"
}
},
"variant": {
"resource": {
"id": 34771159,
"url": "variants/34771159",
"link": "https://api.shoplightspeed.com/us/variants/34771159.json"
}
}
}
]
}
},
"metafields": {
"resource": {
"id": false,
"url": "orders/1623550/metafields",
"link": "https://api.shoplightspeed.com/us/orders/1623550/metafields.json",
"embedded": []
}
},
"quote": {
"resource": {
"id": 20859265,
"url": "quotes/20859265",
"link": "https://api.shoplightspeed.com/us/quotes/20859265.json",
"embedded": {
"id": 20859265,
"createdAt": "2019-08-21T17:14:34+00:00",
"updatedAt": "2019-08-21T17:14:59+00:00",
"recalculatedAt": "2019-08-21T17:14:59+00:00",
"isLocked": false,
"channel": "main",
"recoveryHash": "af04c40dc74f2a7d31e0aaaa20859265",
"remoteIp": "75.119.244.186",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.100 Safari/537.36",
"referralId": false,
"weight": 0,
"volume": 0,
"colli": 0,
"paymentCountry": {
"id": 38,
"code": "ca",
"code3": "can",
"title": "Canada"
},
"shipmentCountry": {
"id": 38,
"code": "ca",
"code3": "can",
"title": "Canada"
},
"shipmentZipcode": "h4a2r2",
"shipmentSameAddress": true,
"priceCost": 0,
"priceExcl": 47.95,
"priceIncl": 50.35,
"discountExcl": 0,
"discountIncl": 0,
"productsCount": 1,
"productsQuantity": 6,
"shipmentIsSet": true,
"shipmentId": "core|33265|55707",
"shipmentIsVirtual": false,
"shipmentIsCashOnDelivery": false,
"shipmentDiscountPercentage": 0,
"shipmentIsServicePoint": false,
"shipmentIsPickup": false,
"shipmentTaxRate": 0.05,
"shipmentBasePriceExcl": 5.95,
"shipmentBasePriceIncl": 6.2475,
"shipmentPriceTax": 0.3,
"shipmentPriceExcl": 5.95,
"shipmentPriceIncl": 6.25,
"shipmentDiscountExcl": 0,
"shipmentDiscountIncl": 0,
"shipmentTitle": "Default Shipping",
"shipmentData": {
"method": "default",
"shipment_id": 33265,
"shipping_value_id": 55707
},
"paymentIsSet": true,
"paymentId": "invoice",
"paymentIsPost": true,
"paymentIsInvoiceExternal": false,
"paymentData": "{\"method\":\"invoice\"}",
"paymentTaxRate": 0,
"paymentBasePriceExcl": 0,
"paymentBasePriceIncl": 0,
"paymentPriceTax": 0,
"paymentPriceExcl": 0,
"paymentPriceIncl": 0,
"additionalCostIncl": "0.0000",
"additionalCostExcl": "0.0000",
"paymentTitle": "Pay by invoice",
"discountIsSet": false,
"discountId": 0,
"discountType": "amount",
"discountAmount": 0,
"discountPercentage": 0,
"discountShipment": "default",
"discountMinimumAmount": "0.00",
"discountCouponCode": "",
"comment": null,
"allowNotifications": true,
"customer": {
"resource": {
"id": 2026523,
"url": "customers/2026523",
"link": "https://api.shoplightspeed.com/us/customers/2026523.json"
}
},
"language": {
"id": 18,
"code": "us",
"locale": "en_US",
"title": "English (US)"
},
"products": {
"resource": {
"id": false,
"url": "quotes/20859265/products",
"link": "https://api.shoplightspeed.com/us/quotes/20859265/products.json"
}
},
"shippingmethods": {
"resource": {
"id": false,
"url": "quotes/20859265/shippingmethods",
"link": "https://api.shoplightspeed.com/us/quotes/20859265/shippingmethods.json"
}
},
"paymentmethods": {
"resource": {
"id": false,
"url": "quotes/20859265/paymentmethods",
"link": "https://api.shoplightspeed.com/us/quotes/20859265/paymentmethods.json"
}
}
}
}
},
"events": {
"resource": {
"id": false,
"url": "orders/events?order=1623550",
"link": "https://api.shoplightspeed.com/us/orders/events.json?order=1623550",
"embedded": [
{
"id": 14874034,
"createdAt": "2019-08-21T17:15:00+00:00",
"channel": "auto",
"type": "order",
"message": "new",
"comment": null,
"order": {
"resource": {
"id": 1623550,
"url": "orders/1623550",
"link": "https://api.shoplightspeed.com/us/orders/1623550.json"
}
},
"invoice": false,
"shipment": false
},
{
"id": 14874035,
"createdAt": "2019-08-21T17:15:00+00:00",
"channel": "auto",
"type": "invoice",
"message": "new",
"comment": null,
"order": {
"resource": {
"id": 1623550,
"url": "orders/1623550",
"link": "https://api.shoplightspeed.com/us/orders/1623550.json"
}
},
"invoice": {
"resource": {
"id": 1741975,
"url": "invoices/1741975",
"link": "https://api.shoplightspeed.com/us/invoices/1741975.json"
}
},
"shipment": false
},
{
"id": 14874036,
"createdAt": "2019-08-21T17:15:00+00:00",
"channel": "auto",
"type": "shipment",
"message": "new",
"comment": null,
"order": {
"resource": {
"id": 1623550,
"url": "orders/1623550",
"link": "https://api.shoplightspeed.com/us/orders/1623550.json"
}
},
"invoice": false,
"shipment": {
"resource": {
"id": 1599522,
"url": "shipments/1599522",
"link": "https://api.shoplightspeed.com/us/shipments/1599522.json"
}
}
},
{
"id": 15453254,
"createdAt": "2019-09-16T19:44:03+00:00",
"channel": "api",
"type": "invoice",
"message": "paid",
"comment": null,
"order": {
"resource": {
"id": 1623550,
"url": "orders/1623550",
"link": "https://api.shoplightspeed.com/us/orders/1623550.json"
}
},
"invoice": {
"resource": {
"id": 1741975,
"url": "invoices/1741975",
"link": "https://api.shoplightspeed.com/us/invoices/1741975.json"
}
},
"shipment": false
},
{
"id": 15453255,
"createdAt": "2019-09-16T19:44:03+00:00",
"channel": "api",
"type": "order",
"message": "paid",
"comment": null,
"order": {
"resource": {
"id": 1623550,
"url": "orders/1623550",
"link": "https://api.shoplightspeed.com/us/orders/1623550.json"
}
},
"invoice": false,
"shipment": false
},
{
"id": 15453275,
"createdAt": "2019-09-16T19:45:05+00:00",
"channel": "api",
"type": "invoice",
"message": "not_paid",
"comment": null,
"order": {
"resource": {
"id": 1623550,
"url": "orders/1623550",
"link": "https://api.shoplightspeed.com/us/orders/1623550.json"
}
},
"invoice": {
"resource": {
"id": 1741975,
"url": "invoices/1741975",
"link": "https://api.shoplightspeed.com/us/invoices/1741975.json"
}
},
"shipment": false
},
{
"id": 15453276,
"createdAt": "2019-09-16T19:45:05+00:00",
"channel": "api",
"type": "order",
"message": "not_paid",
"comment": null,
"order": {
"resource": {
"id": 1623550,
"url": "orders/1623550",
"link": "https://api.shoplightspeed.com/us/orders/1623550.json"
}
},
"invoice": false,
"shipment": false
},
{
"id": 15453289,
"createdAt": "2019-09-16T19:46:01+00:00",
"channel": "api",
"type": "invoice",
"message": "paid",
"comment": null,
"order": {
"resource": {
"id": 1623550,
"url": "orders/1623550",
"link": "https://api.shoplightspeed.com/us/orders/1623550.json"
}
},
"invoice": {
"resource": {
"id": 1741975,
"url": "invoices/1741975",
"link": "https://api.shoplightspeed.com/us/invoices/1741975.json"
}
},
"shipment": false
},
{
"id": 15453290,
"createdAt": "2019-09-16T19:46:01+00:00",
"channel": "api",
"type": "order",
"message": "paid",
"comment": null,
"order": {
"resource": {
"id": 1623550,
"url": "orders/1623550",
"link": "https://api.shoplightspeed.com/us/orders/1623550.json"
}
},
"invoice": false,
"shipment": false
}
]
}
}
}