Querying product and warehouse product based on updated_from

We have an external database that monitors warehouse inventory levels and generates a low stock notification email on the daily. We are finding that products gets missed and it never hits our trigger again because it never updated again after we missed the first update.

My query Product > Warehouse Product

query ($updated_from: ISODateTime, $updated_to: ISODateTime) {
  products(
    has_kits: false
    updated_from: $updated_from
    updated_to: $updated_to
  ) {
    complexity
    data(last: 2000) {
      edges {
        node {
          sku
          name
          account_id
          barcode
          warehouse_products {
            warehouse_id
            on_hand
            allocated
            available
            reorder_amount
            legacy_id
            value
          }
        }
      }
    }
  }
}

Meanwhile flipping the query around to Warehouse Product > Product returns a different set of SKUs.

Is it more reliable to use warehouse_product instead of product? Also, what are the fields considered that would change the updated_from value?

Hey @szushii,

Thanks for reaching out!

Looking into this now, I’ll update you as soon as I can.

Best,
RayanP