shopifyGetOrders - shopify

Version: 2023-01

← shopify Add-On Übersicht

Retrieves orders. The retrieval of orders can be limited by specifying the statuses as well as the creation time and the update time of the orders.

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.	Nein	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.	Nein	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
fulfillments	STRING	Additional: Calls the fulfillments of an order.	Nein	no yes
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	Werte
Orders	SPREADSHEET
	Folgende Felder sind im Output enthalten: Feld Datentyp Beschreibung Standardwert identifier SINGLE parent_identifier SINGLE id SINGLE email SINGLE closed_at SINGLE created_at SINGLE updated_at SINGLE number SINGLE note SINGLE token SINGLE gateway SINGLE test SINGLE total_price SINGLE subtotal_price SINGLE total_weight SINGLE total_tax SINGLE taxes_included SINGLE currency SINGLE financial_status SINGLE confirmed SINGLE total_discounts SINGLE total_line_items_price SINGLE cart_token SINGLE buyer_accepts_marketing SINGLE name SINGLE referring_site SINGLE landing_site SINGLE cancelled_at SINGLE cancel_reason SINGLE checkout_token SINGLE reference SINGLE user_id SINGLE location_id SINGLE source_identifier SINGLE source_url SINGLE processed_at SINGLE device_id SINGLE phone SINGLE customer_locale SINGLE app_id SINGLE browser_ip SINGLE landing_site_ref SINGLE order_number SINGLE discount_codes_code SINGLE discount_codes_amount SINGLE discount_codes_type SINGLE note_attributes SINGLE payment_gateway_names SINGLE processing_method SINGLE checkout_id SINGLE source_name SINGLE fulfillment_status SINGLE tags SINGLE contact_email SINGLE order_status_url SINGLE presentment_currency SINGLE total_tip_received SINGLE admin_graphql_api_id SINGLE customer_id SINGLE customer_email SINGLE customer_accepts_marketing SINGLE customer_created_at SINGLE customer_updated_at SINGLE customer_first_name SINGLE customer_last_name SINGLE customer_state SINGLE customer_note SINGLE customer_verified_email SINGLE customer_multipass_identifier SINGLE customer_tax_exempt SINGLE customer_phone SINGLE customer_tags SINGLE customer_currency SINGLE customer_accepts_marketing_updated_at SINGLE customer_marketing_opt_in_level SINGLE customer_admin_graphql_api_id SINGLE customer_default_address_id SINGLE customer_default_address_customer_id SINGLE customer_default_address_first_name SINGLE customer_default_address_last_name SINGLE customer_default_address_company SINGLE customer_default_address_address1 SINGLE customer_default_address_address2 SINGLE customer_default_address_city SINGLE customer_default_address_province SINGLE customer_default_address_country SINGLE customer_default_address_zip SINGLE customer_default_address_phone SINGLE customer_default_address_name SINGLE customer_default_address_province_code SINGLE customer_default_address_country_code SINGLE customer_default_address_country_name SINGLE customer_default_address_default SINGLE billing_address_first_name SINGLE billing_address_address1 SINGLE billing_address_phone SINGLE billing_address_city SINGLE billing_address_zip SINGLE billing_address_province SINGLE billing_address_country SINGLE billing_address_last_name SINGLE billing_address_address2 SINGLE billing_address_company SINGLE billing_address_latitude SINGLE billing_address_longitude SINGLE billing_address_name SINGLE billing_address_country_code SINGLE billing_address_province_code SINGLE shipping_address_first_name SINGLE shipping_address_address1 SINGLE shipping_address_phone SINGLE shipping_address_city SINGLE shipping_address_zip SINGLE shipping_address_province SINGLE shipping_address_country SINGLE shipping_address_last_name SINGLE shipping_address_address2 SINGLE shipping_address_company SINGLE shipping_address_latitude SINGLE shipping_address_longitude SINGLE shipping_address_name SINGLE shipping_address_country_code SINGLE shipping_address_province_code SINGLE fulfillments_id SINGLE fulfillments_order_id SINGLE fulfillments_status SINGLE fulfillments_created_at SINGLE fulfillments_service SINGLE fulfillments_updated_at SINGLE fulfillments_tracking_company SINGLE fulfillments_shipment_status SINGLE fulfillments_location_id SINGLE fulfillments_tracking_number SINGLE fulfillments_tracking_numbers SINGLE fulfillments_tracking_url SINGLE fulfillments_tracking_urls SINGLE fulfillments_name SINGLE fulfillments_admin_graphql_api_id SINGLE refunds_id SINGLE refunds_order_id SINGLE refunds_created_at SINGLE refunds_note SINGLE refunds_user_id SINGLE refunds_processed_at SINGLE refunds_restock SINGLE refunds_admin_graphql_api_id SINGLE tax_lines_price SINGLE tax_lines_rate SINGLE tax_lines_title SINGLE total_line_items_price_set_shop_money_amount SINGLE total_line_items_price_set_shop_money_currency_code SINGLE total_line_items_price_set_presentment_money_amount SINGLE total_line_items_price_set_presentment_money_currency_code SINGLE total_discounts_set_shop_money_amount SINGLE total_discounts_set_shop_money_currency_code SINGLE total_discounts_set_presentment_money_amount SINGLE total_discounts_set_presentment_money_currency_code SINGLE total_shipping_price_set_shop_money_amount SINGLE total_shipping_price_set_shop_money_currency_code SINGLE total_shipping_price_set_presentment_money_amount SINGLE total_shipping_price_set_presentment_money_currency_code SINGLE subtotal_price_set_shop_money_amount SINGLE subtotal_price_set_shop_money_currency_code SINGLE subtotal_price_set_presentment_money_amount SINGLE subtotal_price_set_presentment_money_currency_code SINGLE total_price_set_shop_money_amount SINGLE total_price_set_shop_money_currency_code SINGLE total_price_set_presentment_money_amount SINGLE total_price_set_presentment_money_currency_code SINGLE total_tax_set_shop_money_amount SINGLE total_tax_set_shop_money_currency_code SINGLE total_tax_set_presentment_money_amount SINGLE total_tax_set_presentment_money_currency_code SINGLE shipping_lines_id SINGLE shipping_lines_title SINGLE shipping_lines_price SINGLE shipping_lines_code SINGLE shipping_lines_source SINGLE shipping_lines_phone SINGLE shipping_lines_discount_allocations SINGLE shipping_lines_requested_fulfillment_service_id SINGLE shipping_lines_delivery_category SINGLE shipping_lines_carrier_identifier SINGLE shipping_lines_discounted_price SINGLE shipping_lines_tax_lines_title SINGLE shipping_lines_tax_lines_price SINGLE shipping_lines_tax_lines_rate SINGLE line_items_identifier SINGLE line_items_order_id SINGLE line_items_order_number SINGLE line_items_id SINGLE line_items_variant_id SINGLE line_items_title SINGLE line_items_quantity SINGLE line_items_sku SINGLE line_items_variant_title SINGLE line_items_vendor SINGLE line_items_fulfillment_service SINGLE line_items_product_id SINGLE line_items_requires_shipping SINGLE line_items_taxable SINGLE line_items_gift_card SINGLE line_items_name SINGLE line_items_variant_inventory_management SINGLE line_items_product_exists SINGLE line_items_fulfillable_quantity SINGLE line_items_grams SINGLE line_items_price SINGLE line_items_total_discount SINGLE line_items_fulfillment_status SINGLE line_items_discount_allocations SINGLE line_items_admin_graphql_api_id SINGLE line_items_properties SINGLE line_items_properties_name SINGLE line_items_properties_value SINGLE line_items_price_set_shop_money_amount SINGLE line_items_price_set_presentment_money_amount SINGLE line_items_price_set_presentment_money_currency_code SINGLE line_items_total_discount_set_presentment_money_amount SINGLE line_items_total_discount_set_presentment_money_currency_code SINGLE line_items_tax_lines_title SINGLE line_items_tax_lines_price SINGLE line_items_tax_lines_rate SINGLE refund_id SINGLE refund_line_item_id SINGLE refund_line_items_created_at SINGLE refund_line_items_processed_at SINGLE refund_quantity SINGLE refund_restock_type SINGLE refund_subtotal SINGLE refund_total_tax SINGLE refund_line_items_id SINGLE refund_line_items_fulfillable_quantity SINGLE refund_line_items_fulfillment_service SINGLE refund_line_items_fulfillment_status SINGLE refund_line_items_name SINGLE refund_line_items_price SINGLE refund_line_items_product_id SINGLE refund_line_items_quantity SINGLE refund_line_items_sku SINGLE refund_line_items_taxable SINGLE refund_line_items_title SINGLE refund_line_items_variant_id SINGLE refund_line_items_properties_value SINGLE refund_line_items_properties SINGLE refund_line_items_total_discount SINGLE
OrderHeaderData	SPREADSHEET
	Folgende Felder sind im Output enthalten: Feld Datentyp Beschreibung Standardwert identifier SINGLE id SINGLE email SINGLE closed_at SINGLE created_at SINGLE updated_at SINGLE number SINGLE note SINGLE token SINGLE gateway SINGLE test SINGLE total_price SINGLE subtotal_price SINGLE total_weight SINGLE total_tax SINGLE taxes_included SINGLE currency SINGLE financial_status SINGLE confirmed SINGLE total_discounts SINGLE total_line_items_price SINGLE cart_token SINGLE buyer_accepts_marketing SINGLE name SINGLE referring_site SINGLE landing_site SINGLE cancelled_at SINGLE cancel_reason SINGLE checkout_token SINGLE reference SINGLE user_id SINGLE location_id SINGLE source_identifier SINGLE source_url SINGLE processed_at SINGLE device_id SINGLE phone SINGLE customer_locale SINGLE app_id SINGLE browser_ip SINGLE landing_site_ref SINGLE order_number SINGLE discount_codes_code SINGLE discount_codes_amount SINGLE discount_codes_type SINGLE note_attributes SINGLE payment_gateway_names SINGLE processing_method SINGLE checkout_id SINGLE source_name SINGLE fulfillment_status SINGLE tags SINGLE contact_email SINGLE order_status_url SINGLE presentment_currency SINGLE total_tip_received SINGLE admin_graphql_api_id SINGLE customer_id SINGLE customer_email SINGLE customer_accepts_marketing SINGLE customer_created_at SINGLE customer_updated_at SINGLE customer_first_name SINGLE customer_last_name SINGLE customer_orders_count SINGLE customer_state SINGLE customer_total_spent SINGLE customer_last_order_id SINGLE customer_note SINGLE customer_verified_email SINGLE customer_multipass_identifier SINGLE customer_tax_exempt SINGLE customer_phone SINGLE customer_tags SINGLE customer_last_order_name SINGLE customer_currency SINGLE customer_accepts_marketing_updated_at SINGLE customer_marketing_opt_in_level SINGLE customer_admin_graphql_api_id SINGLE customer_default_address_id SINGLE customer_default_address_customer_id SINGLE customer_default_address_first_name SINGLE customer_default_address_last_name SINGLE customer_default_address_company SINGLE customer_default_address_address1 SINGLE customer_default_address_address2 SINGLE customer_default_address_city SINGLE customer_default_address_province SINGLE customer_default_address_country SINGLE customer_default_address_zip SINGLE customer_default_address_phone SINGLE customer_default_address_name SINGLE customer_default_address_province_code SINGLE customer_default_address_country_code SINGLE customer_default_address_country_name SINGLE customer_default_address_default SINGLE billing_address_first_name SINGLE billing_address_address1 SINGLE billing_address_phone SINGLE billing_address_city SINGLE billing_address_zip SINGLE billing_address_province SINGLE billing_address_country SINGLE billing_address_last_name SINGLE billing_address_address2 SINGLE billing_address_company SINGLE billing_address_latitude SINGLE billing_address_longitude SINGLE billing_address_name SINGLE billing_address_country_code SINGLE billing_address_province_code SINGLE shipping_address_first_name SINGLE shipping_address_address1 SINGLE shipping_address_phone SINGLE shipping_address_city SINGLE shipping_address_zip SINGLE shipping_address_province SINGLE shipping_address_country SINGLE shipping_address_last_name SINGLE shipping_address_address2 SINGLE shipping_address_company SINGLE shipping_address_latitude SINGLE shipping_address_longitude SINGLE shipping_address_name SINGLE shipping_address_country_code SINGLE shipping_address_province_code SINGLE fulfillments_id SINGLE fulfillments_order_id SINGLE fulfillments_status SINGLE fulfillments_created_at SINGLE fulfillments_service SINGLE fulfillments_updated_at SINGLE fulfillments_tracking_company SINGLE fulfillments_shipment_status SINGLE fulfillments_location_id SINGLE fulfillments_tracking_number SINGLE fulfillments_tracking_numbers SINGLE fulfillments_tracking_url SINGLE fulfillments_tracking_urls SINGLE fulfillments_name SINGLE fulfillments_admin_graphql_api_id SINGLE refunds_id SINGLE refunds_order_id SINGLE refunds_created_at SINGLE refunds_note SINGLE refunds_user_id SINGLE refunds_processed_at SINGLE refunds_restock SINGLE refunds_admin_graphql_api_id SINGLE tax_lines_price SINGLE tax_lines_rate SINGLE tax_lines_title SINGLE total_line_items_price_set_shop_money_amount SINGLE total_line_items_price_set_shop_money_currency_code SINGLE total_line_items_price_set_presentment_money_amount SINGLE total_line_items_price_set_presentment_money_currency_code SINGLE total_discounts_set_shop_money_amount SINGLE total_discounts_set_shop_money_currency_code SINGLE total_discounts_set_presentment_money_amount SINGLE total_discounts_set_presentment_money_currency_code SINGLE total_shipping_price_set_shop_money_amount SINGLE total_shipping_price_set_shop_money_currency_code SINGLE total_shipping_price_set_presentment_money_amount SINGLE total_shipping_price_set_presentment_money_currency_code SINGLE subtotal_price_set_shop_money_amount SINGLE subtotal_price_set_shop_money_currency_code SINGLE subtotal_price_set_presentment_money_amount SINGLE subtotal_price_set_presentment_money_currency_code SINGLE total_price_set_shop_money_amount SINGLE total_price_set_shop_money_currency_code SINGLE total_price_set_presentment_money_amount SINGLE total_price_set_presentment_money_currency_code SINGLE total_tax_set_shop_money_amount SINGLE total_tax_set_shop_money_currency_code SINGLE total_tax_set_presentment_money_amount SINGLE total_tax_set_presentment_money_currency_code SINGLE shipping_lines_id SINGLE shipping_lines_title SINGLE shipping_lines_price SINGLE shipping_lines_code SINGLE shipping_lines_source SINGLE shipping_lines_phone SINGLE shipping_lines_requested_fulfillment_service_id SINGLE shipping_lines_delivery_category SINGLE shipping_lines_carrier_identifier SINGLE shipping_lines_discounted_price SINGLE shipping_lines_tax_lines_title SINGLE shipping_lines_tax_lines_price SINGLE shipping_lines_tax_lines_rate SINGLE
OrderItemData	SPREADSHEET
	Folgende Felder sind im Output enthalten: Feld Datentyp Beschreibung Standardwert identifier SINGLE line_items_identifier SINGLE line_items_order_id SINGLE line_items_order_number SINGLE line_items_id SINGLE line_items_variant_id SINGLE line_items_title SINGLE line_items_quantity SINGLE line_items_sku SINGLE line_items_variant_title SINGLE line_items_vendor SINGLE line_items_fulfillment_service SINGLE line_items_product_id SINGLE line_items_requires_shipping SINGLE line_items_taxable SINGLE line_items_gift_card SINGLE line_items_name SINGLE line_items_variant_inventory_management SINGLE line_items_product_exists SINGLE line_items_fulfillable_quantity SINGLE line_items_grams SINGLE line_items_price SINGLE line_items_total_discount SINGLE line_items_fulfillment_status SINGLE line_items_discount_allocations SINGLE line_items_admin_graphql_api_id SINGLE line_items_properties SINGLE line_items_properties_name SINGLE line_items_properties_value SINGLE line_items_price_set_shop_money_amount SINGLE line_items_price_set_shop_money_currency_code SINGLE line_items_price_set_presentment_money_amount SINGLE line_items_price_set_presentment_money_currency_code SINGLE line_items_tax_lines_title SINGLE line_items_tax_lines_price SINGLE line_items_tax_lines_rate SINGLE line_items_total_discount_set_presentment_money_amount SINGLE line_items_total_discount_set_presentment_money_currency_code SINGLE
OrderRefundItemData	SPREADSHEET
	Folgende Felder sind im Output enthalten: Feld Datentyp Beschreibung Standardwert identifier SINGLE refund_line_items_identifier SINGLE refund_line_items_order_id SINGLE refund_line_items_order_number SINGLE refund_id SINGLE refund_line_item_id SINGLE refund_line_items_created_at SINGLE refund_line_items_processed_at SINGLE refund_quantity SINGLE refund_restock_type SINGLE refund_subtotal SINGLE refund_total_tax SINGLE refund_line_items_fulfillable_quantity SINGLE refund_line_items_fulfillment_service SINGLE refund_line_items_fulfillment_status SINGLE refund_line_items_name SINGLE refund_line_items_price SINGLE refund_line_items_product_id SINGLE refund_line_items_quantity SINGLE refund_line_items_sku SINGLE refund_line_items_taxable SINGLE refund_line_items_title SINGLE refund_line_items_variant_id SINGLE refund_line_items_properties_value SINGLE refund_line_items_properties SINGLE refund_line_items_total_discount SINGLE
OrderFulfillments	SPREADSHEET