Information Systems:Order Minimums

In order to help lower the high cost of delivery, we have daily order minimums for customers (not shareholders). As of November 2015, they are -

BC lower mainland     $ 500

Anywhere else in BC     750

Alberta                1000

Anywhere else          1500

This is calculated by the program WSUPDMIN2, which is called for all stores every night, and for an individual store during partner maintenance in InfoNet. Instead of following the above rule, the order minimum can be overridden. For example, Southwest Central fill is right in our building, so their order minimum has been overridden to a dollar. It is very expensive to ship to Fort Nelson, so the order minimum there is overriden from $750 to $1500.

You can see the effect of this in InfoNet / Carrier Interface / Freight to Sales Analysis

This was done in June 2015. See how freight, as a percentage of sales, has halved. While the monthly sales has stayed about the same.

When we receive a POS order, either by email or FTP, after the regular item checking is done and valid order lines are found, IOPMIN01 is run to check if the customer is over their daily minimum or not. It accumulates the total of orders already accepted today, orders held in IOP with status 55 (under daily order minimum), plus the order currently being validated. If the total is under the minimum, the currently order is changed to status 55, and the email confirmation says `Ùnder order minimum. Please increase order`.

IOPNEP01 calls IOPMIN02 to release orders over minimum IOPPOS00 calls IOPMIN01 to hold if over order minimum IORIQ100 calls IOPMIN02 after manually post an order