A by-order sales report is a report on the product sales with reference to the order the product was sold in. You can download this report in your seller profile, in the Finances → Documents section.
Report structure #
“For reference” («Справочно») section #
Contains information about the products delivered to customers during the reporting period.
- Seller’s price (including the seller’s discount) (Цена продавца (с учётом скидки продавца)) is the price of the product, including all seller’s discounts and promotions.
- Sales commission fee (Комиссия за продажу) is the commission fee rate for the product by category.
If your product was sold under a promotion, the Seller Price (taking into account seller’s discount) column will show the promotional price.
“Sold” («Реализовано») section #
Contains information about the products delivered to customers during the reporting period.
- Selling price (Цена реализации) is the price at which the customer purchased the product. Can be given taking into account a discount at Ozon’s expense, an installment fee or customer’s points.
- Quantity (Количество) is the quantity of the product sold at this price.
- Sold in the amount of (Реализовано на сумму) is the cost of the products sold, taking into account the quantity. Calculation is carried out at the selling price.
- Balance payment at Ozon expense (Доплата за счёт Ozon) is the discount provided to customers at the Ozon initiative to promote the product on the site.
- Total commission fee taking into account discounts and mark-ups, RUB (Итого комиссия с учётом скидок и наценки, руб.) is the amount of the commission fee in rubles taking into account the quantity of products, discounts provided and established mark-ups.
- Total accrual (Итого к начислению) is the amount accrued to the seller for the products sold after deducting the commission fee for the sale, applying discounts and established mark-ups.
The commission fee rate is fixed at the moment the order is created. For example, if a commission fee rate for the product is 5% at the time of ordering but 10% at the time of delivery, the commission fee for the product will be 5%.
Find out more about the commission fee
“Returned by the client” («Возвращено клиентом») section #
Contains information about products that were returned by customers - for example, if the product did not fit in size or color.
- Selling price (Цена реализации) is the price at which the customer purchased the product. Can be given taking into account a discount at Ozon’s expense, an installment fee or customer’s points.
- Quantity (Количество) is the quantity of the returned products.
- Returned for the amount of (Возвращено на сумму) is the cost of the returned products, taking into account the quantity. Calculation is carried out at the selling price.
- Balance payment at Ozon expense (Доплата за счёт Ozon) is the discount provided to customers at the Ozon initiative to promote the product on the site.
- Total commission fee taking into account discounts and mark-ups, RUB (Итого комиссия с учётом скидок и наценки, руб.) is the amount of the commission fee in rubles taking into account the quantity of products, discounts provided and established mark-ups.
- Total refunded (Итого возвращено) is the amount accrued to the seller for the returned products before deducting the commission fee, applying discounts and established mark-ups.
If the customer returns the product, Ozon will refund you 100% of the commission fee for the sale and deduct the balance payment at the expense of Ozon.
“Shipment” («Отправление») section #
- Number (Номер) is the number of the order to which the product belongs.
- Date (Дата) is the date of the order to which the product belongs.
“Sale to a legal entity” («Продажа юридическому лицу») section #
- Tax invoice number (Номер счёта-фактуры) is the number of the tax invoice to which the product belongs.
- Date (Дата) is the date when the tax invoice was issued.
“Total accrual” («Всего к начислению») field #
Displays your total payout and is calculated by the following formula:
Total accrual (Всего к начислению) = Total accrual (Итого к начислению), RUB. (“Sold” column) - Total refunded (Итого возвращено), RUB. (“Returned by the client” column)