FulfillmentOrders

Lists merchant-managed and third-party fulfillment orders with statuses and assignments.

Table-Specific Information

Select

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

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		The globally unique identifier of the fulfillment order.
Status	String	False		The current status of the fulfillment order. The allowed values are open, closed, cancelled, in_progress, incomplete, on_hold, scheduled.
FulfillAt	Datetime	True		The date and time when the fulfillment order becomes fulfillable. At this time, a scheduled fulfillment order automatically transitions to 'open'. For example, subscription orders might have a monthly fulfill_at date, pre-orders might be null, and standard orders typically use the order creation date.
FulfillBy	Datetime	True		The latest date and time by which all items in the fulfillment order must be fulfilled.
OrderName	String	True		The unique order identifier displayed on the order page.
RequestStatus	String	True		The current request status of the fulfillment order.
CreatedAt	Datetime	True		The date and time when the fulfillment order was created.
UpdatedAt	Datetime	True		The date and time when the fulfillment order was last updated.
OrderProcessedAt	Datetime	True		The date and time when the fulfillment order was processed.
AssignedLocationName	String	True		The name of the assigned fulfillment location.
AssignedLocationAddress1	String	True		The first line of the assigned location's address.
AssignedLocationAddress2	String	True		The second line of the assigned location's address.
AssignedLocationCity	String	True		The city of the assigned location.
AssignedLocationPhone	String	True		The phone number of the assigned location.
AssignedLocationProvince	String	True		The province or region of the assigned location.
AssignedLocationZip	String	True		The ZIP or postal code of the assigned location.
AssignedLocationCountryCode	String	True		The two-letter ISO country code of the assigned location.
AssignedLocationLocationId	String	True		The globally unique identifier of the assigned location.
AssignedLocationLocationLegacyResourceId	String	True		The legacy identifier of the assigned location in the REST Admin API.
AssignedLocationLocationName	String	True		The display name of the assigned location.
AssignedLocationLocationActivatable	Bool	True		Indicates whether the location can be reactivated.
AssignedLocationLocationDeactivatable	Bool	True		Indicates whether the location can be deactivated.
AssignedLocationLocationDeletable	Bool	True		Indicates whether the location can be deleted.
AssignedLocationLocationAddressVerified	Bool	True		Indicates whether the location's address has been verified.
AssignedLocationLocationDeactivatedAt	String	True		The date and time when the location was deactivated, in UTC. Example: '2019-09-07T15:50:00Z'.
AssignedLocationLocationIsActive	Bool	True		Indicates whether the location is active.
AssignedLocationLocationShipsInventory	Bool	True		Indicates whether this location is used to calculate shipping rates. In multi-origin shipping mode, this flag is ignored.
AssignedLocationLocationFulfillsOnlineOrders	Bool	True		Indicates whether this location can fulfill online orders.
AssignedLocationLocationHasActiveInventory	Bool	True		Indicates whether this location has active inventory.
AssignedLocationLocationHasUnfulfilledOrders	Bool	True		Indicates whether this location has unfulfilled orders.
DeliveryMethodId	String	True		The globally unique identifier of the delivery method.
DeliveryMethodPresentedName	String	True		The name of the delivery option presented to the buyer at checkout.
DeliveryMethodMethodType	String	True		The type of delivery method for the fulfillment order, such as shipping, local delivery, or pickup.
DeliveryMethodMaxDeliveryDateTime	Datetime	True		The latest date and time when the fulfillment is expected to arrive at the destination.
DeliveryMethodMinDeliveryDateTime	Datetime	True		The earliest date and time when the fulfillment is expected to arrive at the destination.
DeliveryMethodServiceCode	String	True		The reference code of the shipping method.
DeliveryMethodSourceReference	String	True		Provider-specific data associated with the delivery promise.
DeliveryMethodBrandedPromiseName	String	True		The display name of the branded delivery promise. For example: 'Shop Promise'.
DeliveryMethodBrandedPromiseHandle	String	True		The handle identifier of the branded delivery promise. For example: 'shop_promise'.
DeliveryMethodAdditionalInformationPhone	String	True		The phone number to contact regarding delivery.
DeliveryMethodAdditionalInformationInstructions	String	True		Special delivery instructions for the carrier.
DestinationId	String	True		The globally unique identifier of the destination address.
DestinationFirstName	String	True		The first name of the recipient at the destination.
DestinationLastName	String	True		The last name of the recipient at the destination.
DestinationAddress1	String	True		The first line of the destination address.
DestinationAddress2	String	True		The second line of the destination address.
DestinationCity	String	True		The city of the destination address.
DestinationCompany	String	True		The company name associated with the destination address.
DestinationEmail	String	True		The email address of the recipient at the destination.
DestinationPhone	String	True		The phone number of the recipient at the destination.
DestinationProvince	String	True		The province or region of the destination address.
DestinationZip	String	True		The ZIP or postal code of the destination address.
DestinationCountryCode	String	True		The two-letter ISO country code of the destination address.
DestinationLocationId	String	True		The globally unique identifier of the destination location.
InternationalDutiesIncoterm	String	True		The duties payment method for international shipments. Example values: 'DDP' (Delivered Duty Paid), 'DAP' (Delivered At Place).
OrderId	String	True		The globally unique identifier of the related order.

ODBC Driver for Shopify

FulfillmentOrders

Table-Specific Information

Select

Update

Columns