ODBC Driver for Shopify

Build 24.0.9062

AssignedFulfillmentOrders

The AssignedFulfillmentOrder resource allows you to retrieve all the fulfillment orders that are assigned to an app at the shop level.

View-Specific Information

Select

The 本製品 uses the Shopify API to process search criteria that refer to the AssignedLocationId and RequestStatus columns. The 本製品 processes other filters client-side within the 本製品. For example, the following queries are processed server-side.
SELECT * FROM AssignedFulfillmentOrders WHERE AssignedLocationId IN (1, 2)

SELECT * FROM AssignedFulfillmentOrders WHERE RequestStatus = 'cancellation_requested'

Columns

Name Type References Description
Id [KEY] Long The ID of the fulfillment order.
ShopId Long

Shop.Id

The ID of the shop that's associated with the fulfillment order.
OrderId 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.
FulfillmentServiceHandle String A unique numeric identifier for the order.
RequestStatus String The status of the fulfillment.
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.
LineItems String Represents line items belonging to a fulfillment order.
Status String The status of the fulfillment order.
Operation String An operation to apply to the fulfillment. Complete, Open, or Cancel.

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