The consolidated report aims to give you an overview of all of your sales with noon. Every item dispatched by noon will be included in the report along with all of its core financial information
You can use the consolidated report to do some of the following:
- Calculate sales by product
- Calculate sales over time
- Identify items that are intransit and have not been delivered
- Identify items that have been delivered but not yet paid for
Items will only be included in the consolidated report after dispatch by noon
Jump to sections
Accessing the consolidated report
The consolidated report is available in the custom section of the Seller Lab reports section. When filtering by date keep in mind that items are included in the consolidated report based on their shipping date.
This version of the consolidated report is only available to partners on the stock request order processing flow
Understanding the consolidated report
These columns help you identify which of your products was sold. In addition the item number provides a reference that can be used across all subsequent reports.
|item_nr||The unique customer order you can use to link a sale for any item across reports|
|The unique partner sku you have uploaded in seller lab|
|sku||The noon SKU you sold the item against|
Commissions and service levels
These columns show you all of the information used to derive you commission rate. In addition the SLA type and due dates communicate your return promises under the noon sales promise.
All items will have a shipped date. Items will subsequently update with a delivered or returned date, where these items are not present you can assume the item is still in transit.
|city_from||The noon dispatch warehouse|
|city_to||The customer city. Useful for VAT attribution|
|commission_type||The applicable commission scheme with noon. If your product is eligible for a promotion it will be communicated here|
|item_status||The current status of the item.|
|sla_type||The applicable noon sales promise.|
|shipped_date||The date of dispatch from noon's warehouse|
|delivered_date||The date of delivery to the customer. This value may change if noon receives a contradictory update from our logistics partners|
|returned_date||The date for return to noon's warehouse|
|return_ndr_due_date||The return due date if the item cannot be delivered to the end customer|
|return_cir_due_date||The return due date if the item is delivered to the customer and subsequently returned|
|currency_code||The sale currency. You will receive a separate statements denominated in UAE dirham or Saudi Riyal depending on the sale country|
Item prices and promotions
These columns provide you with visibility about any adjustments due to promotions, crossborder markups or taxation.
noon Markup and Indirect VAT are related to crossborder transactions and will no longer be applicable going forward.
The Seller Promo, noon Markup, Promo Deal and Promo Coupon values account for promotional activities. Promo coupon is always funded by noon and is credited back to you via Fee noon Promo.
|base_price||Seller price adjusted for promotional costs borne by you. With prior agreement between you and noon||Seller price minus seller promo|
|seller_promo||Any applicable promotion applied by you as a sale price||No calculation|
|seller_price||The price value updated in Seller Lab||Base price plus seller promo|
|noon_markup||Any applicable noon crossborder or logistics markup||No calculation|
|promo_deal||Any applicable promotion applied by noon||No calculation|
|offer_price||The price of the item on noon.com after all applicable promotions||Seller price plus noon markup and promo deal|
|promo_coupon||Any coupon or promotion applied by the customer||No calculation|
|indirect_vat||Any VAT charges due at the end country for crossborder||No calculation|
|invoice_price||The value invoiced to the customer||Offer price minus promo coupon and indirect VAT|
The Invoice Price corresponds to VAT Supply in the Invoice report and is inclusive of VAT, when recording the sale you can either use the VAT amount from the invoice report to decide how much to book to your VAT account.
Payments due and statements
Statements are generated weekly. Once an item is delivered the Payment Pending value will increase to match the Payment Due amount. Once a statement is generated the value in Payment Statement Total will be deducted from the Payment Due amount.
|fee_commission||noon's commission on the sale. See noon service annexes for KSA and UAE|
|fee_closing||noon's closing fees on the sale. See noon service annexes for KSA and UAE|
|fee_noon_promo||Credit back to you of any marketing / promotional costs due by noon|
|fee_noon_markup||Deduction of noon crossborder fees where applicable|
|fee_adjustments||Adjustment to previous fee or commission values|
|fee_crossborder_vat||Deduction of noon crossborder VAT where applicable|
|fee_vat_deducted_at_source||No longer applicable|
|fee_noon_penalty||Penalty fee incurred by noon due to late or damaged return of an item|
|payment_due||Final payment due|
|payment_statement_total||Payment due in the next applicable statement|
|payment_pending||Final payment due less any payments in other statements|
|invoice_nr||The customer invoice reference for VAT purposes|
|creditnote_nr||The customer return invoice reference for VAT purposes|
|statement_nrs||A comma separated list of statements for the item|
Items missing from the consolidated report
Items will only be included in the consolidated report once they have been dispatched by noon.
For crossdock B2B (crossdock) there will be an average of 24 - 72 hours from the time you handover an item to the time it dispatches.
In addition in the following circumstances an item may not be dispatched at all:
- The customer cancels their order with noon prior to dispatch
- The item is received in a transfer but fails quality control
If the number of sales for a product is lower than what you expected based on what you handed over to noon you can check the following areas to tally the figures
- Your transfers from noon for return to vendor (RTV) documents
- Your stock close report for current noon stock on hand