Count your stock from photos and get a reorder plan: snap your shelves or bins, let AI build the inventory sheet and suggest what to reorder: AI agent prompt
Counting merchandise by hand and working out what to reorder is the job small sellers dread, so it gets put off until something sells out. You can photograph your stock, have an AI assistant identify and count each item and size, turn it into a spreadsheet, compare it with what sold, and suggest a reorder list you check before sending anything to a supplier. OpenAI reported (Oct 2026) that Larissa Guetter of ATV Big Air Tour, a two-person touring motorsports show, uploads photos of the tour's merchandise to ChatGPT Work, which organizes the inventory, builds a spreadsheet and reorder recommendations in under 15 minutes; with her review and adjustments, inventory-to-reorder now takes two to three hours instead of two to three days.
EcommercePhoto inventory and reorder planbeginnerThe prompt
You are my inventory assistant. I'm uploading photos of my stock: [upload clear photos of each shelf, bin or rack; one photo per area, with labels or tags visible where possible]. My product list: [paste item names, sizes or variants, SKU if any, cost, supplier, supplier minimum order and lead time]. Sales since my last count: [paste or upload, or say 'none']. Upcoming events or busy periods: [e.g. 6 shows in the next 8 weeks / holiday sale]. Do this: 1) From the photos, list every item and variant with your count, and mark any count you're unsure of (stacked, hidden or blurry) so I can recount it by hand. 2) Build an inventory table: item, variant, counted quantity, confidence, photo it came from. 3) Using the sales and upcoming periods, estimate how many weeks each item will last. 4) Suggest a reorder list per supplier with quantities, respecting minimums and lead times, and point out slow sellers I should not reorder. 5) Give me the total reorder cost. Don't place any order; I'll review and send it myself.
How to use it
- Copy the prompt above.
- Replace every [bracket] with your own details (or fill in the blanks on AgentPlaybook Real Estate, which remembers your answers for the next prompt).
- Paste it into ChatGPT, Claude, Gemini and review the answer before you use it.
Works with: ChatGPT, Claude, Gemini, Google Sheets, Excel, Shopify
Real-world example: openai.com/index/atv-big-air-tour/
Featured in: Free AI agent prompts for small business (beginner-friendly) · AI prompts for Google Sheets and Excel work
Before you use it: what to check
Already built into this prompt
- Don't place any order; I'll review and send it myself.
Check yourself
- Check every figure, price and total against your own records before anything is sent, posted or booked. A person approves refunds, discounts, payments and price changes.
- Read and edit the draft before it reaches a customer or goes public. If you later automate this prompt, start with "draft and notify me", not "send automatically".
- Check names, dates, numbers and any claim against your own source material before you use the answer. AI can misread or invent details.
Using an AI agent? Download this prompt as a SKILL.md agent skill with these checks built in, or get the .zip for Claude.ai. How to install skills.
Want to make this prompt even better? Grade it with the free prompt grader or build your own with the AI prompt generator.
32 copy-paste agent prompts (PDF) plus 5 new prompts every week.
Get it free