Abandoned Products

I/ Overview

As a store manager, if you want to check which products are often forgotten to check out by the customer, this report is for you.
To access the Sale by Time-frame report: Omni-channel Reports > Report Dashboard > All reports > Marketing > Abandoned Products or Omni-channel Reports > Marketing-> Abandoned Products

The Abandoned Products Report page is displayed with the default view as below:

Report details

On the main page, you can select metrics of the orders you would like to see in the report, based on the information you would like to see, including:

Time range

You can set the time range in which you want to see data on the report (From a date To another specific one)

Data Used

Date used:

You can select either Item Created or Item Updated

By default, the setting would be Order Created

+ Item Created: Show report based on the date the item is created

+ Item Updated: Show report based on the date the item was last updated

Data detail
On this report, there will be 2 types of columns: columns that are shown by default and columns that are hidden by default when you access the report

Columns that are shown by default

Product Name	Name of the product
Abandoned Amount	The abandoned amount of the product in all abandoned carts including that product Value= row total of the product which is abandoned from the cart (excl. tax and discount) -The currency will follow the Base Currency of the Magento site.
Subtotal of the Abandoned Cart	The Subtotal of the abandoned carts which include the product -The currency will follow the Base Currency of the Magento site.
Product Abandonment Rate (%)	The contributions as % of this Abandoned Amount over the Subtotal Value= *(Abandoned Amount of the abandoned product/ the Subtotal of the Abandoned Cart which includes that abandoned product) 100%**

Columns that are hidden by default

Total Abandoned Qty

Total abandoned qty of the product in all abandoned carts
This column is hidden by default

Total Qty added to Abandoned Cart

Total qty of all abandoned carts that include that abandoned product
Ex:

Abandoned Cart 1:
+ Abandoned Item A is added 5 qty
+ Abandoned Item B is added 4 qty

Abandoned Cart 2:
+ Abandoned Item A is added 3 qty
+ Abandoned Item C is added 2 qty

-> Total Qty added to Abandoned Cart of Abandoned Item A is 14 qty.

This column is hidden by default

Number of Cart

Total carts that the product is abandoned from
This column is hidden by default

II/ Filter Report Data

On this report, you can filter by Product Name (text box), Abandoned Amount (from-to), Subtotal of the Abandoned Cart (from-to)

III/ Chart

In this chart, you can compare the data of each metric in the Report by selecting the value through the Select Metrics dropdown including (Revenue (excl. Tax), Revenue (incl. Tax), Qty Sold, Average Selling Price, % Total Revenue, Qty Refunded, COGS, Profit, Margin (%), Refunded, Invoiced, Discount, Tax ).