ASKANER

Shopify

Outros · Disponível
Consultar via API
GET https://askaner.askan.com.br/api/v1/data/shopify?fields=date,account_id&date_preset=last_30d
Authorization: Bearer ik_...

Campos (122 métricas, 307 dimensões)

IDTipoNaturezaDescrição
abandoned_checkout_completed_atTIMESTAMPDimensãoThe date and time (ISO 8601 format) when the checkout was completed, if the customer later recovered it.
abandoned_checkout_created_atTIMESTAMPDimensãoThe date and time (ISO 8601 format) when the checkout was created.
abandoned_checkout_currencyTEXTDimensãoThe currency of the abandoned checkout in the shop currency.
abandoned_checkout_customer_emailTEXTDimensãoThe email address of the customer associated with the checkout.
abandoned_checkout_customer_idTEXTDimensãoThe ID of the customer associated with the abandoned checkout.
abandoned_checkout_idTEXTDimensãoThe unique ID of the abandoned checkout.
abandoned_checkout_nameTEXTDimensãoThe name of the abandoned checkout (e.g. '#1234').
abandoned_checkout_noteTEXTDimensãoThe text of an optional note that a merchant can attach.
abandoned_checkout_subtotal_priceNUMERICMétricaThe sum of the prices of all line items before taxes and discounts.
abandoned_checkout_taxes_includedBOOLEANDimensãoWhether taxes are included in the line item and shipping prices.
abandoned_checkout_total_discountNUMERICMétricaThe total amount of discounts applied to the abandoned checkout.
abandoned_checkout_total_priceNUMERICMétricaThe sum of all line item prices, discounts, shipping and taxes.
abandoned_checkout_total_taxNUMERICMétricaThe total tax applied to the abandoned checkout.
abandoned_checkout_updated_atTIMESTAMPDimensãoThe date and time (ISO 8601 format) when the checkout was last updated.
abandoned_checkout_urlTEXTDimensãoThe recovery URL that returns the customer to their checkout.
balance_transaction_amountNUMERICMétricaThe gross amount contributing to the balance.
balance_transaction_currencyTEXTDimensãoThe currency of the balance transaction amounts.
balance_transaction_dateTIMESTAMPDimensãoThe date the transaction was processed (settlement date).
balance_transaction_feeNUMERICMétricaThe processing fee for the transaction.
balance_transaction_idTEXTDimensãoThe ID of the Shopify Payments balance transaction.
balance_transaction_netNUMERICMétricaThe net amount contributing to the balance (amount minus fee).
balance_transaction_order_idTEXTDimensãoThe ID of the order associated with the transaction.
balance_transaction_order_nameTEXTDimensãoThe name/number of the associated order (e.g. '#1001').
balance_transaction_payout_idTEXTDimensãoThe ID of the payout this transaction belongs to (null if pending).
balance_transaction_payout_statusTEXTDimensãoThe status of the payout this transaction belongs to.
balance_transaction_typeTEXTDimensãoThe transaction category (e.g. CHARGE, REFUND, ADJUSTMENT).
customer_aovNUMERICMétricaAverage order value is the average dollar amount customer spend each time an order is placed on your ecommerce website.
customer_created_atTIMESTAMPDimensãoThe date and time (ISO 8601 format) when the customer was created.
customer_currencyTEXTDimensãoThe three-letter code (ISO 4217 format) for the currency that the customer used when they paid for their last order. Defaults to the shop currency. Returns the shop currency for test orders.
customer_dateDATEDimensãoThe date and time (ISO 8601 format) when the customer information was last updated.
customer_default_addressOBJECTDimensãoThe customer's default address.
customer_default_address_cityCITYDimensãoThe customer's default address city.
customer_default_address_countryCOUNTRYDimensãoThe customer's default address country.
customer_default_address_country_codeTEXTDimensãoThe customer's default address country code.
customer_emailTEXTDimensãoThe unique email address of the customer. Attempting to assign the same email address to multiple customers returns an error.
customer_email_marketing_consent_consent_updated_atTEXTDimensãoThe date and time at which the marketing consent was updated. No date is provided if the email address never updated its marketing consent.
customer_email_marketing_consent_opt_in_levelTEXTDimensãoThe marketing subscription opt-in level, as described by the M3AAWG best practices guidelines, that the customer gave when they consented to receive marketing material by email.
customer_email_marketing_consent_stateTEXTDimensãoThe current email marketing state for the customer.
customer_first_nameTEXTDimensãoThe customer's first name.
customer_idTEXTDimensãoA unique identifier for the customer.
customer_is_returningBOOLEANDimensãoWhether a customer is returning or new.
customer_last_nameTEXTDimensãoThe customer's last name.
customer_last_order_idTEXTDimensãoThe ID of the customer's last order.
customer_last_order_nameTEXTDimensãoThe name of the customer's last order. This is directly related to the name field on the Order resource.
customer_metafield_created_atTIMESTAMPDimensãoThe date and time (ISO 8601 format) when the metafield was created.
customer_metafield_descriptionTEXTDimensãoThe description of the metafield.
customer_metafield_idTEXTDimensãoThe unique ID of the metafield.
customer_metafield_keyTEXTDimensãoThe unique identifier for a metafield within its namespace.
customer_metafield_namespaceTEXTDimensãoThe container for a group of metafields that the metafield is or will be associated with.
customer_metafield_typeTEXTDimensãoThe type of data that is stored in the metafield.
customer_metafield_updated_atTIMESTAMPDimensãoThe date and time (ISO 8601 format) when the metafield was last updated.
customer_metafield_valueTEXTDimensãoThe data stored in the metafield. Always stored as a string, regardless of the metafield's type.
customer_multipass_identifierNUMERICMétricaA unique identifier for the customer that's used with Multipass login.
customer_noteTEXTDimensãoA note about the customer.
customer_orders_countNUMERICMétricaThe number of orders associated with this customer.
customer_phoneTEXTDimensãoThe unique phone number (E.164 format) for this customer.
customer_stateTEXTDimensãoThe state of the customer's account with a shop (Can be disabled, invited, enabled and declined)
customer_tagsTEXTDimensãoTags that the shop owner has attached to the customer, formatted as a string of comma-separated values.
customer_tax_exemptBOOLEANDimensãoWhether the customer is exempt from paying taxes on their order. If true, then taxes won't be applied to an order at checkout. If false, then taxes will be applied at checkout.
customer_total_spentNUMERICMétricaThe total amount of money that the customer has spent across their order history.
customer_updated_atTIMESTAMPDimensãoThe date and time (ISO 8601 format) when the customer information was last updated.
customer_verified_emailBOOLEANDimensãoWhether the customer has verified their email address.
breadcrumb_idTEXTDimensãoThe breadcrumb ID of the event.
budget_typeTEXTDimensãoThe budget type of the event.
ended_atTIMESTAMPDimensãoThe event end datetime.
event_typeTEXTDimensãoThe event type.
manage_urlTEXTDimensãoThe manage URL of the event.
marketing_activity_idTEXTDimensãoThe activity ID of the event.
marketing_channelTEXTDimensãoThe markerting channel of the event.
marketing_event_budgetNUMERICMétricaThe budget of the event.
marketing_event_currencyTEXTDimensãoThe currency of the event.
marketing_event_descriptionTEXTDimensãoThe event description.
marketing_event_paidBOOLEANDimensãoThe flag that indicates if an event is paid.
preview_urlTEXTDimensãoThe preview URL of the event.
referring_domainTEXTDimensãoThe referring domain of the event.
remote_idTEXTDimensãoThe remote id.
scheduled_to_end_atTIMESTAMPDimensãoThe scheduled end date of the event.
started_atTIMESTAMPDimensãoThe event start datetime.
utm_campaignTEXTDimensãoThe UTM campaign of the event.
utm_mediumTEXTDimensãoThe UTM medium of the event.
utm_sourceTEXTDimensãoThe UTM source of the event.
emailTEXTDimensãoThe customers email address.
line_item__discount_allocationsTEXTDimensãoAn ordered list of amounts allocated by discount applications. Eachdiscount allocation is associated with a particular discount application.amount: The discount amount allocated to the line in the shop currency.discount_application_index: The index of the associated discount application in the order'sdiscount_applications list.amount_set: The discount amount allocated to the line item in shop and presentmentcurrencies.
line_item__discount_allocations_objOBJECTDimensãoAn ordered list of amounts allocated by discount applications. Same data as line_item__discount_allocations but returned as an object instead of text.
line_item__discounted_unit_priceNUMERICMétricaThe unit price of the line item in the shop currency after all discounts (line-level, order-level and discount-code) are applied, before taxes.
line_item__dutiesTEXTDimensãoA list of duty objects, each containing information about a duty on the line item.
line_item__fulfillable_quantityNUMERICMétricaDeprecated. Please use 'Line Item Non Fulfillable Quantity' instead.
line_item__fulfillment_statusTEXTDimensãoDeprecated. Please use 'Order Fulfillment Status' instead.
line_item__gift_cardBOOLEANDimensãoWhether the line item represents the purchase of a gift card.
line_item__gramsNUMERICMétricaThe weight of the item in grams.
line_item__idTEXTDimensãoThe ID of the line item.
line_item__nameTEXTDimensãoThe name of the product.
line_item__net_salesNUMERICMétricaNet sales for the line item in the shop currency: the discounted line total (unit price times quantity minus line-level discounts), before taxes. Excludes order-level and discount-code discounts and is not reduced by returns/refunds, which are reported as separate order rows. Added to line_item__total_discount it equals the line's original (gross) total.
line_item__non_fulfillable_quantityNUMERICMétricaThe total number of units that can't be fulfilled. For example, if items have been refunded, or the item is not something that can be fulfilled, like a tip.
line_item__priceNUMERICMétricaThe price of the item before discounts have been applied in the shop currency.
line_item__product_categoryTEXTDimensãoThe name of the standard product taxonomy category of the product that the line item belongs to.
line_item__product_idTEXTDimensãoThe ID of the product that the line item belongs to. Can be null ifthe original product associated with the order is deleted at a later date.
line_item__product_priceNUMERICMétricaThe highest product variant price of this line item.
line_item__propertiesTEXTDimensãoAn array of custom information for the item that has been added to the cart. Often used to provide product customization options.
line_item__quantityNUMERICMétricaThe number of items that were purchased.
line_item__refundable_quantityNUMERICMétricaThe line item's quantity, minus the refunded quantity.
line_item__refundsTEXTDimensãoA list of refund objects
line_item__refunds_idsTEXTDimensãoComma-separated ids of the refunds that include this line item. The ids match the ones returned by the Order Refunds field.
line_item__refunds_priceNUMERICMétricaThe price of a refunded line item in shop currency over all refunds.
line_item__refunds_quantityNUMERICMétricaThe quantity of a refunded line item over all refunds.
line_item__refunds_subtotalNUMERICMétricaThe subtotal price of a refunded line item in shop currency over all refunds.
line_item__refunds_total_taxNUMERICMétricaThe total tax charged on a refunded line item in shop currency over all refunds.
line_item__requires_shippingTEXTDimensãoWhether the item requires shipping.
line_item__skuTEXTDimensãoThe item's SKU (stock keeping unit).
line_item__tax_linesTEXTDimensãoA list of tax line objects, each of which details a tax applied to the item.title: The name of the tax.price: The amount added to the order for this tax in the shop currency.price_set: The amount added to the order for this tax in shop and presentment currencies.rate: The tax rate applied to the order to calculate the tax price.channel_liable: Whether the channel that submitted the tax line is liable for remitting. Avalue of null indicates unknown liability for the tax line.
line_item__tax_lines_objOBJECTDimensãoA list of tax line objects, each of which details a tax applied to the item. Same data as line_item__tax_lines but returned as an object instead of text.
line_item__taxableTEXTDimensãoWhether the item was taxable.
line_item__tip_payment_gatewayTEXTDimensãoThe payment gateway used to tender the tip, such as shopify_payments. Present only on tips.
line_item__titleTEXTDimensãoThe title of the product.
line_item__total_discountNUMERICMétricaThe total amount allocated to the line item in the shop currency. Instead of using this field, Shopify recommends using discount_allocations, which provides the sameinformation.
line_item__unfulfilled_quantityNUMERICMétricaThe number of units not yet fulfilled.
line_item__variant_available_for_saleBOOLEANDimensãoWhether the product variant is available for sale.
line_item__variant_barcodeTEXTDimensãoThe value of the barcode associated with the product.
line_item__variant_compare_at_priceNUMERICMétricaThe compare-at price of the variant in the default shop currency.
line_item__variant_created_atTIMESTAMPDimensãoThe date and time when the variant was created.
line_item__variant_display_nameTEXTDimensãoDisplay name of the variant, based on product's title + variant's title.
line_item__variant_idTEXTDimensãoThe ID of the product variant.
line_item__variant_inventory_quantityNUMERICMétricaThe total sellable quantity of the variant.
line_item__variant_metafield_created_atTIMESTAMPDimensãoThe date and time (ISO 8601 format) when the metafield was last updated.
line_item__variant_metafield_descriptionTEXTDimensãoThe description of the metafield.
line_item__variant_metafield_keyTEXTDimensãoThe unique identifier for a metafield within its namespace.
line_item__variant_metafield_typeTEXTDimensãoThe type of data that is stored in the metafield.
line_item__variant_metafield_update_atTIMESTAMPDimensãoThe type of resource that the metafield is attached to.
line_item__variant_metafield_valueTEXTDimensãoThe data stored in the metafield. Always stored as a string, regardless of the metafield's type.
line_item__variant_priceNUMERICMétricaThe price of the product variant in the default shop currency.
line_item__variant_sellable_online_quantityNUMERICMétricaThe total sellable quantity of the variant for online channels. This doesn't represent the total available inventory or capture limitations based on customer location.
line_item__variant_selling_plan_group_countNUMERICMétricaCount of selling plan groups associated with the product variant.
line_item__variant_tax_codeTEXTDimensãoAvalara tax code for the product variant. Applies only to the stores that have the Avalara AvaTax app installed.
line_item__variant_titleTEXTDimensãoThe title of the product variant.
line_item__variant_unit_costNUMERICMétricaUnit cost associated with the inventory item. Note: the user must have 'View product costs' permission granted in order to access this field once product granular permissions are enabled.
line_item__variant_unit_cost_currencyTEXTDimensãoCurrency of the money for unit cost associated with the inventory item.
line_item__variant_updated_atTIMESTAMPDimensãoThe date and time (ISO 8601 format) when the product variant was last modified.
line_item__variant_weightNUMERICMétricaThe weight of the product variant in the unit system specified with weight_unit.
line_item__variant_weight_unitTEXTDimensãoThe unit of measurement that applies to the product variant's weight. If you don't specify a value for weight_unit, then the shop's default unit of measurement is applied. Valid values: g, kg, oz, lb.
line_item__vendorTEXTDimensãoThe name of the item's supplier.
order_adjusted_discountsNUMERICMétricaThe total product-level discounts for the order, calculated on the product price before taxes, in shop currency.
order_app_idTEXTDimensãoThe id of the application.
order_app_nameTEXTDimensãoThe name of the application.
order_billing_addressTEXTDimensãoThe orders billing address.
order_billing_address_cityCITYDimensãoThe orders billing address city.
order_billing_address_countryCOUNTRYDimensãoThe orders billing address country.
order_billing_address_provinceTEXTDimensãoThe orders billing address province.
order_billing_matches_shippingBOOLEANDimensãoWhether the billing address matches the shipping address.
order_can_mark_as_paidBOOLEANDimensãoWhether the order can be manually marked as paid.
order_can_notify_customerBOOLEANDimensãoWhether a customer email exists for the order.
order_cancel_reasonTEXTDimensãoThe reason why the order was canceled.
order_cancellation_staff_noteTEXTDimensãoStaff provided note for the order cancellation.
order_cancelled_atTIMESTAMPDimensãoThe date and time ( ISO 8601 format) when the order was canceled.
order_capturableBOOLEANDimensãoWhether payment for the order can be captured.
order_cart_discount_amount_presentmentNUMERICMétricaThe order-level discount amount in the customer's presentment currency, before returns and refunds.
order_channel_handleTEXTDimensãoUnique string used as a public identifier for the channel definition associated with the channel that created the order.
order_client_ipTEXTDimensãoThe IP address of the API client that created the order.
order_closedBOOLEANDimensãoWhether the order is closed.
order_closed_atTIMESTAMPDimensãoThe date and time (ISO 8601 format) when the order was closed.
order_confirmation_numberTEXTDimensãoA randomly generated alpha-numeric identifier for the order that may be shown to the customer instead of the sequential order name.
order_confirmedTEXTDimensãoWhether inventory has been reserved for the order.
order_cost_of_goods_soldNUMERICMétricaThe total cost of goods sold for the order, calculated as the sum of line item quantity multiplied by inventory item unit cost (Shopify cost per item). Note: the user must have 'View product costs' permission granted in order to access this field once product granular permissions are enabled.
order_countNUMERICMétricaThe number of orders. Default value is 1, but for refunds, the value is zero. This value is displayed in Analytics Sales report. Aggregates by sum, so a daily query returns the number of orders per day.
order_created_atTIMESTAMPDimensãoThe autogenerated date and time (ISO 8601 format) when the order was created in Shopify. The value for this property cannot be changed.
order_currencyTEXTDimensãoThe three-letter code (ISO 4217 format) for the shop currency.
order_current_cart_discount_amount_presentmentNUMERICMétricaThe current order-level discount amount in the customer's presentment currency, after returns and refunds.
order_current_discount_cartNUMERICMétricaThe current order-level discount amount after all order updates, in shop currency.
order_current_shipping_priceNUMERICMétricaThe current shipping price after applying refunds and discounts. If the parent order.taxesIncluded field is true, then this price includes taxes. Otherwise, this field is the pre-tax price.
order_current_shipping_price_presentmentNUMERICMétricaThe current shipping price after refunds and discounts in the customer's presentment currency.
order_current_subtotal_line_items_quantityNUMERICMétricaThe current order-level discount amount after all order updates, in shop currency.
order_current_subtotal_priceNUMERICMétricaThe current subtotal price of the order in the shop currency. The value of this field reflects order edits, returns, and refunds.
order_current_subtotal_price_presentmentNUMERICMétricaThe current subtotal price of the order in the customer's presentment currency. Reflects order edits, returns, and refunds.
order_current_total_additional_fees_amountNUMERICMétricaThe total amount of additional fees after returns, in shop currency.
order_current_total_additional_fees_presentmentNUMERICMétricaThe current total additional fees on the order in the customer's presentment currency.
order_current_total_discountsNUMERICMétricaThe current total discounts on the order in the shop currency. The value of this field reflects order edits, returns, and refunds.
order_current_total_discounts_presentmentNUMERICMétricaThe current total discounts on the order in the customer's presentment currency. Reflects order edits, returns, and refunds.
order_current_total_duties_amountNUMERICMétricaThe total amount of duties after returns, in shop currency.
order_current_total_duties_presentmentNUMERICMétricaThe current total duties charged on the order in the customer's presentment currency.
order_current_total_priceNUMERICMétricaThe current total price of the order, after returns.This includes taxes and discounts.refunds.
order_current_total_price_presentmentNUMERICMétricaThe current total price of the order, after returns, in the buyer's presentment currency. The presentment twin of `order_current_total_price`.
order_current_total_taxNUMERICMétricaThe current total taxes charged on the order in the shop currency. The value of this field reflects order edits, returns, or refunds.
order_current_total_tax_presentmentNUMERICMétricaThe current total taxes charged on the order in the customer's presentment currency. Reflects order edits, returns, or refunds.
order_current_total_weightNUMERICMétricaThe total weight of the order after returns, in grams.
order_custom_attributesTEXTDimensãoAdditional custom fields (note attributes) attached to the order at checkout, as a semicolon-separated list of key=value pairs.
order_customer_accepts_marketingBOOLEANDimensãoWhether the customer agreed to receive marketing materials.
order_customer_has_multiple_ordersBOOLEANDimensãoWhether the customer has multiple orders.This value is based on amount of orders customer made at the time of the request.
order_customer_idTEXTDimensãoThe ID of the customer that placed the order.
order_customer_last_visit_landing_pageTEXTDimensãoURL of the first page the customer landed on for the session.
order_customer_last_visit_referral_codeTEXTDimensãoMarketing referral code from the link that the customer clicked to visit the store. Supports the following URL attributes: ref, source, or r. For example, if the URL is myshopifystore.com/products/slide?ref=j2tj1tn2, then this value is j2tj1tn2.
order_customer_last_visit_referrer_urlTEXTDimensãoWebpage where the customer clicked a link that sent them to the online store. For example, https://randomblog.com/page1 or android-app://com.google.android.gm.
order_customer_last_visit_sourceTEXTDimensãoSource from which the customer visited the store, such as a platform (Facebook, Google), email, direct, a website domain, QR code, or unknown.
order_customer_last_visit_utm_campaignTEXTDimensãoThe name of a marketing campaign gathered from the last customer visit (session) before an order is made.
order_customer_last_visit_utm_contentTEXTDimensãoThe name of a marketing content gathered from the last customer visit (session) before an order is made.
order_customer_last_visit_utm_mediumTEXTDimensãoThe name of a marketing medium gathered from the last customer visit (session) before an order is made.
order_customer_last_visit_utm_sourceTEXTDimensãoThe name of a marketing source gathered from the last customer visit (session) before an order is made.
order_customer_last_visit_utm_termTEXTDimensãoThe name of a marketing term gathered from the last customer visit (session) before an order is made.
order_customer_number_of_ordersNUMERICMétricaThe number of orders that the customer has made at the store in their lifetime.
order_discount_codeTEXTDimensãoThe discount code used for the order.
order_discount_codesTEXTDimensãoThe discount codes used for the order.
order_editedBOOLEANDimensãoWhether the order has had any edits applied.
order_emailTEXTDimensãoThe customers email address.
order_estimated_taxesBOOLEANDimensãoWhether taxes on the order are estimated. This field returns false when taxes on the order are finalized and aren't subject to any changes.
order_financial_statusTEXTDimensãoThe status of payments associated with the order. Can only be set when the order is created.
order_fulfillableBOOLEANDimensãoWhether there are line items that can be fulfilled. This field returns false when the order has no fulfillable line items.
order_fulfillable_quantityNUMERICMétricaDeprecated. Please use 'Line Item Non Fulfillable Quantity' instead.
order_fulfillment_created_first_dateTIMESTAMPDimensãoCreated date of the first successful order fulfullment.
order_fulfillment_created_last_dateTIMESTAMPDimensãoCreated date of the last successful order fulfullment.
order_fulfillment_delivered_first_dateTIMESTAMPDimensãoDelivered date of the first successful order fulfullment.
order_fulfillment_delivered_last_dateTIMESTAMPDimensãoDelivered date of the last successful order fulfullment.
order_fulfillment_serviceTEXTDimensãoThe order fulfillment service.
order_fulfillment_statusTEXTDimensãoThe fulfillment status for the order that can be shown to the merchant. This field does not capture all the details of an order's fulfillment state. It should only be used for display summary purposes.
order_fulfillment_updated_first_dateTIMESTAMPDimensãoUpdated date of the first successful order fulfullment.
order_fulfillment_updated_last_dateTIMESTAMPDimensãoUpdated date of the last successful order fulfullment.
order_fully_paidBOOLEANDimensãoWhether the order has been paid in full.
order_fx_rateNUMERICMétricaThe implied foreign-exchange rate applied to the order, derived as the current total price in presentment currency divided by the same amount in shop currency. Empty when the shop amount is zero.
order_gross_salesNUMERICMétricaThe order gross sales (before taxes, shipping, discounts, and returns). Pending and unpaid orders are included. Test, canceled, and deleted orders aren't included.
order_has_timeline_commentBOOLEANDimensãoWhether the merchant added a timeline comment to the order.
order_idTEXTDimensãoThe unique identifier of the order
order_inventory_item_costNUMERICMétricaTotal inventory item cost of the order, calculated as the sum of line item quantity multiplied by inventory item unit cost (Shopify cost per item). Same as Order Cost of Goods Sold. Note: the user must have 'View product costs' permission granted in order to access this field once product granular permissions are enabled.
order_line_itemsOBJECTDimensãoThe line items of the order.
order_merchant_editableBOOLEANDimensãoWhether the order can be edited by the merchant. For example, canceled orders can't be edited.
order_merchant_editable_errorsTEXTDimensãoA list of reasons why the order can't be edited. For example, `Canceled orders can't be edited`.
order_metafield_created_atTIMESTAMPDimensãoThe date and time (ISO 8601 format) when the metafield was created.
order_metafield_descriptionTEXTDimensãoThe description of the metafield.
order_metafield_idTEXTDimensãoThe unique ID of the metafield.
order_metafield_keyTEXTDimensãoThe unique identifier for a metafield within its namespace.
order_metafield_namespaceTEXTDimensãoThe container for a group of metafields that the metafield is or will be associated with.
order_metafield_typeTEXTDimensãoThe type of data that is stored in the metafield.
order_metafield_updated_atTIMESTAMPDimensãoThe date and time (ISO 8601 format) when the metafield was last updated.
order_metafield_valueTEXTDimensãoThe data stored in the metafield. Always stored as a string, regardless of the metafield's type.
order_nameTEXTDimensãoThe name of the order
order_net_paymentNUMERICMétricaThe net payment for the order, based on the total amount received minus the total amount refunded.
order_net_salesNUMERICMétricaThe order net sales. Equates to gross sales - discounts - returns. Pending and unpaid orders are included. Test, canceled, and deleted orders aren't included.
order_new_or_returning_customerTEXTDimensãoWhether the customer was new or returning at the time of the order, based on the number of orders the customer had placed: 'new' for their first order, 'returning' otherwise.
order_noteTEXTDimensãoAn optional note that a shop owner can attach to the order.
order_original_priceNUMERICMétricaThe total price of the order at the time of order creation.
order_original_price_presentmentNUMERICMétricaThe total price of the order at creation in the customer's presentment currency.
order_original_total_additional_fees_amountNUMERICMétricaThe total amount of additional fees at the time of order creation.
order_original_total_additional_fees_presentmentNUMERICMétricaThe total additional fees on the order at creation in the customer's presentment currency.
order_original_total_duties_amountNUMERICMétricaThe total amount of duties before returns, in shop currency.
order_original_total_duties_presentmentNUMERICMétricaThe total duties charged on the order at creation in the customer's presentment currency.
order_payment_gatewaysTEXTDimensãoA list of the names of all payment gateways used for the order.
order_payment_referencesTEXTDimensãoThe payment references sent to the payment gateways for the order's transactions, comma-separated. Includes captures, refunds and failed payment attempts.
order_po_numberTEXTDimensãoThe PO number associated with the order.
order_presentment_currencyTEXTDimensãoThe three-letter code (ISO 4217 format) for the currency the buyer used when placing the order. Together with the shop currency and a presentment amount it yields the FX rate applied to the order.
order_processed_atTIMESTAMPDimensãoThe date and time when the order was processed.
order_product_priceNUMERICMétricaThe product price of this line item.
order_quantityNUMERICMétricaThe sum of the quantities for all line items that contribute to the order's current subtotal price.
order_refund_discrepancy_amountNUMERICMétricaThe difference between the suggested and actual refund amount of all refunds that have been applied to the order. A positive value indicates a difference in the merchant's favor, and a negative value indicates a difference in the customer's favor.
order_refund_discrepancy_amount_presentmentNUMERICMétricaThe difference between the refunded amount and the returned amount, in the customer's presentment currency.
order_refund_noteTEXTDimensãoThe notes (reasons) attached to the order's refunds, semicolon-separated when there is more than one refund.
order_refundableBOOLEANDimensãoWhether the order can be refunded.
order_refundsTEXTDimensãoId of refund assigned to the order.
order_refunds_netNUMERICMétrica(Equates to order_gross_sales - order_total_discounts - order_net_sales).
order_refunds_quantityNUMERICMétricaTotal quantity of refunded items.
order_refunds_subtotalNUMERICMétricaThe order total refunds.
order_refunds_total_taxNUMERICMétricaThe total tax on the refund line items.
order_registered_source_urlTEXTDimensãoThe URL of the source that the order originated from, if found in the domain registry.
order_requires_shippingBOOLEANDimensãoWhether the order has shipping lines or at least one line item on the order that requires shipping.
order_restockableBOOLEANDimensãoWhether any line item on the order can be restocked.
order_retail_location_nameTEXTDimensãoThe name of the physical location where a retail order is created or completed.
order_return_statusTEXTDimensãoThe order's aggregated return status for display purposes.
order_returns_amountNUMERICMétricaThe order total returned items value.
order_returns_quantityNUMERICMétricaThe order total returned items quantity.
order_sales_channelTEXTDimensãoThe name of the application.
order_shipping_addressTEXTDimensãoThe orders shipping address.
order_shipping_address_cityCITYDimensãoThe orders shipping address city.
order_shipping_address_countryCOUNTRYDimensãoThe orders shipping address country.
order_shipping_address_provinceTEXTDimensãoThe orders shipping address province.
order_shipping_address_zipTEXTDimensãoThe orders shipping address zip or postal code.
order_shipping_line_amountNUMERICMétricaThe pre-tax shipping price without any discounts applied, in shop currency.
order_shipping_line_carrier_identifierTEXTDimensãoA reference to the carrier service that provided the rate. Present when the rate was computed by a third-party carrier service.
order_shipping_line_codeTEXTDimensãoA reference to the shipping method.
order_shipping_line_delivery_categoryTEXTDimensãoThe general classification of the delivery method.
order_shipping_line_discounted_amountNUMERICMétricaThe shipping price after applying discounts, in shop currency. If the order_taxes_included field is true, then this price includes taxes. If not, it's the pre-tax price.
order_shipping_line_idTEXTDimensãoA globally-unique ID for this shipping line.
order_shipping_line_is_customBOOLEANDimensãoWhether the shipping line is custom or not.
order_shipping_line_is_removedBOOLEANDimensãoWhether the shipping line has been removed.
order_shipping_line_phoneTEXTDimensãoThe phone number at the shipping address.
order_shipping_line_shipping_rate_handleTEXTDimensãoA unique identifier for the shipping rate. The format can change without notice and isn't meant to be shown to users.
order_shipping_line_sourceTEXTDimensãoThe rate source for this shipping line.
order_shipping_line_titleTEXTDimensãoThe title of this shipping line.
order_shipping_net_priceNUMERICMétricaThe shipping price without taxes, in shop currency.
order_shipping_priceNUMERICMétricaThe pre-tax shipping price without any discounts applied, in shop currency.
order_shipping_taxNUMERICMétricaThe pre-tax shipping price without any discounts applied, in shop currency.
order_source_identifierTEXTDimensãoA unique POS or third party order identifier.
order_source_nameTEXTDimensãoThe name of the source (sales channel or POS) where the order originated, for example 'web', 'pos', or an app handle.
order_subtotal_priceNUMERICMétricaThe sum of the prices for all line items after discounts and before returns, in shop currency. If order_taxes_included is true, then the subtotal also includes tax.
order_subtotal_price_presentmentNUMERICMétricaThe sum of line item prices after discounts and before returns, in the customer's presentment currency.
order_tagsTEXTDimensãoTags attached to the order
order_tax_exemptBOOLEANDimensãoWhether taxes are exempt on the order.
order_taxes_includedBOOLEANDimensãoWhether taxes are included in the subtotal price of the order.
order_testBOOLEANDimensãoWhether the order is a test. Test orders are made using the Shopify Bogus Gateway or a payment provider with test mode enabled.
order_total_capturable_amountNUMERICMétricaThe authorized amount that's uncaptured or undercaptured, in shop currency. This amount isn't adjusted for returns.
order_total_capturable_presentmentNUMERICMétricaThe total amount that can be captured on the order in the customer's presentment currency.
order_total_countNUMERICMétricaThe number of all placed orders (including orders with refunds). This value is displayed in Orders report.
order_total_discount_cartNUMERICMétricaThe total order-level discount amount, before returns, in shop currency.
order_total_discountsNUMERICMétricaThe total discounts applied to the price of the order in the shop currency.
order_total_discounts_presentmentNUMERICMétricaThe total discounts applied to the price of the order in the customer's presentment currency.
order_total_discounts_setNUMERICMétricaThe total discounts applied to the price of the order in shop currency. This includes both order and line level discounts.

Mostrando 300 de 429. Lista completa em /api/v1/connectors/shopify/fields.