# Retrieving the Item ID in "Edara"

> Source: https://help.getedara.com/en/articles/9805775-retrieving-the-item-id-in-edara · Category: Warehouse › Stock items · Last updated: 2026-05-04 · العربية: https://help.getedara.com/ar/articles/9805775-%D8%A7%D9%84%D8%AD%D8%B5%D9%88%D9%84-%D8%B9%D9%84%D9%89-id-%D8%A7%D9%84%D8%B5%D9%86%D9%81-%D8%AF%D8%A7%D8%AE%D9%84-%D8%A5%D8%AF%D8%A7%D8%B1%D8%A9

The Item ID is a number automatically generated by the database to ensure unique identification of items. It is considered more reliable than other identifiers like model codes or SKU numbers, which may vary in uniqueness depending on user-defined settings.

The ID column is hidden when exporting item data to avoid potential errors during re-import after modifications. However, in exceptional cases—such as importing raw material lists—it becomes necessary to display the ID for use in the import template.

## Retrieving the Item ID in "Edara"

1. Go to the Warehouse module.
2. [Open the “Warehouse Stocks Report”.](https://help.getedara.com/en/articles/5240910-displaying-the-warehouse-stocks-report)
3. Click “ **Generate** ”.
4. Click on the “ **+** ” icon at the bottom right of the page.
5. Select either Excel or Google Data, depending on your preference.

> **Note:** When opening the Google Data file, you will find the item IDs in the first column. However, they remain hidden in the Excel file.

![Retrieving the Item ID in "Edara" — Select either Excel or Google Data, depending on your preference.](https://help.getedara.com/images/stock-items/9805775/01.en.gif)

## Frequently asked questions

**Why doesn't the item ID appear in the Excel file?**

When opening the Google Data file, you will find the item IDs in the first column. However, they remain hidden in the Excel file.