How To Delete Item From Quickbooks Online Using C#

In this article, we will learn how to delete an item from 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.

We can not delete the item permanently from Quickbooks online, we can only inactive it.

So, if we want to delete an item then we have to inactive it by updating.

We are going to delete the item by its “Name”.

The following are a few steps for the delete(inactive) item.

  • First, we have to create a ServiceContext with Auth tokens and realmId.
  • For that, we need access token and realmId
  • We have to get an item from Quickbooks online by calling Item API.
  • We are querying an item by “Name”.
  • For querying/get an item we have to define QueryService
  • We need to pass a ServiceContext object into QueryService.
  • We will get an item object by querying from Quickbooks online using QueryService.
  • After getting an item object we will change its Active property to false.
  • 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 update(delete/inactive) item and 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 DeleteItemByName()
{
  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;

    string EXISTING_ITEM_QUERYBYNAME = string.Format("select * from Item where Name = '{0}'", "Vision Keyboard Mouse Set");

    var queryService = new QueryService<Item>(serviceContext);
    Item ObjItemFound = queryService.ExecuteIdsQuery(EXISTING_ITEM_QUERYBYNAME).FirstOrDefault<Item>();
    
    //If Item found on Quickbooks online
    if (ObjItemFound != null)
    {
        //if Item is active
        if (ObjItemFound.Active == true)
        {
            ObjItemFound.Active = false;
            DataService dataService = new DataService(serviceContext);

            Item UpdateEntity = dataService.Update<Item>(ObjItemFound);
            if (UpdateEntity != null && !string.IsNullOrEmpty(UpdateEntity.Id))
            {
                //you can write Database code here
                ViewBag.IsSuccess = true;
            }
        }
        else
        {
            ViewBag.IsSuccess = true;
        }
    }
    return View();
  }
  catch (IdsException ex)
  {
    return View();
  }
  catch (Exception ex)
  {
    return View();
  }
}

In Quickbooks online, We can find deleted items in the Sales > Products and Services by enabling include inactive from the filter.

 

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe

Select Categories