We run a business selling second hand goods so have a large number of different products and once they are gone, that is it so we have a very large number of product codes that are unused.
Also we have a very large number of products.
What I would like to do is add new fields to the Check In that would then be copied into the inventory. These include things like price, location, manufacturer, dimensions, type of product, etc.
What I would then like to be able to do is from the Inventory sheet is be able to filter these so I could see items from the same manufacturer for instance.
Obviously I would like to hide the items with zero stock as some of these could be well out of date but this would be able to be covered by a filter, I think.
Adding extra columns does not look too tough but I am not sure how the filter would work. We are on GSuite.