Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › adjusting inventory

adjusting inventory

Thread began 5/29/2019 3:21 pm by paulshoe379536 | Last modified 5/31/2019 11:31 am by paulshoe379536 | 335 views | 2 replies

5/30/2019 5:51 pmRay BorduinWebAssist

I think the easiest option would be to use the Server Behavior:

Webassist->MySQLi->Data Management->MySQLi Execute Query

Then you could use a query like:

UPDATE products SET ProductQtyStock = ProductQtyStock - param1 WHERE ProductID = param2

Bind the two params to the eCart columns and cut and paste the resulting code into your while loop.

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.