1. Add-Ons
  2. shopify
  3. shopifyGetOrders

shopifyGetOrders

Auftragsdaten abfragen

ext. Version: 2019-04

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
Dokumentation im Handbuch aufrufen

Warum Synesty?

  • NoCode Middleware für Integrationen, Schnittstellen & Automatisierung von Geschäftsprozessen.
  • Drag&Drop und Konfiguration - Scripting wenn nötig
  • Schneller und professioneller Support
  • Sehen Sie sich unsere Demo an

Sie haben Fragen zu Ihrem konkreten Anwendungsfall?

Schreiben Sie uns.

Warum Synesty?

  • NoCode Middleware für Integrationen, Schnittstellen & Automatisierung von Geschäftsprozessen.
  • Drag&Drop und Konfiguration - Scripting wenn nötig
  • Schneller und professioneller Support
  • Sehen Sie sich unsere Demo an

Sie haben Fragen zu Ihrem konkreten Anwendungsfall?

Schreiben Sie uns.

Inputs

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

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 zertifizierten Partner. Partner finden

Weitere Steps in shopify


Name Version Beschreibung Anwendungsfall
shopifyModifyProductImages (ext. Version: 2020-10)
shopifyModifyProductImages (ext. Version: 2020-10)
2020-10

Modifies images in shopify. The image position, the alt text and the corresponding variants to the image can be modified. The specified variants to the image are added in addition to any already assigned variant.
Bilder setzen bzw. aktualisieren
shopifyOrderFulfillment (ext. Version: 2020-07)
shopifyOrderFulfillment (ext. Version: 2020-07)
2020-07

This step fullfills all or partialy line items for an order. In addition (optional), tracking information can be added and the customer can be notified via e-mail.
shopifySetInventoryLevel (ext. Version: 2020-10)
shopifySetInventoryLevel (ext. Version: 2020-10)
2020-10

This step sets the inventory of items in a specified location. If no location is determined the default location with the shipping origin address is used.

Please note that only items can be processed by this step where "shopify" is set for inventory management!

 
Produktdaten setzen bzw. aktualisieren
shopifyAddProductMetafields (ext. Version: 2020-10)
shopifyAddProductMetafields (ext. Version: 2020-10)
2020-10

Creates new metafields for products or product variants.
shopifyDeleteMetafields (ext. Version: 2020-10)
shopifyDeleteMetafields (ext. Version: 2020-10)
2020-10

Deletes metafields.
Produktdaten setzen bzw. aktualisieren
shopifyGetRefunds (ext. Version: 2020-10)
shopifyGetRefunds (ext. Version: 2020-10)
2020-10

Retrieves all refund information including refunded items, order adjustments and transactions of all orders according to the set order status, financial status and fulfillment status. The retrieval of orders can be additionally limited by specifying the order creation date (optional) and the order updated date (optional).
Auftragsdaten setzen bzw. aktualisieren
shopifyGetProductImages (ext. Version: 2020-10)
shopifyGetProductImages (ext. Version: 2020-10)
2020-10

Retrieves a list of product images.
Bilder abfragen
shopifyGetOrders (ext. Version: 2020-10)
shopifyGetOrders (ext. Version: 2020-10)
2020-10

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.
Auftragsdaten abfragen
shopifyGetProductMetafields (ext. Version: 2020-10)
shopifyGetProductMetafields (ext. Version: 2020-10)
2020-10

Retrieves a list of metafields that belong to a product or a product variant.
Produktdaten setzen bzw. aktualisieren
shopifyAddVariantToProduct (ext. Version: 2020-10)
shopifyAddVariantToProduct (ext. Version: 2020-10)
2020-10

With this step variants will be added to a simple products with the option1 parameters. 

Does the product already has variants it will also use the option2 and 3 parameters if they exists.
Produktdaten setzen bzw. aktualisieren
shopifyUpdateVariantInformation (ext. Version: 2020-10)
shopifyUpdateVariantInformation (ext. Version: 2020-10)
2020-10

With this step variants will be updated.
Produktdaten setzen bzw. aktualisieren , Preise setzen bzw. aktualisieren
shopifyUpdatePriceAndBarcode (ext. Version: 2020-10)
shopifyUpdatePriceAndBarcode (ext. Version: 2020-10)
2020-10

With this step the price and the barcode of an already created product can be updated.
Produktdaten setzen bzw. aktualisieren , Preise setzen bzw. aktualisieren
shopifyOrderFulfillment (ext. Version: 2020-10)
shopifyOrderFulfillment (ext. Version: 2020-10)
2020-10

This step fullfills all line items for an order. In addition (optional), tracking information can be added and the customer can be notified via e-mail.
Auftragsdaten setzen bzw. aktualisieren , Tracking / Versanddaten setzen bzw. aktualisieren
shopifyGetFulfilledItems (ext. Version: 2020-10)
shopifyGetFulfilledItems (ext. Version: 2020-10)
2020-10

Retrieves all fulfilled items. All orders with the fulfillment status fulfilled (shipped) and partially fulfilled (partially shipped) are processed. The retrieval of orders can be limited by specifying the order status.
Auftragsdaten abfragen , Tracking / Versanddaten abfragen
shopifyAddSingleProducts (ext. Version: 2020-10)
shopifyAddSingleProducts (ext. Version: 2020-10)
2020-10

With this step simple products (without variants) can be created in shopify. Version 2.0 supports the new inventory management of shopify.
Produktdaten setzen bzw. aktualisieren
shopifyCreateOrders (ext. Version: 2020-10)
shopifyCreateOrders (ext. Version: 2020-10)
2020-10

Creates orders in shopify. Orders to create in shopify must first be stored in a master-child datastore with a predefined schema. Only orders in processing status UNPROCESSED will be proceeded.
Auftragsdaten setzen bzw. aktualisieren
shopifyGetLocations (ext. Version: 2020-10)
shopifyGetLocations (ext. Version: 2020-10)
2020-10

Retrieves a list of all locations
Reports / Auswertungen abfragen
shopifyAddProduct (ext. Version: 2020-10)
shopifyAddProduct (ext. Version: 2020-10)
2020-10

With this step simple products (without variants) or products with its first variant(mainvariant)can be created in shopify. Version 2.0 supports the new inventory management of shopify.

To create a product with variant you have to fill at least the option1 parameters.
Produktdaten setzen bzw. aktualisieren , Bilder setzen bzw. aktualisieren
shopifyGetProducts (ext. Version: 2020-10)
shopifyGetProducts (ext. Version: 2020-10)
2020-10

Retrieves a list of products and product variants.
Produktdaten abfragen , Bestand / Verfügbarkeit abfragen , Preise abfragen
shopifyGetOrderTransactions (ext. Version: 2020-07)
shopifyGetOrderTransactions (ext. Version: 2020-07)
2020-07

Retrieves all transaction for all specified order_id's.
Auftragsdaten setzen bzw. aktualisieren , Tracking / Versanddaten setzen bzw. aktualisieren
shopifyDeleteProductImages (ext. Version: 2020-10)
shopifyDeleteProductImages (ext. Version: 2020-10)
2020-10

Deletes images in shopify.
Bilder setzen bzw. aktualisieren
shopifyUploadProductImages (ext. Version: 2020-10)
shopifyUploadProductImages (ext. Version: 2020-10)
2020-10

Uploads new product images to a product via an image URL. In addition, the position and the alt text and the corresponding variants to the image can also be specified.
Bilder setzen bzw. aktualisieren
shopifyUpdateProductInformation (ext. Version: 2020-10)
shopifyUpdateProductInformation (ext. Version: 2020-10)
2020-10

With this step the product information of an already created product can be updated.
Produktdaten setzen bzw. aktualisieren
shopifyGetCountriesAndTax (ext. Version: 2020-10)
shopifyGetCountriesAndTax (ext. Version: 2020-10)
2020-10

Retrieves countries and all tax rates for the countries you ship to.
Reports / Auswertungen abfragen
shopifyUpdateMetafields (ext. Version: 2020-10)
shopifyUpdateMetafields (ext. Version: 2020-10)
2020-10

Updates metafields. Please note that namespace and key cannot be changed.
Produktdaten setzen bzw. aktualisieren