FulfillmentServices
Query, create, update, and delete information regarding different fulfillment services.
Table-Specific Information
Select
The driver uses the Shopify API to process search criteria that refer to the Id column. The supported SQL operator is '='. The driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
For example, the following queries are processed server side:
SELECT * FROM FulfillmentServices
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. | |
String | False |
The email of the fulfillment service. | ||
IncludePendingStock | Boolean | False |
States if the fulfillment service includes a pending stock. | |
RequiresShippingMethod | Boolean | False |
States if the fulfillment service requires products to be physically shipped. Valid values are 'true' and 'false'. | |
TrackingSupport | Boolean | False |
States if the fulfillment service provides tracking numbers for packages. Valid values are | |
InventoryManagement | Boolean | False |
States if the fulfillment service tracks product inventory and provides updates to Shopify. Valid values are | |
FulfillmentOrdersOptIn | Boolean | True |
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. |