object WarehouseProduct

Fields

FieldTypeDescription
idString
legacy_idInt
account_idString
skuString

Stock Keeping Unit

warehouse_idString
warehouse_identifierString

The warehouse identifier, usually Primary/Secondary

priceString

Price of the product

valueString

Price paid for the product

value_currencyString
on_handInt

The total count of a SKU physically in the warehouse. (Note, Available is the count indicated in your sales channels)

inventory_binString

The name of the bin where the product is stored

inventory_overstock_binString

The name of the bin where overstock is stored

reserve_inventoryInt

Count of a SKU that is not to be sold in your sales channel.For example, if you’re running a flash sale and want to hold some stock for returns or exchanges, you would enter your full inventory of say 100 units as the On Hand and a Reserve of 5 units. We’ll then tell the platform that you have 95 available for sale (On Hand minus Reserve). The Available count will remain 100

replenishment_levelInt

Available only for accounts that use Dynamic Slotting and used specifically for replenishment reports. SKUs will appear on the replenishment report if inventory allocated and not enough in pickable bins, or if the pickable bin inventory is less than the replenishment level

replenishment_max_levelInt

The maximum inventory level in the pickable bin. Replenishment quantities are capped so that stock in the pickable bin does not exceed this value

replenishment_incrementInt

The increment used when replenishing inventory. The replenishment quantity is rounded up to the nearest multiple of this value

reorder_amountInt

The number that should be reordered when a SKU reaches the Reorder Level

reorder_levelInt

The Available value a SKU must reach to trigger a Reorder. (See Reorder Amount). Setting this to 0 will prevent a SKU from automatically being added to a PO

backorderInt

Count of how many units you owe to customers for open orders and don’t have stock for in the warehouse

allocatedInt

Count of how many units you have in stock and owe to customers for open orders

availableInt

The number of available stock for any given SKU that is pushed to any connected sales channel. This is On Hand minus any allocations to open orders.

non_sellable_quantityInt

Count of non sellable units of a SKU in the warehouse.

in_toteInt

Total number of units picked in totes

customBoolean
customs_valueString
created_atISODateTime
updated_atISODateTime
sell_aheadInt
activeBoolean
warehouseWarehouse
productProduct
inboundsWarehouseProductInboundConnection
ArgumentTypeRequiredDefaultDescription
statusStringNo
created_fromISODateTimeNo
created_toISODateTimeNo
sortStringNo
beforeStringNo
afterStringNo
firstIntNo
lastIntNo
locationsItemLocationConnection
ArgumentTypeRequiredDefaultDescription
customer_account_idStringNo
sortStringNo
beforeStringNo
afterStringNo
firstIntNo
lastIntNo

Referenced By

Example

{
  "id": "abc123",
  "legacy_id": 987,
  "account_id": "abc123",
  "sku": "abc123",
  "warehouse_id": "abc123",
  "warehouse_identifier": "abc123",
  "price": "abc123",
  "value": "abc123",
  "value_currency": "abc123",
  "on_hand": 987,
  "inventory_bin": "abc123",
  "inventory_overstock_bin": "abc123",
  "reserve_inventory": 987,
  "replenishment_level": 987,
  "replenishment_max_level": 987,
  "replenishment_increment": 987,
  "reorder_amount": 987,
  "reorder_level": 987,
  "backorder": 987,
  "allocated": 987,
  "available": 987,
  "non_sellable_quantity": 987,
  "in_tote": 987,
  "custom": true,
  "customs_value": "abc123",
  "created_at": "abc123",
  "updated_at": "abc123",
  "sell_ahead": 987,
  "active": true,
  "warehouse": Warehouse,
  "product": Product,
  "inbounds": WarehouseProductInboundConnection,
  "locations": ItemLocationConnection
}