stepshopify Skip to content

shopifyGetOrders Step

This is the actual step which will be published in your Add-On. Typically it will consist of Flow-Variables, steps for the execution logic and Output-Variables. The corresponding Test-Flow TestFlow-shopifyGetOrders will then use this step and see the input and outputs.

Inputs

Das sind die Optionen, mit denen man den Step konfigurieren kann.

Name Datentyp Beschreibung Pflichtfeld Werte
account ACCOUNT shopify Account Ja
status STRING Filter orders by their status. Only orders in the selected status will be retrieved. This status can be combined with the other statuses. Ja
  • open
  • closed
  • cancelled
  • any
financial_status STRING Filter orders by their financial status. Only orders in the selected financial status will be retrieved. This status can be combined with the other statuses. Ja
  • any
  • authorized
  • pending
  • paid
  • partially paid
  • refunded
  • voided
  • partially refunded
  • unpaid
fulfillment_status STRING Filter orders by their fulfillment status. Only orders in the selected financial status will be retrieved. This status can be combined with the other statuses. Ja
  • any
  • shipped
  • partially shipped
  • unshipped
limit STRING Limits the number of orders to be retrieved. Enter a small number for tests. If limit is empty or greater than 249 then all orders are retrieved. Nein
ids STRING A comma-separated list of order ids Nein
sales_channel STRING Filter Shopify orders by sales channel. Nein
tag STRING Filter Shopify Orders by Tag. Nein
created_at_from DATETIME Creation time of orders. All orders in the specified status that were created on this date and the specified time and after are retrieved. The time is in UTC. If no date is specified, all orders will be fetched in the specified status. Nein
created_at_to DATETIME Creation time of orders. All orders in the specified status that were created until this date and the specified time and after are retrieved. The time is in UTC. If no date is specified, all orders will be fetched in the specified status. Nein
updated_at_from DATETIME Update time of orders. All orders in the specified status that were updated on this date and the specified time and after are retrieved. The time is in UTC. If no date is specified, all orders will be fetched in the specified status. Nein
updated_at_to DATETIME Update time of orders. All orders in the specified status that were updated until this date and the specified time and after are retrieved. The time is in UTC. If no date is specified, all orders will be fetched in the specified status. Nein
processed_at_from DATETIME Processed time of orders. All orders in the specified status that were processsed on this date and the specified time and after are retrieved. The time is in UTC. If no date is specified, all orders will be fetched in the specified status. Nein
processed_at_to DATETIME Processed time of orders. All orders in the specified status that were processsed until this date and the specified time and after are retrieved. The time is in UTC. If no date is specified, all orders will be fetched in the specified status. Nein

Outputs

Das sind die Ergebnisse des Steps, die von nachfolgenden Steps, nach der Ausführung verwendet werden können.

Name Datentyp Beschreibung Pflichtfeld Werte
Orders SPREADSHEET Ja
Folgende Felder sind im Output enthalten:

Feld Datentyp Beschreibung Pflichtfeld Standardwert
identifierSINGLENein
parent_identifierSINGLENein
idSINGLENein
emailSINGLENein
closed_atSINGLENein
created_atSINGLENein
updated_atSINGLENein
numberSINGLENein
noteSINGLENein
tokenSINGLENein
gatewaySINGLENein
testSINGLENein
total_priceSINGLENein
subtotal_priceSINGLENein
total_weightSINGLENein
total_taxSINGLENein
taxes_includedSINGLENein
currencySINGLENein
financial_statusSINGLENein
confirmedSINGLENein
total_discountsSINGLENein
total_line_items_priceSINGLENein
cart_tokenSINGLENein
buyer_accepts_marketingSINGLENein
nameSINGLENein
referring_siteSINGLENein
landing_siteSINGLENein
cancelled_atSINGLENein
cancel_reasonSINGLENein
total_price_usdSINGLENein
checkout_tokenSINGLENein
referenceSINGLENein
user_idSINGLENein
location_idSINGLENein
source_identifierSINGLENein
source_urlSINGLENein
processed_atSINGLENein
device_idSINGLENein
phoneSINGLENein
customer_localeSINGLENein
app_idSINGLENein
browser_ipSINGLENein
landing_site_refSINGLENein
order_numberSINGLENein
discount_codes_codeSINGLENein
discount_codes_amountSINGLENein
discount_codes_typeSINGLENein
note_attributesSINGLENein
payment_gateway_namesSINGLENein
processing_methodSINGLENein
checkout_idSINGLENein
source_nameSINGLENein
fulfillment_statusSINGLENein
tagsSINGLENein
contact_emailSINGLENein
order_status_urlSINGLENein
presentment_currencySINGLENein
total_tip_receivedSINGLENein
admin_graphql_api_idSINGLENein
customer_idSINGLENein
customer_emailSINGLENein
customer_accepts_marketingSINGLENein
customer_created_atSINGLENein
customer_updated_atSINGLENein
customer_first_nameSINGLENein
customer_last_nameSINGLENein
customer_orders_countSINGLENein
customer_stateSINGLENein
customer_total_spentSINGLENein
customer_last_order_idSINGLENein
customer_noteSINGLENein
customer_verified_emailSINGLENein
customer_multipass_identifierSINGLENein
customer_tax_exemptSINGLENein
customer_phoneSINGLENein
customer_tagsSINGLENein
customer_last_order_nameSINGLENein
customer_currencySINGLENein
customer_accepts_marketing_updated_atSINGLENein
customer_marketing_opt_in_levelSINGLENein
customer_admin_graphql_api_idSINGLENein
customer_default_address_idSINGLENein
customer_default_address_customer_idSINGLENein
customer_default_address_first_nameSINGLENein
customer_default_address_last_nameSINGLENein
customer_default_address_companySINGLENein
customer_default_address_address1SINGLENein
customer_default_address_address2SINGLENein
customer_default_address_citySINGLENein
customer_default_address_provinceSINGLENein
customer_default_address_countrySINGLENein
customer_default_address_zipSINGLENein
customer_default_address_phoneSINGLENein
customer_default_address_nameSINGLENein
customer_default_address_province_codeSINGLENein
customer_default_address_country_codeSINGLENein
customer_default_address_country_nameSINGLENein
customer_default_address_defaultSINGLENein
billing_address_first_nameSINGLENein
billing_address_address1SINGLENein
billing_address_phoneSINGLENein
billing_address_citySINGLENein
billing_address_zipSINGLENein
billing_address_provinceSINGLENein
billing_address_countrySINGLENein
billing_address_last_nameSINGLENein
billing_address_address2SINGLENein
billing_address_companySINGLENein
billing_address_latitudeSINGLENein
billing_address_longitudeSINGLENein
billing_address_nameSINGLENein
billing_address_country_codeSINGLENein
billing_address_province_codeSINGLENein
shipping_address_first_nameSINGLENein
shipping_address_address1SINGLENein
shipping_address_phoneSINGLENein
shipping_address_citySINGLENein
shipping_address_zipSINGLENein
shipping_address_provinceSINGLENein
shipping_address_countrySINGLENein
shipping_address_last_nameSINGLENein
shipping_address_address2SINGLENein
shipping_address_companySINGLENein
shipping_address_latitudeSINGLENein
shipping_address_longitudeSINGLENein
shipping_address_nameSINGLENein
shipping_address_country_codeSINGLENein
shipping_address_province_codeSINGLENein
fulfillments_idSINGLENein
fulfillments_order_idSINGLENein
fulfillments_statusSINGLENein
fulfillments_created_atSINGLENein
fulfillments_serviceSINGLENein
fulfillments_updated_atSINGLENein
fulfillments_tracking_companySINGLENein
fulfillments_shipment_statusSINGLENein
fulfillments_location_idSINGLENein
fulfillments_tracking_numberSINGLENein
fulfillments_tracking_numbersSINGLENein
fulfillments_tracking_urlSINGLENein
fulfillments_tracking_urlsSINGLENein
fulfillments_nameSINGLENein
fulfillments_admin_graphql_api_idSINGLENein
refunds_idSINGLENein
refunds_order_idSINGLENein
refunds_created_atSINGLENein
refunds_noteSINGLENein
refunds_user_idSINGLENein
refunds_processed_atSINGLENein
refunds_restockSINGLENein
refunds_admin_graphql_api_idSINGLENein
tax_lines_priceSINGLENein
tax_lines_rateSINGLENein
tax_lines_titleSINGLENein
total_line_items_price_set_shop_money_amountSINGLENein
total_line_items_price_set_shop_money_currency_codeSINGLENein
total_line_items_price_set_presentment_money_amountSINGLENein
total_line_items_price_set_presentment_money_currency_codeSINGLENein
total_discounts_set_shop_money_amountSINGLENein
total_discounts_set_shop_money_currency_codeSINGLENein
total_discounts_set_presentment_money_amountSINGLENein
total_discounts_set_presentment_money_currency_codeSINGLENein
total_shipping_price_set_shop_money_amountSINGLENein
total_shipping_price_set_shop_money_currency_codeSINGLENein
total_shipping_price_set_presentment_money_amountSINGLENein
total_shipping_price_set_presentment_money_currency_codeSINGLENein
subtotal_price_set_shop_money_amountSINGLENein
subtotal_price_set_shop_money_currency_codeSINGLENein
subtotal_price_set_presentment_money_amountSINGLENein
subtotal_price_set_presentment_money_currency_codeSINGLENein
total_price_set_shop_money_amountSINGLENein
total_price_set_shop_money_currency_codeSINGLENein
total_price_set_presentment_money_amountSINGLENein
total_price_set_presentment_money_currency_codeSINGLENein
total_tax_set_shop_money_amountSINGLENein
total_tax_set_shop_money_currency_codeSINGLENein
total_tax_set_presentment_money_amountSINGLENein
total_tax_set_presentment_money_currency_codeSINGLENein
shipping_lines_idSINGLENein
shipping_lines_titleSINGLENein
shipping_lines_priceSINGLENein
shipping_lines_codeSINGLENein
shipping_lines_sourceSINGLENein
shipping_lines_phoneSINGLENein
shipping_lines_requested_fulfillment_service_idSINGLENein
shipping_lines_delivery_categorySINGLENein
shipping_lines_carrier_identifierSINGLENein
shipping_lines_discounted_priceSINGLENein
shipping_lines_tax_lines_titleSINGLENein
shipping_lines_tax_lines_priceSINGLENein
shipping_lines_tax_lines_rateSINGLENein
line_items_identifierSINGLENein
line_items_order_idSINGLENein
line_items_order_numberSINGLENein
line_items_idSINGLENein
line_items_variant_idSINGLENein
line_items_titleSINGLENein
line_items_quantitySINGLENein
line_items_skuSINGLENein
line_items_variant_titleSINGLENein
line_items_vendorSINGLENein
line_items_fulfillment_serviceSINGLENein
line_items_product_idSINGLENein
line_items_requires_shippingSINGLENein
line_items_taxableSINGLENein
line_items_gift_cardSINGLENein
line_items_nameSINGLENein
line_items_variant_inventory_managementSINGLENein
line_items_product_existsSINGLENein
line_items_fulfillable_quantitySINGLENein
line_items_gramsSINGLENein
line_items_priceSINGLENein
line_items_total_discountSINGLENein
line_items_fulfillment_statusSINGLENein
line_items_discount_allocationsSINGLENein
line_items_admin_graphql_api_idSINGLENein
line_items_propertiesSINGLENein
line_items_properties_nameSINGLENein
line_items_properties_valueSINGLENein
line_items_price_set_shop_money_amountSINGLENein
line_items_price_set_presentment_money_amountSINGLENein
line_items_price_set_presentment_money_currency_codeSINGLENein
line_items_tax_lines_titleSINGLENein
line_items_tax_lines_priceSINGLENein
line_items_tax_lines_rateSINGLENein
refund_idSINGLENein
refund_line_item_idSINGLENein
refund_quantitySINGLENein
refund_restock_typeSINGLENein
refund_subtotalSINGLENein
refund_total_taxSINGLENein
refund_line_items_idSINGLENein
refund_line_items_fulfillable_quantitySINGLENein
refund_line_items_fulfillment_serviceSINGLENein
refund_line_items_fulfillment_statusSINGLENein
refund_line_items_nameSINGLENein
refund_line_items_priceSINGLENein
refund_line_items_product_idSINGLENein
refund_line_items_quantitySINGLENein
refund_line_items_skuSINGLENein
refund_line_items_taxableSINGLENein
refund_line_items_titleSINGLENein
refund_line_items_variant_idSINGLENein
refund_line_items_properties_valueSINGLENein
refund_line_items_propertiesSINGLENein
refund_line_items_total_discountSINGLENein
OrderHeaderData SPREADSHEET Ja
Folgende Felder sind im Output enthalten:

Feld Datentyp Beschreibung Pflichtfeld Standardwert
identifierSINGLENein
idSINGLENein
emailSINGLENein
closed_atSINGLENein
created_atSINGLENein
updated_atSINGLENein
numberSINGLENein
noteSINGLENein
tokenSINGLENein
gatewaySINGLENein
testSINGLENein
total_priceSINGLENein
subtotal_priceSINGLENein
total_weightSINGLENein
total_taxSINGLENein
taxes_includedSINGLENein
currencySINGLENein
financial_statusSINGLENein
confirmedSINGLENein
total_discountsSINGLENein
total_line_items_priceSINGLENein
cart_tokenSINGLENein
buyer_accepts_marketingSINGLENein
nameSINGLENein
referring_siteSINGLENein
landing_siteSINGLENein
cancelled_atSINGLENein
cancel_reasonSINGLENein
total_price_usdSINGLENein
checkout_tokenSINGLENein
referenceSINGLENein
user_idSINGLENein
location_idSINGLENein
source_identifierSINGLENein
source_urlSINGLENein
processed_atSINGLENein
device_idSINGLENein
phoneSINGLENein
customer_localeSINGLENein
app_idSINGLENein
browser_ipSINGLENein
landing_site_refSINGLENein
order_numberSINGLENein
discount_codes_codeSINGLENein
discount_codes_amountSINGLENein
discount_codes_typeSINGLENein
note_attributesSINGLENein
payment_gateway_namesSINGLENein
processing_methodSINGLENein
checkout_idSINGLENein
source_nameSINGLENein
fulfillment_statusSINGLENein
tagsSINGLENein
contact_emailSINGLENein
order_status_urlSINGLENein
presentment_currencySINGLENein
total_tip_receivedSINGLENein
admin_graphql_api_idSINGLENein
customer_idSINGLENein
customer_emailSINGLENein
customer_accepts_marketingSINGLENein
customer_created_atSINGLENein
customer_updated_atSINGLENein
customer_first_nameSINGLENein
customer_last_nameSINGLENein
customer_orders_countSINGLENein
customer_stateSINGLENein
customer_total_spentSINGLENein
customer_last_order_idSINGLENein
customer_noteSINGLENein
customer_verified_emailSINGLENein
customer_multipass_identifierSINGLENein
customer_tax_exemptSINGLENein
customer_phoneSINGLENein
customer_tagsSINGLENein
customer_last_order_nameSINGLENein
customer_currencySINGLENein
customer_accepts_marketing_updated_atSINGLENein
customer_marketing_opt_in_levelSINGLENein
customer_admin_graphql_api_idSINGLENein
customer_default_address_idSINGLENein
customer_default_address_customer_idSINGLENein
customer_default_address_first_nameSINGLENein
customer_default_address_last_nameSINGLENein
customer_default_address_companySINGLENein
customer_default_address_address1SINGLENein
customer_default_address_address2SINGLENein
customer_default_address_citySINGLENein
customer_default_address_provinceSINGLENein
customer_default_address_countrySINGLENein
customer_default_address_zipSINGLENein
customer_default_address_phoneSINGLENein
customer_default_address_nameSINGLENein
customer_default_address_province_codeSINGLENein
customer_default_address_country_codeSINGLENein
customer_default_address_country_nameSINGLENein
customer_default_address_defaultSINGLENein
billing_address_first_nameSINGLENein
billing_address_address1SINGLENein
billing_address_phoneSINGLENein
billing_address_citySINGLENein
billing_address_zipSINGLENein
billing_address_provinceSINGLENein
billing_address_countrySINGLENein
billing_address_last_nameSINGLENein
billing_address_address2SINGLENein
billing_address_companySINGLENein
billing_address_latitudeSINGLENein
billing_address_longitudeSINGLENein
billing_address_nameSINGLENein
billing_address_country_codeSINGLENein
billing_address_province_codeSINGLENein
shipping_address_first_nameSINGLENein
shipping_address_address1SINGLENein
shipping_address_phoneSINGLENein
shipping_address_citySINGLENein
shipping_address_zipSINGLENein
shipping_address_provinceSINGLENein
shipping_address_countrySINGLENein
shipping_address_last_nameSINGLENein
shipping_address_address2SINGLENein
shipping_address_companySINGLENein
shipping_address_latitudeSINGLENein
shipping_address_longitudeSINGLENein
shipping_address_nameSINGLENein
shipping_address_country_codeSINGLENein
shipping_address_province_codeSINGLENein
fulfillments_idSINGLENein
fulfillments_order_idSINGLENein
fulfillments_statusSINGLENein
fulfillments_created_atSINGLENein
fulfillments_serviceSINGLENein
fulfillments_updated_atSINGLENein
fulfillments_tracking_companySINGLENein
fulfillments_shipment_statusSINGLENein
fulfillments_location_idSINGLENein
fulfillments_tracking_numberSINGLENein
fulfillments_tracking_numbersSINGLENein
fulfillments_tracking_urlSINGLENein
fulfillments_tracking_urlsSINGLENein
fulfillments_nameSINGLENein
fulfillments_admin_graphql_api_idSINGLENein
refunds_idSINGLENein
refunds_order_idSINGLENein
refunds_created_atSINGLENein
refunds_noteSINGLENein
refunds_user_idSINGLENein
refunds_processed_atSINGLENein
refunds_restockSINGLENein
refunds_admin_graphql_api_idSINGLENein
tax_lines_priceSINGLENein
tax_lines_rateSINGLENein
tax_lines_titleSINGLENein
total_line_items_price_set_shop_money_amountSINGLENein
total_line_items_price_set_shop_money_currency_codeSINGLENein
total_line_items_price_set_presentment_money_amountSINGLENein
total_line_items_price_set_presentment_money_currency_codeSINGLENein
total_discounts_set_shop_money_amountSINGLENein
total_discounts_set_shop_money_currency_codeSINGLENein
total_discounts_set_presentment_money_amountSINGLENein
total_discounts_set_presentment_money_currency_codeSINGLENein
total_shipping_price_set_shop_money_amountSINGLENein
total_shipping_price_set_shop_money_currency_codeSINGLENein
total_shipping_price_set_presentment_money_amountSINGLENein
total_shipping_price_set_presentment_money_currency_codeSINGLENein
subtotal_price_set_shop_money_amountSINGLENein
subtotal_price_set_shop_money_currency_codeSINGLENein
subtotal_price_set_presentment_money_amountSINGLENein
subtotal_price_set_presentment_money_currency_codeSINGLENein
total_price_set_shop_money_amountSINGLENein
total_price_set_shop_money_currency_codeSINGLENein
total_price_set_presentment_money_amountSINGLENein
total_price_set_presentment_money_currency_codeSINGLENein
total_tax_set_shop_money_amountSINGLENein
total_tax_set_shop_money_currency_codeSINGLENein
total_tax_set_presentment_money_amountSINGLENein
total_tax_set_presentment_money_currency_codeSINGLENein
shipping_lines_idSINGLENein
shipping_lines_titleSINGLENein
shipping_lines_priceSINGLENein
shipping_lines_codeSINGLENein
shipping_lines_sourceSINGLENein
shipping_lines_phoneSINGLENein
shipping_lines_requested_fulfillment_service_idSINGLENein
shipping_lines_delivery_categorySINGLENein
shipping_lines_carrier_identifierSINGLENein
shipping_lines_discounted_priceSINGLENein
shipping_lines_tax_lines_titleSINGLENein
shipping_lines_tax_lines_priceSINGLENein
shipping_lines_tax_lines_rateSINGLENein
OrderItemData SPREADSHEET Ja
Folgende Felder sind im Output enthalten:

Feld Datentyp Beschreibung Pflichtfeld Standardwert
identifierSINGLENein
line_items_identifierSINGLENein
line_items_order_idSINGLENein
line_items_order_numberSINGLENein
line_items_idSINGLENein
line_items_variant_idSINGLENein
line_items_titleSINGLENein
line_items_quantitySINGLENein
line_items_skuSINGLENein
line_items_variant_titleSINGLENein
line_items_vendorSINGLENein
line_items_fulfillment_serviceSINGLENein
line_items_product_idSINGLENein
line_items_requires_shippingSINGLENein
line_items_taxableSINGLENein
line_items_gift_cardSINGLENein
line_items_nameSINGLENein
line_items_variant_inventory_managementSINGLENein
line_items_product_existsSINGLENein
line_items_fulfillable_quantitySINGLENein
line_items_gramsSINGLENein
line_items_priceSINGLENein
line_items_total_discountSINGLENein
line_items_fulfillment_statusSINGLENein
line_items_discount_allocationsSINGLENein
line_items_admin_graphql_api_idSINGLENein
line_items_propertiesSINGLENein
line_items_properties_nameSINGLENein
line_items_properties_valueSINGLENein
line_items_price_set_shop_money_amountSINGLENein
line_items_price_set_shop_money_currency_codeSINGLENein
line_items_price_set_presentment_money_amountSINGLENein
line_items_price_set_presentment_money_currency_codeSINGLENein
line_items_tax_lines_titleSINGLENein
line_items_tax_lines_priceSINGLENein
line_items_tax_lines_rateSINGLENein
OrderRefundItemData SPREADSHEET Ja
Folgende Felder sind im Output enthalten:

Feld Datentyp Beschreibung Pflichtfeld Standardwert
identifierSINGLENein
refund_line_items_identifierSINGLENein
refund_line_items_order_idSINGLENein
refund_line_items_order_numberSINGLENein
refund_idSINGLENein
refund_line_item_idSINGLENein
refund_quantitySINGLENein
refund_restock_typeSINGLENein
refund_subtotalSINGLENein
refund_total_taxSINGLENein
refund_line_items_fulfillable_quantitySINGLENein
refund_line_items_fulfillment_serviceSINGLENein
refund_line_items_fulfillment_statusSINGLENein
refund_line_items_nameSINGLENein
refund_line_items_priceSINGLENein
refund_line_items_product_idSINGLENein
refund_line_items_quantitySINGLENein
refund_line_items_skuSINGLENein
refund_line_items_taxableSINGLENein
refund_line_items_titleSINGLENein
refund_line_items_variant_idSINGLENein
refund_line_items_properties_valueSINGLENein
refund_line_items_propertiesSINGLENein
refund_line_items_total_discountSINGLENein