As of 13 August 2026, AI can only partly consolidate orders from multiple suppliers.

What to actually do

1. Hand it to a person

   The route this page recommends

   A person who owns the outcome does this end to end, worth it when the failure is dear.

2. Use a tool built for this

   Second choice

3. Do it yourself

   The distant third

   A chat interface, chat-fluent skill, and roughly 30 minutes until you can act on the result.

   How to actually do it

   1. Open the emails, spreadsheets, PDFs and purchase-order records containing the current orders from each supplier.
   2. Gather the current product codes, descriptions, required quantities, pack sizes, prices, minimum order quantities, delivery dates and supplier terms for every line.
   3. Paste the source material and your purchasing constraints into the prompt, keeping each supplier's name and document heading attached to its lines.
   4. Ask the model to produce the consolidated schedule, decision list, discrepancy list and supplier totals without sending or placing any order.
   5. Copy the drafted schedule into your approved spreadsheet or purchasing system and compare every line with its original supplier source, including quantities, product codes, prices, pack sizes and dates.
   6. Ask the responsible colleague to resolve every flagged exception and approve the corrected schedule before sending separate orders to suppliers.

   Prompt

   Consolidate the supplier orders below into one reviewable order schedule. Do not place or send any order. Preserve the supplier name, product code, description, quantity, unit, unit price, currency, delivery date, minimum order quantity, pack size and any stated terms. Match products only when the product code or description clearly identifies the same item. Do not merge uncertain matches. Flag duplicates, missing fields, conflicting prices, different pack sizes, minimum order quantities, conflicting delivery dates and any item that cannot be matched. Separate the result into: 1. consolidated lines grouped by supplier or delivery requirement, 2. items that need a decision, 3. source discrepancies, and 4. a total by supplier only where the arithmetic and currency are clear. Show your calculations. Do not invent prices, quantities, dates or supplier terms. Use the UK date format where dates are unambiguous. Source orders: [paste emails, spreadsheets or PDFs here]. Current requirements and constraints: [paste required quantities, stock levels, delivery requirements and approval rules here].

   Open it prefilled in ChatGPT or Claude, or copy it into Gemini, which takes no prefill link.