stock inventory system

Hi Dharmendra,

You can update inventory as below after sell happen.

Call below method for each item of cart after sells completion means from thank you page.

public void UpdateInventory(string skuID, int count)
{
   //use below query to update inventory table
   string query = "UPDATE inventory SET itemCount = (itemCount - " + count.ToString() + ") WHERE skuID = '" + skuID + "'";
  //write more code to execute this query
}

For updation of inventory when item is added to the system use below method.

public void RefreshInventory(Product product)
{
  //Write your code to update the invenroty
}

Hope this will help you.

For more specific answer you need to post code snippet as well, which you have tried.