You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Ean Schuessler <ea...@brainfood.com> on 2011/03/24 23:55:47 UTC
Serialized inventory and the ShoppingCart
I may be missing something but it looks like you cannot shop an order
for a piece of serialized inventory as part of your shopping cart
process. Am I wrong about that? If you have a user walk up with, say, a
hard drive or something else with a serial number on it how do you
represent that in the cart? Obviously the order doesn't exist yet, but I
know that no one else can reserve that inventory (for real) since the
user is holding it in their hand.
Any thoughts on this one?
--
Ean Schuessler, CTO
ean@brainfood.com
214-720-0700 x 315
Brainfood, Inc.
http://www.brainfood.com
Re: Serialized inventory and the ShoppingCart
Posted by David E Jones <de...@me.com>.
On Apr 7, 2011, at 6:10 PM, Ean Schuessler wrote:
> That makes sense. So I don't need to touch the OrderItem structure, just
> create reservations at the same time that I create the order.
>
> Adding an array of serial numbers to ShoppingCartItem seems necessary
> though. Do you agree?
Yes, that makes sense. That would be the data that feeds into the new/alternative inventory reservation service.
-David
> On 04/07/11 11:19, David E Jones wrote:
>> 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.
>>
> --
> Ean Schuessler, CTO
> ean@brainfood.com
> 214-720-0700 x 315
> Brainfood, Inc.
> http://www.brainfood.com
>
> <ean.vcf>
Re: Serialized inventory and the ShoppingCart
Posted by Ean Schuessler <ea...@brainfood.com>.
That makes sense. So I don't need to touch the OrderItem structure, just
create reservations at the same time that I create the order.
Adding an array of serial numbers to ShoppingCartItem seems necessary
though. Do you agree?
On 04/07/11 11:19, David E Jones wrote:
> 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.
>
--
Ean Schuessler, CTO
ean@brainfood.com
214-720-0700 x 315
Brainfood, Inc.
http://www.brainfood.com
Re: Serialized inventory and the ShoppingCart
Posted by David E Jones <de...@me.com>.
>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
> ean@brainfood.com
> 214-720-0700 x 315
> Brainfood, Inc.
> http://www.brainfood.com
>
Re: Serialized inventory and the ShoppingCart
Posted by Ean Schuessler <ea...@brainfood.com>.
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
ean@brainfood.com
214-720-0700 x 315
Brainfood, Inc.
http://www.brainfood.com
Re: Serialized inventory and the ShoppingCart
Posted by Ruth Hoffman <rh...@aesolves.com>.
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?
TIA
Ruth
On 3/25/11 10:11 AM, Jacopo Cappellato wrote:
> Yeah, this is not supported ootb because reservations happens when the order is created, not when the items are added to the cart.
> What you described could be handled, with some small changes, creating an order and then immediately reassigning reservations by specifying the exact inventory item.
>
> Kind regards,
>
> Jacopo
>
> On Mar 24, 2011, at 11:55 PM, Ean Schuessler wrote:
>
>> I may be missing something but it looks like you cannot shop an order
>> for a piece of serialized inventory as part of your shopping cart
>> process. Am I wrong about that? If you have a user walk up with, say, a
>> hard drive or something else with a serial number on it how do you
>> represent that in the cart? Obviously the order doesn't exist yet, but I
>> know that no one else can reserve that inventory (for real) since the
>> user is holding it in their hand.
>>
>> Any thoughts on this one?
>>
>> --
>> Ean Schuessler, CTO
>> ean@brainfood.com
>> 214-720-0700 x 315
>> Brainfood, Inc.
>> http://www.brainfood.com
>>
>
Re: Serialized inventory and the ShoppingCart
Posted by Jacopo Cappellato <ja...@hotwaxmedia.com>.
Yeah, this is not supported ootb because reservations happens when the order is created, not when the items are added to the cart.
What you described could be handled, with some small changes, creating an order and then immediately reassigning reservations by specifying the exact inventory item.
Kind regards,
Jacopo
On Mar 24, 2011, at 11:55 PM, Ean Schuessler wrote:
> I may be missing something but it looks like you cannot shop an order
> for a piece of serialized inventory as part of your shopping cart
> process. Am I wrong about that? If you have a user walk up with, say, a
> hard drive or something else with a serial number on it how do you
> represent that in the cart? Obviously the order doesn't exist yet, but I
> know that no one else can reserve that inventory (for real) since the
> user is holding it in their hand.
>
> Any thoughts on this one?
>
> --
> Ean Schuessler, CTO
> ean@brainfood.com
> 214-720-0700 x 315
> Brainfood, Inc.
> http://www.brainfood.com
>