Saleable recommended RTV report

Noon enforces a Long Term Storage Fee for inventory stored in: FBN warehouses in UAE or KSA for over...

noon enforces a Long Term Storage Fee for inventory stored in:

FBN warehouses in UAE or KSA for over 12 months.
FBN warehouses in Egypt for over 6 months.

To avoid these charges, it is essential to retrieve aging stock before the respective time limit. The Saleable Recommended RTV Report helps sellers identify such stock, simplifying the retrieval process and preventing storage fees. Below is a guide on how to access this report and an explanation of the included data.

How to access this report?

Accessing this report is a very easy and simple procedure. All you have to do it follow the simple steps given below.

1. Click on Navigation menu, then select FBN and choose the Reports.

2. Click on Generate Report.

3. Under Report Name, select a category and choose Returns.From the Returns Reports tab, select Saleable Recommended RTV Report. Choose a Close Date and then click on Generate Report to complete the process.

Explanation of the columns in the sheet:

Download header	Description	Example value
run_date	The date till which the data is updated	Previous day's date
sku	Noon SKU or ZSKU	N12345
pbarcode	Product barcode	123456grt
title	Title of the product	Iphone 14pro
brand	Brand of the product	apple
longest_side	The dimensions of the longest side of a single unit of the item (in centimeters)	15
median_side	The dimensions of the side of a single unit (in centimeters) of the item that is neither the longest nor the shortest. The Inventory Storage Fee is charged by volume in cubic feet, which equals the longest side x median side x shortest side. These often correspond to the length, width, and height of an item	14
shortest_side	The dimensions of the shortest side of a single unit (in centimeters) of the item	10
weight	The item's weight used to identify its product-size tier. This can be the item's unit weight or dimensional weight, depending on the item. (we can take the larger value) (in kilograms)	1.7
item_volume	The Inventory Storage Fee is charged per volume in cubic feet, which equals the longest side x median side x shortest side. These often correspond to the length, width, and height of an item. (in cubic feet)	0.074
volumetric_weight	It refers to the overall size of an item which is calculated by multiplying longest, median, and shortest side and dividing by 5000	0.42
product-size-tier	Classification of the item by its dimensions for purposes of calculating fees	Standard-sized or Oversize
country_code	Country of the noon warehouse	UAE/KSA/Egypt
warehouse_code	Warehouse where the inventory is stored	DXB05
warehouse_type	Type of the warehouse	Sort/Non-sort/Bulky
closing_qty	It refers to the net stock inventory after reducing the pending rtv removal qty	5
recommended_rtv	This is the inventory that has aged at least: -12 months from ASN in UAE or KSA noon warehouse. - 6 months from ASN in Egypt noon warehouse.	1

That's it

Got more questions?