- Version: API v3 - wc 3.5.x or later
- Add-On
Retrieve order data from woocommerce.
Das sind die Optionen, mit denen man den Step konfigurieren kann.
Name | Datentyp | Beschreibung | Pflichtfeld | Werte |
account | ACCOUNT | account data | Ja | |
status | STRING | Limit result set to orders assigned a specific status. | Ja | - any
- pending
- processing
- on-hold
- completed
- cancelled
- refunded
- failed
|
createdAt | DATETIME | Limit response to orders created AFTER the given date. | Nein | |
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 | |
Das sind die Ergebnisse des Steps, die von nachfolgenden Steps, nach der Ausführung verwendet werden können.
Name | Datentyp | Beschreibung | Pflichtfeld | Werte |
OrderData | SPREADSHEET | | Ja | |
| Folgende Felder sind im Output enthalten:
Feld | Datentyp | Beschreibung | Pflichtfeld | Standardwert | identifier | SINGLE | | Nein | | parent_identifier | SINGLE | | Nein | | order_identifiere | SINGLE | | Nein | | order_item_identifiere | SINGLE | | Nein | | id | SINGLE | | Nein | | parent_id | SINGLE | | Nein | | number | SINGLE | | Nein | | order_key | SINGLE | | Nein | | created_via | SINGLE | | Nein | | version | SINGLE | | Nein | | status | SINGLE | | Nein | | currency | SINGLE | | Nein | | date_created | SINGLE | | Nein | | date_created_gmt | SINGLE | | Nein | | date_modified | SINGLE | | Nein | | date_modified_gmt | SINGLE | | Nein | | discount_total | SINGLE | | Nein | | discount_tax | SINGLE | | Nein | | shipping_total | SINGLE | | Nein | | shipping_tax | SINGLE | | Nein | | cart_tax | SINGLE | | Nein | | total | SINGLE | | Nein | | total_tax | SINGLE | | Nein | | prices_include_tax | SINGLE | | Nein | | customer_id | SINGLE | | Nein | | customer_ip_address | SINGLE | | Nein | | customer_user_agent | SINGLE | | Nein | | customer_note | SINGLE | | Nein | | billing_first_name | SINGLE | | Nein | | billing_last_name | SINGLE | | Nein | | billing_company | SINGLE | | Nein | | billing_address_1 | SINGLE | | Nein | | billing_address_2 | SINGLE | | Nein | | billing_city | SINGLE | | Nein | | billing_state | SINGLE | | Nein | | billing_postcode | SINGLE | | Nein | | billing_country | SINGLE | | Nein | | billing_email | SINGLE | | Nein | | billing_phone | SINGLE | | Nein | | billing_title | SINGLE | | Nein | | shipping_first_name | SINGLE | | Nein | | shipping_last_name | SINGLE | | Nein | | shipping_company | SINGLE | | Nein | | shipping_address_1 | SINGLE | | Nein | | shipping_address_2 | SINGLE | | Nein | | shipping_city | SINGLE | | Nein | | shipping_state | SINGLE | | Nein | | shipping_postcode | SINGLE | | Nein | | shipping_country | SINGLE | | Nein | | shipping_title | SINGLE | | Nein | | shipping_parcelshop | SINGLE | | Nein | | shipping_parcelshop_post_number | SINGLE | | Nein | | payment_method | SINGLE | | Nein | | payment_method_title | SINGLE | | Nein | | transaction_id | SINGLE | | Nein | | date_paid | SINGLE | | Nein | | date_paid_gmt | SINGLE | | Nein | | date_completed | SINGLE | | Nein | | date_completed_gmt | SINGLE | | Nein | | cart_hash | SINGLE | | Nein | | parcel_delivery_opted_in | SINGLE | | Nein | | direct_debit_holder | SINGLE | | Nein | | direct_debit_iban | SINGLE | | Nein | | direct_debit_bic | SINGLE | | Nein | | direct_debit_mandate_id | SINGLE | | Nein | | meta_data_id | SINGLE | | Nein | | meta_data_key | SINGLE | | Nein | | meta_data_value | SINGLE | | Nein | | tax_lines_id | SINGLE | | Nein | | tax_lines_rate_code | SINGLE | | Nein | | tax_lines_rate_id | SINGLE | | Nein | | tax_lines_label | SINGLE | | Nein | | tax_lines_compound | SINGLE | | Nein | | tax_lines_tax_total | SINGLE | | Nein | | tax_lines_shipping_tax_total | SINGLE | | Nein | | tax_lines_meta_data | SINGLE | | Nein | | shipping_lines_id | SINGLE | | Nein | | shipping_lines_method_title | SINGLE | | Nein | | shipping_lines_method_id | SINGLE | | Nein | | shipping_lines_instance_id | SINGLE | | Nein | | shipping_lines_total | SINGLE | | Nein | | shipping_lines_total_tax | SINGLE | | Nein | | shipping_lines_taxes | SINGLE | | Nein | | shipping_lines_meta_data_id | SINGLE | | Nein | | shipping_lines_meta_data_key | SINGLE | | Nein | | shipping_lines_meta_data_value | SINGLE | | Nein | | coupon_lines_id | SINGLE | | Nein | | coupon_lines_code | SINGLE | | Nein | | coupon_lines_discount | SINGLE | | Nein | | coupon_lines_discount_tax | SINGLE | | Nein | | items_id | SINGLE | | Nein | | items_name | SINGLE | | Nein | | items_product_id | SINGLE | | Nein | | items_variation_id | SINGLE | | Nein | | items_quantity | SINGLE | | Nein | | items_tax_class | SINGLE | | Nein | | items_subtotal | SINGLE | | Nein | | items_subtotal_tax | SINGLE | | Nein | | items_total | SINGLE | | Nein | | items_total_tax | SINGLE | | Nein | | items_sku | SINGLE | | Nein | | items_price | SINGLE | | Nein | | items_taxes_id | SINGLE | | Nein | | items_taxes_total | SINGLE | | Nein | | items_taxes_subtotal | SINGLE | | Nein | | items_meta_data_id | SINGLE | | Nein | | items_meta_data_key | SINGLE | | Nein | | items_meta_data_value | SINGLE | | Nein | |
|
OrderHeaderData | SPREADSHEET | | Ja | |
| Folgende Felder sind im Output enthalten:
Feld | Datentyp | Beschreibung | Pflichtfeld | Standardwert | identifier | SINGLE | | Nein | | order_identifiere | SINGLE | | Nein | | id | SINGLE | | Nein | | parent_id | SINGLE | | Nein | | number | SINGLE | | Nein | | order_key | SINGLE | | Nein | | created_via | SINGLE | | Nein | | version | SINGLE | | Nein | | status | SINGLE | | Nein | | currency | SINGLE | | Nein | | date_created | SINGLE | | Nein | | date_created_gmt | SINGLE | | Nein | | date_modified | SINGLE | | Nein | | date_modified_gmt | SINGLE | | Nein | | discount_total | SINGLE | | Nein | | discount_tax | SINGLE | | Nein | | shipping_total | SINGLE | | Nein | | shipping_tax | SINGLE | | Nein | | cart_tax | SINGLE | | Nein | | total | SINGLE | | Nein | | total_tax | SINGLE | | Nein | | prices_include_tax | SINGLE | | Nein | | customer_id | SINGLE | | Nein | | customer_ip_address | SINGLE | | Nein | | customer_user_agent | SINGLE | | Nein | | customer_note | SINGLE | | Nein | | billing_first_name | SINGLE | | Nein | | billing_last_name | SINGLE | | Nein | | billing_company | SINGLE | | Nein | | billing_address_1 | SINGLE | | Nein | | billing_address_2 | SINGLE | | Nein | | billing_city | SINGLE | | Nein | | billing_state | SINGLE | | Nein | | billing_postcode | SINGLE | | Nein | | billing_country | SINGLE | | Nein | | billing_email | SINGLE | | Nein | | billing_phone | SINGLE | | Nein | | billing_title | SINGLE | | Nein | | shipping_first_name | SINGLE | | Nein | | shipping_last_name | SINGLE | | Nein | | shipping_company | SINGLE | | Nein | | shipping_address_1 | SINGLE | | Nein | | shipping_address_2 | SINGLE | | Nein | | shipping_city | SINGLE | | Nein | | shipping_state | SINGLE | | Nein | | shipping_postcode | SINGLE | | Nein | | shipping_country | SINGLE | | Nein | | shipping_title | SINGLE | | Nein | | shipping_parcelshop | SINGLE | | Nein | | shipping_parcelshop_post_number | SINGLE | | Nein | | payment_method | SINGLE | | Nein | | payment_method_title | SINGLE | | Nein | | transaction_id | SINGLE | | Nein | | date_paid | SINGLE | | Nein | | date_paid_gmt | SINGLE | | Nein | | date_completed | SINGLE | | Nein | | date_completed_gmt | SINGLE | | Nein | | cart_hash | SINGLE | | Nein | | parcel_delivery_opted_in | SINGLE | | Nein | | direct_debit_holder | SINGLE | | Nein | | direct_debit_iban | SINGLE | | Nein | | direct_debit_bic | SINGLE | | Nein | | direct_debit_mandate_id | SINGLE | | Nein | | meta_data_id | SINGLE | | Nein | | meta_data_key | SINGLE | | Nein | | meta_data_value | SINGLE | | Nein | | tax_lines_id | SINGLE | | Nein | | tax_lines_rate_code | SINGLE | | Nein | | tax_lines_rate_id | SINGLE | | Nein | | tax_lines_label | SINGLE | | Nein | | tax_lines_compound | SINGLE | | Nein | | tax_lines_tax_total | SINGLE | | Nein | | tax_lines_shipping_tax_total | SINGLE | | Nein | | tax_lines_meta_data | SINGLE | | Nein | | shipping_lines_id | SINGLE | | Nein | | shipping_lines_method_title | SINGLE | | Nein | | shipping_lines_method_id | SINGLE | | Nein | | shipping_lines_instance_id | SINGLE | | Nein | | shipping_lines_total | SINGLE | | Nein | | shipping_lines_total_tax | SINGLE | | Nein | | shipping_lines_taxes | SINGLE | | Nein | | shipping_lines_meta_data_id | SINGLE | | Nein | | shipping_lines_meta_data_key | SINGLE | | Nein | | shipping_lines_meta_data_value | SINGLE | | Nein | | coupon_lines_id | SINGLE | | Nein | | coupon_lines_code | SINGLE | | Nein | | coupon_lines_discount | SINGLE | | Nein | | coupon_lines_discount_tax | SINGLE | | Nein | |
|
OrderItemData | SPREADSHEET | | Ja | |
| Folgende Felder sind im Output enthalten:
Feld | Datentyp | Beschreibung | Pflichtfeld | Standardwert | identifier | SINGLE | | Nein | | order_identifiere | SINGLE | | Nein | | order_item_identifiere | SINGLE | | Nein | | items_id | SINGLE | | Nein | | items_name | SINGLE | | Nein | | items_product_id | SINGLE | | Nein | | items_variation_id | SINGLE | | Nein | | items_quantity | SINGLE | | Nein | | items_tax_class | SINGLE | | Nein | | items_subtotal | SINGLE | | Nein | | items_subtotal_tax | SINGLE | | Nein | | items_total | SINGLE | | Nein | | items_total_tax | SINGLE | | Nein | | items_sku | SINGLE | | Nein | | items_price | SINGLE | | Nein | | items_taxes_id | SINGLE | | Nein | | items_taxes_total | SINGLE | | Nein | | items_taxes_subtotal | SINGLE | | Nein | | items_meta_data_id | SINGLE | | Nein | | items_meta_data_key | SINGLE | | Nein | | items_meta_data_value | SINGLE | | Nein | |
|