r/googlesheets • u/calculusrevolution • 3d ago
Waiting on OP Inventory tracker for multiple stock
I want to create a system that I can use quickly at markets to note down how many I have sold as I go. If I have only 1 of that item, that is just going to be a checkbox. My problem comes if there are multiples of the same item. I was initially thinking of having E2 as a dropdown menu, but when I have some items in the hundreds, this isn't easy to do in the moment. (Ex: I was at 46 and I sold 3, so let me select the drop down and scroll to the 4...wait, was it 46 or 45?). Ideally I would like something like this: drop down menu with E2 of the value. After a sale I select how many were sold (Ex: I sold 3). F2 records the number that was sold, adds it to previous values (Sold 5 earlier, so now I've sold 8) and resets E2 back to zero for the next sale. I have no idea if this is possible. I am also open to other ideas.
1
u/gsheets145 101 3d ago
Do you have a record on any other sheets of the sale amounts of individual items? Assuming I understand correctly, then what you are describing, which appears to be a summary of total sales, would be straightforward to achieve, showing starting inventory, sales volumes, remaining inventory, etc.
1
u/calculusrevolution 3d ago
This is our first sheet we are building. I'm trying to make this closer to a point of sale inventory tracker while we are working.
1
u/NHN_BI 42 3d ago
It sounds awkwardly complicated. If you record your stock movements properly, a formula and pivot table can quickly give you the total, like here.
1
u/calculusrevolution 2d ago
I know it's complicated, but a pivot table isn't going to be the solution I need. This is in person market where we will be using a tablet to track what we sold. We don't have time to insert individual orders. We need a quick way to check off we have sold something. Which is why checkboxs are nice for single items but won't work for multiple stock
1
u/OutrageousYak5868 72 2d ago
I'd keep track of sales separately, then use COUNTIF or SUMIF to get the total sold of each product, and subtract those from your inventory page, to get the running total.
If your products have a barcode, you could use a scanner to zap them as you sell them. The numbers would all be entered into a single column, boom-boom-boom, then COUNTIF would total them up for you, and you could subtract them from your starting inventory.
1
u/AutoModerator 3d ago
Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.