Skip to main content

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


25.png

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


Screen Shot 2022-05-02 at 2.04.47 PM26.png

Click on the "Upload Min Max Settings" button. 

Screen Shot 2022-05-02 at 2.05.44 PM23.png

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 PM24.png

Upload the saved template and click OK to apply changes. 


Screen Shot 2022-05-02 at 2.06.31 PM22.png

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