Skip to content

woocommerceGetOrders - woocommerce

Version: API v3 - wc 3.5.x or later

← woocommerce Add-On Übersicht

Retrieve order data from woocommerce.


Inputs

Das sind die Optionen, mit denen man den Step konfigurieren kann.

NameDatentypBeschreibungPflichtfeldWerte
accountACCOUNTaccount dataJa
statusSTRINGLimit result set to orders assigned a specific status.Ja
  • any
  • pending
  • processing
  • on-hold
  • completed
  • cancelled
  • refunded
  • failed
createdAtDATETIMELimit response to orders created AFTER the given date.Nein
limitSTRINGLimit 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

Outputs

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

NameDatentypBeschreibungWerte
OrderDataSPREADSHEET
Folgende Felder sind im Output enthalten:

FeldDatentypBeschreibungStandardwert
identifierSINGLE
parent_identifierSINGLE
order_identifiereSINGLE
order_item_identifiereSINGLE
idSINGLE
parent_idSINGLE
numberSINGLE
order_keySINGLE
created_viaSINGLE
versionSINGLE
statusSINGLE
currencySINGLE
date_createdSINGLE
date_created_gmtSINGLE
date_modifiedSINGLE
date_modified_gmtSINGLE
discount_totalSINGLE
discount_taxSINGLE
shipping_totalSINGLE
shipping_taxSINGLE
cart_taxSINGLE
totalSINGLE
total_taxSINGLE
prices_include_taxSINGLE
customer_idSINGLE
customer_ip_addressSINGLE
customer_user_agentSINGLE
customer_noteSINGLE
billing_first_nameSINGLE
billing_last_nameSINGLE
billing_companySINGLE
billing_address_1SINGLE
billing_address_2SINGLE
billing_citySINGLE
billing_stateSINGLE
billing_postcodeSINGLE
billing_countrySINGLE
billing_emailSINGLE
billing_phoneSINGLE
billing_titleSINGLE
shipping_first_nameSINGLE
shipping_last_nameSINGLE
shipping_companySINGLE
shipping_address_1SINGLE
shipping_address_2SINGLE
shipping_citySINGLE
shipping_stateSINGLE
shipping_postcodeSINGLE
shipping_countrySINGLE
shipping_titleSINGLE
shipping_parcelshopSINGLE
shipping_parcelshop_post_numberSINGLE
payment_methodSINGLE
payment_method_titleSINGLE
transaction_idSINGLE
date_paidSINGLE
date_paid_gmtSINGLE
date_completedSINGLE
date_completed_gmtSINGLE
cart_hashSINGLE
parcel_delivery_opted_inSINGLE
direct_debit_holderSINGLE
direct_debit_ibanSINGLE
direct_debit_bicSINGLE
direct_debit_mandate_idSINGLE
meta_data_idSINGLE
meta_data_keySINGLE
meta_data_valueSINGLE
tax_lines_idSINGLE
tax_lines_rate_codeSINGLE
tax_lines_rate_idSINGLE
tax_lines_labelSINGLE
tax_lines_compoundSINGLE
tax_lines_tax_totalSINGLE
tax_lines_shipping_tax_totalSINGLE
tax_lines_meta_dataSINGLE
shipping_lines_idSINGLE
shipping_lines_method_titleSINGLE
shipping_lines_method_idSINGLE
shipping_lines_instance_idSINGLE
shipping_lines_totalSINGLE
shipping_lines_total_taxSINGLE
shipping_lines_taxesSINGLE
shipping_lines_meta_data_idSINGLE
shipping_lines_meta_data_keySINGLE
shipping_lines_meta_data_valueSINGLE
coupon_lines_idSINGLE
coupon_lines_codeSINGLE
coupon_lines_discountSINGLE
coupon_lines_discount_taxSINGLE
items_idSINGLE
items_nameSINGLE
items_product_idSINGLE
items_variation_idSINGLE
items_quantitySINGLE
items_tax_classSINGLE
items_subtotalSINGLE
items_subtotal_taxSINGLE
items_totalSINGLE
items_total_taxSINGLE
items_skuSINGLE
items_priceSINGLE
items_taxes_idSINGLE
items_taxes_totalSINGLE
items_taxes_subtotalSINGLE
items_meta_data_idSINGLE
items_meta_data_keySINGLE
items_meta_data_valueSINGLE
OrderHeaderDataSPREADSHEET
Folgende Felder sind im Output enthalten:

FeldDatentypBeschreibungStandardwert
identifierSINGLE
order_identifiereSINGLE
idSINGLE
parent_idSINGLE
numberSINGLE
order_keySINGLE
created_viaSINGLE
versionSINGLE
statusSINGLE
currencySINGLE
date_createdSINGLE
date_created_gmtSINGLE
date_modifiedSINGLE
date_modified_gmtSINGLE
discount_totalSINGLE
discount_taxSINGLE
shipping_totalSINGLE
shipping_taxSINGLE
cart_taxSINGLE
totalSINGLE
total_taxSINGLE
prices_include_taxSINGLE
customer_idSINGLE
customer_ip_addressSINGLE
customer_user_agentSINGLE
customer_noteSINGLE
billing_first_nameSINGLE
billing_last_nameSINGLE
billing_companySINGLE
billing_address_1SINGLE
billing_address_2SINGLE
billing_citySINGLE
billing_stateSINGLE
billing_postcodeSINGLE
billing_countrySINGLE
billing_emailSINGLE
billing_phoneSINGLE
billing_titleSINGLE
shipping_first_nameSINGLE
shipping_last_nameSINGLE
shipping_companySINGLE
shipping_address_1SINGLE
shipping_address_2SINGLE
shipping_citySINGLE
shipping_stateSINGLE
shipping_postcodeSINGLE
shipping_countrySINGLE
shipping_titleSINGLE
shipping_parcelshopSINGLE
shipping_parcelshop_post_numberSINGLE
payment_methodSINGLE
payment_method_titleSINGLE
transaction_idSINGLE
date_paidSINGLE
date_paid_gmtSINGLE
date_completedSINGLE
date_completed_gmtSINGLE
cart_hashSINGLE
parcel_delivery_opted_inSINGLE
direct_debit_holderSINGLE
direct_debit_ibanSINGLE
direct_debit_bicSINGLE
direct_debit_mandate_idSINGLE
meta_data_idSINGLE
meta_data_keySINGLE
meta_data_valueSINGLE
tax_lines_idSINGLE
tax_lines_rate_codeSINGLE
tax_lines_rate_idSINGLE
tax_lines_labelSINGLE
tax_lines_compoundSINGLE
tax_lines_tax_totalSINGLE
tax_lines_shipping_tax_totalSINGLE
tax_lines_meta_dataSINGLE
shipping_lines_idSINGLE
shipping_lines_method_titleSINGLE
shipping_lines_method_idSINGLE
shipping_lines_instance_idSINGLE
shipping_lines_totalSINGLE
shipping_lines_total_taxSINGLE
shipping_lines_taxesSINGLE
shipping_lines_meta_data_idSINGLE
shipping_lines_meta_data_keySINGLE
shipping_lines_meta_data_valueSINGLE
coupon_lines_idSINGLE
coupon_lines_codeSINGLE
coupon_lines_discountSINGLE
coupon_lines_discount_taxSINGLE
OrderItemDataSPREADSHEET
Folgende Felder sind im Output enthalten:

FeldDatentypBeschreibungStandardwert
identifierSINGLE
order_identifiereSINGLE
order_item_identifiereSINGLE
items_idSINGLE
items_nameSINGLE
items_product_idSINGLE
items_variation_idSINGLE
items_quantitySINGLE
items_tax_classSINGLE
items_subtotalSINGLE
items_subtotal_taxSINGLE
items_totalSINGLE
items_total_taxSINGLE
items_skuSINGLE
items_priceSINGLE
items_taxes_idSINGLE
items_taxes_totalSINGLE
items_taxes_subtotalSINGLE
items_meta_data_idSINGLE
items_meta_data_keySINGLE
items_meta_data_valueSINGLE