shopifyGetOrders Step

shopifyGetOrders

ext. Version: 2019-04
Bestellungen abrufen / auslesen

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

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

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 Hilfe bei der Einrichtung dieses Steps benötigen oder ein Projekt umsetzen wollen, dann unterstützen Sie unsere verifizierten Partner. Partner finden

shopifyGetOrders wird oft in Verbindung mit folgenden Steps verwendet:

Name Version Beschreibung Anwendungsfall
Filter Step 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 Step Mapper
Mapper
- Wandelt ein Spreadsheet in ein anderes um.