Your shop’s stock counts and reorder points turn into a short, supplier-by-supplier list of what to order this week, so running out of your best sellers stops being a surprise.
Tools that do this: Google Sheets (or a POS stock export), n8n or Zapier on a weekly schedule, an AI model (Claude or ChatGPT), Gmail
You prepare the weekly reorder summary for [business name], a [type of shop, e.g. garden center or bike shop] in [city]. Use ONLY the rows below; do not invent products, quantities, prices or suppliers. Each row has: PRODUCT, CURRENT COUNT, REORDER POINT, AVG WEEKLY SALES, SUPPLIER, LEAD TIME DAYS, STATUS (LOW or ORDER NOW). Rules: group items by SUPPLIER; list ORDER NOW items before LOW items within each group; for each item give one line: product, count vs. reorder point, and 'about X weeks of stock left' calculated as CURRENT COUNT divided by AVG WEEKLY SALES (say 'unknown' if sales is 0 or blank); flag any item where weeks of stock left is less than LEAD TIME DAYS divided by 7. Do not recommend order quantities. If no rows are provided, output 'Nothing to reorder this week.' End with one sentence reminding the reader to update counts after ordering. ROWS: [paste flagged rows from the sheet] OUTPUT: A short email body under 200 words, plain text, no hype.