I am an online reseller (eBay, Amazon, Poshmark etc), and I use AirTable to track inventory, sales and some expenses. The way I have it set up, when I enter a sale of an item, it pulls that item out of current inventory, so I’m able to accurately determine my COG at any time. It’s probably rudimentary compared to what most of y’all work with, but IMO pretty good for a novice, hah. My issue is two-fold: When I enter a sale, I’ve never figured out how to make it multi-quantity if needed; and, due to that issue, I haven’t figured out how to enter returns on the sales table - because I can’t enter a negative quantity. And due to those two issues, my inventory is off. Hope that makes sense.
