Fluent Commerce Logo
Docs
Sign In

Enhanced Search Capabilities for Orders and Fulfilments by Product References

Release

Author:

Fluent Commerce

Changed on:

1 Apr 2025

Target release date:2025-04-01
Release status:Released

Description

This release introduces enhanced search capabilities for Orders and Fulfilments, allowing users to query records by specific Product References (

`productRef`
). These updates enable better management of product recalls, particularly for pre-orders, back-orders, and in-flight orders or fulfilments. Users can now identify orders or fulfilments containing specific products with greater efficiency.

Key Benefits

  • Handle Recalls or Returns: Quickly find affected orders or fulfilments when a product is recalled or a customer requests a return.
  • Manage Back-Orders and Pre-Orders: Easily identify orders with items still on the way or waiting to be shipped.
  • Track Best-Selling Items: Identify your most popular products by seeing how often they appear in orders.
  • Improve Customer Support: Locate orders for products under warranty or requiring special care, helping resolve issues faster.

New Features

  • Search Orders by Product References
    • Single Product Ref Search: Find all orders containing a specific product by searching with its product ref.
    • Multiple Product Ref Search: Retrieve orders with items matching any product ref from a list of specified refs.
    • Combined Filters: Refine searches by combining product ref filters with existing order query filters.
  • Search Fulfilments by Product References
    • Single Product Ref Search: Locate fulfilments containing items related to a specific product ref.
    • Multiple Product Ref Search: Query fulfilments using multiple product refs and return all relevant results.
    • Combined Filters: Enhance search precision by using product refs alongside other fulfilment query filters.

Changelog

New Argument:

`productRef`
added to both
`orders`
and
`fulfilments`
queries.

Data Type:
`productRef`
can be a string or an array of strings.

Functionality: Enables searching for orders / fulfilments containing specific product references

Example Use Cases

1query {
2  orders(productRef: ["recalled-ref-123"]) {
3    orderEdge:edges {
4      orderNode: node {
5        ref
6        items {
7          orderItemEdge:edges {
8            orderItemNode: node {
9              product {
10                ref
11              }
12            }
13          }
14        }
15      }
16    }
17  }
18}

Language: plain_text

Name: Finding Affected Orders in a Recall

Description:

Query orders containing a recalled product ref to identify impacted customers.

1query {
2  fulfilments(productRef: ["preorder-ref-456"] status:["PENDING"]) {
3    fulfilmentEdge:edges {
4      fulfilmentNode: node {
5        id
6        ref
7      }
8    }
9  }
10}

Language: plain_text

Name: Identifying Pending Fulfilments for Back-Orders

Description:

Search fulfilments for products awaiting shipment to manage pre-order and back-order workflows.

Released capability depth:Enhancement
Release bundle / Capability type:Platform, Fluent OMS
Fluent Commerce

Fluent Commerce