Item - QuickBooks Online Data Target Requirement

DataBlend supports the standard API calls to Create and Update Item within QuickBooks leveraging the QuickBooks Online SDK. In addition, Custom Fields can be added for data that is unique to your business practices.

DataBlend Query Name Example	QuickBooks Online API	Required	Notes
Art Supplies	Name	Yes	String. Name of the item. This value must be unique, at least one character in length, and cannot include tabs, new lines, or colons. Required for create.
10	QtyOnHand	Yes	Decimal. Current quantity of the Inventory items available for sale. Not used for Service or NonInventory type items.Required for Inventory type items.
1	IncomeAccountRef	Yes
Inventory	Type	Yes	For requests with minor versions earlier than 4 specified, this field is read-only and system-defined as follows: Inventory--Default setting when TrackQtyOnHand, InvStartDate, and AssetAccountRef are specified. Used for goods the company sells and buys that are tracked as inventory.
81	AssetAccountRef	Yes
2015-01-01	InvStartDate	Yes
80	ExpenseAccountRef	Yes

To learn more about QuickBooks Online API information, please visit https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/item.