# How To: Bulk Update Data

_By Brandon Munn · Feb 3, 2026_

#### **How to Bulk Update Data**

When you want to make bulk changes to data in BrewMan, it can be more effective and quicker to download the data into a spreadsheet, make the changes there and then **Import** it back into BrewMan. For example, you may want to make changes to all your **Outlets** or **Products** at once.

If you instead want to import new data into the system, please follow this guide, [5: Importing Data](https://premier-systems-ltd.featureos.help/en/articles/step-4-importing-data)

You can **Bulk Update** via csv for the following sets of data between BrewMan and Microsoft Excel.

-   **Ageing Casks**
    
-   **Item Purchase Details**
    
-   **Leads**
    
-   **Materials**
    
-   **Outlet Contacts**
    
-   **Outlet Group Contacts**
    
-   **Outlet Groups**
    
-   **Outlet/Outlet Group Codes**
    
-   **Outlets**
    
-   **Price List Entries**
    
-   **Product Brands**
    
-   **Product GL Codes**
    
-   **Products**
    
-   **Stock Availability and Reordering**
    
-   **Suppliers/Manufacturers**
    

### **New Bulk Data Update**

1.  Go to **Administration** **→ Data Management → Import.**
    
2.  Select **New Bulk Data Update** at the bottom of the screen.
    
3.  Select the **Data Type** from the dropdown and click **Download Update File.**
    
4.  Once downloaded, open the file in Microsoft Excel.
    

_Please note, you cannot use the '_**_Export_**_' function, update your data and then_ **_Import._** _You must use an_ **_Update File_** _from_ **_New Bulk Update_** _in_ **_Import._**

![](https://vault.featureos.app/uploads/attachment/upload/2f32dc6ae44a48988c32128771d43829.png)

#### **Editing the Data**

1.  In the spreadsheet, every field will have a **New** column next to it. Add any changes you wish to make in the **New** columns and leave the pre-existing information in the adjacent column. 
    
2.  If the field is remaining the same, leave it as it is and leave the field in the **New** column blank.
    
3.  Save any changes you have made.
    

![](https://vault.featureos.app/uploads/attachment/upload/35a823d0dad3f257fb6065f7901623cf.png)

#### **Importing the Updated Data**

1.  Switch back to the update screen in BrewMan.
    
2.  Click **\*Choose CSV to upload** and select the updated Excel file.
    
3.  Click **Next Step**.
    

![](https://vault.featureos.app/uploads/attachment/upload/ce4ac141772c89a2a2251ceec92e30e4.png)

#### **Confirming the Update**

The system will then show you a preview of Row 1 of your data if everything is in the right format.

If there are any errors in the file, such as name clashes or setting clashes, BrewMan will highlight these. Before you can import the data, these errors will need to be resolved and the file uploaded again. Once all errors have been resolved, click **Update** in the bottom right.

After successfully updating, the system will confirm this with a pop up message. You will then have a record listed in the **Import** menu.

![](https://vault.featureos.app/uploads/attachment/upload/9c6db0d4f082d1727762e2169823ab99.png)

For any assistance with errors or uploading please contact support@premiersystems.com

[View this article on the web](https://premier-systems-ltd.featureos.help/en/articles/how-to-bulk-update-data)