Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Inventory Base - add quantity for each item in one order?

Topic Labels: Base design
367 3
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m sorry, I’m a little new to this. I have built an inventory base to keep track of inventory or orders, i used a template from the Airtable universe.

In the Incoming table there is a list of the orders (orders from me to the head office, and customer orders), I’m not sure how to create a way to specify the quantity of each item.

Any idea and the best way to do this?

3 Replies 3

You need another “line item” table to show how many of each item was logged. Keep your Incoming table as is except instead of linking directly to products, you’d link to line item records which would have the product and the quantity stored.

Follow this example of of a base that includes a line items table.

I’ll take a look and try to figure it out. Thanks.

We just released an E-commerce base template with line items and many other things. It’s free to download if you want to check it out.