SSIS Components for Shopify

Build 25.0.9434

FulfillmentServices

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

Table-Specific Information

Select

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

  SELECT * FROM FulfillmentServices

Insert

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

ServiceName, CallbackUrl, InventoryManagement, RequiresShippingMethod

Update

The following columns can be updated:

ServiceName, CallbackUrl, InventoryManagement, RequiresShippingMethod

Delete

You can delete entries by specifying the following columns:

Id, LocationId

Columns

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.

Pseudo-Columns

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

Name Type Description
InventoryAction String

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

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

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434