QuoteGuestCart
QuoteGuestCart is an auto generated table. The supported operations are Querying data from this table.
Table Specific Information
Select
The connector uses the AdobeCommerce API to filter the results by CartId while the rest of the filter is executed client side within the connector.
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. |