Contact person: Business Client

Phone:Show

Email:Show

Location: Kandy, Sri Lanka

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"Project Summary: Google AppSheet App Linked to Google Sheets for Stock Management
Overview

I am looking for an experienced AppSheet developer to build a custom stock management app that integrates directly with Google Sheets. The app will manage and track stock across two warehouses, with features for daily stock counting, transfers, sales deductions, and automated low-stock alerts.

Core Features Required
1. Stock Take Module

Scan or select products and enter counted quantities

Automatically syncs with Google Sheets

Capture who performed the stock take and timestamp

2. Daily Stock Count Schedule

App suggests which products must be counted each day (weekly rotation)

Daily push notification or email reminder with items to check

3. Warehouse Transfers

Move stock between 2 warehouses

Automatically deduct from source warehouse and add to destination

4. Low Stock Notifications

System monitors quantities continuously

Sends alert (email or push notification) when items fall below a set reorder threshold

5. Sales Deduction Module

Automatically deduct stock based on daily sales

Sales data can be imported from a Google Sheet or entered manually

Real-time quantity updates

Data & Syncing Requirements

Live syncing with Google Sheets at all times

Product names, stock levels, and warehouse details easily editable directly from Sheets

App must be fully functional on both mobile and tablet

Technical Requirements

Must be built using Google AppSheet

Must integrate fully with Google Sheets

Scalable structure so additional warehouses or items can be added later

Deliverables

Fully functional AppSheet app connected to Google Sheets

Active low-stock notification system

Daily stock count scheduling feature

Short user guide or brief training video on how to use and maintain the system" (client-provided description)