[Resolved] 1 item in 2 carts... help please

[statusquo]

I am looking at shopping carts for download and had a general question regarding them.

We deal in collectible lp's and 45's and in many cases we only have one in stock of any given item.

What happens if two people add the one item to the cart and check out at the same time?

Is there a way to avoid this?

Thanks in advance.

[LordShryku]

Well, if it's a database driven cart, you could add a column to your inventory table to "lock" the item when it is first chosen....

[statusquo]

Ahhhhh.... you mean if someone adds the item to a cart, I could update the item so it is locked from being added to other carts....and even update it again, if the buyer decides not to buy, so it would be unlocked?

[LordShryku]

That would be my suggestion.....

[statusquo]

Excellent idea....

Thank you so much.

[LordShryku]

yarr 😉