Magento Business Intelligence Help Center

The Enterprise_Rma_Item_Entity Table

Each row in the enterprise_rma_item_entity table (often called magento_rma_item_entity in Magento 2.x, but the name can be customized) contains information about a specific item from a requested return. Please note that this table only comes standard with your Magento 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 will not necessarily match the value of the overall return’s status.
qty_requested The quantity the customer requests for return.
qty_approved The quantity the approved for return.
qty_returned The quantity actually 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 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 will be used to calculate the total return amount on the `enterprise_rma` table.

 

Common Metrics

Click to view full list
Metric Name Metric Description Metric 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

enterprise_rma

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

sales_flat_order_item

  • Create joined columns on the  enterprise_rma_item_entity table via the following join:
    • Magento 1.x: enterprise_rma_item_entity.order_item_id (many) => sales_flat_order_item.item_id (one)
    • Magento 2.x: magento_rma_item_entity.order_item_id (many) => sales_order_item.item_id (one)
Was this article helpful?
0 out of 0 found this helpful

Comments

Powered by Zendesk