> For the complete documentation index, see [llms.txt](https://help.supplyd.co/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.supplyd.co/supplyd-erp/suppliers/bulk-importing-suppliers/bulk-importing-supplier-locations.md).

# Bulk Importing Supplier Locations

If you have a large number of supplier locations to add, Supply’d allows you to save time by adding them in bulk using a spreadsheet.

Completing **Supplier Locations** in bulk using a spreadsheet provides a quick and efficient way to add or update location information for multiple suppliers. Using the spreadsheet template helps reduce manual data entry, maintain consistent location details, and save time when managing a large number of supplier locations.

{% hint style="success" %}
👉See the [Adding Suppliers in Bulk](https://help.supplyd.co/supplyd-erp/suppliers/bulk-importing-suppliers/adding-suppliers-in-bulk.md) document for details on downloading the spreadsheet and completing the import.

👉 See [Bulk Importing Supplier Details](https://help.supplyd.co/supplyd-erp/suppliers/bulk-importing-suppliers/bulk-importing-supplier-details.md) for details on completing the bulk import spreadsheet supplier data.<br>

👉 See [Bulk Importing Supplier Contacts](https://help.supplyd.co/supplyd-erp/suppliers/bulk-importing-suppliers/bulk-importing-supplier-contacts.md) for details on completing the bulk import spreadsheet supplier locations.

👉 See the [Adding a Custom Supplier](https://help.supplyd.co/supplyd-erp/suppliers/adding-suppliers/adding-a-custom-supplier.md) document for instructions on completing supplier information one supplier at a time.
{% endhint %}

This document explains how to complete the **Supplier Locations** spreadsheet and prepare the information for bulk import into Supply’d.

***

### Completing the Supplier Locations Template

<br>

{% stepper %}
{% step %}

#### Select the Data

Following the instructions for [Adding Suppliers in Bulk](https://help.supplyd.co/supplyd-erp/suppliers/bulk-importing-suppliers/adding-suppliers-in-bulk.md):

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

1. In **Step 2**, select **Supplier Data** from the menu.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2Fte9HmRZDBjMrjl6qndo4%2FSupplier%20-%203%20Dot%20Import.png?alt=media&amp;token=d810c019-f8cc-4bfe-ab8b-9ce97b50d4ab" alt="" width="187"><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

2. In **Step 3**, in the **Fields** section, select **Locations**.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FJ5pNdDKfg2wLymACASiK%2F2%20-%20Suppliers%20-%20Export%20Sample%20Supplier%20Locations.png?alt=media&amp;token=462b14cd-e422-4bf4-99bf-c7d962bf7784" alt="" width="563"><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

***

{% endstep %}

{% step %}

#### Complete the Template

Complete the template by opening it in a spreadsheet application, such as **Excel** or **Numbers**, and entering the required information. Follow the instructions provided for each section, using the downloaded sample data as a reference when entering your information.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

{% hint style="warning" %}

* Follow the column headings carefully.
* Do not change column names.
* Leave **Location ID** fields blank for new records.
* Delete any sample data before importing.
  {% endhint %}

{% hint style="success" %}
When updating supplier location details, you can remove any columns from the CSV that you do not need to update. Keeping only the fields you want to change makes the import easier to manage and reduces the risk of unintentionally changing other location information.

For example, if you only want to update a supplier location’s **Name** and **Address**, keep the **Location ID**, **Supplier Number**, **Name**, and **Address** columns and remove the other fields. Any fields removed from the CSV will remain unchanged during the import.

**Important:** Keep the **Location ID** and **Supplier Number** columns for every supplier location you want to update. The **Location ID** identifies the existing location, while the **Supplier Number** identifies the supplier the location belongs to, ensuring Supply’d updates the correct records when the CSV is imported.
{% endhint %}

{% hint style="danger" %}
**Important:** The title row should remain in the document in order for the system to match the columns when imported. You should remove the sample data before importing otherwise the system will create custom suppliers with the sample data.
{% endhint %}

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

***

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

#### Location Fields

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FxCpJSnY9cAWkXCSDXFhc%2FSpacer.png?alt=media&amp;token=afe204fe-beb4-4ae2-9a9d-85b55c10514a" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FtbDzBGXB0zfUsUhKkIGV%2F8%20-%20Locations%20Spreadsheet.png?alt=media&amp;token=efe8094d-c535-40f5-b697-639f85bc164d" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FxCpJSnY9cAWkXCSDXFhc%2FSpacer.png?alt=media&amp;token=afe204fe-beb4-4ae2-9a9d-85b55c10514a" alt=""><figcaption></figcaption></figure>

**Supplier Number**

Enter the **Supplier Number**, which is the unique identifier for the supplier in Supply’d. This ensures the location is linked to the correct supplier.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Supplier Name**

Enter the trading name of the supplier associated with the location.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Location ID**

Enter the unique identifier for the supplier location in Supply’d. This is used to identify an existing location when updating location details.

Leave this field blank when adding a new location.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Location Name**

Enter a name that clearly identifies the supplier location, such as **Head Office**, **Warehouse**, or **Melbourne Office**.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Address**

Enter the street address for the supplier location.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Suburb**

Enter the suburb for the supplier location.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**State**

Enter the state or territory for the supplier location.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Postcode**

Enter the postcode for the supplier location.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Country**

Enter the country where the supplier location is located.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Email**

Enter the email address associated with the supplier location.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Is Billing**

Enter **Yes** if this location should be used as the supplier’s billing address.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Is Shipping**

Enter **Yes** if this location should be used as the supplier’s shipping address.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

**Next Call Date**

Enter the next scheduled call date for this supplier location. This can be used to keep track of when the supplier at this location should next be contacted.

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2Fgm1lLnsL3UmGeKlFMD5d%2FSpacer.png?alt=media&amp;token=9490e112-dce7-4e69-baf5-bf4ee3ef4513" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2965503026-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDaPYJDB89ny0x7wcMedb%2Fuploads%2FbJDih3Dwv41QavjV1QDa%2FSpacer.png?alt=media&amp;token=6c34f805-9610-4de9-8f8a-a029f13dd1a1" alt=""><figcaption></figcaption></figure>

{% endstep %}
{% endstepper %}

{% hint style="success" %}
👉 Once imported, supplier locations can be managed as outlined in the [Supplier Locations Tab](https://help.supplyd.co/supplyd-erp/suppliers/managing-suppliers/supplier-locations-tab.md) document.
{% endhint %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

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

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://help.supplyd.co/supplyd-erp/suppliers/bulk-importing-suppliers/bulk-importing-supplier-locations.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.
