ChatGPT Prompts for Supply Chain Management: 12 to Use Now

ChatGPT prompts for supply chain management are most useful when you paste your own stock, demand, lead time, and supplier numbers and ask for decisions with the math shown. The 12 prompts below cover reorder planning, stockout checks, supplier performance, demand changes, and supplier communication for small and mid-size product businesses. Check every output against your spreadsheet before you place an order.

Get your data ready

The prompts work best with a simple table per SKU: on hand, open purchase orders and their arrival week, average weekly demand, lead time in weeks, minimum order quantity, and unit cost. Add a short supplier record, such as on-time deliveries out of the last ten orders. Paste it as plain text so ChatGPT reads each number, and tell it not to invent anything that is missing.

Inventory and reorder planning

1. Weeks of cover check

From this SKU table, [paste], calculate inventory position (on hand plus open POs), weeks of cover, and required weeks (lead time plus [safety weeks]). Mark each SKU as order now, watch, or fine, and show the math.

2. Reorder quantities with MOQ

For the SKUs marked order now, [list], calculate the quantity needed to cover lead time plus safety, adjust for MOQ and case packs, and total the cost against my cash limit of [amount]. Show each calculation.

3. Stockout week finder

For [SKU], roll stock forward week by week using [weekly demand] and these arrivals, [POs], and tell me the first week it hits zero. Then repeat assuming the next PO is [number] weeks late.

4. Cash-limited buy plan

I can spend [amount] on POs this month and need these orders: [list with costs]. Rank them by stockout risk and margin impact using my numbers, and propose what to buy now versus next month.

Suppliers

5. Supplier scorecard

Build a scorecard for these suppliers from my records: [on-time counts, defects, response time, notes]. Calculate each rate from the counts, rank them, and suggest one improvement request per supplier.

6. Delay impact check

Supplier [name] is usually [number] weeks late on [share] of orders. Using my stock table, [paste], show which SKUs would run out if the next order is late and by how many units.

7. Second-source brief

I depend on one supplier for [SKU]. Draft a request for quote for a backup supplier: specs, volumes from my data, required lead time, quality checks, and questions to compare answers fairly.

Demand and planning

8. Promo or season adjustment

I expect demand for [SKU] to change to [number] per week during weeks [range] because of [event]. Recalculate the reorder quantity and stockout week with that change and show the before and after.

9. Slow mover review

From this table, [paste], list SKUs with more than [number] weeks of cover, the cash tied up in each (on hand times unit cost), and options to free it up such as bundles, smaller reorders, or pausing POs.

10. Weekly supply review agenda

Turn these updates, [stock changes, late POs, supplier news], into a 20-minute weekly supply review agenda with the decisions needed and an owner for each.

Communication

11. Supplier ship date email

Write a short, polite email to [supplier] about PO [number] for [quantity] of [SKU], due [week]. Say when our stock runs out, ask them to confirm the ship date this week, and ask for a partial early shipment if a delay is likely.

12. Stockout heads-up to sales

Write a note to our sales and support team that [SKU] may be out of stock from [week] to [week]. Include what customers can be offered instead and what not to promise.

Worked example

A small drinkware brand pasted three SKUs. Its 24 oz bottle had 1,800 on hand, no open order, demand of 300 a week, a 6-week lead time, and a holiday promo expected to lift demand to 450 a week in weeks 6 to 8. The goal was lead time plus 2 weeks of safety.

The flagship prompt showed 6.0 weeks of cover against 8 required, rolled stock forward to show it runs out during week 6, and calculated the order: 5 weeks at 300 plus 3 weeks at 450 is 2,850, minus 1,800 on hand, so 1,050 units at $6.20 for $6,510.00, inside the $8,000 cash limit. It also caught that a kids bottle with a supplier on time only 7 of 10 times would hit zero in week 5 if the open order slipped, and drafted the ship date email. Get the full supply chain reorder prompt.

Related business prompts

For the wider operations picture, see the ChatGPT prompts for operations and the weekly ops review prompt. To compare suppliers on set criteria, use the vendor scorecard prompt, and to clean up your stock sheet first, try the ChatGPT prompts for Excel data analysis.

Find more in the Business prompts hub, browse all prompts, or share your own prompt.