>From a purely model perspective you should be able to create a >OrderItemShpGrpInvRes record for each serialized inventory item.
The code side of things in OFBiz might do some funny things, especially with re-reservation of inventory (so that re-reserve code may need to be modified to not touch these records), and you'd have to write a reservation service for this case to use instead of the stock reservation, but beyond that I think everything should work the same with the standard reservation records and such. -David On Apr 7, 2011, at 10:11 AM, Ean Schuessler wrote: > 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 >
