FulfillmentServices

Query, create, update, and delete information regarding different fulfillment services.

Table-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the Id column. The supported SQL operator is '='. The connector processes other filters client-side within the connector.

For example, the following queries are processed server-side:

SELECT * FROM FulfillmentServices WHERE Id = '123'

Insert

You must specify the Name, CallbackUrl, and Format to create a fulfillment service.

INSERT INTO FulfillmentServices (Name, CallbackUrl, Format) VALUES ('testing fulfillment services', 'http://google.com', 'json')

Update

You must specify the Id to update a fulfillment service. For example:

UPDATE FulfillmentServices SET Name = 'test32', IncludePendingStock = true WHERE Id = '123'

Delete

You must specify the Id of the fulfillment service to delete it.

DELETE FROM FulfillmentServices WHERE Id = '123'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		A unique numeric identifier for the fulfillment service.
LocationId	Long	True	Locations.Id	The unique identifier of the location tied to the fulfillment service.
ProviderId	String	True		A unique identifier for the fulfillment service provider.
Name	String	False		The name of the fulfillment service as seen by merchants and their customers.
Handle	String	True		A human-friendly unique string for the fulfillment service generated from its title.
ServiceName	String	True		The name of the fulfillment service.
Email	String	False		The email of the fulfillment service.
IncludePendingStock	Bool	False		States if the fulfillment service includes a pending stock.
RequiresShippingMethod	Bool	False		States if the fulfillment service requires products to be physically shipped. Valid values are 'true' and 'false'.
TrackingSupport	Bool	False		States if the fulfillment service provides tracking numbers for packages. Valid values are
InventoryManagement	Bool	False		States if the fulfillment service tracks product inventory and provides updates to Shopify. Valid values are
FulfillmentOrdersOptIn	Bool	False		States if the fulfillment orders is opt in.
CallbackUrl	String	False		States the URL endpoint that Shopify needs to retrieve inventory and tracking updates. This field is necessary if either inventory_management or tracking_support is set to
Format	String	False		Specifies the format of the API output. Valid values are json and xml.