> For the complete documentation index, see [llms.txt](https://factorypos.gitbook.io/pos-r4-en/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://factorypos.gitbook.io/pos-r4-en/main-screen/data-settings/data-import.md).

# Data Import

## Data Settings - Utilities

<figure><img src="https://167739833-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fm3BN5zhEJvDLjmb5OTOS%2Fuploads%2FkkAOqNYB4AfBoK16bYWZ%2FFactoryPOS%20PDA%20Data%20Import%201.png?alt=media&amp;token=f133e11d-384d-4e65-9971-de73b1b144a7" alt=""><figcaption></figcaption></figure>

You have the option of **importing the item, department and price level information** from an external **EXCEL** file, or importing the items, departments and price levels information from an external **SQL** file. This process **overwrites the current data** but does not delete the database. Therefore, you can perform imports of a few records that will be added or updated in the database, but will not delete any information.&#x20;

<figure><img src="https://167739833-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fm3BN5zhEJvDLjmb5OTOS%2Fuploads%2FNi3aTWnycXpyh69ciTBj%2FFactoryPOS%20PDA%20Data%20Import%202.png?alt=media&amp;token=fd653057-4408-4181-9cb7-03760f3f77fa" alt=""><figcaption></figcaption></figure>

When you want to import an EXCEL or SQL file, click the <img src="https://167739833-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fm3BN5zhEJvDLjmb5OTOS%2Fuploads%2FLcO0eXMLWy1cRFdCAScd%2Fimage.png?alt=media&amp;token=555c39a8-08c1-4177-be75-651c200ebf51" alt="" data-size="line"> button to browse for the file.&#x20;

<figure><img src="https://167739833-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fm3BN5zhEJvDLjmb5OTOS%2Fuploads%2FJIZzDXjZ8ucUz0ibkJhj%2FFactoryPOS%20PDA%20Data%20Import%203.png?alt=media&amp;token=fd787ecd-12c4-4167-adc3-4a511dc4aafb" alt=""><figcaption></figcaption></figure>

When you select the file you want to import, simply click on the **Accept** button to start the process.&#x20;

<figure><img src="https://167739833-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fm3BN5zhEJvDLjmb5OTOS%2Fuploads%2F75VVV1k0jsEABmp57kyX%2FFactoryPOS%20PDA%20Data%20Import%204.png?alt=media&amp;token=aa372044-b713-443a-84e6-d67b66f89360" alt=""><figcaption></figcaption></figure>

To see the format of the file to be imported, we recommend that you first select **Data Export** and use the obtained file as a sample for the **Import**.

##

If you are importing an external file in **EXCEL** format, you will need to confirm if you want to delete previous data.&#x20;

<figure><img src="https://167739833-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fm3BN5zhEJvDLjmb5OTOS%2Fuploads%2F8voe2GYngvCMzBWBZAeR%2FFactoryPOS%20PDA%20Data%20Import%205.png?alt=media&amp;token=231d8ab7-b0b2-4ed3-88af-406a0fa8c1fb" alt=""><figcaption></figcaption></figure>
