item_locations

Arguments

Argument	Type	Required	Description
`warehouse_id`	`String`	No
`sku`	[`String`]	No
`customer_account_id`	`String`	No
`location_name`	[`String`]	No
`location_name_prefix`	`String`	No
`has_inventory`	`Boolean`	No
`location_type_id`	[`String`]	No
`pickable`	`Boolean`	No
`sellable`	`Boolean`	No
`created_from`	ISODateTime	No
`created_to`	ISODateTime	No
`updated_from`	ISODateTime	No
`updated_to`	ISODateTime	No
`analyze`	`Boolean`	No	If true, the query will only be analyzed (cost estimated) without executing it.

Return Type

ItemLocationsQueryResult

Query

query item_locations(
  $warehouse_id: String,
  $sku: [String],
  $customer_account_id: String,
  $location_name: [String],
  $location_name_prefix: String,
  $has_inventory: Boolean,
  $location_type_id: [String],
  $pickable: Boolean,
  $sellable: Boolean,
  $created_from: ISODateTime,
  $created_to: ISODateTime,
  $updated_from: ISODateTime,
  $updated_to: ISODateTime,
  $analyze: Boolean
) {
  item_locations(
    warehouse_id: $warehouse_id,
    sku: $sku,
    customer_account_id: $customer_account_id,
    location_name: $location_name,
    location_name_prefix: $location_name_prefix,
    has_inventory: $has_inventory,
    location_type_id: $location_type_id,
    pickable: $pickable,
    sellable: $sellable,
    created_from: $created_from,
    created_to: $created_to,
    updated_from: $updated_from,
    updated_to: $updated_to,
    analyze: $analyze
  ) {
    request_id
    complexity
    data {
      ...ItemLocationConnectionFragment
    
      pageInfo {
        ...PageInfoFragment
      
        hasNextPage
        hasPreviousPage
        startCursor
        endCursor
      }
      edges {
        ...ItemLocationEdgeFragment
      
        node {
          ...ItemLocationFragment
        
          id
          legacy_id
          account_id
          warehouse_id
          location_id
          sku
          quantity
          created_at
          updated_at
          location {
            ...LocationFragment
          
            id
            legacy_id
            account_id
            warehouse_id
            type {
              ...LocationTypeFragment
            
              id
              legacy_id
              account_id
              name
              daily_storage_cost
              category
              is_lpn_allowed
            }
            name
            zone
            pickable
            sellable
            staging
            is_cart
            pick_priority
            dimensions {
              ...DimensionsFragment
            
              weight
              height
              width
              length
            }
            length
            width
            height
            max_weight
            temperature
            products {
              ...ProductConnectionFragment
            
              pageInfo {
                ...PageInfoFragment
              
                hasNextPage
                hasPreviousPage
                startCursor
                endCursor
              }
              edges {
                ...ProductEdgeFragment
              
                node {
                  ...ProductFragment
                
                  id
                  legacy_id
                  account_id
                  name
                  sku
                  price
                  value
                  value_currency
                  barcode
                  country_of_manufacture
                  dimensions {
                    ...DimensionsFragment
                  
                    weight
                    height
                    width
                    length
                  }
                  tariff_code
                  kit
                  kit_build
                  no_air
                  final_sale
                  customs_value
                  customs_description
                  not_owned
                  dropship
                  needs_serial_number
                  thumbnail
                  large_thumbnail
                  created_at
                  updated_at
                  product_note
                  virtual
                  ignore_on_invoice
                  ignore_on_customs
                  active
                  needs_lot_tracking
                  is_assembly
                  packer_note
                  size
                  style
                  vendor_part_number
                  consumer_package_code
                  buyer_part_number
                  buyer_style_number
                  auto_pack
                  warehouse_products {
                    ...WarehouseProductFragment
                  
                    id
                    legacy_id
                    account_id
                    sku
                    warehouse_id
                    warehouse_identifier
                    price
                    value
                    value_currency
                    on_hand
                    inventory_bin
                    inventory_overstock_bin
                    reserve_inventory
                    replenishment_level
                    replenishment_max_level
                    replenishment_increment
                    reorder_amount
                    reorder_level
                    backorder
                    allocated
                    available
                    non_sellable_quantity
                    in_tote
                    custom
                    customs_value
                    created_at
                    updated_at
                    sell_ahead
                    active
                    warehouse {
                      ...WarehouseFragment
                    }
                    product {
                      ...ProductFragment
                    }
                    inbounds {
                      ...WarehouseProductInboundConnectionFragment
                    }
                    locations {
                      ...ItemLocationConnectionFragment
                    }
                  }
                  fba_inventory {
                    ...FbaInventoryFragment
                  
                    id
                    legacy_id
                    quantity
                    marketplace_id
                    merchant_id
                  }
                  images {
                    ...ProductImageFragment
                  
                    src
                    position
                  }
                  tags
                  vendors {
                    ...ProductVendorFragment
                  
                    vendor_id
                    vendor_sku
                    price
                  }
                  components {
                    ...ProductFragment
                  }
                  kit_components {
                    ...KitComponentFragment
                  
                    id
                    legacy_id
                    account_id
                    sku
                    quantity
                  }
                  assembly_components {
                    ...AssemblyComponentFragment
                  
                    id
                    legacy_id
                    account_id
                    sku
                    quantity
                  }
                  cases {
                    ...CaseFragment
                  
                    id
                    legacy_id
                    case_barcode
                    case_quantity
                  }
                }
                cursor
              }
            }
            last_counted
            created_at
            expiration_lots {
              ...LotConnectionFragment
            
              pageInfo {
                ...PageInfoFragment
              
                hasNextPage
                hasPreviousPage
                startCursor
                endCursor
              }
              edges {
                ...LotEdgeFragment
              
                node {
                  ...LotFragment
                
                  id
                  legacy_id
                  account_id
                  po_id
                  name
                  sku
                  created_at
                  updated_at
                  expires_at
                  received_at
                  is_active
                  locations {
                    ...LocationConnectionFragment
                  
                    pageInfo {
                      ...PageInfoFragment
                    }
                    edges {
                      ...LocationEdgeFragment
                    }
                  }
                  purchase_orders {
                    ...PurchaseOrderConnectionFragment
                  
                    pageInfo {
                      ...PageInfoFragment
                    }
                    edges {
                      ...PurchaseOrderEdgeFragment
                    }
                  }
                }
                cursor
              }
            }
          }
          location_type {
            ...LocationTypeFragment
          
            id
            legacy_id
            account_id
            name
            daily_storage_cost
            category
            is_lpn_allowed
          }
          expiration_lot {
            ...LotFragment
          
            id
            legacy_id
            account_id
            po_id
            name
            sku
            created_at
            updated_at
            expires_at
            received_at
            is_active
            locations {
              ...LocationConnectionFragment
            
              pageInfo {
                ...PageInfoFragment
              
                hasNextPage
                hasPreviousPage
                startCursor
                endCursor
              }
              edges {
                ...LocationEdgeFragment
              
                node {
                  ...LocationFragment
                
                  id
                  legacy_id
                  account_id
                  warehouse_id
                  type {
                    ...LocationTypeFragment
                  
                    id
                    legacy_id
                    account_id
                    name
                    daily_storage_cost
                    category
                    is_lpn_allowed
                  }
                  name
                  zone
                  pickable
                  sellable
                  staging
                  is_cart
                  pick_priority
                  dimensions {
                    ...DimensionsFragment
                  
                    weight
                    height
                    width
                    length
                  }
                  length
                  width
                  height
                  max_weight
                  temperature
                  products {
                    ...ProductConnectionFragment
                  
                    pageInfo {
                      ...PageInfoFragment
                    }
                    edges {
                      ...ProductEdgeFragment
                    }
                  }
                  last_counted
                  created_at
                  expiration_lots {
                    ...LotConnectionFragment
                  
                    pageInfo {
                      ...PageInfoFragment
                    }
                    edges {
                      ...LotEdgeFragment
                    }
                  }
                }
                cursor
              }
            }
            purchase_orders {
              ...PurchaseOrderConnectionFragment
            
              pageInfo {
                ...PageInfoFragment
              
                hasNextPage
                hasPreviousPage
                startCursor
                endCursor
              }
              edges {
                ...PurchaseOrderEdgeFragment
              
                node {
                  ...PurchaseOrderFragment
                
                  id
                  legacy_id
                  po_number
                  account_id
                  warehouse_id
                  vendor_id
                  created_at
                  po_date
                  date_closed
                  arrived_at
                  packing_note
                  fulfillment_status
                  po_note
                  description
                  partner_order_number
                  subtotal
                  discount
                  total_price
                  tax
                  shipping_method
                  shipping_carrier
                  shipping_name
                  shipping_price
                  tracking_number
                  pdf
                  images
                  payment_method
                  payment_due_by
                  payment_note
                  locking
                  locked_by_user_id
                  line_items {
                    ...PurchaseOrderLineItemConnectionFragment
                  
                    pageInfo {
                      ...PageInfoFragment
                    }
                    edges {
                      ...PurchaseOrderLineItemEdgeFragment
                    }
                  }
                  attachments {
                    ...PurchaseOrderAttachmentConnectionFragment
                  
                    pageInfo {
                      ...PageInfoFragment
                    }
                    edges {
                      ...PurchaseOrderAttachmentEdgeFragment
                    }
                  }
                  vendor {
                    ...VendorFragment
                  
                    id
                    legacy_id
                    name
                    email
                    account_number
                    account_id
                    address {
                      ...AddressFragment
                    }
                    currency
                    internal_note
                    default_po_note
                    logo
                    partner_vendor_id
                    created_at
                  }
                  warehouse {
                    ...WarehouseFragment
                  
                    id
                    legacy_id
                    account_id
                    identifier
                    dynamic_slotting
                    invoice_email
                    phone_number
                    profile
                    address {
                      ...AddressFragment
                    }
                    return_address {
                      ...AddressFragment
                    }
                    company_name
                    company_alias
                    active
                    products {
                      ...ProductConnectionFragment
                    }
                  }
                  origin_of_shipment
                  tracking_numbers {
                    ...PurchaseOrderTrackingNumberConnectionFragment
                  
                    pageInfo {
                      ...PageInfoFragment
                    }
                    edges {
                      ...PurchaseOrderTrackingNumberEdgeFragment
                    }
                  }
                  ship_date
                }
                cursor
              }
            }
          }
          lpns {
            ...LicensePlateNumberConnectionFragment
          
            pageInfo {
              ...PageInfoFragment
            
              hasNextPage
              hasPreviousPage
              startCursor
              endCursor
            }
            edges {
              ...LicensePlateNumberEdgeFragment
            
              node {
                ...LicensePlateNumberFragment
              
                container_type
                status
                lpn_id
                sku
                units
              }
              cursor
            }
          }
          product {
            ...ProductFragment
          
            id
            legacy_id
            account_id
            name
            sku
            price
            value
            value_currency
            barcode
            country_of_manufacture
            dimensions {
              ...DimensionsFragment
            
              weight
              height
              width
              length
            }
            tariff_code
            kit
            kit_build
            no_air
            final_sale
            customs_value
            customs_description
            not_owned
            dropship
            needs_serial_number
            thumbnail
            large_thumbnail
            created_at
            updated_at
            product_note
            virtual
            ignore_on_invoice
            ignore_on_customs
            active
            needs_lot_tracking
            is_assembly
            packer_note
            size
            style
            vendor_part_number
            consumer_package_code
            buyer_part_number
            buyer_style_number
            auto_pack
            warehouse_products {
              ...WarehouseProductFragment
            
              id
              legacy_id
              account_id
              sku
              warehouse_id
              warehouse_identifier
              price
              value
              value_currency
              on_hand
              inventory_bin
              inventory_overstock_bin
              reserve_inventory
              replenishment_level
              replenishment_max_level
              replenishment_increment
              reorder_amount
              reorder_level
              backorder
              allocated
              available
              non_sellable_quantity
              in_tote
              custom
              customs_value
              created_at
              updated_at
              sell_ahead
              active
              warehouse {
                ...WarehouseFragment
              
                id
                legacy_id
                account_id
                identifier
                dynamic_slotting
                invoice_email
                phone_number
                profile
                address {
                  ...AddressFragment
                
                  name
                  address1
                  address2
                  city
                  state
                  country
                  zip
                  phone
                }
                return_address {
                  ...AddressFragment
                
                  name
                  address1
                  address2
                  city
                  state
                  country
                  zip
                  phone
                }
                company_name
                company_alias
                active
                products {
                  ...ProductConnectionFragment
                
                  pageInfo {
                    ...PageInfoFragment
                  
                    hasNextPage
                    hasPreviousPage
                    startCursor
                    endCursor
                  }
                  edges {
                    ...ProductEdgeFragment
                  
                    node {
                      ...ProductFragment
                    }
                    cursor
                  }
                }
              }
              product {
                ...ProductFragment
              }
              inbounds {
                ...WarehouseProductInboundConnectionFragment
              
                pageInfo {
                  ...PageInfoFragment
                
                  hasNextPage
                  hasPreviousPage
                  startCursor
                  endCursor
                }
                edges {
                  ...WarehouseProductInboundEdgeFragment
                
                  node {
                    ...WarehouseProductInboundFragment
                  
                    id
                    legacy_id
                    sku
                    warehouse_id
                    po_id
                    purchase_order_line_item_id
                    po_date
                    quantity
                    quantity_received
                    quantity_rejected
                    sell_ahead
                    status
                  }
                  cursor
                }
              }
              locations {
                ...ItemLocationConnectionFragment
              }
            }
            fba_inventory {
              ...FbaInventoryFragment
            
              id
              legacy_id
              quantity
              marketplace_id
              merchant_id
            }
            images {
              ...ProductImageFragment
            
              src
              position
            }
            tags
            vendors {
              ...ProductVendorFragment
            
              vendor_id
              vendor_sku
              price
            }
            components {
              ...ProductFragment
            }
            kit_components {
              ...KitComponentFragment
            
              id
              legacy_id
              account_id
              sku
              quantity
            }
            assembly_components {
              ...AssemblyComponentFragment
            
              id
              legacy_id
              account_id
              sku
              quantity
            }
            cases {
              ...CaseFragment
            
              id
              legacy_id
              case_barcode
              case_quantity
            }
          }
          warehouse_product {
            ...WarehouseProductFragment
          
            id
            legacy_id
            account_id
            sku
            warehouse_id
            warehouse_identifier
            price
            value
            value_currency
            on_hand
            inventory_bin
            inventory_overstock_bin
            reserve_inventory
            replenishment_level
            replenishment_max_level
            replenishment_increment
            reorder_amount
            reorder_level
            backorder
            allocated
            available
            non_sellable_quantity
            in_tote
            custom
            customs_value
            created_at
            updated_at
            sell_ahead
            active
            warehouse {
              ...WarehouseFragment
            
              id
              legacy_id
              account_id
              identifier
              dynamic_slotting
              invoice_email
              phone_number
              profile
              address {
                ...AddressFragment
              
                name
                address1
                address2
                city
                state
                country
                zip
                phone
              }
              return_address {
                ...AddressFragment
              
                name
                address1
                address2
                city
                state
                country
                zip
                phone
              }
              company_name
              company_alias
              active
              products {
                ...ProductConnectionFragment
              
                pageInfo {
                  ...PageInfoFragment
                
                  hasNextPage
                  hasPreviousPage
                  startCursor
                  endCursor
                }
                edges {
                  ...ProductEdgeFragment
                
                  node {
                    ...ProductFragment
                  
                    id
                    legacy_id
                    account_id
                    name
                    sku
                    price
                    value
                    value_currency
                    barcode
                    country_of_manufacture
                    dimensions {
                      ...DimensionsFragment
                    }
                    tariff_code
                    kit
                    kit_build
                    no_air
                    final_sale
                    customs_value
                    customs_description
                    not_owned
                    dropship
                    needs_serial_number
                    thumbnail
                    large_thumbnail
                    created_at
                    updated_at
                    product_note
                    virtual
                    ignore_on_invoice
                    ignore_on_customs
                    active
                    needs_lot_tracking
                    is_assembly
                    packer_note
                    size
                    style
                    vendor_part_number
                    consumer_package_code
                    buyer_part_number
                    buyer_style_number
                    auto_pack
                    warehouse_products {
                      ...WarehouseProductFragment
                    }
                    fba_inventory {
                      ...FbaInventoryFragment
                    }
                    images {
                      ...ProductImageFragment
                    }
                    tags
                    vendors {
                      ...ProductVendorFragment
                    }
                    components {
                      ...ProductFragment
                    }
                    kit_components {
                      ...KitComponentFragment
                    }
                    assembly_components {
                      ...AssemblyComponentFragment
                    }
                    cases {
                      ...CaseFragment
                    }
                  }
                  cursor
                }
              }
            }
            product {
              ...ProductFragment
            
              id
              legacy_id
              account_id
              name
              sku
              price
              value
              value_currency
              barcode
              country_of_manufacture
              dimensions {
                ...DimensionsFragment
              
                weight
                height
                width
                length
              }
              tariff_code
              kit
              kit_build
              no_air
              final_sale
              customs_value
              customs_description
              not_owned
              dropship
              needs_serial_number
              thumbnail
              large_thumbnail
              created_at
              updated_at
              product_note
              virtual
              ignore_on_invoice
              ignore_on_customs
              active
              needs_lot_tracking
              is_assembly
              packer_note
              size
              style
              vendor_part_number
              consumer_package_code
              buyer_part_number
              buyer_style_number
              auto_pack
              warehouse_products {
                ...WarehouseProductFragment
              }
              fba_inventory {
                ...FbaInventoryFragment
              
                id
                legacy_id
                quantity
                marketplace_id
                merchant_id
              }
              images {
                ...ProductImageFragment
              
                src
                position
              }
              tags
              vendors {
                ...ProductVendorFragment
              
                vendor_id
                vendor_sku
                price
              }
              components {
                ...ProductFragment
              }
              kit_components {
                ...KitComponentFragment
              
                id
                legacy_id
                account_id
                sku
                quantity
              }
              assembly_components {
                ...AssemblyComponentFragment
              
                id
                legacy_id
                account_id
                sku
                quantity
              }
              cases {
                ...CaseFragment
              
                id
                legacy_id
                case_barcode
                case_quantity
              }
            }
            inbounds {
              ...WarehouseProductInboundConnectionFragment
            
              pageInfo {
                ...PageInfoFragment
              
                hasNextPage
                hasPreviousPage
                startCursor
                endCursor
              }
              edges {
                ...WarehouseProductInboundEdgeFragment
              
                node {
                  ...WarehouseProductInboundFragment
                
                  id
                  legacy_id
                  sku
                  warehouse_id
                  po_id
                  purchase_order_line_item_id
                  po_date
                  quantity
                  quantity_received
                  quantity_rejected
                  sell_ahead
                  status
                }
                cursor
              }
            }
            locations {
              ...ItemLocationConnectionFragment
            }
          }
        }
        cursor
      }
    }
  }
}

Variables

{
  "warehouse_id": "abc123",
  "sku": ["abc123"],
  "customer_account_id": "abc123",
  "location_name": ["abc123"],
  "location_name_prefix": "abc123",
  "has_inventory": true,
  "location_type_id": ["abc123"],
  "pickable": true,
  "sellable": true,
  "created_from": ISODateTime,
  "created_to": ISODateTime,
  "updated_from": ISODateTime,
  "updated_to": ISODateTime,
  "analyze": true
}

Response

{
  "data": {
    "item_locations": {
      "request_id": "abc123",
      "complexity": 987,
      "data": ItemLocationConnection
    }
  }
}