QuoteGuestCart
QuoteGuestCart is an auto generated table. The supported operations are Querying data from this table.
Table Specific Information
Select
The add-in uses the AdobeCommerce API to filter the results by CartId while the rest of the filter is executed client side within the add-in.
The CartId column must be specified in the WHERE clause to retrieve results from QuoteGuestCart. CartId can be used only with the equals (=) operator.
For example:
SELECT * FROM [QuoteGuestCart] WHERE CartId = '123'
Columns
| Name | Type | Description |
| Id [KEY] | Int | Cart/quote ID. |
| CartId | String | cartId |
| BillingAddress | String | This is an auto-generated column |
| ConvertedAt | String | Cart conversion date and time. Otherwise, null. |
| CreatedAt | Datetime | Cart creation date and time. Otherwise, null. |
| Currency | String | This is an auto-generated column |
| Customer | String | This is an auto-generated column |
| CustomerIsGuest | Bool | For guest customers, false for logged in customers |
| CustomerNote | String | Notice text |
| CustomerNoteNotify | Bool | Customer notification flag |
| CustomerTaxClassId | Int | Customer tax class ID. |
| ExtensionAttributes | String | This is an auto-generated column |
| IsActive | Bool | Active status flag value. Otherwise, null. |
| IsVirtual | Bool | Virtual flag value. Otherwise, null. |
| Items | String | Array of items. Otherwise, null. |
| ItemsCount | Int | Number of different items or products in the cart. Otherwise, null. |
| ItemsQty | Double | Total quantity of all cart items. Otherwise, null. |
| OrigOrderId | Int | Original order ID. Otherwise, null. |
| ReservedOrderId | Int | Reserved order ID. Otherwise, null. |
| StoreId | Int | Store identifier |
| UpdatedAt | Datetime | Cart last update date and time. Otherwise, null. |