MagentoSearchOrders

fetch Order data

Get Orders from Magento.

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 Demo

Related templates

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 Demo

Related templates

Inputs

Name Type Description Required Values
account ACCOUNT Your account Yes
orderStatus STRING Return only orders in the specified status. No
  • All
  • canceled
  • closed
  • complete
  • processing
  • fraud
  • holded
  • payment_review
  • paypal_canceled_reversal
  • paypal_reversed
  • pending (Default)
  • pending_payment
  • pending_paypal
orderID STRING Filter for magento orderID No
orderIncrementID STRING Filter for magento order increment ID No
storeID STRING Filter for magento storeID No
purchasedAfter DATETIME Returns only orders inserted after the given date , e.g. 2014-02-15 06:57:22 No
purchasedBefore DATETIME Returns only orders inserted before the given date , e.g. 2014-02-19 06:57:22 No
updatedAfter DATETIME Returns only orders updated after the given date , e.g. 2014-02-15 06:57:22 No
updatedBefore DATETIME Returns only orders updated before the given date , e.g. 2014-02-19 06:57:22 No
limitItems STRING Limit the number of fetched items. No Default: 25

Outputs

Name Type Description
orders SPREADSHEET A spreadsheet object containing the orders.
The following fields are contained in the output:

Field Description Type Required Default-Value
type Text
identifier Text
parent_identifier Text
order_id Text
order_increment_id Text
order_status Text
order_state Text
order_created_at Text
order_updated_at Text
order_store_id Text
total_item_count Text
total_paid Text
total_invoiced Text
grand_total Text
total_due Text
total_qty_ordered Text
subtotal Text
subtotal_incl_tax Text
subtotal_invoiced Text
subtotal_refunded Text
order_currency_code Text
store_currency_code Text
global_currency_code Text
shipping_amount Text
shipping_tax_amount Text
shipping_incl_tax Text
shipping_invoiced Text
shipping_method Text
shipping_description Text
billing_firstname Text
billing_lastname Text
billing_name Text
billing_addresse_type Text
billing_company Text
billing_zip Text
billing_city Text
billing_street Text
billing_region Text
billing_country_id Text
billing_phone Text
billing_fax Text
shipping_firstname Text
shipping_lastname Text
shipping_name Text
shipping_addresse_type Text
shipping_company Text
shipping_zip Text
shipping_city Text
shipping_street Text
shipping_region Text
shipping_country_id Text
shipping_phone Text
shipping_fax Text
customer_id Text
customer_is_guest Text
customer_email Text
customer_gender Text
customer_prefix Text
customer_suffix Text
customer_group_id Text
customer_note_notitfy Text
email_sent Text
order_payment_id Text
order_payment_method Text
paypal_ipn_customer_notified Text
status_history Text
item_order_id Text
item_id Text
item_product_id Text
item_sku Text
item_name Text
item_product_options Text
item_is_virtual Text
item_is_qty_decimal Text
item_currency_code Text
item_price Text
item_free_shipping Text
item_row_total Text
item_base_amount_refunded Text
item_base_discount_amount Text
item_base_discount_invoiced Text
item_base_original_price Text
item_base_price Text
item_base_row_invoiced Text
item_base_row_total Text
item_base_tax_amount Text
item_base_tax_before_discount Text
item_base_tax_invoiced Text
item_base_weee_tax_applied_amount Text
item_base_weee_tax_applied_row_amount Text
item_base_weee_tax_disposition Text
item_base_weee_tax_row_disposition Text
item_tax_amount Text
item_tax_percent Text
item_tax_invoiced Text
item_tax_discount Text
item_discount_amount Text
item_discount_invoiced Text
item_discount_percent Text
item_no_discount Text
item_qty_ordered Text
item_qty_invoiced Text
item_qty_shipped Text
item_qty_canceled Text
item_qty_refunded Text
item_amount_refunded Text
item_cost Text
item_weight Text
item_row_weight Text
item_row_invoiced Text
item_gift_message Text
item_gift_message_available Text
item_gift_message_id Text
item_applied_rule_ids Text
item_created_at Text
item_updated_at 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 Magento Schnittstelle


Name Version Description Use-Case
MagentoGetProducts
MagentoGetProducts
- Get Products from Magento.
fetch Product data
MagentoOrdersAddTrackingNumber
MagentoOrdersAddTrackingNumber
- Add tracking numbers to orders in Magento.
set or update Order data
MagentoAddOrders
MagentoAddOrders
- Adds orders to a Magento store.
set or update Order data
MagentoUpdateInventory
MagentoUpdateInventory
- Update inventory stock and price information in Magento.
set or update Stock data , set or update Price data
MagentoGetStocks
MagentoGetStocks
- Get Stocks from Magento.
fetch Stock data
MagentoCreateProduct
MagentoCreateProduct
- Creates products in Magento.
set or update Product data
MagentoSearchCustomers
MagentoSearchCustomers
- Get Customers from Magento.
fetch Customer data
MagentoSearchOrders
MagentoSearchOrders
- Get Orders from Magento.
fetch Order data
MagentoUpdateOrders
MagentoUpdateOrders
- Updates orders in Magento (status, comment).
set or update Order data