AI Agent for Order Management System

Automated the creation of client-facing order visualizations — pulling real material swatches from the catalog to show customers exactly what they bought before delivery

Role

Systems Architect & AI Integration Lead

Company

FullFlat LLC

Location

United Arab Emirates

Year

2026

Core Tech

Airtable OpenAI AI Image Generation

The Challenge

Customers ordering multiple pieces had no way to preview how their color and material selections would look together before delivery. Color and material combinations across a sofa, bed, side tables, and accent pieces were impossible to visualize ahead of time, creating uncertainty and occasional post-purchase dissatisfaction.

Overview

An AI agent built into FullFlat's Order Management System on Airtable, automating the creation of client-facing visuals. Every order gets a visualization pulling real material swatches from the catalog, so customers see exactly what they're getting before it ships.

Discuss a Similar Project

Solution

Built an AI agent as an Airtable automation running on GPT Image, generating furniture visualizations on demand—either for a single catalog item or an entire client order.

Order & Product Visualizer

This agent generates furniture layout visualizations pulling swatches from a material library linked to each product variation—shown above as an example: sofa, bed, side tables, lamp, and nightstands laid out together with their available finish options. It works two ways: on a single catalog product, to show a customer the material and color options for that item, or on a full customer order, combining every piece the customer bought into one coherent visualization with their exact selected finishes.

When triggered on an order, the agent pulls each ordered item's variation record, retrieves the linked materials from the shared material library, and composes a layout image showing the full order together—rather than customers imagining how five separately-photographed pieces might look side by side in their chosen colors. The finished visualization is sent directly to the client via email or WhatsApp, giving them a clear preview of their order before it ships.

Order visualization: sofa, armchair, coffee table, dining chair, dining table, and TV console with linked material swatches Order visualization: sofa, bed, nightstand, rug, lighting, wall art, and console with material swatches

The operator also has the option to add custom products that fall outside the catalog, dropping in reference images directly. This covers the occasional off-catalog sale made at a client's request, so the visualization stays accurate even when an order includes something FullFlat doesn't normally carry.

Inside the Moodboard Editor

In practice, the operator works from the Order Line Items view and marks which products should go into the visualization using a star toggle in the "Add to Moodboard" column—useful for orders where only some line items (say, the Basic package) should appear in the render, while Add-ons or Undefined items are left out.

Order Line Items table with star toggles marking which products to include in the moodboard

Clicking into the order's Moodboard Editor shows the selected product images pulled automatically from each item's catalog record, alongside the generated Mood Board output and its matched material swatches once the agent has run.

Moodboard Editor showing selected product images and the generated mood board with material swatches

Underneath, the "Create Moodboards" automation runs on a button click: it takes the selected product images as input, sends them to an image generation model (GPT Image, low fidelity, landscape 1536x1024) with a prompt instructing it to compose a designer moodboard collage using the input images as-is without modification, then writes the result back to the record's Mood Boards attachment field via a follow-up script step.

Airtable automation: button click triggers Generate Image action, then a script writes the output back to the Mood Boards field

Integration & Workflow

The agent runs as an Airtable automation inside the Order Management System, triggered on demand by a button click. No external infrastructure, no servers to manage—just Airtable's native automation coupled with GPT Image API calls. The visualizer sends its output straight to the client, closing the loop between order confirmation and delivery with a clear visual preview.

Impact

Discuss a Similar Project
Previous Project View All Projects Next Project
WhatsApp