Return Item View

The Return Item view provides dimensions and measures for the items belonging to a return.

The measures calculated by this view are:

NameMeasure TypeDescription
Average Item Shipping AmountAverageAverage of item shipping amount for all return items.
Average Item Taxable AmountAverageAverage of item taxable amount for all return items.
Average Product Loss AmountAverageAverage of product loss amount for all return items.
Average Product Loss Tax AmountAverageAverage of product loss tax amount for all return items.
Average QuantityAverageAverage of quantity for all return items.
Average Quantity ReceivedAverageAverage of quantity received for all return items.
Average Quantity RestockableAverageAverage of quantity restockable for all return items.
Average Quantity ShippedAverageAverage of quantity shipped for all return items.
Average Shipping Loss AmountAverageAverage of shipping loss amount for all return items.
Average Shipping Loss Tax AmountAverageAverage of shipping loss tax amount for all return items.
Average With Weighted Shipping And Handling TotalAverageAverage of with weighted shipping and handling total for all return items.
Average Without Weighted Shipping And Handling TotalAverageAverage of without weighted shipping and handling total for all return items.
Return Item CountCountCount of all return items.
Total Item Shipping AmountSumSum of item shipping amount for all return items.
Total Item Taxable AmountSumSum of item taxable amount for all return items.
Total Product Loss AmountSumSum of product loss amount for all return items.
Total Product Loss Tax AmountSumSum of product loss tax amount for all return items.
Total QuantitySumSum of quantity for all return items.
Total Quantity ReceivedSumSum of quantity received for all return items.
Total Quantity RestockableSumSum of quantity restockable for all return items.
Total Quantity ShippedSumSum of quantity shipped for all return items.
Total Shipping Loss AmountSumSum of shipping loss amount for all return items.
Total Shipping Loss Tax AmountSumSum of shipping loss tax amount for all return items.
Total With Weighted Shipping And Handling TotalSumSum of with weighted shipping and handling total for all return items.
Total Without Weighted Shipping And Handling TotalSumSum of without weighted shipping and handling total for all return items.

The dimensions included in this view are:

NameData TypeDescription
Goods TypeStringThe type of goods in a bundled product. A bundled product is composed of products associated to sell together. Possible values include Physical and DigitalCredit.
Item Fulfillment StatusStringThe current fulfillment status of the item such as Fulfilled, NotFulfilled, or PartiallyFulfilled.
Item Shipping AmountNumberThe calculated total shipping amount for the order item including tax.
Item Taxable AmountNumberThe monetary amount of an item that is subject to tax. This amount typically represents the line item subtotal before applied discounts for an order.
Order Item IDStringInternal unique identifier of the order item.
Product CodeStringThe unique user-defined identifier for a product.
Product Loss AmountNumberThe total value of the product returned to the merchant for accounting purposes, calculated by multiplying the cost of the item by its quantity returned.
Product Loss Tax AmountNumberThe total tax amount levied on the product loss amount.
Product NameStringThe user supplied name of the product.
Product PriceNumberFull price of the product.
Product Sale PriceNumberThe set sale price for a product consisting of a price with a discount already applied.
QuantityNumberThe number of units of the item ordered.
Quantity ReceivedNumberThe actual quantity received for the return item.
Quantity RestockableNumberThe quantity of returned items that can be returned to active product stock.
Quantity ShippedNumberThe quantity of the item shipped to the shopper in the event of a return item replacement.
ReasonStringThe reason the item was returned.
Return IDStringThe internal unique identifier of the return.
Return Item Created DateDatetimeThe timestamp of the date and time the return item was created.
Return Item IDStringThe internal unique identifier of the return.
Return Item Updated DateDatetimeThe timestamp of the date and time the return item was most recently updated.
Return NumberStringA merchant-specific identifier used to sequentially order returns.
Return TypeStringThe type of return, which is Refund or Replace.At the top-level return level, this field is deprecated because Refund and Replace items can now be mixed within a single return. For backwards-compatibility with older applications, the field defaults to Replace.
Shipping Loss AmountNumberThe total value of shipping the returned product to the merchant for accounting purposes, calculated by multiplying the shipping cost of the item by its quantity returned.
Shipping Loss Tax AmountNumberThe tax amount levied on the shipping loss amount.
Site IDNumberUnique identifier for the site. This ID is used at all levels of a store and catalog to associate objects to a site.
Total With Weighted Shipping And HandlingNumberThe total cost with shipping and handling applied.
Total Without Weighted Shipping And HandlingNumberThe total cost without shipping and handling applied.