> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.posbytz.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Upload/Import Files

# Download Sample

| Navigation: Pos Backend → Upload/Import Files →	Download Sample

Multiple records can be imported into the system using import feature. 

![](https://storage.crisp.chat/users/helpdesk/website/9ae720b538edc000/1_cyra6a.png)

The following buttons available on the top right corner: 
* Download Sample
* Import File

**Download Sample**

Press this button to download the sample XL sheet. The following sheets are available:

1. Categories 
3. Taxes 
4. Items
5. Transfer Order
6. Waste Management
7. GRN 
8. Item Price Update
9. Price Categories
10. Stock Update
11. Purchase Order
12. Order
13. Item Variation Update
14. Item Inventory Tax Update
15. Item Ingredient Update

Sample sheet contains demo data for reference. Have data in the sheets which are to be imported and delete information in the other sheets. For example, if we are configuring Taxes, Categories and Items, delete information in other sheets. After filling the required details, save and close the XL. 



||| **Note**: _Columns names marked with RED colour in **Download Sample** XL sheet are mandatory fields._
---
# Upload/Import Files

**Step 1**: Press Import File button and choose the XL file to import.


![](https://storage.crisp.chat/users/helpdesk/website/9ae720b538edc000/1png_1py5r8a.png)

**Step 2**:  After every import, an entry is created in the table with **pending **status. Wait for 10 seconds and refresh the page to see the current status. After refresh, the status changes from **Pending** to the either one of the following:

 * **Completed**: Press ** View** button under the **Actions **column to open the **Import Information Table**.
* **Error** : Upload the sheet again.


![](https://storage.crisp.chat/users/helpdesk/website/9ae720b538edc000/2png_1uz7jr9.png)

**Step 3 **: Once the status is **Completed** press **View** button under Actions to open the import information. To download the uploaded sheet press **Download** button. The following are the columns available in **Import Information**. 

* **Sheet Name**: Displays the imported tab name.
* **Total Error Lines**: No of error lines, click the lines to see the detailed error report.
* **Total Records**: Total number of records imported.
* **Failed Records**: Failed number of records.
* **Finished Records**: Completed number of records.
* **Completion Progress**: Completion progress of the import.


![](https://storage.crisp.chat/users/helpdesk/website/9ae720b538edc000/3png_tq9kul.png)


![](https://storage.crisp.chat/users/helpdesk/website/9ae720b538edc000/4png_nevj62.png)