QuoteCartItem
QuoteCartItem is an auto generated table. The supported operations are Insert, Update, Delete, and 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 QuoteCartItem. CartId can be used only with the equals (=) operator.
For example:
SELECT * FROM [QuoteCartItem] WHERE CartId = '123'
Columns
| Name | Type | ReadOnly | Description |
| ExtensionAttributes | String | False |
This is an auto-generated column |
| CartId | String | False |
cartId |
| ItemId | Int | False |
Item ID. Otherwise, null. |
| Name | String | False |
Product name. Otherwise, null. |
| Price | Double | False |
Product price. Otherwise, null. |
| ProductOption | String | False |
This is an auto-generated column |
| ProductType | String | False |
Product type. Otherwise, null. |
| Qty | Double | False |
Product quantity. |
| QuoteId [KEY] | String | False |
Quote id. |
| Sku | String | False |
Product SKU. Otherwise, null. |