How To Update Item In Quickbooks Online Using C#

In this article, we will learn how to update an item in Quickbooks online from .NET MVC web application using SDK.

Before using any Quickbooks online API we need access token, if you don’t know how to get access token then you can find it here.

• First, we have to create a ServiceContext with Auth tokens and realmId.
• For that, we need access token and realmId
• We have to get the item from Quickbooks online by calling Item API.
• We are querying an item by Name and Type.
• For querying/get item we have to define QueryService
• We need to pass the ServiceContext object into QueryService.
• We must need item Id and SyncToken for an update.
• We will create an item object and pass all data with updated data along with Id and SyncToken.
• After that, We have to create a DataService object by passing a ServiceContext object as a parameter.
• Add item object in DataService.Update<item>() for updating an item.
• It will return the newly updated item object, you can store the required details to the database according to your needs.
• The code is as below.

public ActionResult UpdateItem()
{
  List<Item> ItemList = new List<Item>();
  try
  {
    OAuth2RequestValidator oauthValidator = new OAuth2RequestValidator(Access_token);
    // Create a ServiceContext with Auth tokens and realmId
    ServiceContext serviceContext = new ServiceContext(RealmId, IntuitServicesType.QBO, oauthValidator);
    serviceContext.IppConfiguration.MinorVersion.Qbo = "23";
    serviceContext.IppConfiguration.BaseUrl.Qbo = QboBaseUrl;

    // Create a QuickBooks QueryService using ServiceContext
    QueryService<Item> querySvc = new QueryService<Item>(serviceContext);

    string EXISTING_ITEM_QUERYBYNAME = string.Format("select * from Item where Name = '{0}' and Type = '{1}'", "Vision Keyboard", "Inventory");
    Item objItemFound = querySvc.ExecuteIdsQuery(EXISTING_ITEM_QUERYBYNAME).FirstOrDefault<Item>();

    if (objItemFound != null)
    {

        Item ObjItem = new Item();

        ObjItem.Id = objItemFound.Id;
        ObjItem.SyncToken = objItemFound.SyncToken;

        ObjItem.Name = "Vision Keyboard Mouse Set";

        ObjItem.TypeSpecified = objItemFound.TypeSpecified;
        ObjItem.Type = objItemFound.Type;

        ObjItem.TrackQtyOnHand = objItemFound.TrackQtyOnHand;
        ObjItem.TrackQtyOnHandSpecified = objItemFound.TrackQtyOnHandSpecified;
        ObjItem.QtyOnHandSpecified = objItemFound.QtyOnHandSpecified;
        ObjItem.QtyOnHand = objItemFound.QtyOnHand;

        ObjItem.InvStartDateSpecified = objItemFound.InvStartDateSpecified;
        ObjItem.InvStartDate = objItemFound.InvStartDate;

        ObjItem.Description = "This Keyboard Mouse Set is made by vision infotech";
        ObjItem.UnitPriceSpecified = objItemFound.UnitPriceSpecified;
        ObjItem.UnitPrice = objItemFound.UnitPrice;

        ObjItem.PurchaseDesc = "This Keyboard Mouse Set is purchase from Vision infotech";
        ObjItem.PurchaseCostSpecified = objItemFound.PurchaseCostSpecified;
        ObjItem.PurchaseCost = objItemFound.PurchaseCost;

        ObjItem.AssetAccountRef = objItemFound.AssetAccountRef;
        ObjItem.IncomeAccountRef = objItemFound.IncomeAccountRef;
        ObjItem.ExpenseAccountRef = objItemFound.ExpenseAccountRef;

        DataService dataService = new DataService(serviceContext);

        Item UpdateEntity = dataService.Update<Item>(ObjItem);
        if (UpdateEntity != null && !string.IsNullOrEmpty(UpdateEntity.Id))
        {
            //you can write Database code here
            ViewBag.IsSuccess = true;
        }

    }

    return View();
  }
  catch (IdsException ex)
  {
    return View();
  }
  catch (Exception ex)
  {
    return View();
  }
}

• If there is an item which name is “Vision Keyboard” and Type is “Inventory” in Quickbooks online then its Name, Description, PurchaseDesc will be updated.