shopifyGetOrders

ext. Version: 2019-04

Bestellungen abrufen

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.

Step veraltet: deprecated - please use the latest step version of step shopifyGetOrders

Über Synesty Studio

Mit Synesty als No Code Middleware verbinden Sie Ihre Systeme, Schnittstellen und APIs ohne Programmierung per Drag&Drop. Automatisieren Sie Geschäftsprozesse und Integrationen wie EDI Datenimport / Export oder eine einmalige Daten-Migration.

Wir unterstützen Datenformate wie CSV, Excel (XLS/XLSX), XML oder JSON und ermöglichen auch HTTP-Konnektoren zu REST- oder GraphQL-APIs. Kunden nutzen es auch für Auswertungen, ETL-Aufgaben oder Feed-Optimierung.
Unser No Code Flow-Editor und unsere Low Code Scripting Tools ermöglichen kreative Anpassungen für jede Art von Integration.

Jetzt registrieren und zeitlich unbegrenzt testen

Über Synesty Studio

Jetzt registrieren und zeitlich unbegrenzt testen

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 (Standardwert) 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 (Standardwert) 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 (Standardwert) shipped partially shipped unshipped
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	Standardwert:
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	Standardwert:

Outputs

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

Name

Datentyp

Beschreibung

Orders

SPREADSHEET

Folgende Felder sind im Output enthalten:

Feld	Beschreibung	Datentyp	Pflichtfeld	Standardwert
id		Text
email		Text
closed_at		Text
created_at		Text
updated_at		Text
number		Text
note		Text
token		Text
gateway		Text
test		Text
total_price		Text
subtotal_price		Text
total_weight		Text
total_tax		Text
taxes_included		Text
currency		Text
financial_status		Text
confirmed		Text
total_discounts		Text
total_line_items_price		Text
cart_token		Text
buyer_accepts_marketing		Text
name		Text
referring_site		Text
landing_site		Text
cancelled_at		Text
cancel_reason		Text
total_price_usd		Text
checkout_token		Text
reference		Text
user_id		Text
location_id		Text
source_identifier		Text
source_url		Text
processed_at		Text
device_id		Text
phone		Text
customer_locale		Text
app_id		Text
browser_ip		Text
landing_site_ref		Text
order_number		Text
discount_codes_code		Text
discount_codes_amount		Text
discount_codes_type		Text
note_attributes		Text
payment_gateway_names		Text
processing_method		Text
checkout_id		Text
source_name		Text
fulfillment_status		Text
tags		Text
contact_email		Text
order_status_url		Text
presentment_currency		Text
total_tip_received		Text
admin_graphql_api_id		Text
customer_id		Text
customer_email		Text
customer_accepts_marketing		Text
customer_created_at		Text
customer_updated_at		Text
customer_first_name		Text
customer_last_name		Text
customer_orders_count		Text
customer_state		Text
customer_total_spent		Text
customer_last_order_id		Text
customer_note		Text
customer_verified_email		Text
customer_multipass_identifier		Text
customer_tax_exempt		Text
customer_phone		Text
customer_tags		Text
customer_last_order_name		Text
customer_currency		Text
customer_accepts_marketing_updated_at		Text
customer_marketing_opt_in_level		Text
customer_admin_graphql_api_id		Text
customer_default_address_id		Text
customer_default_address_customer_id		Text
customer_default_address_first_name		Text
customer_default_address_last_name		Text
customer_default_address_company		Text
customer_default_address_address1		Text
customer_default_address_address2		Text
customer_default_address_city		Text
customer_default_address_province		Text
customer_default_address_country		Text
customer_default_address_zip		Text
customer_default_address_phone		Text
customer_default_address_name		Text
customer_default_address_province_code		Text
customer_default_address_country_code		Text
customer_default_address_country_name		Text
customer_default_address_default		Text
billing_address_first_name		Text
billing_address_address1		Text
billing_address_phone		Text
billing_address_city		Text
billing_address_zip		Text
billing_address_province		Text
billing_address_country		Text
billing_address_last_name		Text
billing_address_address2		Text
billing_address_company		Text
billing_address_latitude		Text
billing_address_longitude		Text
billing_address_name		Text
billing_address_country_code		Text
billing_address_province_code		Text
shipping_address_first_name		Text
shipping_address_address1		Text
shipping_address_phone		Text
shipping_address_city		Text
shipping_address_zip		Text
shipping_address_province		Text
shipping_address_country		Text
shipping_address_last_name		Text
shipping_address_address2		Text
shipping_address_company		Text
shipping_address_latitude		Text
shipping_address_longitude		Text
shipping_address_name		Text
shipping_address_country_code		Text
shipping_address_province_code		Text
fulfillments_id		Text
fulfillments_order_id		Text
fulfillments_status		Text
fulfillments_created_at		Text
fulfillments_service		Text
fulfillments_updated_at		Text
fulfillments_tracking_company		Text
fulfillments_shipment_status		Text
fulfillments_location_id		Text
fulfillments_tracking_number		Text
fulfillments_tracking_numbers		Text
fulfillments_tracking_url		Text
fulfillments_tracking_urls		Text
fulfillments_name		Text
fulfillments_admin_graphql_api_id		Text
refunds_id		Text
refunds_order_id		Text
refunds_created_at		Text
refunds_note		Text
refunds_user_id		Text
refunds_processed_at		Text
refunds_restock		Text
refunds_admin_graphql_api_id		Text
tax_lines_price		Text
tax_lines_rate		Text
tax_lines_title		Text
total_line_items_price_set_shop_money_amount		Text
total_line_items_price_set_shop_money_currency_code		Text
total_line_items_price_set_presentment_money_amount		Text
total_line_items_price_set_presentment_money_currency_code		Text
total_discounts_set_shop_money_amount		Text
total_discounts_set_shop_money_currency_code		Text
total_discounts_set_presentment_money_amount		Text
total_discounts_set_presentment_money_currency_code		Text
total_shipping_price_set_shop_money_amount		Text
total_shipping_price_set_shop_money_currency_code		Text
total_shipping_price_set_presentment_money_amount		Text
total_shipping_price_set_presentment_money_currency_code		Text
subtotal_price_set_shop_money_amount		Text
subtotal_price_set_shop_money_currency_code		Text
subtotal_price_set_presentment_money_amount		Text
subtotal_price_set_presentment_money_currency_code		Text
total_price_set_shop_money_amount		Text
total_price_set_shop_money_currency_code		Text
total_price_set_presentment_money_amount		Text
total_price_set_presentment_money_currency_code		Text
total_tax_set_shop_money_amount		Text
total_tax_set_shop_money_currency_code		Text
total_tax_set_presentment_money_amount		Text
total_tax_set_presentment_money_currency_code		Text
shipping_lines_id		Text
shipping_lines_title		Text
shipping_lines_price		Text
shipping_lines_code		Text
shipping_lines_source		Text
shipping_lines_phone		Text
shipping_lines_requested_fulfillment_service_id		Text
shipping_lines_delivery_category		Text
shipping_lines_carrier_identifier		Text
shipping_lines_discounted_price		Text
shipping_lines_tax_lines_title		Text
shipping_lines_tax_lines_price		Text
shipping_lines_tax_lines_rate		Text
line_items_identifier		Text
line_items_order_id		Text
line_items_order_number		Text
line_items_id		Text
line_items_variant_id		Text
line_items_title		Text
line_items_quantity		Text
line_items_sku		Text
line_items_variant_title		Text
line_items_vendor		Text
line_items_fulfillment_service		Text
line_items_product_id		Text
line_items_requires_shipping		Text
line_items_taxable		Text
line_items_gift_card		Text
line_items_name		Text
line_items_variant_inventory_management		Text
line_items_product_exists		Text
line_items_fulfillable_quantity		Text
line_items_grams		Text
line_items_price		Text
line_items_total_discount		Text
line_items_fulfillment_status		Text
line_items_discount_allocations		Text
line_items_admin_graphql_api_id		Text
line_items_properties		Text
line_items_properties_name		Text
line_items_properties_value		Text
line_items_price_set_shop_money_amount		Text
line_items_price_set_shop_money_currency_code		Text
line_items_price_set_presentment_money_amount		Text
line_items_price_set_presentment_money_currency_code		Text
line_items_tax_lines_title		Text
line_items_tax_lines_price		Text
line_items_tax_lines_rate		Text

OrderHeaderData

SPREADSHEET

Folgende Felder sind im Output enthalten:

Feld	Beschreibung	Datentyp	Pflichtfeld	Standardwert
id		Text
email		Text
closed_at		Text
created_at		Text
updated_at		Text
number		Text
note		Text
token		Text
gateway		Text
test		Text
total_price		Text
subtotal_price		Text
total_weight		Text
total_tax		Text
taxes_included		Text
currency		Text
financial_status		Text
confirmed		Text
total_discounts		Text
total_line_items_price		Text
cart_token		Text
buyer_accepts_marketing		Text
name		Text
referring_site		Text
landing_site		Text
cancelled_at		Text
cancel_reason		Text
total_price_usd		Text
checkout_token		Text
reference		Text
user_id		Text
location_id		Text
source_identifier		Text
source_url		Text
processed_at		Text
device_id		Text
phone		Text
customer_locale		Text
app_id		Text
browser_ip		Text
landing_site_ref		Text
order_number		Text
discount_codes_code		Text
discount_codes_amount		Text
discount_codes_type		Text
note_attributes		Text
payment_gateway_names		Text
processing_method		Text
checkout_id		Text
source_name		Text
fulfillment_status		Text
tags		Text
contact_email		Text
order_status_url		Text
presentment_currency		Text
total_tip_received		Text
admin_graphql_api_id		Text
customer_id		Text
customer_email		Text
customer_accepts_marketing		Text
customer_created_at		Text
customer_updated_at		Text
customer_first_name		Text
customer_last_name		Text
customer_orders_count		Text
customer_state		Text
customer_total_spent		Text
customer_last_order_id		Text
customer_note		Text
customer_verified_email		Text
customer_multipass_identifier		Text
customer_tax_exempt		Text
customer_phone		Text
customer_tags		Text
customer_last_order_name		Text
customer_currency		Text
customer_accepts_marketing_updated_at		Text
customer_marketing_opt_in_level		Text
customer_admin_graphql_api_id		Text
customer_default_address_id		Text
customer_default_address_customer_id		Text
customer_default_address_first_name		Text
customer_default_address_last_name		Text
customer_default_address_company		Text
customer_default_address_address1		Text
customer_default_address_address2		Text
customer_default_address_city		Text
customer_default_address_province		Text
customer_default_address_country		Text
customer_default_address_zip		Text
customer_default_address_phone		Text
customer_default_address_name		Text
customer_default_address_province_code		Text
customer_default_address_country_code		Text
customer_default_address_country_name		Text
customer_default_address_default		Text
billing_address_first_name		Text
billing_address_address1		Text
billing_address_phone		Text
billing_address_city		Text
billing_address_zip		Text
billing_address_province		Text
billing_address_country		Text
billing_address_last_name		Text
billing_address_address2		Text
billing_address_company		Text
billing_address_latitude		Text
billing_address_longitude		Text
billing_address_name		Text
billing_address_country_code		Text
billing_address_province_code		Text
shipping_address_first_name		Text
shipping_address_address1		Text
shipping_address_phone		Text
shipping_address_city		Text
shipping_address_zip		Text
shipping_address_province		Text
shipping_address_country		Text
shipping_address_last_name		Text
shipping_address_address2		Text
shipping_address_company		Text
shipping_address_latitude		Text
shipping_address_longitude		Text
shipping_address_name		Text
shipping_address_country_code		Text
shipping_address_province_code		Text
fulfillments_id		Text
fulfillments_order_id		Text
fulfillments_status		Text
fulfillments_created_at		Text
fulfillments_service		Text
fulfillments_updated_at		Text
fulfillments_tracking_company		Text
fulfillments_shipment_status		Text
fulfillments_location_id		Text
fulfillments_tracking_number		Text
fulfillments_tracking_numbers		Text
fulfillments_tracking_url		Text
fulfillments_tracking_urls		Text
fulfillments_name		Text
fulfillments_admin_graphql_api_id		Text
refunds_id		Text
refunds_order_id		Text
refunds_created_at		Text
refunds_note		Text
refunds_user_id		Text
refunds_processed_at		Text
refunds_restock		Text
refunds_admin_graphql_api_id		Text
tax_lines_price		Text
tax_lines_rate		Text
tax_lines_title		Text
total_line_items_price_set_shop_money_amount		Text
total_line_items_price_set_shop_money_currency_code		Text
total_line_items_price_set_presentment_money_amount		Text
total_line_items_price_set_presentment_money_currency_code		Text
total_discounts_set_shop_money_amount		Text
total_discounts_set_shop_money_currency_code		Text
total_discounts_set_presentment_money_amount		Text
total_discounts_set_presentment_money_currency_code		Text
total_shipping_price_set_shop_money_amount		Text
total_shipping_price_set_shop_money_currency_code		Text
total_shipping_price_set_presentment_money_amount		Text
total_shipping_price_set_presentment_money_currency_code		Text
subtotal_price_set_shop_money_amount		Text
subtotal_price_set_shop_money_currency_code		Text
subtotal_price_set_presentment_money_amount		Text
subtotal_price_set_presentment_money_currency_code		Text
total_price_set_shop_money_amount		Text
total_price_set_shop_money_currency_code		Text
total_price_set_presentment_money_amount		Text
total_price_set_presentment_money_currency_code		Text
total_tax_set_shop_money_amount		Text
total_tax_set_shop_money_currency_code		Text
total_tax_set_presentment_money_amount		Text
total_tax_set_presentment_money_currency_code		Text
shipping_lines_id		Text
shipping_lines_title		Text
shipping_lines_price		Text
shipping_lines_code		Text
shipping_lines_source		Text
shipping_lines_phone		Text
shipping_lines_requested_fulfillment_service_id		Text
shipping_lines_delivery_category		Text
shipping_lines_carrier_identifier		Text
shipping_lines_discounted_price		Text
shipping_lines_tax_lines_title		Text
shipping_lines_tax_lines_price		Text
shipping_lines_tax_lines_rate		Text

OrderItemData

SPREADSHEET

Folgende Felder sind im Output enthalten:

Feld	Beschreibung	Datentyp	Pflichtfeld	Standardwert
line_items_identifier		Text
line_items_order_id		Text
line_items_order_number		Text
line_items_id		Text
line_items_variant_id		Text
line_items_title		Text
line_items_quantity		Text
line_items_sku		Text
line_items_variant_title		Text
line_items_vendor		Text
line_items_fulfillment_service		Text
line_items_product_id		Text
line_items_requires_shipping		Text
line_items_taxable		Text
line_items_gift_card		Text
line_items_name		Text
line_items_variant_inventory_management		Text
line_items_product_exists		Text
line_items_fulfillable_quantity		Text
line_items_grams		Text
line_items_price		Text
line_items_total_discount		Text
line_items_fulfillment_status		Text
line_items_discount_allocations		Text
line_items_admin_graphql_api_id		Text
line_items_properties		Text
line_items_properties_name		Text
line_items_properties_value		Text
line_items_price_set_shop_money_amount		Text
line_items_price_set_shop_money_currency_code		Text
line_items_price_set_presentment_money_amount		Text
line_items_price_set_presentment_money_currency_code		Text
line_items_tax_lines_title		Text
line_items_tax_lines_price		Text
line_items_tax_lines_rate		Text

Hilfe oder Projektsupport gewünscht?

Wenn Sie Unterstützung oder Beratung für Ihr Vorhaben benötigen, begleiten wir Sie mit gezielten Workshops und Trainings auf dem Weg zum erfolgreichen Einsatz von Synesty.
Weitere Informationen

shopifyGetOrders wird oft in Verbindung mit folgenden Steps verwendet:

Name	Version	Beschreibung	Anwendungsfall
Filter Filter	-	Kann ein Spreadheet nach einem bestimmten Ausdruck in der Freemarker-Syntax filtern und gibt nur Zeilen zurück, die der Filterbedingung entsprechen. Es wird auch ein zweites SPREADSHEET ausgegeben, das das negative Ergebnis enthält (Zeilen, die nicht der Filterbedingung entsprechen).
Mapper Mapper	-	Wandelt ein Spreadsheet in ein anderes um.