CData Python Connector for Shopify

Build 25.0.9454

FulfillmentOrders

Contains records of fulfillment orders, representing groupings of items to be shipped from a specific location.

Table-Specific Information

Select

The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.

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

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

  SELECT * FROM FulfillmentOrders WHERE Id = 'Val1'
  SELECT * FROM FulfillmentOrders WHERE Status = 'open'
  SELECT * FROM FulfillmentOrders WHERE AssignedLocationLocationId = 'Val1'
  SELECT * FROM FulfillmentOrders WHERE OrderId = 'Val1'

Update

The following column can be updated:

Status

Columns

Name Type ReadOnly References Description
Id [KEY] String True

A globally unique identifier for the fulfillment order record.

Status String False

The current state of the fulfillment order.

The allowed values are open, closed, cancelled, in_progress, incomplete, on_hold, scheduled.

FulfillAt Datetime True

The scheduled date and time when the fulfillment order becomes eligible for fulfillment. For example, a subscription order may have a future fulfill_at date each month, while a standard order is typically fulfillable immediately after creation.

FulfillBy Datetime True

The latest date and time by which all items in the fulfillment order must be fulfilled to meet delivery expectations.

OrderName String True

The unique order reference name displayed on the order page within Shopify Admin.

RequestStatus String True

The current request status of the fulfillment order, such as pending, accepted, rejected, or cancellation_requested.

CreatedAt Datetime True

The timestamp representing when the fulfillment order was initially created in Shopify.

UpdatedAt Datetime True

The timestamp representing the most recent update made to the fulfillment order record.

OrderProcessedAt Datetime True

The date and time when the original order associated with this fulfillment order was processed.

AssignedLocationName String True

The display name of the location assigned to fulfill this order.

AssignedLocationAddress1 String True

The first line of the street address for the assigned fulfillment location.

AssignedLocationAddress2 String True

The second line of the street address for the assigned fulfillment location, if applicable.

AssignedLocationCity String True

The city where the assigned fulfillment location is based.

AssignedLocationPhone String True

The contact phone number of the assigned fulfillment location.

AssignedLocationProvince String True

The province, state, or regional subdivision where the assigned fulfillment location is situated.

AssignedLocationZip String True

The postal or ZIP code of the assigned fulfillment location.

AssignedLocationCountryCode String True

The two-letter ISO country code representing the assigned fulfillment location.

AssignedLocationLocationId String True

A globally unique identifier for the assigned fulfillment location.

AssignedLocationLocationLegacyResourceId String True

The legacy REST Admin API identifier for the assigned location resource.

AssignedLocationLocationName String True

The name of the assigned location as it appears in the store's location list.

AssignedLocationLocationActivatable Bool True

Indicates whether this location can be reactivated after being deactivated.

AssignedLocationLocationDeactivatable Bool True

Indicates whether this location can be deactivated from active use.

AssignedLocationLocationDeletable Bool True

Specifies whether the location can be permanently deleted from the store.

AssignedLocationLocationAddressVerified Bool True

Indicates whether the location's address has been verified for accuracy within Shopify.

AssignedLocationLocationDeactivatedAt String True

The date and time when the location was deactivated, formatted in UTC. For example: '2019-09-07T15:50:00Z'.

AssignedLocationLocationIsActive Bool True

Indicates whether the location is currently active and operational for fulfillment.

AssignedLocationLocationShipsInventory Bool True

Specifies whether this location contributes inventory to shipping rate calculations. Ignored in multi-origin shipping mode.

AssignedLocationLocationFulfillsOnlineOrders Bool True

Indicates whether this location can fulfill online store orders.

AssignedLocationLocationHasActiveInventory Bool True

Shows whether the location currently maintains active inventory for assigned products.

AssignedLocationLocationHasUnfulfilledOrders Bool True

Indicates whether this location currently has pending orders awaiting fulfillment.

DeliveryMethodId String True

A globally unique identifier for the delivery method applied to the fulfillment order.

DeliveryMethodPresentedName String True

The delivery method name displayed to the customer at checkout, such as Standard Shipping or Express Delivery.

DeliveryMethodMethodType String True

The type of delivery method, such as local_delivery, shipping, or pickup.

DeliveryMethodMaxDeliveryDateTime Datetime True

The latest estimated date and time the order is expected to arrive at the customer's location.

DeliveryMethodMinDeliveryDateTime Datetime True

The earliest estimated date and time the order may arrive at the customer's location.

DeliveryMethodServiceCode String True

The carrier service code that identifies the shipping method selected for the order.

DeliveryMethodSourceReference String True

Provider-specific metadata associated with the delivery promise, typically used by shipping or logistics integrations.

DeliveryMethodBrandedPromiseName String True

The name of the branded delivery promise shown to the buyer, such as 'Shop Promise'.

DeliveryMethodBrandedPromiseHandle String True

The internal handle representing the branded delivery promise, such as 'shop_promise'.

DeliveryMethodAdditionalInformationPhone String True

The phone number to contact when executing the delivery or resolving delivery-related issues.

DeliveryMethodAdditionalInformationInstructions String True

Special delivery instructions provided for the carrier or delivery personnel.

DestinationId String True

A globally unique identifier representing the destination record for this fulfillment order.

DestinationFirstName String True

The first name of the recipient at the fulfillment destination.

DestinationLastName String True

The last name of the recipient at the fulfillment destination.

DestinationAddress1 String True

The first line of the destination address, typically the street address.

DestinationAddress2 String True

The second line of the destination address, such as apartment or suite number.

DestinationCity String True

The city where the fulfillment order is being delivered.

DestinationCompany String True

The company name associated with the fulfillment destination, if applicable.

DestinationEmail String True

The email address of the customer or recipient at the destination.

DestinationPhone String True

The contact phone number for the customer or recipient at the destination.

DestinationProvince String True

The province, state, or region of the delivery destination.

DestinationZip String True

The postal or ZIP code of the delivery destination.

DestinationCountryCode String True

The two-letter ISO country code representing the fulfillment destination.

DestinationLocationId String True

A globally unique identifier for the destination location record, if applicable.

InternationalDutiesIncoterm String True

Specifies the incoterm that defines responsibility for duties and taxes, such as 'DDP' (Delivered Duty Paid) or 'DAP' (Delivered at Place).

OrderId String True

A globally unique identifier linking this fulfillment order back to its parent Shopify order.

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