GuestShippingMethods
GuestShippingMethods 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.
You must specify the CartId column in the WHERE clause to retrieve results from GuestShippingMethods. CartId can be used only with the equals (=) operator.
For example:
SELECT * FROM [GuestShippingMethods] WHERE CartId = '123'
Columns
| Name | Type | Description |
| Amount | Double | Shipping amount in store currency. |
| CartId | String | cartId |
| Available | Bool | The value of the availability flag for the current shipping method. |
| BaseAmount | Double | Shipping amount in base currency. |
| CarrierCode | String | Shipping carrier code. |
| CarrierTitle | String | Shipping carrier title. Otherwise, null. |
| ErrorMessage | String | Shipping Error message. |
| ExtensionAttributes | String | This is an auto-generated column |
| MethodCode [KEY] | String | Shipping method code. |
| MethodTitle | String | Shipping method title. Otherwise, null. |
| PriceExclTax | Double | Shipping price excl tax. |
| PriceInclTax | Double | Shipping price incl tax. |