CData Python Connector for Shopify

Build 23.0.8839

FulfillmentOrders

Query fulfillment orders.

View-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the OrderId and Id columns. The connector processes other filters client-side within the connector. For example, the following queries are processed server-side.
SELECT * FROM FulfillmentOrders WHERE OrderId = '1'

SELECT * FROM FulfillmentOrders WHERE Id = '1'

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839