Shopify - Get Orders

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