Excel Add-In for Adobe Commerce

Build 24.0.9062

GuestShippingMethods

GuestShippingMethods is an auto generated table. The supported operations are Querying data from this table.

Table Specific Information

Select

The 本製品 uses the AdobeCommerce API to filter the results by CartId while the rest of the filter is executed client side within the 本製品.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062