Add a new Item with Stock=0:
Add a supplier for this item
Order 120 of this item to the supplier
Update Item.Stock after the item is delivered.
When processing an order, first verify sufficent quantities exist in stock and adjust items.Stock.
A new item.AdjustStockDB() checks and update as a single transaction.
After the order is completed, a new record is added to Stocktransaction and items.Stock is updated.
Supplier information:
Name: Supplier Company Ltd.
John Smith :
Street: 12 Main Street
City: Torrance
State: CA
Country: US
Zip: 90210
Email: John@test.com
Phone: 111-222-3333
The items are provided by this supplier:
ID: b8bff320-54dd-4708-aead-c0fa79cb22c6
Name: Tulip
Stock: 118
Stock transactions for this item:
ID: 3788
Date: 4/16/2026
Comment: Sold to customerID: 1234
Quantity: -2
Stock information for this supplier:
ItemID: b8bff320-54dd-4708-aead-c0fa79cb22c6
OrderDate: 4/16/2026
DeliveryDate: 4/18/2026
Price: $2.99
Quantity: 120