enterprise_rma_item_entity Table

Last update: 2023-07-24
  • Created for:
  • Beginner

Each row in the enterprise_rma_item_entity table (often called magento_rma_item_entity in Commerce 2.x, but the name can be customized) contains information about a specific item from a requested return.


This table only comes standard with your Commerce account if you are an Enterprise Edition or Enterprise Cloud Edition customer.

Common Native Columns

Column Name Description
entity\_id Unique identifier for the table. Each entity\_id represents an item that has been requested for return.
rma\_entity\_id Foreign key associated with the enterprise\_rma table.
status The status of the item’s return. Values include ‘received’, ‘pending’, ‘authorized’, among others. The values in this status may not match the value of the overall return’s status.
qty\_requested The quantity the customer requests for return.
qty\_approved The quantity approved for return.
qty\_returned The quantity returned.
order\_item\_id Foreign key associated with the sales\_flat\_order\_item table.
product\_sku The sku being returned.

Common Calculated Columns

Column Name Description
Return date\_requested This is the date that the customer requested the return.
Item price The price of the item.
Return item's total value (qty\_returned * price) This is the total monetary value of the items that are returned. This is used to calculate the total return amount on the enterprise\_rma table.

Common Metrics

Metric Name Description Construction
Number of items returned The number of items that are returned. Operation Column: qty returned
Operation: Sum
Timestamp Column: Return date requested
Returned items' total value The monetary amount returned. Operation Column: Return item’s total value (qty returned * price)
Operation: Sum
Timestamp Column: Return date requested

Connections to Other Tables


  • Create joined columns such as Return date\_requested on the enterprise_rma_item_entity table via the following join:
  • Commerce 1.x: enterprise_rma_item_entity.rma_entity_id  (many) => enterprise_rma.entity_id (one)
  • Commerce 2.x: magento_rma_item_entity.rma_entity_id  (many) => magento_rma.entity_id (one)


  • Create joined columns on the  enterprise_rma_item_entity table via the following join:

  • Commerce 1.x: enterprise_rma_item_entity.order_item_id  (many) => sales_flat_order_item.item_id (one)

  • Commerce 2.x: magento_rma_item_entity.order_item_id  (many) => sales_order_item.item_id (one)

On this page