Consolidated Item Level Fees Report

Consolidated Item Level Fees Report

The Consolidated Item Level Fees Report provides sellers with a detailed breakdown of each item sold on Noon within a selected date range. It includes only those items for which at least one statement has been generated and offers key insights into product details, sales statuses, fees, and tracking references.

What’s Included in the Report?

This report helps sellers track their transactions and understand the financial impact of each sale, including:

  • Product details (title, brand, category, etc.).

  • Item status (delivered, returned, or pending).

  • Timestamps (order date, shipment date, delivery date, return date).

  • Fees and charges levied on sales.

  • Reference numbers (statement number, invoice number, credit note) to track sales transactions.

Note: The Consolidated Item Level Fees Report applies only to items sold on the Noon marketplace. It does not include payment details for other Noon subsidiaries, such as Sivvi, Noon Grocery, etc.

How to access the Consolidated Item Level Fees Report?

Follow these steps to generate the report:

  1. Open the Navigation Menu, go to Payments & Fees, and select Export.

  2. Click on Generate Report.

  1. Under Category, choose Consolidated Item Level Fees Report.

  2. Select the Start Date and End Date, then click Create.

Understanding the Consolidated Item Level Fees Report

Identifiers

This section helps you identify the products that were sold. It provides item numbers that serve as reference numbers across all your reports, making it easier to track individual items.

Note: The certain fields, such as Airway bill number (AWB) and SKU, might not have data when the order status is "shipped". However, once the order is delivered, andstatements are generated, all relevant data will be visible.

Field

Definition

id_partner

A unique identifier (numerical number) that differentiates one seller from the other. 

marketplace

Business platform under which the item was sold (noon marketplace)

order_nr

The unique identifier you can use to link a sale (common for all items involved in a single payment transaction) across reports

item_nr

The unique item level identification number you can use to link a sale for any item across reports

partner_sales_nr

The purchase order number linked to a particular item_nr

awb_nr

Shipment reference number you can use to link packages that were created against any particular order fulfillment

SKU

The SKU identification number of noon you sold the item against

partner_sku

The unique SKU identifier number you have uploaded in the seller lab

Sale Information

Here, you'll find essential details about your sales, including the current item status, sales promise service level, and timestamps for each transaction.

Field

Definition

fulfillment_mode

Whether the customer order was fulfilled by noon (FBN) or fulfilled by partner (FBP)

family

noon defined product family the sold SKU falls under

product_type

noon defined product type the sold SKU falls under

brand_en

The brand name of the sold SKU, in English

product_title_en

The title of the sold SKU in English, as defined by the seller

brand_ar

The brand name of the sold SKU, in Arabic. If Arabic content is missing, English content will appear by default.

product_title_ar

The title of the sold SKU in Arabic, as defined by the seller. If Arabic content is missing, English content will appear by default.

item_status

The current status of the sold item. 

country_code

The country where the item was sold. UAE is coded as AE, KSA is coded as SA and Egypt is coded as EG

last_statement_date

The last date within the selected date range (for which the report was generated), when a statement was generated 

order_date

The date when the order was placed successfully

shipped_date

The date when a shipment was prepared and made ready for despatch

delivered_date

The date of delivery to the customer. 

returned_date

The date for return to noon's/ seller warehouse

currency_code

The sale currency. You will receive a separate statement denominated in UAE dirham or Saudi Riyal depending on the sale country 

Item Prices and Promotions

These columns provides visibility into any adjustments made due to promotions, markups or taxation. The fields named seller promo, noon markup and promo coupon are funded by noon and will be credited back to the seller as fee noon promo.

Field

Definition

Calculation

seller_price

The item price value updated by the seller in the seller lab

No calculation

seller_promo

Any applicable promotion applied by you as a sale price

No calculation

base_price

Seller price adjusted for promotional costs borne by the seller with prior agreement between seller and noon

seller price minus seller promo

promo_deal

Any applicable promotion applied by noon 

No calculation

noon_markup

Any price difference applied on an item fulfilled by an alternate partner other than the original seller on whom the order was placed

Offer price of the alternate seller minus the offer price of the original seller 

offer_price

The price of the item on noon.com after all applicable promotions

Base price plus noon markup and promo deal

promo_coupon

Any coupon or promotion applied by the customer

No calculation

invoice_price

The item value invoiced to the customer. The invoice price is inclusive of VAT.

Offer price minus promo coupon

Fees and charges.

These columns give you a complete overview of all the fees and deductions for each sale made on noon.

Note: The Direct Ship Outbound fees and FBN Outbound fees are charged immediately when the item is shipped. However, all other fees will be charged upon successful delivery of the order.

Field

Definition

fee_noon_promo

Reimbursement of marketing / promotional activity sponsored by noon

fee_noon_markup

Any price adjustment done on the item price due to alternate fulfillment

fee_referral

noon's commission on the sale. See noon service annexes for KSA and UAE

fee_outbound_fbn_old

Order fulfillment fee charged for items shipped from FBN (fulfillment by Noon) warehouses before 1st Jul'22

fee_outbound_fbn_v2

Order fulfillment fee charged for items shipped from FBN (fulfillment by Noon) warehouses from 1st Jul'22

fee_weight_handling

Additional fulfillment fee charged on an oversize (non-sort and non-bulky) item over and above old FBN outbound fee.

fee_crossdock

Fulfillment fee charged on the X-dock items before 1st Nov'22

fee_outbound_direct_old

Logistics fee charged on items shipped from FBP (Fulfilled by Partner) warehouses under Directship fulfillment mode till 31st Dec'22

fee_directship_outbound

Logistics fee charged on items shipped from FBP (Fulfilled by Partner) warehouses from 1st Jan'23

fee_shipping

Reimbursement of shipping fees collected from the customers on FBP delivered items

fee_damaged_return

Compensation paid against any damages on a returned item

fee_noon_penalty

Compensation paid to the sellers on breach of sales promise

fee_item_cancellation

An item level penalty charged on the seller initiated order cancellation such as out-of-stock.

fee_warranty_penalty

An item level penalty charged against unfulfilled warranty claim of a customer

fee_retention_penalty

An item level penalty charged to recover any compensation we had paid to the customer against their grievances where the seller is at fault

fee_alternate_seller_fulfillment

An item level penalty applied on the original seller who missed to fulfill an order and the order was fulfilled by another seller

fee_miscellaneous

Any other kind of penalty levied on a seller

fee_direct_collection

Adjustment of payment against COD (Cash on delivery) amount collected from the customer

fee_reinvoicing

Adjustment against any invoicing anomalies

total_payment

Final eligible payment against a sale

statement_nr

A comma separated list of statement numbers linked to the item

invoice_nr

The customer invoice reference for VAT purposes

creditnote_nr

The customer return invoice reference for VAT purposes

 


That’s it!  

 

Got questions?

Contact us at seller@noon.com


 




    • Related Articles

    • Orders Level Fee

      The Order Level Fees section in Seller Lab provides a detailed breakdown of the profit and loss for each order. It includes Net Proceeds and all applicable Fees for a specific order, offering a granular representation of the information already ...
    • New Statement Detail Report

      The Statement Detail Report provides a concise overview of fees and payments in a statement. It offers a detailed breakdown of fees at both the item-level and shipment/AWB level. Note: The Statement Detailed Report is only applicable to items ...
    • Return to Vendor (RTV) Report

      When you transfer stock to Noon’s warehouses, it remains your property and can be retrieved at any time, subject to retrieval fees. To provide transparency and clarity, Noon offers two reports in Seller Lab to help you manage and track retrieval ...
    • Saleable Recommended RTV Report

      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 ...
    • Non- Saleable Recommended RTV Report

      To help you avoid Non-Saleable Item Storage Fees and manage your non-saleable inventory efficiently, Noon provides the Non-Saleable Recommended RTV Report. This report details non-saleable items stored in Noon fulfillment centers that are eligible ...