Velo: Wix Stores "AbandonedCarts" Collection Fields

In this article

Permissions
Fields
ID (_id)
Buyer Info (buyerInfo)
Date Abandoned (abandonTime)
Status (status)
Activities (activities)
Total (total)

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

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

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

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

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

Permissions

The AbandonedCarts collection has the following permissions:

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

You cannot change the AbandonedCarts 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.

ID (_id)

Description: The ID of the abandoned cart. This is a system field and is hidden by default.
Type: Text
Can connect to data: Yes
Can use in dynamic page URL: Yes
Can be sorted: Yes
Can be filtered: eq, ne, hasSome, contains, startsWith
Read-only: Yes

Buyer Info (buyerInfo)

Description: Buyer information as a JSON object.
Type: Object
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": Buyer is a logged-in site member.
"CONTACT": A contact has been created for the buyer.

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}

1// filter a dataset by Buyer Info ID
2
3import wixData from 'wix-data';
4
5$w("#myDataset").setFilter(wixData.filter()
6    .eq("buyerInfo.id", ["5ceea2d0-a537-41dc-a51e-51fc8645afd9"]))

Date Abandoned (abandonTime)

Description: Time the cart was abandoned.
Type: Date
Can connect to data: Yes
Can use in dynamic page URL: No
Can be sorted: Yes
Can be filtered: Yes
Read-only: Yes

Status (status)

Description: Status of the abandoned cart.
Type: Text
Can connect to data: Yes
Can use in dynamic page URL: Yes
Can be sorted: Yes
Can be filtered: eq, ne
Read-only: Yes
Notes: Either "ABANDONED" or "RECOVERED".

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:

"UNRECOGNIZED_TYPE"
"SCHEDULED"
"EMAIL_SENT"
"EMAIL_NOT_SENT"
"NOTIFICATION_SENT"
"TASK_CREATED"
"CUSTOM_ACTIVITY"

1[
2  {
3    "type": "SCHEDULED",
4    "timestamp": "2019-01-28T15:43:28.986Z"
5  },
6  {
7    "type": "EMAIL_SENT",
8    "timestamp": "2019-01-28T15:53:24.347Z"
9  }
10]

Total (total)

Description: The order total.
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

Did this help?

Hire a Velo Web DeveloperNeed a little extra help with your site? Hire a developer from the Wix Marketplace to build and deploy advanced web applications.

Start Now

Helpmate

Hello

Need a bit more guidance?

Unlock personalized helpLog in to get the most out of Helpmate.