Setting up reorder points for a whole catalog one row at a time is slow. If you already keep your minimums and maximums in a spreadsheet, you can upload them in one go.
Get the template
In the top menu, click Inventory, then Item Reorder Points.
At the top right, click Import. The Import reorder points window opens.
Click Download sample XLSX.
The template has these columns, and no example row: Warehouse, SkuCode, Min, Max, Advance Reorder, Processing Time, Safety Stock, Growth Multiplier and Replenish Days.
Fill it in
Add one row per item and warehouse:
Warehouse: the warehouse name, exactly as it appears in Brahmin Solutions.
SkuCode: the item's SKU (its item code).
Min and Max: the numbers you want.
Every column in your row is saved, including empty ones. If an item already has a Processing Time or Safety Stock, a row that leaves those cells empty sets them back to 0. Fill them in on any row where you want to keep them.
Upload it
Back on Item Reorder Points, click Import.
Drag your file onto the box that says Drag XLSX here to import reorder points., or click the underlined link in that box and choose the file.
The file's name appears in the box and the Import button turns green. Click Import.
How to know it worked
The window closes and a message says how many rows went in, for example 1 reorder points imported. Search for one of the items to check its new numbers.
If some rows don't go in
When a row can't be used, for example because the SKU doesn't exist, the window stays open with Some rows could not be imported. Every other row has already been saved.
Click Download error file. It lists the rows that failed, with a Failure Reason column such as SKU 'HH-899' not found. Fix those rows and import that file again.


