Export products and your product KPIs
In a single export, you can obtain the list of your products as well as the following performance indicators:
- Number of rentals per product
- Revenue per product
- Stock at point of sale, initial stock, and broken or lost stock per product
For information: KPIs are updated after 1 hour.
Here is how to obtain your product export:
Go to the Catalogue - Products menu.
Click the "Export" button located above the product list.
Choose the export format. Select the export format you wish to obtain: CSV (file in .csv format) or EXCEL (file in .xls format).
Click "Export". A notification indicates that your request is being processed: "The export is in progress, you will be notified by email when it is available."
When processing is complete, a new notification will inform you. To find your export, click the "bell" icon to display the latest notifications.
Then click on the corresponding notification to download it. The "View all" button below the latest notifications opens a page displaying the list of all notifications. Select the export(s) you wish to download.
Then click "Download" to start the download.
Stock columns in the export
Warning: As in the back office, archived items are neither counted nor deducted in the quantity columns of this export.
As a reminder, an archived item is ignored in stock calculations, regardless of its status (end of life, broken, lost…). The "archive" function is only intended to remove an item that was created by mistake.
Here are the stock columns available in this export:
- Quantity at point of sale
- Initial stock at point of sale
- Lost or broken stock
- Quantity under repair
Quantity at point of sale = Initial stock at point of sale - lost or broken stock Corresponds to the "stock at point of sale" quantity.
Initial stock at point of sale = Stock entered manually or by import into the system Corresponds to the "global stock" in the product record.
Lost or broken stock: number of items returned with a broken or lost status Corresponds to the statistics of "Lost" + "Broken" items on the product record.
For information: KPIs are updated after 1 hour.
Quantity under repair: number of items returned with an under repair status. Corresponds to the statistics of "Under repair" items on the product record.