CData Python Connector for Shopify

Build 25.0.9454

FulfillmentOrders

Retrieves fulfillment order records, representing items to be shipped from a specific location.

Columns

Name Type References Description
Id [KEY] Long A unique numeric identifier for the fulfillment order.
ShopId Long

Shop.Id

The unique numeric identifier for the shop associated with this fulfillment order.
OrderId [KEY] Long

Orders.Id

The unique numeric identifier for the order linked to this fulfillment order.
AssignedLocationId Long The unique numeric identifier for the location assigned to fulfill this order.
DestinationId String The unique identifier for the fulfillment order destination.
DestinationAddress1 String The first line of the destination address, typically the street address or PO box.
DestinationAddress2 String The second line of the destination address, often used for apartment, suite, or unit numbers.
DestinationCity String The city portion of the destination address.
DestinationCompany String The company name associated with the destination address, if applicable.
DestinationFirstName String The first name of the recipient at the destination address.
DestinationLastName String The last name of the recipient at the destination address.
DestinationPhone String The phone number associated with the destination address.
FullfillAt Datetime The date and time (in UTC) when the fulfillment order becomes ready for fulfillment.
LineItems String A JSON aggregate containing all line items included in this fulfillment order.
RequestStatus String The current state of the fulfillment request, such as 'open', 'in_progress', or 'completed'.
Status String The overall status of the fulfillment order, indicating its progress or completion state.
SupportedActions String The set of actions that can currently be performed on this fulfillment order, such as 'cancel', 'hold', or 'fulfill'.
MerchantRequests String A list of requests sent by the merchant to the fulfillment service related to this fulfillment order.
FulfillmentHolds String Information about any holds or restrictions currently applied to the fulfillment order.
InternationalDuties String Details about international duties or import fees associated with this fulfillment order.
AssignedLocationAddress1 String The first line of the address for the assigned fulfillment location.
AssignedLocationAddress2 String An optional second line for the assigned fulfillment location address, such as suite or unit number.
AssignedLocationCity String The city where the assigned fulfillment location is situated.
AssignedLocationCountryCode String The two-letter ISO 3166-1 alpha-2 country code of the assigned location.
AssignedLocationName String The name of the assigned fulfillment location.
AssignedLocationPhone String The phone number of the assigned fulfillment location.
DeliveryMethodId Long The unique identifier for the delivery option chosen by the buyer during checkout.
DeliveryMethodPresentedName String The display name of the delivery option shown to the buyer during checkout.
DeliveryMethodType String The type of delivery method used, such as 'standard', 'express', or 'pickup'.

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