Version: 2024-01
← shopify Add-On Übersicht
Retrieves all refund information including refunded items, order adjustments and transactions of all orders according to the set <em>order status</em>, <em>financial status</em> and <em>fulfillment status</em>. The retrieval of orders can be additionally limited by specifying the <em>order creation date</em> (optional) and the <em>order updated date</em> (optional).
Das sind die Optionen, mit denen man den Step konfigurieren kann.
Name | Datentyp | Beschreibung | Pflichtfeld | Werte |
account | ACCOUNT | shopify Account | Ja | |
status | STRING | Filter orders by their status. Only orders in the selected status will be retrieved. This status can be combined with the other statuses. | Ja | |
financial_status | STRING | Filter orders by their financial status. Only orders in the selected financial status will be retrieved. This status can be combined with the other statuses. | Ja | - any
- authorized
- pending
- paid
- partially paid
- refunded
- partially refunded
- voided
- unpaid
|
fulfillment_status | STRING | Filter orders by their fulfillment status. Only orders in the selected financial status will be retrieved. This status can be combined with the other statuses. | Ja | - any
- shipped
- partially shipped
- unshipped
|
limit | STRING | Limits the number of orders to be retrieved for refund processing. Enter a small number for tests. If limit is empty or greater than 249 then all orders are retrieved. | Nein | |
created_at_from | DATETIME | Creation time of orders. All orders in the specified status that were created on this date and the specified time and after are retrieved. The time is in UTC. If no date is specified, all orders will be fetched in the specified status. | Nein | |
updated_at_from | DATETIME | Update time of orders. All orders in the specified status that were updated on this date and the specified time and after are retrieved. The time is in UTC. If no date is specified, all orders will be fetched in the specified status. | Nein | |
Outputs
Das sind die Ergebnisse des Steps, die von nachfolgenden Steps, nach
der Ausführung verwendet werden können.
Name | Datentyp | Beschreibung | Pflichtfeld | Werte |
RefundedItems | SPREADSHEET | | Ja | |
| Folgende Felder sind im Output enthalten
:
Feld | Datentyp | Beschreibung | Pflichtfeld | Standardwert | identifier | SINGLE | | Nein | | refund_line_items_id | SINGLE | | Nein | | order_id | SINGLE | | Nein | | order_created_at | SINGLE | | Nein | | order_updated_at | SINGLE | | Nein | | order_number | SINGLE | | Nein | | order_name | SINGLE | | Nein | | order_financial_status | SINGLE | | Nein | | order_fulfillment_status | SINGLE | | Nein | | order_source_name | SINGLE | | Nein | | order_tags | SINGLE | | Nein | | order_note | SINGLE | | Nein | | refund_id | SINGLE | | Nein | | refund_note | SINGLE | | Nein | | refund_line_items_quantity | SINGLE | | Nein | | refund_line_items_line_item_id | SINGLE | | Nein | | refund_line_items_location_id | SINGLE | | Nein | | refund_line_items_restock_type | SINGLE | | Nein | | refund_line_items_subtotal | SINGLE | | Nein | | refund_line_items_total_tax | SINGLE | | Nein | | refund_line_items_line_item_variant_id | SINGLE | | Nein | | refund_line_items_line_item_title | SINGLE | | Nein | | refund_line_items_line_item_quantity | SINGLE | | Nein | | refund_line_items_line_item_sku | SINGLE | | Nein | | refund_line_items_line_item_variant_title | SINGLE | | Nein | | refund_line_items_line_item_vendor | SINGLE | | Nein | | refund_line_items_line_item_fulfillment_service | SINGLE | | Nein | | refund_line_items_line_item_product_id | SINGLE | | Nein | | refund_line_items_line_item_requires_shipping | SINGLE | | Nein | | refund_line_items_line_item_taxable | SINGLE | | Nein | | refund_line_items_line_item_gift_card | SINGLE | | Nein | | refund_line_items_line_item_name | SINGLE | | Nein | | refund_line_items_line_item_variant_inventory_management | SINGLE | | Nein | | refund_line_items_line_item_product_exists | SINGLE | | Nein | | refund_line_items_line_item_fulfillable_quantity | SINGLE | | Nein | | refund_line_items_line_item_grams | SINGLE | | Nein | | refund_line_items_line_item_price | SINGLE | | Nein | | refund_line_items_line_item_total_discount | SINGLE | | Nein | | refund_line_items_line_item_fulfillment_status | SINGLE | | Nein | | refund_line_items_line_item_admin_graphql_api_id | SINGLE | | Nein | | refund_line_items_line_item_price_set_shop_money_amount | SINGLE | | Nein | | refund_line_items_line_item_price_set_shop_money_currency_code | SINGLE | | Nein | | refund_line_items_line_item_price_set_presentment_money_amount | SINGLE | | Nein | | refund_line_items_line_item_price_set_presentment_money_currency_code | SINGLE | | Nein | | refund_line_items_line_item_tax_lines_title | SINGLE | | Nein | | refund_line_items_line_item_tax_lines_price | SINGLE | | Nein | | refund_line_items_line_item_tax_lines_rate | SINGLE | | Nein | | refund_line_items_line_item_properties | SINGLE | | Nein | | refund_line_items_line_item_properties_name | SINGLE | | Nein | | refund_line_items_line_item_properties_value | SINGLE | | Nein | | |
OrderAdjustments | SPREADSHEET | | Ja | |
| Folgende Felder sind im Output enthalten
:
Feld | Datentyp | Beschreibung | Pflichtfeld | Standardwert | identifier | SINGLE | | Nein | | order_adjustments_id | SINGLE | | Nein | | order_id | SINGLE | | Nein | | order_created_at | SINGLE | | Nein | | order_updated_at | SINGLE | | Nein | | order_number | SINGLE | | Nein | | order_name | SINGLE | | Nein | | order_financial_status | SINGLE | | Nein | | order_fulfillment_status | SINGLE | | Nein | | order_source_name | SINGLE | | Nein | | order_tags | SINGLE | | Nein | | order_note | SINGLE | | Nein | | refund_id | SINGLE | | Nein | | refund_note | SINGLE | | Nein | | order_adjustments_order_id | SINGLE | | Nein | | order_adjustments_refund_id | SINGLE | | Nein | | order_adjustments_amount | SINGLE | | Nein | | order_adjustments_tax_amount | SINGLE | | Nein | | order_adjustments_kind | SINGLE | | Nein | | order_adjustments_reason | SINGLE | | Nein | | order_adjustments_amount_set_shop_money | SINGLE | | Nein | | order_adjustments_amount_set_presentment_money | SINGLE | | Nein | | order_adjustments_tax_amount_set_shop_money | SINGLE | | Nein | | order_adjustments_tax_amount_set_presentment_money | SINGLE | | Nein | | |
Transactions | SPREADSHEET | | Ja | |
| Folgende Felder sind im Output enthalten
:
Feld | Datentyp | Beschreibung | Pflichtfeld | Standardwert | identifier | SINGLE | | Nein | | transactions_id | SINGLE | | Nein | | order_id | SINGLE | | Nein | | order_created_at | SINGLE | | Nein | | order_updated_at | SINGLE | | Nein | | order_number | SINGLE | | Nein | | order_name | SINGLE | | Nein | | order_financial_status | SINGLE | | Nein | | order_fulfillment_status | SINGLE | | Nein | | order_source_name | SINGLE | | Nein | | order_tags | SINGLE | | Nein | | order_note | SINGLE | | Nein | | refund_id | SINGLE | | Nein | | refund_note | SINGLE | | Nein | | transactions_order_id | SINGLE | | Nein | | transactions_kind | SINGLE | | Nein | | transactions_gateway | SINGLE | | Nein | | transactions_status | SINGLE | | Nein | | transactions_message | SINGLE | | Nein | | transactions_created_at | SINGLE | | Nein | | transactions_test | SINGLE | | Nein | | transactions_authorization | SINGLE | | Nein | | transactions_location_id | SINGLE | | Nein | | transactions_user_id | SINGLE | | Nein | | transactions_parent_id | SINGLE | | Nein | | transactions_processed_at | SINGLE | | Nein | | transactions_device_id | SINGLE | | Nein | | transactions_error_code | SINGLE | | Nein | | transactions_source_name | SINGLE | | Nein | | transactions_amount | SINGLE | | Nein | | transactions_currency | SINGLE | | Nein | | transactions_admin_graphql_api_id | SINGLE | | Nein | | |