Shopify - Get Orders

↩ Part of the Shopify integration.

Description

This module allows querying orders from your Shopify store with filters by financial status, shipping status, dates, customer, and more.

Configuration

Field	Type	Required	Description
credentials_id	string	Yes	Shopify credentials ID
order_id	number	No	Specific order ID
customer_id	number	No	Specific customer orders
status	string	No	open, closed, cancelled, any
financial_status	string	No	Payment status
fulfillment_status	string	No	Shipping status
created_at_min	string	No	Created since (ISO 8601)
created_at_max	string	No	Created until (ISO 8601)
updated_at_min	string	No	Updated since (ISO 8601)
updated_at_max	string	No	Updated until (ISO 8601)
processed_at_min	string	No	Processed since (ISO 8601)
processed_at_max	string	No	Processed until (ISO 8601)
limit	number	No	Result limit (max 250)
since_id	number	No	Orders with ID greater than this
fields	string	No	Fields to return

Credentials

This module requires Shopify credentials.

Field	Description
shop_domain	Store domain (my-store.myshopify.com)
access_token	Admin API access token

Financial Statuses (financial_status)

Value	Description
pending	Payment pending
authorized	Payment authorized
partially_paid	Partially paid
paid	Paid
partially_refunded	Partially refunded
refunded	Refunded
voided	Voided
any	Any status
unpaid	Unpaid (pending + authorized)

Shipping Statuses (fulfillment_status)

Value	Description
shipped	Fully shipped
partial	Partially shipped
unshipped	Not shipped
unfulfilled	Unfulfilled
any	Any status

Output

{
  "success": true,
  "orders": [
    {
      "id": 123456789,
      "order_number": 1001,
      "name": "#1001",
      "email": "cliente@ejemplo.com",
      "financial_status": "paid",
      "fulfillment_status": "unfulfilled",
      "total_price": "89.99",
      "subtotal_price": "79.99",
      "total_tax": "10.00",
      "line_items": [],
      "shipping_address": {},
      "billing_address": {},
      "created_at": "2024-01-15T10:30:00-05:00"
    }
  ],
  "total": 45,
  "filters_applied": {}
}

Usage Example

Orders ready to ship

{
  "credentials_id": "shopify_tienda",
  "financial_status": "paid",
  "fulfillment_status": "unfulfilled",
  "limit": 50
}

Today’s orders

{
  "credentials_id": "shopify_tienda",
  "created_at_min": "2024-01-15T00:00:00Z",
  "created_at_max": "2024-01-15T23:59:59Z"
}

Customer orders

{
  "credentials_id": "shopify_tienda",
  "customer_id": 987654321,
  "limit": 20
}

Notes

• By default only returns open orders (status=open)
• To see all orders, use status: "any"
• The maximum limit per request is 250 orders
• Dates must be in ISO 8601 format
• Orders are returned sorted by creation date descending

Related Nodes

• ShopifyUpdateOrder - Update, cancel, or close orders
• ShopifyGetCustomers - Get order customer data
• ShopifyGetProducts - Get product details in the order