ItemInventory · Query
simulated in sandboxItemInventoryQuery
Inventory items are stock QuickBooks tracks with quantity on hand and average cost. They need an income, a COGS and an asset account.
qbXML request
<?xml version="1.0" encoding="utf-8"?>
<?qbxml version="13.0"?>
<QBXML>
<QBXMLMsgsRq onError="stopOnError">
<ItemInventoryQueryRq requestID="1">
<MaxReturned>10</MaxReturned>
<ActiveStatus>ActiveOnly</ActiveStatus>
<FromModifiedDate>2026-10-01T00:00:00</FromModifiedDate>
</ItemInventoryQueryRq>
</QBXMLMsgsRq>
</QBXML>JSON equivalent
GET /v1/items?limit=10&updatedAfter=2026-10-01&type=inventorycurl "https://ledgerwire.vibiz.app/v1/items?limit=10&updatedAfter=2026-10-01&type=inventory" \
-H "Authorization: Bearer $LEDGERWIRE_KEY"qbXML response (from the sandbox seed data)
<?xml version="1.0" ?>
<QBXML>
<QBXMLMsgsRs>
<ItemInventoryQueryRs requestID="1" statusCode="0" statusSeverity="Info" statusMessage="Status OK">
<ItemInventoryRet>
<ListID>8000002D-1794871862</ListID>
<TimeCreated>2026-02-04T23:59:57+00:00</TimeCreated>
<TimeModified>2026-02-04T23:59:57+00:00</TimeModified>
<EditSequence>1770249597</EditSequence>
<Name>Copper Pipe 1/2in</Name>
<FullName>Copper Pipe 1/2in</FullName>
<IsActive>true</IsActive>
<Sublevel>0</Sublevel>
<QuantityOnHand>108</QuantityOnHand>
<AverageCost>18.20</AverageCost>
<AssetAccountRef>
<ListID>80000005-1760311862</ListID>
<FullName>Inventory Asset</FullName>
</AssetAccountRef>
<COGSAccountRef>
<ListID>8000000F-1760311862</ListID>
<FullName>Cost of Goods Sold</FullName>
</COGSAccountRef>
<IncomeAccountRef>
<ListID>8000000D-1760311862</ListID>
<FullName>Sales Income</FullName>
</IncomeAccountRef>
<PurchaseCost>18.20</PurchaseCost>
<PurchaseDesc>Copper pipe, 1/2 in x 10 ft</PurchaseDesc>
<ReorderPoint>2</ReorderPoint>
<SalesDesc>Copper pipe, 1/2 in x 10 ft</SalesDesc>
<SalesPrice>32.50</SalesPrice>
</ItemInventoryRet>
</ItemInventoryQueryRs>
</QBXMLMsgsRs>
</QBXML>FAQ
How do I page through ItemInventoryQuery results?
In qbXML, add iterator="Start" to ItemInventoryQueryRq with MaxReturned, then send iterator="Continue" with the iteratorID until iteratorRemainingCount is 0. With LedgerWire, GET /v1/items?limit=100 and follow nextCursor.
How do I fetch only items changed since my last sync?
Use FromModifiedDate inside ItemInventoryQueryRq, or updatedAfter=2026-10-01T00:00:00Z on the REST endpoint.
Why does ItemInventoryQuery return statusCode 1?
Status 1 is informational: "A query request did not find a matching object in QuickBooks". The request was valid and nothing matched the filters. LedgerWire returns an empty data array for it.
Sandbox fidelity
The LedgerWire sandbox simulates ItemInventoryQuery with QuickBooks rules: required fields, element names, refs that must exist (3140), unique names (3100), field lengths (3070) and EditSequence locking (3200). Tax calculation, custom fields and preferences are not simulated.
More ItemInventory messages
Skip the XML: call GET /v1/items with JSON.
Get a free sandbox key