Preparing Your Auto-Reorder Rules Spreadsheet

Print Friendly and PDF

Skubana is able to determine your inventory re-order analytics based on your sales velocity over a number of criteria. 

1. Navigate to Inventory>Import/Export>Import Reorder Rules.

2. On the Product Auto-Reorder Rules Import page, click the link to download the Auto-Reorder Rules Import template. You may also download the template from here.

3. Complete the Auto-Reorder Rules Import spreadsheet.

Header Description
Master SKU The Master SKU used to create your products.
Velocity Days Back  The date range for which Skubana should calculate a product's sales velocity. 
Desired Days in Stock The number of days a product must be in stock once replenished.
Forecasted Growth  Expected % change in a product's sales velocity. This number can be negative. 
Buffer (Safety) Days Days to order before lead time to allow for vendor to respond to a P.O. request.


4. Save the spreadsheet until you are ready to import the file.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Please sign in to leave a comment.