Velo: Wix Stores "Orders" Collection Fields

Tip: Before continuing, make sure you've read Working with Wix App Collections.

To use the Orders collection in code, refer to it as "Stores/Orders".

Copy
1
wixData.query("Stores/Orders")
2
.find()
3
.then( (results) => {
4
// handle the results
5
} );

This document describes the permissions and fields in your Orders collection.

Important: You can query up to 100 items from the Orders collection. Trying to query more than 100 items by raising the wix-data limit will result in an error.

Permissions

The Order collection has the following permissions:

  • Read: Admin 
  • Create: None
  • Update: None
  • Delete: None

You cannot change the Order collection's permissions. 

Fields

Note: This app collection contains read-only fields that cannot be managed from the collection. You can update the fields from the relevant app in your site’s dashboard.

The field name is listed as the heading of each section, with the field ID listed in parentheses, like this: Name (name). The fields appear in this document in the order in which they appear in your collection by default.

Number (number)

Description: Running order number.

Type: Number

Can connect to data: Yes

Can use in dynamic page URL: Yes

Can be sorted: Yes

Can be filtered: eq, ne, hasSome, le, lt, gt, ge

Read-only: Yes

ID (_id)

Description: The ID of the order. This is a system field and is hidden by default.

Type: Text

Can connect to data: Yes

Can use in dynamic page URL: No

Can be sorted: Yes

Can be filtered: eq, ne, hasSome

Read-only: Yes

Updated Date (_updatedDate)

Description: The date and time the order was last updated. This is a system field and is hidden by default.

Type: Date

Can connect to data: Yes

Can use in dynamic page URL: No

Can be sorted: Yes

Can be filtered: eq, ne, hasSome, lt, le, gt, ge

Read-only: Yes

Billing Info (billingInfo)

Description: Billing information as a JSON object.

Type: JSON

Can connect to data: No

Can use in dynamic page URL: No

Can be sorted: No

Can be filtered: No

Read-only: Yes

Copy
1
{
2
"address": {
3
"formatted": "235 W 23rd St, NYC, New York 10011, USA",
4
"city": "NYC",
5
"country": "USA",
6
"addressLine": "235 W 23rd St",
7
"addressLine2": "Apt 3",
8
"postalCode": "10011",
9
"subdivision": "NY"
10
}
11
"firstName": "John",
12
"lastName": "Doe",
13
"email": "john.doe@somedomain.com",
14
"phone": "5555555555",
15
"company" : "Company Name",
16
"vatId": {
17
"number": "452.765.395-39",
18
"type": "CPF"
19
},
20
"paidDate": "2000-05-24T21:00:00.000Z",
21
"paymentMethod": "VISA",
22
"paymentGatewayTransactionId": "29A06193U6234935D",
23
"paymentProviderTransactionId": "7c03ca74-eaf5-4541-8678-9b857634fdcb"
24
}

Buyer Info (buyerInfo)

Description: Buyer information as a JSON object.

Type: JSON

Can connect to data: No

Can use in dynamic page URL: No

Can be sorted: No

Can be filtered: No

Read-only: Yes

Note: "identityType" is one of the following:

  • "MEMBER": A logged-in site member.
  • "CONTACT": A Wix contact.
Copy
1
{
2
"id": "4kf9ka09-4e9f-a02d-972f-9a5844d9d9a2",
3
"identityType": "CONTACT",
4
"firstName": "John",
5
"lastName":"Doe",
6
"phone": "5555555555",
7
"email": "john.doe@somedomain.com"
8
}

Buyer Note (buyerNote)

Description: A note added by the buyer on the cart page when creating the order.

Type: Text

Can connect to data: Yes

Can use in dynamic page URL: No

Can be sorted: No

Can be filtered: No

Read-only: Yes

Date Created (_dateCreated)

Description: Date and time the order was created.

Type: Date

Can connect to data: Yes

Can use in dynamic page URL: No

Can be sorted: Yes

Can be filtered: eq, ne, hasSome, lt, le, gt, ge

Read-only: Yes

Currency (currency)

Description: Currency of the order.

Type: Text

Can connect to data: Yes

Can use in dynamic page URL: No

Can be sorted: No

Can be filtered: No

Read-only: Yes

Fulfillment Status (fulfillmentStatus)

Description: The status of the order's fulfillment.

Type: Text

Can connect to data: Yes

Can use in dynamic page URL: No

Can be sorted: No

Can be filtered: No

Read-only: Yes

Note: Value is one of:

  • "FULFILLED" - Order was fulfilled successfully.
  • "NOT_FULFILLED" - Order is not yet fulfilled.
  • "CANCELLED" - Order was cancelled.
  • "PARTIALLY_FULFILLED": Order was partially fulfilled.

Archived (archived)

Description: Whether the order is archived.

Type: Boolean

Can connect to data: Yes

Can use in dynamic page URL: No

Can be sorted: No

Can be filtered: eq, ne

Read-only: Yes

Line Items (lineItems)

Description: Lists all the line items for this order in an array of JSON objects.

Type: JSON

Can connect to data: No

Can use in dynamic page URL: No

Can be sorted: No

Can be filtered: No

Read-only: Yes

Note: The "lineItemType" value is one of:

  • "PHYSICAL"
  • "DIGITAL"
  • "CUSTOM_AMOUNT_ITEM" - Item with a custom price.
Copy
1
[
2
{
3
"index": 1,
4
"quantity": 1,
5
"discount": 0,
6
"tax": 5,
7
"taxGroupId": "4",
8
"name": "Black T-Shirt",
9
"translatedName": "Nombre traducido",
10
"productId": "28e0d578-64ac-7c12-b675-d1944d1c4155",
11
"sku": "364215376135191",
12
"weight": 5.2,
13
"lineItemType": "PHYSICAL",
14
"notes": "Some notes here",
15
"variantId": "0042-0005-a316f7c67df7",
16
"fulfillerId": "0000-0420-0005-a3dcfd7e6930",
17
"priceData": {
18
"price": 35,
19
"totalPrice": 40,
20
"taxIncludedInPrice": true
21
},
22
"options": [
23
{
24
"option": "Color",
25
"selection": "Red"
26
},
27
{
28
"option": "Size",
29
"selection": "Small"
30
}
31
],
32
"customTextFields": [
33
{
34
"title": "Notes for delivery",
35
"value": "Please leave at front door"
36
}
37
],
38
"mediaItem": {
39
"altText": "A description of the image",
40
"id": "nsplsh_5386255~mv2_d_2977_3951_s_4_2.jpg",
41
"externalImageUrl": "http://static.wixstatic...al_c,q_90/file.jpg",
42
"src": "wix:image://v1/.../jpg#originWidth=1000&originHeight=1000",
43
"type": "IMAGE"
44
}
45
}, ...
46
]

Activities (activities)

Description: List of activities for this order in an array of JSON objects.

Type: JSON

Can connect to data: No

Can use in dynamic page URL: No

Can be sorted: No

Can be filtered: No

Read-only: Yes

Notes: The "type" value is one of:

  • "MERCHANT_COMMENT" - A merchant comment.
  • "ORDER_PLACED" - Order placed.
  • "ORDER_PAID" - Order marked as paid, either by the store owner (for offline orders), or when an online transaction is confirmed.
  • "ORDER_FULFILLED" - Order shipping status set as fulfilled.
  • "ORDER_NOT_FULFILLED" - Order shipping status set as not fulfilled.
  • "DOWNLOAD_LINK_SENT" - Download link was sent (relevant for orders with digital line items).
  • "PICKUP_READY_EMAIL_SENT" - Email notification for pickup was sent.
  • "TRACKING_NUMBER_ADDED" - Shipping tracking number was set.
  • "TRACKING_NUMBER_EDITED" - Shipping tracking number was edited.
  • "TRACKING_LINK_WAS_SET" - Shipping tracking link was set.
  • "SHIPPING_CONFIRMATION_EMAIL_SENT" - An email confirmation of the order shipment was sent.
  • "INVOICE_WAS_SET" - Invoice was added to the order.
  • "INVOICE_WAS_REMOVED" - Invoice was removed from the order.
  • "INVOICE_WAS_SENT" - Invoice was sent to customer via email.
Copy
1
[
2
{
3
"type": "ORDER_PLACED",
4
"timestamp": "2019-01-28T15:43:28.986Z"
5
},
6
{
7
"type": "MERCHANT_COMMENT",
8
"author": "jane.doe@somedomain.com",
9
"message": "Enjoy you purchase!",
10
"timestamp": "2019-01-28T15:53:24.347Z"
11
}
12
]

Payment Status (paymentStatus)

Description: Status of the order's payment.

Type: Text

Can connect to data: Yes

Can use in dynamic page URL: No

Can be sorted: Yes

Can be filtered: eq, ne, hasSome

Read-only: Yes

Note: One of: 

  • "PAID"
  • "NOT_PAID"
  • "PARTIALLY_REFUNDED"
  • "FULLY_REFUNDED"

The "NOT_PAID" status is only for manual payment orders. Other non-paid orders, such as declined payments, do not appear in the orders collection.

Shipping Info (shippingInfo)

Description: The order's shipping information as a JSON object.

Type: JSON

Can connect to data: No

Can use in dynamic page URL: No

Can be sorted: No

Can be filtered: No

Read-only: Yes

Notes

  • Either "shipmentDetails" or "pickupDetails" will be present, but not both.
Copy
1
{
2
"deliveryOption": "PPP",
3
"estimatedDeliveryTime": "1 day",
4
"shippingRegion": "Domestic",
5
"shipmentDetails": {
6
"address": {
7
"formatted": "235 W 23rd St, NYC, New York 10011, USA",
8
"city": "NYC",
9
"country": "USA",
10
"addressLine": "235 W 23rd St",
11
"addressLine2": "Apt 3",
12
"postalCode": "10011",
13
"subdivision": "NY"
14
},
15
"firstName": "John",
16
"lastName": "Doe",
17
"email": "john.doe@somedomain.com",
18
"phoneNumber": "55555555555",
19
"company" : "Some Company",
20
"vatId": {
21
"number": "294.593.590-21",
22
"type": "CPF"
23
},
24
},
25
"pickupDetails": {
26
"buyerDetails": {
27
"firstName": "John",
28
"lastName": "Doe",
29
"email": "john.doe@somedomain.com",
30
"phoneNumber": "55555555555"
31
},
32
"pickupInstructions": "Some instructions",
33
"pickupAddress": {
34
"formatted": "235 W 23rd St, NYC, New York 10011, USA"
35
"city": "New York",
36
"country": "USA",
37
"addressLine": "235 W 23rd St",
38
"postalCode": "10011",
39
"subdivision": "NY"
40
}
41
}
42
}

Totals (totals)

Description: The order's total information as a JSON object.

Type: JSON

Can connect to data: No

Can use in dynamic page URL: No

Can be sorted: No

Can be filtered: No

Read-only: Yes

Copy
1
{
2
"discount": 0.0,
3
"quantity": 1,
4
"shipping": 0.0,
5
"subtotal": 1.0,
6
"tax": 0.0,
7
"total": 1.0,
8
"weight": 0.0
9
}

Weight Unit (weightUnit)

Description: The unit in which the order's weight is measured ("KG" or "LB").

Type: Text

Can connect to data: Yes

Can use in dynamic page URL: No

Can be sorted: No

Can be filtered: No

Read-only: Yes

Custom Field (customField)

Description: Information about a custom field added to the checkout process as a JSON object.

Type: JSON

Can connect to data: No

Can use in dynamic page URL: No

Can be sorted: No

Can be filtered: No

Read-only: Yes

Copy
1
{
2
"title": "Notes for delivery",
3
"translatedTitle": "Notas de entrega",
4
"value": "Please call when outside"
5
}

Fulfillments (fulfillments)

Description: Lists of fulfillments for this order in an array of JSON objects.

Type: JSON

Can connect to data: No

Can use in dynamic page URL: No

Can be sorted: No

Can be filtered: No

Read-only: Yes

Copy
1
[
2
{
3
"id": "8",
4
"dateCreated": "2020-04-20T21:00:00.000Z",
5
"lineItems": [
6
{
7
"index": 1,
8
"quantity": 1
9
}
10
],
11
"trackingInfo": {
12
"trackingNumber": "449044304137821",
13
"shippingProvider": "FEDEX",
14
"trackingLink": "https://www.fedex.com/...trackingnumber=449044304137821",
15
}
16
}
17
]

Buyer Language (buyerLanguage)

Description: The site's displayed language.

Type: Text

Can connect to data: Yes

Can use in dynamic page URL: No

Can be sorted: No

Can be filtered: No

Read-only: Yes

Cart ID (cartId)

Description: The shopping cart's unique ID.

Type: Text

Can connect to data: Yes

Can use in dynamic page URL: No

Can be sorted: No

Can be filtered: No

Read-only: Yes

Channel Info (channelInfo)

Description: Information about the sales channel that submitted the order, as a JSON object.

Type: JSON

Can connect to data: No

Can use in dynamic page URL: No

Can be sorted: No

Can be filtered: No

Read-only: Yes

Copy
1
{
2
"externalOrderId": "03-04896-40604",
3
"externalOrderUrl": "http://www.eBay.com/sh/ord/details?orderid=03-04896-40604",
4
"type": "EBAY"
5
}

Entered By (enteredBy)

Description: Information about the identity of the order's operator as a JSON object.

Type: JSON

Can connect to data: No

Can use in dynamic page URL: No

Can be sorted: No

Can be filtered: No

Read-only: Yes

Note: The identityType value - the order was created by one of the following:

  • "USER" - Wix user who performed a POS transaction on behalf of the buyer.
  • "MEMBER" - Logged-in site member.
  • "CONTACT" - A Wix contact.
Copy
1
{
2
"id": "f6c2c0f9-4e9f-a58d-a02d-9af2497294d9",
3
"identityType": "MEMBER"
4
}

Refunds (refunds)

Description: Information about order refunds in an array of JSON objects.

Type: JSON

Can connect to data: No

Can use in dynamic page URL: No

Can be sorted: No

Can be filtered: No

Read-only: Yes

Note: Details about externalRefund boolean field:

  • Indicates whether the refund was made externally.
  • An external refund refers to refunds processed by the payment provider and reported to the Wix orders system.
  • When the value is false, the refund was reported to the Wix orders system but was not processed by the payment provider.
Copy
1
[
2
{
3
"id": "caa2918c-6d38-08df-b484-09b702099e2b",
4
"dateCreated": "2021-01-13T08:20:31.638Z",
5
"amount": "26.4",
6
"reason": "returned",
7
"externalRefund": true,
8
"paymentProviderTransactionId": "19615318-2134-4160-b886-cdde9c7ae88e"
9
},
10
{
11
"id": "7079923b-1c65-1c7a-37c9-3733de32ea1d",
12
"dateCreated": "2021-01-13T08:26:09.419Z",
13
"amount": "60.0",
14
"externalRefund": false
15
}
16
]

Subscription Information (subscriptionInfo)

Description: Information about an order's subscription as a JSON object.

Type: JSON

Can connect to data: No

Can use in dynamic page URL: No

Can be sorted: No

Can be filtered: No

Read-only: Yes

Note: 'frequency' field - frequency of recurring payment. One of:

  • "DAY" - Daily
  • "WEEK" - Weekly
  • "MONTH" - Monthly
  • "YEAR" - Yearly
Copy
1
{
2
"subscriptionInfo": {
3
"id": "9275fb37-5377-434e-a484-6b6933896bc3",
4
"cycleNumber": 3,
5
"subscriptionSettings": {
6
"frequency": "WEEK",
7
"autoRenewal": true,
8
"billingCycles": 1
9
},
10
"subscriptionOptionInfo": {
11
"id": "0a7c4732-09c8-430c-b94e-f189cc0ce25a",
12
"title": "Weekly",
13
"description": "Weekly subscription"
14
}
15
}
16
}
Was this helpful?
Yes
No