Reducing Quantities as Items ordered?

pdate:
>
> UPDATE items
> SET stock = stock - qtysold
> WHERE item = itemfromcart
>
> You could also do this when the items have shipped, which would avoid
> any problems.
>
> Dooza
Thanks

Art wrote:
> I had a request from a client to have the cart reduce the total quantity
> available when a product is sold. So if I have a total of 5 items
> available and the customer buys 2, the total would be 3 left over after
>
> I suspect that this is done with Store Procedures.
>
> I've been doing this stuff for a while but with new things, I have a
> hard time getting my head around it; could you explain with that in
> mind? Thanks
>
> Also, do you have code that would demonstrate how this is done?
>
> Thanks

Hmm, yes, a stored procedure would work, I think.

What your doing needs to be looped. You take your response from your
payment gateway which says the money has been taken, then loop through
the cart, adjusting the stock levels accordingly. Your just doing an update:

UPDATE items
SET stock = stock - qtysold
WHERE item = itemfromcart

You could also do this when the items have shipped, which would avoid
any problems.

Dooza
--
Posting Guidelines
http://www.adobe.com/support/forums/guidelines.html
How To Ask Smart Questions
http://www.catb.org/esr/faqs/smart-questions.html