{{item.notificationType}}:

woocommerceGetOrders

fetch Order data

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

Retrieve order data from woocommerce.

View manual

Why Synesty?

  • Central middleware for all integrations, connectors and automation of business processes
  • No coding required - just Drag&Drop and configuration
  • Professional support with quick responses
Sign up for FREE Request a demo

Why Synesty?

  • Central middleware for all integrations, connectors and automation of business processes
  • No coding required - just Drag&Drop and configuration
  • Professional support with quick responses
Sign up for FREE Request a demo

Inputs

Name Type Description Required Values
account ACCOUNT account data Yes
status STRING Limit result set to orders assigned a specific status. Yes
  • any (Default)
  • pending
  • processing
  • on-hold
  • completed
  • cancelled
  • refunded
  • failed
createdAt DATETIME Limit response to orders created AFTER the given date. No Default:
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. No Default: 1

Outputs

Name Type Description
OrderData SPREADSHEET
The following fields are contained in the output:

Field Description Type Required Default-Value
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
The following fields are contained in the output:

Field Description Type Required Default-Value
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
The following fields are contained in the output:

Field Description Type Required Default-Value
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

Need help or project support?

If you need help during setup of this step or a project then reach out to our certified partners. Find Partners

More steps steps in woocommerce


Name Version Description Use-Case
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.

fetch Order data
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. 

set or update Product data
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.

fetch Product data
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.

fetch Product data
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.

fetch Order data
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".

set or update Product data
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

set or update Order data
woocommerceUpdatePriceAndStock (ext. Version: API v3 - wc 3.5.x or later)
woocommerceUpdatePriceAndStock (ext. Version: API v3 - wc 3.5.x or later)
API v3 - wc 3.5.x or later

Updates the price and stock of products and variants

set or update Stock data , set or update Price data