When an item is tracked with serialized inventory a separate InventoryItem is created for each physical piece of inventory. The internal unique ID for OFBiz is InventoryItem.inventoryItemId. The InventoryItem.serialNumber field is not populated by default and seems to be intended for the manufacturer's serial number.
In my situation, customers can select serialized inventory off the shelf and bring it to the counter for check-out. When the system checks out the item I must ensure that the specific item selected by the user is reserved against their order and not some other random item. This kind of scenario is common for all sorts of products. My proposed solution is to add an inventoryItemId field to ShoppingCartItem and OrderItem and then have the inventory reservation code use those values when the order is approved. This has some problems for quantity > 1 but seems like the easiest modification. I will created multiple order items to handle that situation. Another complicated issue would be a situation where the same store is handling web sales and physical sales off the floor. You would have corner cases where the web sales system is trying to reserve inventory that could be picked up by customers. Luckily I don't have that problem with my current customer. On 03/25/11 09:28, Ruth Hoffman wrote: > Hi Ean, Jacopo: > > Please forgive if this is obvious, but I don't understand why this is > a desired behavior. Under what circumstances would you need to > represent the inventoryItemId (as serialized inventory) in the > shopping cart? > > From my reading of the data model, the inventoryItemId (for serialized > inventory) is not the same as a serial number associated with a > product. Again, my understanding: Serialized inventory is used to > track each individual piece of inventory not to uniquely identify a > product. Maybe I've got it all wrong? Am I missing something? -- Ean Schuessler, CTO e...@brainfood.com 214-720-0700 x 315 Brainfood, Inc. http://www.brainfood.com
