Design an order, inventory, and replenishment tracking process
Автор: AILesson10 мин на настройкуПроверено на:ChatGPTПроверено: 2026-08-28
Быстрый ответ
Connect sales, stock movements, purchasing, receiving, exceptions, and reconciliation into one controlled workflow. Укажите: Business and inventory model, Current records and problems, Constraints and controls. Ожидаемый результат: A practical inventory-control process with records, formulas, roles, alerts, and test cases.
1
Добавьте контекст
ваш текст остаётся в этом браузере. AILesson Prompts не отправляет его ни в модель, ни на сервер.
2
Ваш промпт
Незаполненные поля остаются видимыми как заполнители, поэтому вы всё равно можете скопировать и отредактировать промпт
Design an order, inventory, and replenishment tracking process from the supplied business facts.
SKUs, locations, channels, orders, suppliers, lead times, returns, bundles, units, and service targets:
[business]
Systems/files, fields, timestamps, ownership, counts, discrepancies, stockouts, delays, and quality issues:
[records]
Review, demand/lead-time evidence, safety-stock policy, authority, budget, audit, access, integrations, and scale:
[controls]
Define the inventory event model before recommending a sheet or tool. Distinguish on hand, available, allocated, picked, shipped, returned-pending-inspection, damaged, inbound ordered, inbound confirmed, received, and adjusted only where relevant. Choose one source of truth and stable SKU/location/order/purchase-order IDs. Never infer missing units, supplier reliability, demand, lead time, reorder point, safety stock, or available stock. Do not use negative inventory or manual overwrite to hide discrepancies.
Map order-to-fulfillment and replenishment workflows with trigger, input, action, record change, owner, timestamp, evidence, exception, approval, and SLA. Specify tables/fields, status values, validation, calculations with units, alert logic, review cadence, cycle counts, returns, cancellations, partial shipments, backorders, bundles, supplier changes, and audit history as applicable. Recommend reorder formulas only from supplied policy/evidence; otherwise show required data and a temporary manual review. Include role/access matrix, reconciliation, dashboard definitions with denominators, implementation phases, migration, and normal/edge/failure test cases.
Конфиденциально по умолчаниюПромпт собирается локально в вашем браузере. Не вводите конфиденциальную информацию в сервисы ИИ, если ваша организация этого не разрешает.
От исходных данных к результату
Разобранный пример
Посмотрите, как конкретный контекст превращает этот рецепт в полезный результат
Реальный ввод
Business and inventory model
Small ceramics shop with 42 SKUs at one store/stockroom. Sales channels: POS and online store; online orders reserve stock at checkout and ship next business day. Products use units 'pieces'; gift set BND-01 contains 2 MUG-BLU + 1 TEA-WHT. Two suppliers, typical stated lead times 7 and 14 calendar days but no reliability history. Returns are inspected before restock; damaged pieces never return to available. Service goal: avoid accepting online orders without available pieces.
Current records and problems
POS exports daily CSV; online store exports orders with order ID, SKU, quantity, paid/cancelled/refunded timestamps. Spreadsheet has SKU and one 'stock' column overwritten after counts. Purchase orders live in email; receiving has no PO reference. Last month three online orders were cancelled after physical shortage. SKU labels differ for five products. Owner approves purchases; store associate picks/receives; bookkeeper reconciles weekly.
Constraints and controls
Start in Google Sheets; no integration budget this quarter. Daily 15-minute review, weekly reconciliation, monthly cycle count. Owner has not set safety stock or reorder service level. Six months of daily sales can be exported; supplier promised dates available only in emails. Purchase over $500 needs owner approval; associate may draft POs but not send. Protect customer details; inventory sheet should not contain names/addresses.
Пример вывода
Source of truth: one append-only Inventory Events table plus SKU master; the current overwritten stock column becomes a migration snapshot, not history. IDs: canonical SKU, Location=STORE, order ID, PO ID, event ID. Normalize five aliases before go-live. Units are pieces.
Core fields: Events—event ID/time/type/SKU/qty signed/location/reference ID/source/status/entered by/evidence/approved by/correction-of. Orders—order ID/channel/status/SKU/qty/reserved/picked/shipped timestamps, no customer identity. POs—PO ID/supplier/SKU/qty/unit cost/draft/approved/sent/promised/received status. Returns—reference/SKU/qty/inspection outcome. Never delete an error; add reversing/correcting event.
States/calculation: On hand = opening + received + approved restock returns − shipped/POS sold − damaged ± approved adjustments. Allocated = paid open online units not cancelled/shipped. Available = On hand − Allocated. Inbound is reported separately and never included in Available. Bundle availability BND-01 = min(floor(available MUG-BLU/2), available TEA-WHT); allocate/release components when bundle order is paid/cancelled. Block/manual-review online acceptance when Available would go below zero; the sheet cannot enforce storefront checkout, so this remains an operational control and integration gap.
Daily: import POS/order events, validate SKU/order uniqueness, reconcile open allocations, inspect exceptions. Associate drafts PO; owner approves/sends, mandatory if >$500 and still owner-controlled below that unless policy changes. Receiving records PO/actual qty/date; mismatches go Exception, not overwrite. Returns remain pending until inspection. Weekly bookkeeper reconciles computed on-hand with source exports and logs variances; monthly count creates approved adjustments with reason.
Reorder: do not invent points. Phase 1 dashboard flags owner review using six-month demand, current available/inbound, emailed promised dates; collect actual PO sent/received dates for reliability. Owner later chooses lead-time/safety-stock policy. Tests: sale, reservation/cancel, partial ship, duplicate import, unknown SKU, bundle depletion, damaged return, partial PO receipt, >$500 approval, count variance. Migration requires physical count, alias map, open order/PO capture, and signed opening snapshot.
Почему это работает
1
An event model prevents one ambiguous stock number from mixing physical, committed, damaged, and inbound units
2
Reconciliation and audit evidence make exceptions visible instead of letting manual edits silently rewrite history
Проверьте результат
Are inventory states, events, units, IDs, source of truth, and record ownership unambiguous
Are reorder logic, available-stock calculations, and alerts supported by supplied policy and data
Does the process cover reconciliation, approvals, access, exceptions, and edge-case tests
Используйте уверенно
Часто задаваемые вопросы
Практические ответы о том, когда использовать этот рецепт, что нужно предоставить и где по-прежнему важна проверка человеком
What should I prepare before using “Design an order, inventory, and replenishment tracking process”?
For “Design an order, inventory, and replenishment tracking process,” prepare Business and inventory model, Current records and problems, and Constraints and controls. Replace placeholders only with information you can verify. If a detail is unknown, preserve that uncertainty explicitly instead of asking the model to infer it.
When is the “Design an order, inventory, and replenishment tracking process” result not ready to use?
The result is not ready if it does not yet deliver the stated outcome—A practical inventory-control process with records, formulas, roles, alerts, and test cases—from the supplied evidence, or if it relies on unresolved assumptions, missing approvals, or invented details. Use the checks as release gates: revise the source inputs or assign a named, authorized reviewer instead of polishing an unsupported output.
Which AI tools have recorded tests for “Design an order, inventory, and replenishment tracking process”?
The published test record for “Design an order, inventory, and replenishment tracking process” lists ChatGPT as of 2026-08-28. This confirms recorded runs, not guaranteed compatibility or identical results in later product versions. For another tool or version, keep every constraint visible and repeat the result checks before use.
Перейдите от понимания ИИ к выполнению задач. Практикуйтесь в составлении запросов, проверке и улучшении результатов с помощью интерактивных уроков для работы и повседневной жизни.
ChatGPT
