ODBC Driver for Shopify

Build 24.0.9062

AssignedFulfillmentOrders

Retrieves a paginated list of fulfillment orders assigned to the shop locations owned by the app. Assigned fulfillment orders are fulfillment orders that are set to be fulfilled from locations managed by fulfillment services that are registered by the app. One app (api_client) can host multiple fulfillment services on a shop. Each fulfillment service manages a dedicated location on a shop. Assigned fulfillment orders can have associated, or might currently not be requested to be fulfilled. The app must have 'read_assigned_fulfillment_orders' to be able to retrieve fulfillment orders assigned to its locations. All assigned fulfillment orders (except those with the 'CLOSED' status) will be returned by default.

View-Specific Information

Select

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

  • AssignedLocationLocationId supports the '=,IN' comparison operators.

For example, the following queries are processed server side:

  SELECT * FROM AssignedFulfillmentOrders
  SELECT * FROM AssignedFulfillmentOrders WHERE AssignedLocationLocationId = 'Val1'

Columns

Name Type References Description
Id [KEY] String A globally-unique ID.
ShopId String

Shop.Id

A globally-unique ID.
OrderId String A globally-unique ID.
Status String The status of the fulfillment order.
FulfillAt Datetime The date and time at which the fulfillment order will be fulfillable. When this date and time is reached, the scheduled fulfillment order is automatically transitioned to open. For example, the 'fulfill_at' date for a subscription order might be the 1st of each month, a pre-order 'fulfill_at' date would be 'nil', and a standard order 'fulfill_at' date would be the order creation date.
FulfillBy Datetime The latest date and time by which all items in the fulfillment order need to be fulfilled.
RequestStatus String The request status of the fulfillment order.
CreatedAt Datetime Date and time when the fulfillment order was created.
UpdatedAt Datetime The date and time when the fulfillment order was last updated.
AssignedLocationName String The name of the location.
AssignedLocationAddress1 String The first line of the address for the location.
AssignedLocationAddress2 String The second line of the address for the location.
AssignedLocationCity String The city of the location.
AssignedLocationPhone String The phone number of the location.
AssignedLocationProvince String The province of the location.
AssignedLocationZip String The ZIP code of the location.
AssignedLocationCountryCode String The two-letter country code of the location.
AssignedLocationLocationId String A globally-unique ID.
AssignedLocationLocationLegacyResourceId String The ID of the corresponding resource in the REST Admin API.
AssignedLocationLocationName String The name of the location.
AssignedLocationLocationActivatable Bool Whether this location can be reactivated.
AssignedLocationLocationDeactivatable Bool Whether this location can be deactivated.
AssignedLocationLocationDeletable Bool Whether this location can be deleted.
AssignedLocationLocationAddressVerified Bool Whether the location address has been verified.
AssignedLocationLocationDeactivatedAt String The date and time that the location was deactivated at. For example, 3: 30 pm on September 7, 2019 in the time zone of UTC (Universal Time Coordinated) is represented as '2019-09-07T15: 50: 00Z'.
AssignedLocationLocationIsActive Bool Whether the location is active.
AssignedLocationLocationShipsInventory Bool Whether this location is used for calculating shipping rates. In multi-origin shipping mode, this flag is ignored.
AssignedLocationLocationFulfillsOnlineOrders Bool Whether this location can fulfill online orders.
AssignedLocationLocationHasActiveInventory Bool Whether this location has active inventory.
AssignedLocationLocationHasUnfulfilledOrders Bool Whether this location has orders that need to be fulfilled.
DeliveryMethodId String A globally-unique ID.
DeliveryMethodMethodType String The type of the delivery method.
DeliveryMethodMaxDeliveryDateTime Datetime The latest delivery date and time when the fulfillment is expected to arrive at the buyer's location.
DeliveryMethodMinDeliveryDateTime Datetime The earliest delivery date and time when the fulfillment is expected to arrive at the buyer's location.
DestinationId String A globally-unique ID.
DestinationFirstName String The first name of the customer at the destination.
DestinationLastName String The last name of the customer at the 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.
DestinationEmail String The email of the customer at the destination.
DestinationPhone String The phone number of the customer at the destination.
DestinationProvince String The province of the destination.
DestinationZip String The ZIP code of the destination.
DestinationCountryCode String The two-letter country code of the destination.
InternationalDutiesIncoterm String The method of duties payment. Example values: 'DDP', 'DAP'.

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