JDBC Driver for Shopify

Build 25.0.9434

FulfillmentOrders

Query fulfillment orders.

Columns

Name Type References Description
Id [KEY] Long An ID for the fulfillment order.
ShopId Long

Shop.Id

The ID of the shop that's associated with the fulfillment order.
OrderId [KEY] Long

Orders.Id

The ID of the order that's associated with the fulfillment order.
AssignedLocationId Long The ID of the location that has been assigned to do the work.
DestinationId String The ID of the fulfillment order destination.
DestinationAddress1 String The first line of the address of the destination.
DestinationAddress2 String The second line of the address of the destination.
DestinationCity String The city of the destination.
DestinationCompany String The company of the destination.
DestinationFirstName String The first name of the customer at the destination.
DestinationLastName String The last name of the customer at the destination.
DestinationPhone String The phone number of the customer at the destination.
FullfillAt Datetime The datetime (in UTC) when the fulfillment order is ready for fulfillment.
LineItems String Represents line items belonging to a fulfillment order.
RequestStatus String The status of the fulfillment.
Status String The status of the fulfillment order.
SupportedActions String The actions that can be performed on this fulfillment order.
MerchantRequests String A list of requests sent by the merchant to the fulfillment service for this fulfillment order..
FulfillmentHolds String Represents the fulfillment holds applied on the fulfillment order.
InternationalDuties String The international duties relevant to the fulfillment order.
AssignedLocationAddress1 String The street address of the assigned location
AssignedLocationAddress2 String An optional additional field for the street address of the assigned location.
AssignedLocationCity String The city of the assigned location.
AssignedLocationCountryCode String The two-letter code for the country of the assigned location
AssignedLocationName String The name of the assigned location.
AssignedLocationPhone String The phone number of the assigned location.
DeliveryMethodId Long The ID of the delivery option that was presented to the buyer during checkout.
DeliveryMethodPresentedName String The name of the delivery option that was presented to the buyer during checkout.
DeliveryMethodType String The type of the delivery option that was presented to the buyer during checkout.

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