Excel Add-In for Shopify

Build 24.0.9060

RefundDuties

Lists the refunded duties as part of this refund.

View-Specific Information

Select

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

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

For example, the following queries are processed server side:

  SELECT * FROM RefundDuties
  SELECT * FROM RefundDuties WHERE RefundId = 'Val1'

Columns

Name Type References Description
OriginalDutyId [KEY] String A globally-unique ID.
RefundId [KEY] String

Refunds.Id

A globally-unique ID.
OriginalDutyHarmonizedSystemCode String The harmonized system code of the item used in calculating the duty.
OriginalDutyCountryCodeOfOrigin String The ISO 3166-1 alpha-2 country code of the country of origin used in calculating the duty.
AmountSetPresentmentMoneyAmount Decimal Decimal money amount.
AmountSetPresentmentMoneyCurrencyCode String Currency of the money.
AmountSetShopMoneyAmount Decimal Decimal money amount.
AmountSetShopMoneyCurrencyCode String Currency of the money.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060