Turn a Messy Custom Order Email Into a Clean Sales Order in Under a Minute

author Aditya Jain • CEO & Founder
• • AIOrders
Share Share Share Email
Turn a Messy Custom Order Email Into a Clean Sales Order in Under a Minute

In this article

    Custom orders are the lifeblood of gemstone and jewelry businesses, but they're also where operations slow down. This tutorial shows how Loupe Factory converts unstructured email text into a structured, reviewable sales order table using AI—so order entry takes minutes, not hours.

    If you run a gemstone manufacturing company or jewelry production/wholesale business, you've probably experienced this: a key customer sends a long custom order email with mixed formats, shape acronyms, quantities, weights, internal notes, and a few spelling mistakes. To get that into a system accurately, someone has to retype and clean every line item.

    That manual work doesn't just waste time, it increases the risk of errors that show up later in production, invoicing, and delivery.

    Watch the Tutorial

    Paste a customer email → AI formats & extracts → review → submit sales order in under a minute.

    The Problem: Custom Order Emails Are Not "System-Ready"

    Most custom order emails are not clean spreadsheets. They include:

    • Multiple gemstone types in one message
    • Shape abbreviations and inconsistent naming
    • Quantities mixed with weights (often in different units)
    • Scattered notes and instructions
    • Typos, extra lines, and unclear formatting

    In a typical setup, your team has to:

    1. Copy details into a sheet or ERP
    2. Standardize shapes/sizes
    3. Convert weights/units
    4. Manually build each line item
    5. Double-check everything

    For a long email, this can easily turn into 1-2 hours of admin work for a single order.

    The Better Way: AI-Assisted Order Entry From Email Text

    In Loupe Factory, you can paste the customer's email directly into an order text box. The AI then formats and extracts the important details into a clean table that's ready to turn into a sales order.

    This is especially useful for:

    • Gemstone manufacturing orders (stones + weights + units)
    • Jewelry production orders with multiple SKUs/variants
    • Auto parts orders with mixed descriptions, kit quantities, and operational notes
    • Wholesale "memo / export" style invoices and requests
    • Any business still relying on spreadsheets or manual re-entry

    Step-by-Step: Create a Sales Order From a Customer Email

    Here's the exact workflow shown in the video.

    1. Copy the entire customer email
      • Select all text (Cmd + A on Mac or Ctrl + A on Windows)
      • Copy (Cmd/Ctrl + C)
    2. Start a new order in Loupe Factory
      • Click Add Order
      • Choose the customer and your order lead
    3. Paste the email into the Order Text box
      • Paste (Cmd/Ctrl + V)
      • At this point, you have two options: Edit the text manually (remove extra lines, add internal notes, clean up the message), or click AI Format to automatically restructure the email into a clear, standardized layout
    4. Let AI convert the email into a structured table
      • Click Next, and the AI transforms the messy email into an organized line-item table ready for review
      • This table becomes your draft sales order, including the details your team needs to move forward

    Why This Matters: Faster Orders, Fewer Errors, Smoother Production

    The biggest win isn't just speed, it's accuracy.

    Key Benefits

    • Save hours on every complex order, instead of retyping line items one by one, your team reviews and adjusts a structured table
    • Reduce human error during data entry, when you're not manually copying dozens of items, you dramatically lower the chance of wrong quantities, incorrect shape/size/spec selection, unit mistakes, part-reference confusion, and missed notes that affect production
    • Keep production and invoicing aligned, when orders are created cleanly from the start, everything downstream becomes easier: production planning, internal deadlines, customer delivery targets, invoicing and shipment readiness

    Review and Adjust Before Submitting

    After the AI generates the table, you can quickly refine it. For example:

    • Change shape and standardize acronyms
    • Select a different size
    • Enter weight in any unit
    • Add internal production notes
    • Set a reference sales price

    Then click Next to set an order budget in any currency, so your team has a clear cost/price reference.

    You can also work with default date logic, like:

    • A required date for internal planning
    • A customer deadline set a number of days from today

    Finally, click Submit to create the sales order.

    After the Order Is Created: One Place to Run Operations

    Once submitted, the order lives on the order details page, where you can manage:

    • Order status and updates
    • Production progress
    • Internal coordination
    • Tracking and follow-through

    The goal is simple: fewer tools, less manual admin, and more visibility for the entire team.

    Who This AI Feature Is Built For

    This workflow is ideal for businesses that handle complex orders such as:

    • Gemstone manufacturers managing WIP and stone specs
    • Jewelry manufacturers coordinating production jobs and inventory
    • Auto parts manufacturers and exporters handling high-mix part catalogs, repeated B2B orders, and shipment-ready documentation
    • Wholesalers handling memo/export and multi-line customer requests
    • Teams that still rely heavily on spreadsheets or manual entry

    If your business receives long, messy order emails and your team spends significant time "cleaning" them before production starts, this tutorial workflow is designed to remove that bottleneck.

    Try Loupe Factory Free

    If you want to see this with one of your real customer emails, you can try it immediately.

    Create a free account at loupefactory.com and paste a sample order email to see how the AI formats and structures it.

    Want help implementing this?

    Talk to our team

    FAQ

    Common questions

    You copy the customer's email text and paste it into the Order Text box in Loupe Factory. When you click AI Format (and then Next), the AI restructures the unstructured text into a clean, line-item table—so you can review and submit it as a sales order with far less manual work.

    The AI works best on detailed B2B order emails that mix product names, quantities, sizes, weights, units, prices, delivery notes, and customer-specific instructions. That can include gemstone requests, jewelry SKUs, or auto-parts orders with part descriptions, kit counts, and mixed formatting. Even when the email is messy or inconsistent, the AI is designed to help structure it.

    Yes. The workflow is built for manufacturers and wholesalers that receive mixed-format order requests. It supports weights in different units, piece quantities, and operational notes so your team can standardize details before the order moves into production or fulfillment.

    Yes. After pasting the email into the Order Text box, you can: delete irrelevant lines, add internal instructions for your team, and clean up spelling or formatting. Or you can skip manual cleanup and use AI Format to structure it automatically.

    You always review the generated table before submitting. You can adjust key fields such as product description, shape or size, quantities, part or variant details, weight and unit, internal production notes, and reference pricing. The AI speeds up the first draft; your team stays in control.

    Yes—because QuickBooks and Tally are primarily accounting tools, while this feature targets operations workflows like order creation, production planning, and inventory/WIP visibility. Many teams still rely on spreadsheets for operational tracking even if they use accounting software—Loupe Factory reduces that spreadsheet dependency.

    That is the goal for most teams. Loupe Factory is built to replace spreadsheet-heavy workflows by giving manufacturers and wholesalers structured visibility across production jobs, inventory, orders, invoices, and shipments. AI-assisted data entry makes the transition easier because your team does not need to manually rebuild every complex order from scratch.

    Yes. Manual retyping is one of the biggest sources of mistakes—wrong quantities, incorrect shapes, missed notes, or unit errors. By converting the email into a structured table and reducing re-entry, you lower the chance of errors that later affect production, invoicing, and fulfillment.

    Yes. The workflow is designed to support memo-style orders and export invoices where line items are often listed in inconsistent formats. You can paste, format, extract, review, and submit—without rebuilding the order from scratch.

    For many orders, it takes under a minute to paste the email, let the AI structure it, and review the table—compared to potentially hours of manual entry for long, complex requests.

    You can try it by signing up for a free account at loupefactory.com, then pasting a sample customer email into the Order Text box and using AI Format to generate the structured table.

    Supercharge your business

    With Artificial Intelligence ✨

    Get started with Loupe Factory

    Cookies & Privacy

    We use non-essential cookies (like analytics) to improve your experience. In your region, consent is required. You can change your choice anytime in Privacy Choices. Learn more.

    You can update your cookie choices. Manage cookies