Hi everyone; I use different parts from different vendors to create new products that I then offer for sale online. I do not need to track sales, payments, or customers in my database. I do need to track an inventory of parts that are used to make products AND I need to track the product from listing to sold. I currently do this on a spreadsheet which has three primary tabs, data links between the tabs (for drop down selections) and several calculated fields (both logical and numerical)
I’ve tried to adapt my current spreadsheet to AirTable with little happiness. I think I need to start from scratch. I’d like to hear how you think the table designs should be approached. Here’s an example of my work flow:
I buy a number of category1 parts from category1 vendors.
I buy a number of category2 parts from category2 vendors.
I use 1 part from each category to create a new product.
A unique SKU is created by formula, CAT1-CAT2-RAND#
The per item cost of each part is summed to create a new PRODCOST field for the item.
I list that product for sale and mark it as listed.
When it sells I mark it as sold.
The two categories of parts have separate characteristics, naming, and descriptors, and very little duplication of data, so I’ve kept them separate in my current system. I suppose they could be combined, but it just means that a lot of fields in a data row get left blank. I need for the count of parts in each category to reflect current availability, a live inventory, if you will. So, I need it to be reduced by 1 or more whenever I use parts to create a new product.
This seems to pretty straightforward DB stuff. In an SQL database, I think I know how I’d set it up, but I’ll be damned if I can make sense of how to do it in Airtable. Any help will be appreciated.