Save Printful orders to Google Drive from Google Sheets
This query returns the current status and details of a Printful order by its order ID or external order number.
Developer info
- API endpoint slug
- printful.look_up_an_order
- Runtime method
- performQuery("printful.look_up_an_order"}
Query fields
Order Text input > Other
- Label
- Order ID or external order number
- Helper text
- Enter the Printful order ID, or your external order number (the ID you set when the order was created).
- Slug
- order_id
- Required
- true
- Can have default value
- true
Ingredients
Order The Printful order ID.
- Slug
- order_id
- Filter code
- Printful.lookUpAnOrder.OrderId
- Type
- String
- Example
- 94832478
External order Your external order ID for the order, when one was set.
- Slug
- external_order_id
- Filter code
- Printful.lookUpAnOrder.ExternalOrderId
- Type
- String
- Example
- MY-STORE-1001
Order status The current status of the order.
- Slug
- order_status
- Filter code
- Printful.lookUpAnOrder.OrderStatus
- Type
- String
- Example
- fulfilled
Recipient name The name of the order's recipient.
- Slug
- recipient_name
- Filter code
- Printful.lookUpAnOrder.RecipientName
- Type
- String
- Example
- Jane Doe
Order total The order total, as a string you can parse downstream.
- Slug
- order_total
- Filter code
- Printful.lookUpAnOrder.OrderTotal
- Type
- String
- Example
- 39.98
Currency The currency of the order total.
- Slug
- currency
- Filter code
- Printful.lookUpAnOrder.Currency
- Type
- String
- Example
- USD
Tracking number The shipment's tracking number, once the order has shipped.
- Slug
- tracking_number
- Filter code
- Printful.lookUpAnOrder.TrackingNumber
- Type
- String
- Example
- 9400111899223817612345
Tracking url A link to track the shipment, once the order has shipped.
- Slug
- tracking_url
- Filter code
- Printful.lookUpAnOrder.TrackingUrl
- Type
- Web URL
- Example
- https://tools.usps.com/go/TrackConfirmAction?tLabels=9400111899223817612345
Created at When the order was created.
- Slug
- created_at
- Filter code
- Printful.lookUpAnOrder.CreatedAt
- Type
- Date with time (ISO8601)
- Example
- 2020-07-08T04:17:06+05:00
