Supplier order based on sales (en)¶

Inventar → Supplier orders based on sales → Generate new supplier order

1. Select supplier (mandatory).

2. Select categories and manufactures for supplier products (can be empty). You can set for each estimated fluctuation.

3. Select excluded product status from order (Offline).

4. Add general fluctuation for order (max fluctuation is used for the product if it is set for product categories or for manufacturer)

5. Select date interval for sales analysis

6. Select days for order.

Algorithm

1. Select supplier products that were ordered between the selected dates.

2. Filter products by categories and manufacturers (if they are set).

For each products:

→ Calculate average ordered quantity / day (avg)

i) Find days when product was in stock.

ii) For each days calculate ordered product quantity from shop and from external orders.

→ Calculate available stock (product stock in warehouse - reserved stock).

→ Add quantity from another supplier orders to available stock.

Quantity for order = avg * days - available stock + minimum stock

→ Add fluctuation.