Excel Add-In for Shopify

Build 25.0.9434

AbandonedCheckoutTaxLines

Shows the tax lines calculated for an abandoned checkout by jurisdiction and rate.

View-Specific Information

Select

The add-in uses the Shopify API to process WHERE clause conditions built with the following column and operators. The add-in processes other filters client-side within the add-in.

  • ResourceId supports the '=, IN' comparison operators.

For example, the following query is processed server-side:

  SELECT * FROM AbandonedCheckoutTaxLines WHERE ResourceId = 'Val1'

Columns

Name Type References Description
Title [KEY] String The name or label of the applied tax, such as Sales Tax or value-added tax (VAT).
ResourceId [KEY] String

AbandonedCheckouts.Id

The globally unique identifier of the abandoned checkout that this tax line belongs to.
Source String The system or integration that applied the tax, such as Shopify or a third-party app.
Rate Double The tax rate expressed as a decimal fraction of the line item price.
ChannelLiable Bool Indicates whether the sales channel that submitted the checkout is responsible for remitting this tax. Returns null if liability is unknown.
RatePercentage Double The tax rate expressed as a percentage of the line item price.
PriceSetPresentmentMoneyAmount Decimal The tax amount applied, expressed as a decimal money value in the presentment currency.
PriceSetPresentmentMoneyCurrencyCode String The presentment currency code for the tax amount.
PriceSetShopMoneyAmount Decimal The tax amount applied, expressed as a decimal money value in the shop's base currency.
PriceSetShopMoneyCurrencyCode String The shop currency code for the tax amount.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434