---
title: "Mass Update Product Branch Data"
canonical: "https://kb.myframeworks.com.au/space/PROSTIXV48DOC/31097016/Mass%20Update%20Product%20Branch%20Data"
format: markdown
---
The Mass  Update Product Branch Data  import utility allows for Branch level mass updates of Product information such as preferred supplier, or min/max stock via a .csv file. The csv must be in the following format and saved to /prostix/dmp on the ProStix server prior to running the utility: Column A = Product Code (mandatory) Column B = Branch (mandatory) Column C = Product Type Column D = Preferred Supplier Column E = Min Stock Column F = Max Stock Column G = Primary Location Column H = Lead time Column I  = Reorder Cycle Column J = Cost Loading Type ( $ or %) Column K = Cost Loading Column L = Cost Loading Effective Date Column M = Performance Category To mass update Branch Product Data , perform the following: 1. From the  ProStix   Main Menu  select  'System Administration'  then  'Utilities'  then  ' Run a Program ' . 2. Enter program  invubrdscimp.p  in the "Which program" field 3. Press <F1> or Enter to prompt for import data parameters Press <F3> to search and select  Location ID Add name of csv file import in the  CSV File name  field. Press <F1> or Enter. 4. When prompted enter yes/no to the values you wish to update: 3. Select <F1> (Go) to run utility. A warning popup will advise if any errors occurred during the import Select <View Errors> to view the errors on screen, or select <OK> to output a csv error report to /prostix/dmp.