# Upload Bill of Materials (BOM)

A **Bill Of Materials (BOM)** is a list of raw materials, sub-assemblies, or any labor that goes into the Manufacturing of an Item. The materials from a BOM get consumed to produce the manufactured good.

Use the Bill of Materials module to create a BOM for an item.

Use the **Batch Upload Bill Of Materials** module to batch upload the BOMs in the system.

### Uploading the Bill Of Materials

Follow the steps below to upload the bill of materials.

* Download the latest CSV template from the “**Batch** **Upload Bill Of Materials**” module.
* Copy the BOM information into the CSV template.
* Upload the updated CSV template into Xoro.

### Downloading the CSV template

* Go to the “**Batch** **Upload Bill Of Materials**” module using the search menu.
* Click on the “**Download Template**“.

  <figure><img src="/files/Bm5H3J4OyNshXH8X92Bl" alt=""><figcaption></figcaption></figure>

### Copying the information into the template

Once you’ve downloaded the template file, you can copy your data using any spreadsheet software. There are columns that you must complete and others that are optional. Mandatory fields are marked with a double asterisk (\*\*) prefix.

Below are some points to be noted when entering the data into the template.

* The file must be a CSV (Comma-separated values) file. The name of your file must end with csv.
* Make sure you don’t change any column headings from row 1 in the template; these are needed for the file to import correctly.
* All date fields will accept the MM-DD-YYYY format.
* Be mindful of any leading zeros in your data; some spreadsheet software will trim them automatically without notifying you. This can be resolved by ensuring your columns have correct formatting.
* Sometimes long numbers are formatted as scientific notation. Be sure to change the formatting on this data to display these long numbers correctly.

{% hint style="info" %}
If you’re importing more than 5,000 records, we recommend you split up the file.
{% endhint %}

<figure><img src="/files/P9dw6fL0YP7Xw0M7anWW" alt=""><figcaption></figcaption></figure>

#### Upload Bill Of Material Template Fields

<table><thead><tr><th width="205">Column Name</th><th width="110.33333333333331">Data Type</th><th>Description</th></tr></thead><tbody><tr><td>**BomName</td><td>Text</td><td>Give a name to the Bill Of material.</td></tr><tr><td>**BomItemNumber</td><td>Text</td><td>Enter an item that this bill of materials is for. Note that only items that are configured as manufacturable will be fetched in this field.</td></tr><tr><td>BomItemDescription</td><td>Text</td><td>Add Description of the BOM Item in this column.</td></tr><tr><td>Memo</td><td>Text</td><td>This field allows you to add notes or any additional information related to the bill of material. This allows you to add important details or instructions that need to be considered during the manufacturing or assembly of the product.</td></tr><tr><td>Revision</td><td>Text</td><td>If you are uploading a BOM Revision, enter the revision number here.</td></tr><tr><td>EstimateTimeMinutes</td><td>Numeric</td><td>Enter the approximate time (in minutes) it takes to produce this item.</td></tr><tr><td>ValidFromDate</td><td>Numeric</td><td>Enter a date from where the validity of this BOM starts.</td></tr><tr><td>ValidToDate</td><td>Numeric</td><td>Enter a date from the validity of this BOM ends.</td></tr><tr><td>**RawMaterialSku</td><td>Text</td><td>Enter the raw material SKU number for the BOM. Please note that only items configured as raw materials can be added.</td></tr><tr><td>Description</td><td>Text</td><td>Add a description for the raw material item.</td></tr><tr><td>Instructions</td><td>Text</td><td>Add the manufacturing instructions for the raw material.</td></tr><tr><td>**Qty</td><td>Numeric</td><td>Enter the number of units of the raw material added.</td></tr><tr><td>ServiceUnitCost</td><td>Numeric</td><td>This field allows you to input the unit cost of the Service/Non Inventory Item added in the BOM.</td></tr><tr><td>OneTimeItem</td><td>Text</td><td>Enter “Y” if this item is only consumed once during the manufacturing process, regardless of the quantity being produced.</td></tr><tr><td>PPENotes</td><td>Text</td><td>This field allows you to add specific instructions or information related to Personal Protective Equipment (PPE) that should be followed during the manufacturing or assembly of the product.</td></tr><tr><td>IsRevision</td><td>Text</td><td><p>If this is set to “Y”, then the Bill Of Material will be uploaded as a revision to the existing BOM. <br></p><p><strong>Please Note:</strong></p><ul><li>If this is marked as true, then the columns “Revision”, “ValidFromDate”, and “ValidToDate” fields are required.</li><li>The revision will only be created if a Bill of Material exists.</li><li>If BOM does not exist, the upload will create a BOM and not a revision.</li></ul></td></tr><tr><td>PreventSubMo</td><td>Text</td><td>Enter "Y" to prevent auto-creation of sub-MO for this item line even if inventory is short when releasng the MO. </td></tr><tr><td>ImportError</td><td>Text</td><td>If there any errors from an upload, they will be listed in this column.</td></tr></tbody></table>

### Uploading the template

Once you have filled the CSV file with your data, you can follow the steps below to upload it into Xoro:

* The **Default values** for required columns can be configured before the upload.

  <figure><img src="/files/40DkvLfeBMTtiFYK6b0G" alt=""><figcaption></figcaption></figure>
* Please check the defaults before uploading BOM(s).
* If the data in the template is blank or incorrect, then the uploader will fall back and use these specified default values.
* Click **Browse** to select the saved CSV template file.

  <figure><img src="/files/iTomJc71DUTZqaJfknUz" alt=""><figcaption></figcaption></figure>
* After the file has been selected, click on **Upload** to start importing.

  <figure><img src="/files/KSv0CbC0eEeTFU6gxdWu" alt=""><figcaption></figcaption></figure>
* While the import is in progress, the summary of the progress will be displayed at the bottom of the screen with the progress bar.
* After the import has been completed, the result will be displayed with the message for success or error (if any).

  <figure><img src="/files/whyHFA9XhB2Mgq5QmNLR" alt=""><figcaption></figcaption></figure>
* BOM will only get uploaded into the system if there are no errors in the file. If there are errors in the file, you can download the error file, fix the errors in the **original file,** and upload it back into Xoro.

  <figure><img src="/files/Qp0SZRA8MuhdqGWH0rWa" alt=""><figcaption></figcaption></figure>
* You can check the uploaded BOM(s) from the BOM Centre module.

  <figure><img src="/files/XXlF7SJgcNkXroT3y0DB" alt=""><figcaption></figcaption></figure>

### Scheduling the Upload

XoroERP allows you to schedule the upload of your bill of materials (BOM). This feature is particularly useful for managing large datasets or performing uploads during off-peak hours to minimize disruption.

To schedule the upload, click on the upload dropdown and select “Schedule Import”.

<figure><img src="/files/ZUTdkKBlOaMWo2To0m7k" alt=""><figcaption></figcaption></figure>

&#x20;The Job Scheduler window will populate. Fill in the details and click “Save” to schedule the BOM import.

<figure><img src="/files/Fk4sKneCV6ZgQ8RlOc0I" alt=""><figcaption></figcaption></figure>


---

# 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://docs.xorosoft.com/xoroerp-1/utilities/data-imports/upload-bill-of-materials-bom.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.