Help us test the new Databridge BETA with MySQLi support

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › Product Batch Price updating Cart

View all replies to this thread

Product Batch Price updating Cart

Thread began 4/06/2016 11:05 pm by Kumel | Last modified 4/07/2016 9:00 pm by Kumel | 640 views | 33 replies

4/07/2016 4:14 pmKumel

Yes it is unique.
Attached ecart screenshots.

My current sql:

SELECT Quantity - (SELECT Coalesce(SUM(DetailQuantity),0) FROM orders Inner Join orderdetails ON orderdetails.DetailOrderID = orders.OrderID WHERE OrderDate > ProductUpdateDate AND DetailProductID = Products.ID) AS RemainingInventory FROM products INNER JOIN ProductBatch on products.ID = ProductBatch.ProductID WHERE ProductBatch.ProductID = %s

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.