Subtract product from inventory on checkout

Hi,

I am using ecart 4.x, coding with .asp.

I have in the product table a column with the max number of items that I start with.
I have a column that would display the current number of that item on hand.

So on the product detail page I could show currently in stock the number of items.

How would I get the cart to subtract the items in the order from the product table and update the current stock level?

It seems there was a thread about this that I had bookmarked from the old forums, but that link is bad now.

thx!
Eric

You would need to hand code this on the confirm page. After the eCart checkout code, add a loop through the cart items with an update record behavior inside it to update each purchased item based on the product ID in the cart and the Quantity in the cart.

It should not be too difficult to program this if you are comfortable with ASP programing.

Could I use the DataAssist Multiple update for this?

I would need to write a SQL command to subtract the qty number from the inventory number, is that correct?

sorry for two questions, thanks!

no, you wont be able to use data assist for this, you will need to hand code the update statements.

Yes, the update code will update the quantity column and subtract the purchased quantity.

okay, not that good at asp.

what if it is in php?

thx
Eric

it's the same in PHP as in ASP, you will still need to hand code the logic to loop through the cart and perform the update to the quantity column.

Thanks Jason. I think I have the idea.

I can take the recordset that the cart already uses:

<%' WA eCart Store Cart Details in Db
if (Request.ServerVariables("Request_Method") = "POST") then
WA_connection = MM_connBBT_STRING
WA_table = "dbo.OrderDetails"
WA_redirectURL = ""
WA_indexField = "DetailOrderID"
WA_fieldNamesStr = "regID|DetailDate|DetailOrderID|DetailItemID|DTitle|Description|Quantity|Day|Time|AttendeeName|Preg|PregTerm|GolfClubs|TennisRac|InventoryORD" .......

And copy that, edit the SQL to subtract the Quanity from the inventory
then loop that recordset with an update behavior in there.

Would I still use the if (Request.ServerVariables("Request_Method") = "POST") then
to have the update post when the submit order button is pressed?

thx
Eric

Yes, you would still want to use the POST request method as the trigger for the update.

The code you are highlighting is not what you should be using


you really need to create the code by hand to do this.

okay.

Not sure how to get the cart contents recordset on that page.

Here is the confirm.asp page currently in place.

We had a setup where that went to the success page and this captured the session and ran thru a multiple update to post the new inventory number.

However that code is not correct on the success page so it does not post the incremental numbers.

thx
eric

Jason - sorry for the slow uptake. Tell me if this is correct:

The update method will be updating each record individually in the loop as opposed to a multi record update where it updates multiple records at once.

Correct?

thx
Eric