Re: Inventory model design

Hi, I will try to give my shot at this. I would create one 'Item' model which have common fields like description, product category etc. For quantities I would create a system of units and unit conversion tables for each item using one model called 'Unit' and one called 'ItemUnit' or similar. Unit

Inventory model design

Hi, I wanted to design a system that would keep inventory data for items. The items themselves are different enough, that they don't conform to a simple model. E.g., the products are for a bakery company. The company keeps inventory of solid items, liquid items, and items that are used in partial