All Collections
Purchasing
Demand Forecast
Replenish Based on Reorder Levels
Replenish Based on Reorder Levels

Bulk create purchase orders for multiple products based on preset reorder levels

Updated over a week ago

Overview

Replenishing stock in your location is key to avoiding stockouts and lost revenue.

There are two ways to easily create purchase orders in bulk for multiple products.

  1. Create purchase orders based on reorder levels (this article)

In this section:


Replenishment report

Navigate to Demand Forecast report and select Settings -> Reorder Levels

To fine-tune recommended reorders, adjust the following settings:

  • Max stock option: When enabled, this will cap the recommended reorder quantity at the preset levels by SKU

  • Show default supplier: When enabled it will only show suppliers who are the default for that product.


How recommended reorder levels are calculated

  1. For each location, products below the preset Min Stock Qty threshold are added to the reorder report

  2. On the reorder report, recommended reorder levels use the preset Reorder Qty per product

  3. If the "max stock option" setting is enabled, reorder levels will be capped at the product's preset Max Stock Qty


Bulk create purchase orders

  1. Select the products you would like to reorder from your suppliers and click New Purchase Order

  2. Choose between using the product's default supplier, or manually select a supplier

  3. Indicate whether the purchase order's status is Draft or Active. If Active, you can choose to send an email to the supplier directly through Veeqo

  4. You can chase to add the items to an existing draft purchase order (if applicable)


Tips for using this report

Before getting started:

  • Add reorder levels for each product, which can differ by location. If a product falls below the reorder level, the product will be added to the reorder report

  • Set a default supplier and cost price for each of your products. This will speed up the process of bulk purchase order creation

When sending suppliers a purchase order:

  • You can only create a purchase order when you have only 1 location selected. If you have set it to "All Locations" then this feature is blocked.

  • If you prefer to send your supplier one big order, then you can create a draft purchase order and then keep adding items to that same purchase order by using the option "Add items to existing draft purchase order".


Report column definitions

Report Column

Definition

SKU

SKU stands for Stock keeping unit. A unique identifier per product variation.

Previous Sales (Units sold)

Total sales revenue for this product excluding sales tax and shipping revenue but includes discounts.

Units sold = sales of this product. Excludes the sale of this item from inside another product bundle/kit. You can toggle the "Include Kits" option to change this.

Supplier (lead time)

Your default supplier for this product, which can be changed.

Lead time: The number of days it takes for goods to be delivered after being ordered from the supplier.

Cost

The cost price of the selected supplier. Each supplier in Veeqo can have a separate price per product. You can overwrite this manually in the report.

Available (Days left to sell out)

Inventory available for sale which is calculated by stock on hand, less committed stock.

Days left to sell out: Days/weeks/months left before this product runs out of stock based on the sales period selected.

Customer backorder

This quantity is calculated by the number of products that are unallocated in orders with the status "Waiting for Stock".

Incoming

Number of units that have been ordered from a supplier but have not been received

In transit

Inventory due to arrive from another of your locations

After

Inventory available when everything arrives from suppliers and stock transfers.

Calculated by: Available + incoming + In Transit - customer backorders

Min stock qty

Minimum stock qty you should keep for this product. Set per location manually.

Max stock qty

Maximum stock qty you should keep for this product. Set per location manually.

Qty to order (Days left to sell out)

Inventory qty you should order to have enough to cover stock holding time (i.e. 4 weeks) minus you After inventory qty.

Stock cover time qty is calculated by: (Number of days in period / units sold) * Number of days in stock cover.

Days left to sell out = Days/weeks/months left before this product runs out of stock based on sales period selected.

Did this answer your question?