{"section":"tutorials","requestedLocale":"en","requestedSlug":"how-to-rank-the-best-selling-items","locale":"en","slug":"how-to-rank-the-best-selling-items","path":"docs/en/tutorials/orders/all-orders/how-to-rank-the-best-selling-items.md","branch":"main","content":"> ⚠️ The **Orders** module was not designed as a Business Intelligence (BI) tool. It's usually through the ERP that the store has access to sales reports.\n\nWhile the **Orders** module primary goal is to manage the order flow, it is possible to manipulate data from the [order report](/en/tutorial/planilha-de-pedidos) to extract information that may be useful to your business.\n\nTo get a list of SKUs sold in a certain period by order of top sellers, follow the steps below:\n\n1. In the VTEX Admin, go to **Orders > All Orders**, or type **All Orders** in the search bar at the top of the page.\n2. Using the [filters](/en/docs/tutorials/filtering-all-orders), choose the period you want information about. \n3. Click the `Export` button in order to [export orders](/en/docs/tutorials/exporting-orders-in-orders-module).\n4. Open your email and download the link within 72 hours; the link will expire after that period.\n\nEach line corresponds to an SKU purchased in a particular order. In the `Quantity_SKU` column, you have the SKU quantity for that order. And in the `ID_SKU` column, you have the SKU ID.\n\nTherefore, you can use Excel to count how many times each SKU appears (`ID_SKU`), also taking into account cases where the SKU quantity for the same order is greater than 1.\n\nExample: in the case below, the SKU of ID 009 appears twice, both with quantity 1. Therefore, the total quantity for this SKU is 2. The SKU of ID 034 appears only once, but with quantity 2, so its total quantity is 2 as well. The other SKUs (001 and 050) appear only once, with quantity 1. So the total quantity of each of these SKUs is 1.\n\n| Quantity_SKU | ID_SKU |\n| ---------- | ---------- |\n| 1 | 001 |\n| 1 | 009 |\n| 2 | 034 |\n| 1 | 050 |\n| 1 | 009 |"}