Skip to content
  • There are no suggestions because the search field is empty.

How to Track Consumables by Quantity or Volume

Keep track of bulk consumables like paint, flakes, fabric, chemicals, or raw materials by the total amount on hand, so you don't have to count each individual unit. You set up one item in the unit you measure in, subtract what your team uses, and Sortly keeps the running total for you. This article walks you through creating the item, subtracting what you use, and monitoring and replenishing your stock.

When to use this method

Use this method when you don't need to track each individual unit, only an accurate running total. For example, you might want to know how many yards of fabric or gallons of paint you have left, not which roll or can was used.


Create the item

1
Go to your Sortly inventory and select Add Item.
2
Enter a name for the item, for example Muslin Roll.
3
Set Unit of Measure to the unit you track in, such as pounds, gallons, yards, feet, or liters.
4
In Quantity, enter the total amount you have on hand. For example, if you have 12 rolls at 10 yards each, enter 120 yards.
Add Item window with Quantity set to 120 and Unit of Measure set to yd for a Muslin Roll item
5
Select Add.

Subtract the quantity used

When your team uses material for a job, update the item's quantity so the total stays accurate.

1
Open the item and update its quantity. In the Update Quantity window, select the minus button (−) and enter the amount used in Quantity, for example 5 yards.
2
New Quantity shows the updated total. In this example, 120 yards becomes 115 yards.
Update Quantity window subtracting 5 yards from a Muslin Roll item, with New Quantity showing 115
3
Add a Reason or Transaction Note if you'd like, then select Update.

The total quantity in stock goes down right away. To track usage by project, you can also move that amount into a job folder or location folder.


Monitor and replenish

  • Update the total quantity whenever you receive new stock.
  • Use reports to track consumption trends.
  • Add custom fields if you want to record more detail, such as supplier, batch, or purchase date. You can create them with Add Custom Field on the Custom Fields page.
Custom Fields page with Expiry Date, Assigned Crew, and Purchase Date fields and the Add Custom Field button

Tips and best practices

  • Use the smallest unit of measure possible. For example, track individual straws instead of boxes of straws for more accurate stock counts. This gives you flexibility when subtracting smaller amounts.
  • Set up low stock alerts so you're notified before you run out and can stay ahead of reordering.
  • Move quantities into job or location folders whenever they're used. This makes reporting more accurate at the project level.
💡 Need to track each individual item with its own QR code instead? See How to Track Individual Items with Unique QR Codes.

Frequently Asked Questions

What's the difference between this method and unique QR codes per item?
This method tracks one total quantity for the whole item, which suits bulk consumables. Unique QR codes give each individual unit its own identifier, which is better when you need to trace specific pieces.
What unit of measure should I use?
Use the smallest practical unit for your material, like pounds, gallons, yards, feet, or liters. Smaller units give you more precise stock counts and more flexibility when subtracting usage.
How do I get notified before I run out of stock?
Set up low stock alerts on the item so you're notified before the quantity runs out and can stay ahead of reordering.
Can I track usage by job or location?
Yes. When material is used, move that quantity into a job folder or location folder so reporting stays accurate at the project level.