Natural Language Data Querying
Essential knowledgeCore knowledge to understand Fluent Commerce
Changed on:
20 Aug 2026
Overview
[Warning: empty required content area]Key points
- Translate a business question into a well-formed prompt for a data query
- Read and sanity-check the results an assistant returns
- Recognize signs that a query result is wrong, incomplete, or scoped incorrectly
Reframing Business Questions
Business questions and data questions look similar but aren't the same thing. "Why are these orders late?" is a business question as it's really asking about causes, patterns, and next steps. A data query can't answer "why" directly, as it can only return information that may help you answer why. If a question is not reframed, results returned may not be usable even if it is technically providing what you asked for.| Business question | Reframed data question |
| "Why are these orders late?" | |
| "How many returns did we get last week?" | |
| "Which fulfillments are stuck?" |
Effective Prompting for Data Querying
Effective prompts for data querying generally include:- The entity type being asked about (orders, fulfillments, InventoryCatalogues, retailers, etc.)
- A status or date filter, where relevant
- Clear scope (one retailer? one location? a specific time window?)
Differences between weak prompts and strong prompts
Weak: "show me problem orders"This prompt is missing all three ingredients. The LLM has to guess what "problem" means, over what time window, and for which retailer. Returned results will vary as there is not enough context provided.Strong: List me all orders from Retailer A where the status is not 'Completed'Checking Results
Before accepting a query result as accurate, check the important points:- Entity match: Does the result match the entity type you asked about?
- Scope match: Is the scope (retailer/location/date range) what you intended?
- Plausibility: Does the row count and shape of the data look plausible?
- Completeness: Did the result actually cover everything the question was asking about?