Handle 500 ml and 750 ml oil formats separately
Illustrative inputs, not verified product specifications or care recommendations.The household question
A delivery mixes bottle capacities, so one capacity field is insufficient.
Measurements and assumptions
Record A
| Full bottles | 2 |
|---|---|
| Capacity per bottle (ml) | 500 |
| Open bottle remaining (ml) | 0 |
| Item name | 500 ml oil |
| Storage location | Household supply shelf |
| Minimum stock | 0 |
Record B
| Full bottles | 1 |
|---|---|
| Capacity per bottle (ml) | 750 |
| Open bottle remaining (ml) | 0 |
| Item name | 750 ml oil |
| Storage location | Household supply shelf |
| Minimum stock | 0 |
Calculation and observed tool result
Record A
2 bottles × 500 ml + 0 ml = 1,000 mlRecorded quantity: 1,000 ml.
Record B
1 bottles × 750 ml + 0 ml = 750 mlRecorded quantity: 750 ml.
Carry out this task
- Open the linked tool for Record A.
- Create two capacity-specific records instead of editing one average capacity.
- Check each result separately; follow the interpretation before retaining both records as physical stock.
What the result means
Both records describe 1,750 ml combined while retaining the two purchasing formats.
A mistake to avoid
A single capacity value cannot represent these three unlike bottles exactly.
Limits of this example
Only totals measured in the same volume unit can be compared directly.
Open Cooking Oil & Condiment Bottle Tracker · How to Organize Kitchen Supplies with QR Codes