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 calls WSORDAMT to accumulate the total of orders already accepted today, plus orders held in IOP with status 55 (under daily order minimum). It then adds 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`.

UW_CART in Web Orders also calls WSORDAMT to get the total of orders already received (accepted or not) today.

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