CData Python Connector for Shopify

Build 23.0.8839

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.

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