CData Python Connector for Shopify

Build 23.0.8839

FulfillmentOrders

Retrieves a paginated list of merchant-managed and third-party fulfillment orders.

Table-Specific Information

Select

The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators:

  • Id supports the '=,IN' comparison operators.
  • Status supports the '=,!=' comparison operators.
  • AssignedLocationLocationId supports the '=,!=' comparison operators.

The connector processes other filters client-side within the connector.

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

SELECT * FROM FulfillmentOrders WHERE Id='VALUE'

SELECT * FROM FulfillmentOrders WHERE Status='VALUE'

SELECT * FROM FulfillmentOrders WHERE AssignedLocationLocationId='VALUE'

UPDATE

UPDATE statements are mapped to the 'dynamic_depends_on_status' GraphQL mutation.

The following column can be updated:

Status

Columns

Name Type ReadOnly References Description
Id [KEY] String True

A globally-unique ID.

Status String False

The status of the fulfillment order.

FulfillAt Datetime True

The date and time at which the fulfillment order will be fulfillable. When this date and time is reached, the scheduled fulfillment order is automatically transitioned to open. For example, the 'fulfill_at' date for a subscription order might be the 1st of each month, a pre-order 'fulfill_at' date would be 'nil', and a standard order 'fulfill_at' date would be the order creation date.

FulfillBy Datetime True

The latest date and time by which all items in the fulfillment order need to be fulfilled.

RequestStatus String True

The request status of the fulfillment order.

CreatedAt Datetime True

Date and time when the fulfillment order was created.

UpdatedAt Datetime True

The date and time when the fulfillment order was last updated.

AssignedLocationName String True

The name of the location.

AssignedLocationAddress1 String True

The first line of the address for the location.

AssignedLocationAddress2 String True

The second line of the address for the location.

AssignedLocationCity String True

The city of the location.

AssignedLocationPhone String True

The phone number of the location.

AssignedLocationProvince String True

The province of the location.

AssignedLocationZip String True

The ZIP code of the location.

AssignedLocationCountryCode String True

The two-letter country code of the location.

AssignedLocationLocationId String True

A globally-unique ID.

AssignedLocationLocationLegacyResourceId String True

The ID of the corresponding resource in the REST Admin API.

AssignedLocationLocationName String True

The name of the location.

AssignedLocationLocationActivatable Bool True

Whether this location can be reactivated.

AssignedLocationLocationDeactivatable Bool True

Whether this location can be deactivated.

AssignedLocationLocationDeletable Bool True

Whether this location can be deleted.

AssignedLocationLocationAddressVerified Bool True

Whether the location address has been verified.

AssignedLocationLocationDeactivatedAt String True

The date and time that the location was deactivated at. For example, 3: 30 pm on September 7, 2019 in the time zone of UTC (Universal Time Coordinated) is represented as '2019-09-07T15: 50: 00Z'.

AssignedLocationLocationIsActive Bool True

Whether the location is active.

AssignedLocationLocationShipsInventory Bool True

Whether this location is used for calculating shipping rates. In multi-origin shipping mode, this flag is ignored.

AssignedLocationLocationFulfillsOnlineOrders Bool True

Whether this location can fulfill online orders.

AssignedLocationLocationHasActiveInventory Bool True

Whether this location has active inventory.

AssignedLocationLocationHasUnfulfilledOrders Bool True

Whether this location has orders that need to be fulfilled.

DeliveryMethodId String True

A globally-unique ID.

DeliveryMethodMethodType String True

The type of the delivery method.

DeliveryMethodMaxDeliveryDateTime Datetime True

The latest delivery date and time when the fulfillment is expected to arrive at the buyer's location.

DeliveryMethodMinDeliveryDateTime Datetime True

The earliest delivery date and time when the fulfillment is expected to arrive at the buyer's location.

DestinationId String True

A globally-unique ID.

DestinationFirstName String True

The first name of the customer at the destination.

DestinationLastName String True

The last name of the customer at the destination.

DestinationAddress1 String True

The first line of the address of the destination.

DestinationAddress2 String True

The second line of the address of the destination.

DestinationCity String True

The city of the destination.

DestinationCompany String True

The company of the destination.

DestinationEmail String True

The email of the customer at the destination.

DestinationPhone String True

The phone number of the customer at the destination.

DestinationProvince String True

The province of the destination.

DestinationZip String True

The ZIP code of the destination.

DestinationCountryCode String True

The two-letter country code of the destination.

InternationalDutiesIncoterm String True

The method of duties payment. Example values: 'DDP', 'DAP'.

OrderId String True

A globally-unique ID.

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