# Import - BOM (Bill Of Materials)

In case you have the Bill of Materials in an xls spreadhseet, you can easily import it in ERPAG.

If you have the finished product and parts (materials) entered in ERPAG, make sure that the SKUs and descriptions match exactly both in the system and in your xls, otherwise the system might double them. If you don't have parts and/or finished product entered in the system, they will be automatically added with the import.

You can download the template for the BOM import from the import window.

```
Inventory > products and services > import > bill of materials
```

![](/files/-LLjkm2IrIEZjdo1bY0g)

When you get a window for importing the BOM, click on the more button and 'export to xls' in order to export the blank template to your computer.

![](/files/-LLjlLPl77P__dmHL-Fh)

You will get an empty xls spreadsheet with neccessary columns for import. You can either just add the captions of the columns to your xls, or copy/paste the information to the downloaded one.

The populated xls spreadsheet for importing should look like this:

![](/files/-LLjoKzsX9Px4yes8Cvo)

{% hint style="info" %}
Make sure that you have the captions of the column entered, otherwise the system will skip the first row when you copy/paste the information to ERPAG.
{% endhint %}

Just copy entire colmn from your xls, along with the caption of the column and empty rows (don't worry about those, they won't be imported).

![](/files/-LLjpqbVc8t6u6fosLJ5)

And paste it to a matching column in ERPAG.

![](/files/-LLjq9NQ9J4MO94IgGmB)

Do this for all columns. The finished table should look just like your xls spreadsheet.

![](/files/-LLjqXi93PG4cyX4FSp7)

From here, just save the document and the system will import the product, along with its bill of materials.

![](/files/-LLjr1kQAivlQxEVvfTJ)

The imported products (the finished product and materials) will automatically appear in your list of products and services as well (unless you already had them entered before importing).

![](/files/-LLjrMHl-zhPDNCzQSH-)

![](/files/-LLjrUlYIrGaxZn3KNUG)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://learn.erpag.com/project/importing/import-bom-bill-of-materials.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.