woocommerceGetOrders

Auftragsdaten abfragen

ext. Version: API v3 - wc 3.5.x or later

Retrieve order data from woocommerce.

Über Synesty Studio für woocommerce

Mit Synesty als Middleware verbinden Sie woocommerce mit anderen Systemen, Schnittstellen und APIs ohne Programmierung per Drag&Drop. Automatisieren Sie Geschäftsprozesse und Integrationen wie EDI Datenimport / Export.

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 Low Code Scripting Tools ermöglichen kreative Anpassungen für jede Art von Integration.

Zum Add-On

Über Synesty Studio für woocommerce

Zum Add-On

Inputs

Name	Datentyp	Beschreibung	Pflichtfeld	Werte
account	ACCOUNT	account data	Ja
status	STRING	Limit result set to orders assigned a specific status.	Ja	any (Standardwert) pending processing on-hold completed cancelled refunded failed
createdAt	DATETIME	Limit response to orders created AFTER the given date.	Nein	Standardwert:
limit	STRING	Limit of order pages to be retrieved. One page contains 10 orders. The default value is 1. Enter a corresponding high number to retrieve all orders.	Nein	Standardwert: 1

Outputs

Name

Datentyp

Beschreibung

OrderData

SPREADSHEET

Folgende Felder sind im Output enthalten:

Feld	Beschreibung	Datentyp	Pflichtfeld	Standardwert
order_identifiere		Text
order_item_identifiere		Text
id		Text
parent_id		Text
number		Text
order_key		Text
created_via		Text
version		Text
status		Text
currency		Text
date_created		Text
date_created_gmt		Text
date_modified		Text
date_modified_gmt		Text
discount_total		Text
discount_tax		Text
shipping_total		Text
shipping_tax		Text
cart_tax		Text
total		Text
total_tax		Text
prices_include_tax		Text
customer_id		Text
customer_ip_address		Text
customer_user_agent		Text
customer_note		Text
billing_first_name		Text
billing_last_name		Text
billing_company		Text
billing_address_1		Text
billing_address_2		Text
billing_city		Text
billing_state		Text
billing_postcode		Text
billing_country		Text
billing_email		Text
billing_phone		Text
billing_title		Text
shipping_first_name		Text
shipping_last_name		Text
shipping_company		Text
shipping_address_1		Text
shipping_address_2		Text
shipping_city		Text
shipping_state		Text
shipping_postcode		Text
shipping_country		Text
shipping_title		Text
shipping_parcelshop		Text
shipping_parcelshop_post_number		Text
payment_method		Text
payment_method_title		Text
transaction_id		Text
date_paid		Text
date_paid_gmt		Text
date_completed		Text
date_completed_gmt		Text
cart_hash		Text
parcel_delivery_opted_in		Text
direct_debit_holder		Text
direct_debit_iban		Text
direct_debit_bic		Text
direct_debit_mandate_id		Text
meta_data_id		Text
meta_data_key		Text
meta_data_value		Text
tax_lines_id		Text
tax_lines_rate_code		Text
tax_lines_rate_id		Text
tax_lines_label		Text
tax_lines_compound		Text
tax_lines_tax_total		Text
tax_lines_shipping_tax_total		Text
tax_lines_meta_data		Text
shipping_lines_id		Text
shipping_lines_method_title		Text
shipping_lines_method_id		Text
shipping_lines_instance_id		Text
shipping_lines_total		Text
shipping_lines_total_tax		Text
shipping_lines_taxes		Text
shipping_lines_meta_data_id		Text
shipping_lines_meta_data_key		Text
shipping_lines_meta_data_value		Text
coupon_lines_id		Text
coupon_lines_code		Text
coupon_lines_discount		Text
coupon_lines_discount_tax		Text
items_id		Text
items_name		Text
items_product_id		Text
items_variation_id		Text
items_quantity		Text
items_tax_class		Text
items_subtotal		Text
items_subtotal_tax		Text
items_total		Text
items_total_tax		Text
items_sku		Text
items_price		Text
items_taxes_id		Text
items_taxes_total		Text
items_taxes_subtotal		Text
items_meta_data_id		Text
items_meta_data_key		Text
items_meta_data_value		Text

OrderHeaderData

SPREADSHEET

Folgende Felder sind im Output enthalten:

Feld	Beschreibung	Datentyp	Pflichtfeld	Standardwert
order_identifiere		Text
id		Text
parent_id		Text
number		Text
order_key		Text
created_via		Text
version		Text
status		Text
currency		Text
date_created		Text
date_created_gmt		Text
date_modified		Text
date_modified_gmt		Text
discount_total		Text
discount_tax		Text
shipping_total		Text
shipping_tax		Text
cart_tax		Text
total		Text
total_tax		Text
prices_include_tax		Text
customer_id		Text
customer_ip_address		Text
customer_user_agent		Text
customer_note		Text
billing_first_name		Text
billing_last_name		Text
billing_company		Text
billing_address_1		Text
billing_address_2		Text
billing_city		Text
billing_state		Text
billing_postcode		Text
billing_country		Text
billing_email		Text
billing_phone		Text
billing_title		Text
shipping_first_name		Text
shipping_last_name		Text
shipping_company		Text
shipping_address_1		Text
shipping_address_2		Text
shipping_city		Text
shipping_state		Text
shipping_postcode		Text
shipping_country		Text
shipping_title		Text
shipping_parcelshop		Text
shipping_parcelshop_post_number		Text
payment_method		Text
payment_method_title		Text
transaction_id		Text
date_paid		Text
date_paid_gmt		Text
date_completed		Text
date_completed_gmt		Text
cart_hash		Text
parcel_delivery_opted_in		Text
direct_debit_holder		Text
direct_debit_iban		Text
direct_debit_bic		Text
direct_debit_mandate_id		Text
meta_data_id		Text
meta_data_key		Text
meta_data_value		Text
tax_lines_id		Text
tax_lines_rate_code		Text
tax_lines_rate_id		Text
tax_lines_label		Text
tax_lines_compound		Text
tax_lines_tax_total		Text
tax_lines_shipping_tax_total		Text
tax_lines_meta_data		Text
shipping_lines_id		Text
shipping_lines_method_title		Text
shipping_lines_method_id		Text
shipping_lines_instance_id		Text
shipping_lines_total		Text
shipping_lines_total_tax		Text
shipping_lines_taxes		Text
shipping_lines_meta_data_id		Text
shipping_lines_meta_data_key		Text
shipping_lines_meta_data_value		Text
coupon_lines_id		Text
coupon_lines_code		Text
coupon_lines_discount		Text
coupon_lines_discount_tax		Text

OrderItemData

SPREADSHEET

Folgende Felder sind im Output enthalten:

Feld	Beschreibung	Datentyp	Pflichtfeld	Standardwert
order_identifiere		Text
order_item_identifiere		Text
items_id		Text
items_name		Text
items_product_id		Text
items_variation_id		Text
items_quantity		Text
items_tax_class		Text
items_subtotal		Text
items_subtotal_tax		Text
items_total		Text
items_total_tax		Text
items_sku		Text
items_price		Text
items_taxes_id		Text
items_taxes_total		Text
items_taxes_subtotal		Text
items_meta_data_id		Text
items_meta_data_key		Text
items_meta_data_value		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

Weitere Steps in woocommerce

Name	Version	Beschreibung	Anwendungsfall
woocommerceGetOrders (ext. Version: API v3 - wc 3.5.x or later) woocommerceGetOrders (ext. Version: API v3 - wc 3.5.x or later)	API v3 - wc 3.5.x or later	Retrieve order data from woocommerce.	Auftragsdaten abfragen
woocommerceGetCategories (ext. Version: API v3 - wc 3.5.x or later) woocommerceGetCategories (ext. Version: API v3 - wc 3.5.x or later)	API v3 - wc 3.5.x or later	Retrieve categories from woocommerce.	Produktdaten abfragen
woocommerceCreateUpdateCategories (ext. Version: API v3 - wc 3.5.x or later) woocommerceCreateUpdateCategories (ext. Version: API v3 - wc 3.5.x or later)	API v3 - wc 3.5.x or later	Create or update woocommerce categories.	Produktdaten setzen bzw. aktualisieren
woocommerceUpdateProductVariations (ext. Version: API v3 - wc 3.5.x or later) woocommerceUpdateProductVariations (ext. Version: API v3 - wc 3.5.x or later)	API v3 - wc 3.5.x or later	Updates product information for product variants including price and stock	Produktdaten setzen bzw. aktualisieren , Bestand / Verfügbarkeit setzen bzw. aktualisieren , Preise setzen bzw. aktualisieren
woocommerceGetProducts (ext. Version: API v3 - wc 3.5.x or later) woocommerceGetProducts (ext. Version: API v3 - wc 3.5.x or later)	API v3 - wc 3.5.x or later	Retrieves products and product variations from woocommerce.	Produktdaten abfragen , Bestand / Verfügbarkeit abfragen , Preise abfragen
woocommerceGetOrders (ext. Version: API v2 - wc 3.0.x or later) woocommerceGetOrders (ext. Version: API v2 - wc 3.0.x or later)	API v2 - wc 3.0.x or later	Retrieve order data from woocommerce.	Auftragsdaten abfragen
woocommerceCreateSimpleProducts (ext. Version: API v3 - wc 3.5.x or later) woocommerceCreateSimpleProducts (ext. Version: API v3 - wc 3.5.x or later)	API v3 - wc 3.5.x or later	Creates products of the product type "Simple product".	Produktdaten setzen bzw. aktualisieren
woocommerceUpdateOrders (ext. Version: API v3 - wc 3.5.x or later) woocommerceUpdateOrders (ext. Version: API v3 - wc 3.5.x or later)	API v3 - wc 3.5.x or later	Updates the order status	Auftragsdaten setzen bzw. aktualisieren