enterprise_rma_item_entity Table

Last update: Mon Jul 24 2023 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

Beginner
Intermediate
Admin
Developer
User

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.

NOTE

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

enterprise_rma

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)

sales_flat_order_item

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)

recommendation-more-help

e1f8a7e8-8cc7-4c99-9697-b1daa1d66dbc