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