FulfillmentServices

Lists fulfillment services that prepare and ship orders on behalf of the merchant.

Table-Specific Information

The connector processes all filters client-side within the connector. The following query is the only one processed server-side:

  SELECT * FROM FulfillmentServices

The following columns can be used to create a new record:

ServiceName, CallbackUrl, InventoryManagement, RequiresShippingMethod

The following columns can be updated:

ServiceName, CallbackUrl, InventoryManagement, RequiresShippingMethod

You can delete entries by specifying the following columns:

Id, LocationId


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The globally unique identifier of the fulfillment service.
ServiceName	String	False		The name of the fulfillment service as displayed to merchants.
Handle	String	True		A human-readable, unique string that identifies the fulfillment service.
Type	String	True		The type of the fulfillment service.
CallbackUrl	String	False		The callback URL that the fulfillment service registers to receive requests from Shopify.
InventoryManagement	Bool	False		Indicates whether the fulfillment service tracks product inventory and provides updates to Shopify.
PermitsSkuSharing	Bool	True		Indicates whether the fulfillment service can stock inventory alongside other locations.
RequiresShippingMethod	Bool	False		Indicates whether the fulfillment service requires products to be physically shipped.
TrackingSupport	Bool	True		Indicates whether the fulfillment service supports tracking numbers through the /fetch_tracking_numbers endpoint.
LocationId	String	True		The globally unique identifier of the location associated with the fulfillment service.

疑似カラムは、明示的にリストされているタイプのステートメントでのみ使用できるフィールドです。これらは標準的なカラムではなく、特定の操作のための追加機能を提供するものです。

Name

Type

Description

InventoryAction

String

Specifies the action to take with the location after the fulfillment service is deleted.

使用できる値は次のとおりです。DELETE, KEEP, TRANSFER