# Retail Sales & Inventory Manager

**Category:** Retail  
**Tools:** n8n, HTTP, Google Sheets  
**Nodes:** 34  
**Built by:** Forgent Systems

A complete shop back-office in Google Sheets. It records sales, updates stock, sends receipts, alerts on low stock, handles restocking and sends a daily sales summary.

![Workflow](preview.webp)

## How it works

1. A sale form checks the product and calculates the total and remaining stock.
2. Stock is updated, the sale is saved and the customer receives a receipt.
3. Low stock triggers a manager alert.
4. Inventory forms add new products or restock existing ones.
5. A daily summary of sales is generated and sent.

## Use cases

- Convenience and general stores
- Boutiques
- Small multi-product shops

## Data setup

**Google Sheets** (tab: columns)

- **Retail Shop Daily Sales Sheet → inventory**: `product`, `stock`, `min_stock`, `price`
- **Retail Shop Daily Sales Sheet → sales**: `customer_name`, `phone_number`, `product`, `quantity`, `price`, `total`, `time`, `date`
- **Retail Shop Daily Sales Sheet → daily_summary**: `date`, `total_sales`, `orders`, `top_product`

## Setup

1. In n8n open **Workflows → Import from File** and choose `workflow.json`.
2. Connect these credentials:
   - Google Sheets account
   - Twilio account
3. Point the Sheets / Airtable / Drive / Slack nodes at your own resources (structure above).
4. Replace placeholder emails, phone numbers and `YOUR-FORM-ID` links with your own.
5. Times use the America/New_York timezone and dates use MM/DD/YYYY. Adjust if needed.
6. Run a test execution, then activate.

## Nodes

- **Sale Form Trigger** — `n8n-nodes-base.formTrigger`
- **Fetch Product from Inventory** — `n8n-nodes-base.googleSheets`
- **Validate Product Exists** — `n8n-nodes-base.if`
- **Product Not Found Alert** — `n8n-nodes-base.twilio`
- **Calculate Sale, Total & Stock** — `n8n-nodes-base.code`
- **Check Low Stock Threshold** — `n8n-nodes-base.if`
- **Low Stock Alert (Manager)** — `n8n-nodes-base.twilio`
- **Update Inventory Stock 1** — `n8n-nodes-base.googleSheets`
- **Update Inventory Stock** — `n8n-nodes-base.googleSheets`
- **Save Sale Record** — `n8n-nodes-base.googleSheets`
- **Save Sale Record 1** — `n8n-nodes-base.googleSheets`
- **Send Customer Receipt** — `n8n-nodes-base.twilio`
- **Send Customer Receipt 1** — `n8n-nodes-base.twilio`
- **No Operation, do nothing** — `n8n-nodes-base.noOp`
- **Inventory Form Trigger** — `n8n-nodes-base.formTrigger`
- **Fetch Inventory Records** — `n8n-nodes-base.googleSheets`
- **Check Product Exists** — `n8n-nodes-base.code`
- **Is Product Duplicate?** — `n8n-nodes-base.if`
- **Save New Inventory** — `n8n-nodes-base.googleSheets`
- **Stock Update Form Trigger** — `n8n-nodes-base.formTrigger`
- **Fetch Product from Inventory1** — `n8n-nodes-base.googleSheets`
- **Validate Product Exists1** — `n8n-nodes-base.if`
- **Calculate Updated Stock** — `n8n-nodes-base.code`
- **Update Inventory Stock1** — `n8n-nodes-base.googleSheets`
- **Daily Summary Scheduler** — `n8n-nodes-base.scheduleTrigger`
- **Fetch Today Sales Data** — `n8n-nodes-base.googleSheets`
- **Calculate Daily Sales Summary** — `n8n-nodes-base.code`
- **Save Daily Summary** — `n8n-nodes-base.googleSheets`
- **Send Daily Report (Manager)** — `n8n-nodes-base.twilio`
- **Sticky Note2** — `n8n-nodes-base.stickyNote`
- **Sticky Note1** — `n8n-nodes-base.stickyNote`
- **Sticky Note** — `n8n-nodes-base.stickyNote`
- **Sticky Note3** — `n8n-nodes-base.stickyNote`
- **Sticky Note4** — `n8n-nodes-base.stickyNote`
