Update Min/Max Values via Spreadsheet.

Instructions on how to update min/max values for products via spreadsheet.

 

To set min-max values via spreadsheet, navigate to the calculate reorder page and click on the "Get Template" button to download the template excel sheet.

Screen Shot 2022-05-02 at 2.14.10 PM

Next, fill in the required fields. Save the spreadsheet.

Screen Shot 2022-05-02 at 2.04.47 PM

Click on the "Upload Min Max Settings" button. 

Screen Shot 2022-05-02 at 2.05.44 PM

Select the location type (DC, Store, or Supplier), and select the specific location you wish to update.  

Screen Shot 2022-05-02 at 2.06.17 PM

Upload the saved template and click OK to apply changes. 

Screen Shot 2022-05-02 at 2.06.31 PM

 

Note that this method only updates the specified SKUs at one location.