> 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/customers/importing-customers-in-bulk/customer-location-info.md).
# Customer Location Info
Completing Customer Locations in bulk saves time, reduces manual data entry, and helps keep location information accurate and consistent across Supply’d.
Completing **Customer Locations** in bulk using a spreadsheet provides a quick and efficient way to add or update location information for multiple customers. Using the spreadsheet template helps reduce manual data entry, maintain consistent location records, and save time when managing customers with multiple delivery or trading locations.
{% hint style="success" %}
👉See the [Importing Customers in Bulk](/supplyd-erp/customers/importing-customers-in-bulk.md) document for details on downloading the spreadsheet and completing the import.
👉 See [Customer Details](/supplyd-erp/customers/importing-customers-in-bulk/customer-details.md) for details on completing the bulk import spreadsheet customer data.
👉 See [Customer Contact Info](/supplyd-erp/customers/importing-customers-in-bulk/customer-contact-info.md) for details on completing the bulk import spreadsheet customer contacts.
👉 See the [Adding a Customer](/supplyd-erp/customers/adding-customers-leads-and-customer-groups/adding-a-customer.md) document for instructions on completing customer information one customer at a time.
{% endhint %}
This document explains how to complete the **Customer Locations** spreadsheet and prepare the information for bulk import into Supply’d.
***
### Completing the Customer Location Information
{% stepper %}
{% step %}
#### Select the Data
Following the instructions for [Adding Customers in Bulk](/supplyd-erp/customers/importing-customers-in-bulk/adding-customers-in-bulk.md):
1. In **Step 2**, select **Locations** from the menu.
2. In **Step 3**, in the **Fields** section, select **Locations**.
***
{% 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.
{% hint style="warning" %}
* Follow the column headings carefully.
* Do not change column names.
* Leave **Customer Number** fields blank for new records.
* Delete any sample data before importing.
{% endhint %}
{% hint style="success" %}
When updating customer 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 customer information.
For example, if you only want to update a customer’s **Name** and **Email Address**, keep the **Customer ID**, **Name**, and **Email Address** columns and remove the other fields from the CSV. Any fields that are removed from the CSV will not be changed during the import.
**Important:** Keep the **ID** column for every customer you want to modify. The **Customer ID** identifies the specific existing customer that Supply’d should update 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 customers with the sample data.
{% endhint %}
#### Customer Locations
**Customer Number**
The unique identification number for this customer.
**Customer Name**
The trading name of your customer's business.
**Id**
An identifying number for this location. Leave blank for new locations.
**Name**
Enter a name for this location.
**Address**
Enter the customer's street address.
**Suburb**
Enter the customer's suburb.
**State**
Enter the customer's state.
**Postcode**
Enter the customer's postcode.
**Country**
Enter the customer's country.
**Email**
Enter the customer's email address.
**Is Billing**
Whether or not this is the address for billing. Enter "Yes" or "No".
**Is Shipping**
Whether or not this is the address for shipping. Enter "Yes" or "No".
**Next Call Date**
Enter the next date for a sales rep visit or call to this customer.
{% hint style="success" %}
Double-check that all required fields are filled out correctly before uploading.
{% endhint %}
{% endstep %}
{% endstepper %}
Once you've completed and saved your customer data template, you’re ready to import it into Supply’d.
👉 See [Adding Customers in Bulk](/supplyd-erp/customers/importing-customers-in-bulk/adding-customers-in-bulk.md) for details on importing your data.
---
# 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 dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:
```
GET https://help.supplyd.co/supplyd-erp/customers/importing-customers-in-bulk/customer-location-info.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
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.
