SSIS Components for Shopify

Build 25.0.9434

FulfillmentOrders

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

Table-Specific Information

Select

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

  • 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.

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