> 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/products/bulk-importing-of-products/updating-products-in-bulk.md).
# Updating Products in Bulk
Bulk updating products saves time, reduces manual data entry, and makes it easier to keep your product catalogue accurate and up to date.
**Bulk Updating Products** allows you to update information for multiple products at once using a CSV spreadsheet, rather than editing each product individually. This is a quick and efficient way to maintain your product catalogue, particularly when making changes to a large number of products.
This document explains how to prepare the CSV, select the information you want to update, and import the changes into Supply’d while minimising the risk of unintended changes.
***
### Updating Products
{% stepper %}
{% step %}
#### Open the Import Products Form
1. Select **Products** from the menu.
2. Click on the 3 dots on the top right corner
3. Select **Import** then **Products**.
The **Import Products** form will open.
***
{% endstep %}
{% step %}
#### Download the Template
Click on **Download the template** to download our base template containing some sample products for your guidance.
The **Export Products** form will open.
***
{% endstep %}
{% step %}
#### Export Your Data
**Data Source**
Select a sales channel from the menu to export your existing products and use them as the basis for your bulk update.
**Fields**
Select the type(s) of data to include in the export.
Click .
{% hint style="info" %}
The more selections you make in the **Fields** section, the more data fields will be included in the spreadsheet.
{% endhint %}
***
{% endstep %}
{% step %}
#### Remove Unwanted Columns
Remove all unnecessary columns from the CSV, keeping only the specific fields you wish to change (eg. Price or Category).
{% hint style="success" %}
When bulk updating existing products in Supply'd via a CSV file, following a "lean" approach is recommended to prevent data loss or operational disruption. Keeping only the fields you want to change makes the import easier to manage, reduces processing time, and minimises the risk of unintentionally changing other product information.
For example, if you only want to update **Price** and **Category**, keep the **Product ID**, **Price**, and **Category** columns and remove the others. Fields removed from the CSV will not be changed during the import.
**Important:** Keep the **ID** column for every product you want to modify. The **Product ID** identifies the specific product that Supply’d should update.
**Why This Method is Best Practice**
* **Avoids User Conflicts:** Helps prevent changes from interfering with team members editing the same products.
* **Prevents Data Deletion:** Leaving unnecessary fields blank can cause existing data to be cleared.
* **Improves Efficiency:** A smaller CSV reduces processing time and the risk of import errors.
Keeping only the fields you need ensures the import is focused and reduces unintended changes.
{% endhint %}
{% hint style="danger" %}
**Important:** The title row should remain in the document in order for the system to match the columns when imported.
{% endhint %}
***
{% endstep %}
{% step %}
#### Complete the Spreadsheet
Open the CSV in **Excel** or **Numbers**, enter the information you want to update, and follow the guidance in the following documents for completing the various fields in each template.
* [Product Info](/supplyd-erp/products/bulk-importing-of-products/product-info.md)
* [Label Info](/supplyd-erp/products/bulk-importing-of-products/label-info.md)
* [Purchasing Info](/supplyd-erp/products/bulk-importing-of-products/purchasing-info.md)
* [Sales Channel Info](/supplyd-erp/products/bulk-importing-of-products/sales-channel-info.md)
{% hint style="warning" %}
* Follow the column headings carefully.
* Do not change column names.
* Leave **ID** field blank for new records.
* Delete any sample data before importing.
* Double-check that all required fields are filled out correctly before uploading.
{% endhint %}
***
{% endstep %}
{% step %}
#### Export/Save the File
Once you have completed your changes in the spreadsheet, save or export it as a CSV file as this format is required for successful import into Supply’d.
***
{% endstep %}
{% step %}
#### Upload the File
On the **Products** page, click on the 3 dots in the top right and select **Import**, then **Products**.
The **Import Products** form will open.
In the **Upload CSV File** field, click on to select the CSV file you just completed.
{% hint style="warning" %}
After selecting the file please ensure you wait for the file to successfully upload before clicking Import.
{% endhint %}
***
{% endstep %}
{% step %}
#### Select Options
**Update Existing Products**
Select **Yes** to update existing products when their SKUs match.
#### **Advanced**
Optional data you would like to be used to populate the export.
**Auto Extract Data**
Choose whether to enable **Automatic Extract Data**, which automatically matches CSV columns to the correct Supply’d fields, saving time and reducing errors.
**Run Other Product Importers**
Choose whether to let Supply’d automatically detect and map CSV files from platforms such as **Shopify** or **Square**, without reformatting the file.
***
{% endstep %}
{% step %}
#### Import the File
Once the file has successfully uploaded and you have selected your options, click to begin the import.
{% hint style="info" %}
Product data will be imported immediately into Supply'd. If you have a lot of products, please be patient.
{% endhint %}
{% endstep %}
{% endstepper %}
---
# 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/products/bulk-importing-of-products/updating-products-in-bulk.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.
.
to select the CSV file you just completed.
to begin the import.