warehouse_products

Arguments

Argument	Type	Required	Description
`warehouse_id`	`String`	No
`active`	`Boolean`	No
`sku`	`String`	No
`customer_account_id`	`String`	No	If you are a 3PL you can specify one of your customer's account
`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

WarehouseProductsQueryResult

Query

query warehouse_products(
  $warehouse_id: String,
  $active: Boolean,
  $sku: String,
  $customer_account_id: String,
  $created_from: ISODateTime,
  $created_to: ISODateTime,
  $updated_from: ISODateTime,
  $updated_to: ISODateTime,
  $analyze: Boolean
) {
  warehouse_products(
    warehouse_id: $warehouse_id,
    active: $active,
    sku: $sku,
    customer_account_id: $customer_account_id,
    created_from: $created_from,
    created_to: $created_to,
    updated_from: $updated_from,
    updated_to: $updated_to,
    analyze: $analyze
  ) {
    request_id
    complexity
    data {
      ...WarehouseProductConnectionFragment
    
      pageInfo {
        ...PageInfoFragment
      
        hasNextPage
        hasPreviousPage
        startCursor
        endCursor
      }
      edges {
        ...WarehouseProductEdgeFragment
      
        node {
          ...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
                  
                    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
                  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
                  }
                  cases {
                    ...CaseFragment
                  
                    id
                    legacy_id
                    case_barcode
                    case_quantity
                  }
                }
                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
            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
            }
            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
          
            pageInfo {
              ...PageInfoFragment
            
              hasNextPage
              hasPreviousPage
              startCursor
              endCursor
            }
            edges {
              ...ItemLocationEdgeFragment
            
              node {
                ...ItemLocationFragment
              
                id
                legacy_id
                account_id
                warehouse_id
                location_id
                sku
                quantity
                created_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
                    }
                    edges {
                      ...ProductEdgeFragment
                    }
                  }
                  last_counted
                  created_at
                  expiration_lots {
                    ...LotConnectionFragment
                  
                    pageInfo {
                      ...PageInfoFragment
                    }
                    edges {
                      ...LotEdgeFragment
                    }
                  }
                }
                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
                    }
                    edges {
                      ...LocationEdgeFragment
                    }
                  }
                  purchase_orders {
                    ...PurchaseOrderConnectionFragment
                  
                    pageInfo {
                      ...PageInfoFragment
                    }
                    edges {
                      ...PurchaseOrderEdgeFragment
                    }
                  }
                }
                lpns {
                  ...LicensePlateNumberConnectionFragment
                
                  pageInfo {
                    ...PageInfoFragment
                  
                    hasNextPage
                    hasPreviousPage
                    startCursor
                    endCursor
                  }
                  edges {
                    ...LicensePlateNumberEdgeFragment
                  
                    node {
                      ...LicensePlateNumberFragment
                    }
                    cursor
                  }
                }
              }
              cursor
            }
          }
        }
        cursor
      }
    }
  }
}

Variables

{
  "warehouse_id": "abc123",
  "active": true,
  "sku": "abc123",
  "customer_account_id": "abc123",
  "created_from": ISODateTime,
  "created_to": ISODateTime,
  "updated_from": ISODateTime,
  "updated_to": ISODateTime,
  "analyze": true
}

Response

{
  "data": {
    "warehouse_products": {
      "request_id": "abc123",
      "complexity": 987,
      "data": WarehouseProductConnection
    }
  }
}