inventory_changes

Arguments

Argument	Type	Required	Description
`sku`	`String`	No
`warehouse_id`	`String`	No
`location_id`	`String`	No
`location_name`	`String`	No
`date_from`	ISODateTime	No
`date_to`	ISODateTime	No
`customer_account_id`	`String`	No
`reason`	`String`	No	It performs a contains / like search and requires a date range, with a maximum of 60 days
`analyze`	`Boolean`	No	If true, the query will only be analyzed (cost estimated) without executing it.

Return Type

InventoryChangesQueryResult

Query

query inventory_changes(
  $sku: String,
  $warehouse_id: String,
  $location_id: String,
  $location_name: String,
  $date_from: ISODateTime,
  $date_to: ISODateTime,
  $customer_account_id: String,
  $reason: String,
  $analyze: Boolean
) {
  inventory_changes(
    sku: $sku,
    warehouse_id: $warehouse_id,
    location_id: $location_id,
    location_name: $location_name,
    date_from: $date_from,
    date_to: $date_to,
    customer_account_id: $customer_account_id,
    reason: $reason,
    analyze: $analyze
  ) {
    request_id
    complexity
    data {
      ...InventoryChangeConnectionFragment
    
      pageInfo {
        ...PageInfoFragment
      
        hasNextPage
        hasPreviousPage
        startCursor
        endCursor
      }
      edges {
        ...InventoryChangeEdgeFragment
      
        node {
          ...InventoryChangeFragment
        
          id
          legacy_id
          user_id
          account_id
          warehouse_id
          sku
          previous_on_hand
          change_in_on_hand
          reason
          cycle_counted
          location_id
          lot_id
          lot_name
          lot_expiration
          created_at
          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
            
              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
              
                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
                    }
                    expiration_lot {
                      ...LotFragment
                    }
                    lpns {
                      ...LicensePlateNumberConnectionFragment
                    }
                  }
                  cursor
                }
              }
            }
            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
            }
          }
          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
                  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
                  }
                  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
              }
            }
          }
        }
        cursor
      }
    }
  }
}

Variables

{
  "sku": "abc123",
  "warehouse_id": "abc123",
  "location_id": "abc123",
  "location_name": "abc123",
  "date_from": ISODateTime,
  "date_to": ISODateTime,
  "customer_account_id": "abc123",
  "reason": "abc123",
  "analyze": true
}

Response

{
  "data": {
    "inventory_changes": {
      "request_id": "abc123",
      "complexity": 987,
      "data": InventoryChangeConnection
    }
  }
}