This report will help you understand what products you need to order in advance so you do not run out and lose sales.

Important NoteThis report is designed to be viewed 1 warehouse at a time, but you can select "All warehouses" which will add/combine all the values for those warehouse per product.

 

 You have two options on how to use this report depending on your business process.

Option 1 - Forecasting based on sales history

Veeqo calculates your sell-out rate for a previous period (default to last 30 days but you can adjust to whatever you want) to predict you stock requirement for the future, this also factors in the following data points:

Sales uplift
Adjust you the sell our rate by a fixed %.  So if you set the previous sales history date to last December but know you are growing at 10% from the previous year, you can set the uplift to 10%

Stock holding time
The length of time you want your new order of stock to last, default to 4 weeks, but you can adjust to your needs.

Supplier lead time
Set a value in days per supplier per product and Veeqo will factor this in when working our your stock requirements.

Customer waiting on backorders
Order stock for orders which are waiting on the stock. When ON this will adjust “Suggested Qty” to add these. 

This qty is calculated by the number of product which is UNALLOCATED in orders with status WAITING FOR STOCK. 

Max Stock option
Optional. If enabled then Veeqo will cap the order qty to the "max" amount set for the product in that warehouse.

 

Option 2 - Forecasting on fixed minimum stock qty

 Veeqo suggests the qty to order based on the minimum stock level you have set per product per the warehouse.

The suggested qty is the Re-order qty you have set per product per the warehouse.

 
Max Stock option
Optional. If enabled then Veeqo will cap the order qty to the "max" amount set for the product in that warehouse.

 
 Tips for getting most out of the report

  • Set a default supplier and cost price for each of your products.
  • Set a lead time for each product per supplier
  • If you prefer to set fix "minimum stock qty" rather than a forecast based on previous sales, then you should set a min/max/reorder qty per product per warehouse by finding the product and adjusting this qty in the app.

 

Bulk creating purchase orders

  • Tick which products you would like to create a purchase order for
  • Select between using the products default supplier OR manually selecting a supplier
  • Choose if the purchase order will be draft or active and if it should email the supplier
  • Add the items to an existing draft purchase order if it exists

 

 

Did this answer your question?