Product Display

[BillM]

Which product is displayed to the customer when it is available from multiple suppliers?

When products are displayed to the user, certain criteria are used to pick which one to show. These are as follows (in order of priority):

1. On-hand quantity is greater than 0
   
2. Supplier quantity is greater than 0
   
3. Lowest price
   
4. Preferred supplier
   

This means that if a product has an on-hand quantity, it is used no matter what. Otherwise, it chooses the product with the lowest price for which a supplier has in stock. In the event of a tie for price, then the order of suppliers here takes precedence.