Contact person: Business Client

Phone:Show

Email:Show

Location: Dubai, United Arab Emirates

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"Project Title:

AppSheet App Linked to Google Sheets for Stock Management, Sales Deductions & Manufacturing

Project Description:

I need a custom AppSheet app built that integrates directly with Google Sheets to manage and track stock across multiple warehouses. The app must allow for daily stock management, warehouse transfers, manufacturing input/output tracking, and automated low-stock alerts.

Key Features Required:

Stock Take Module:

Ability to scan or select products and input counted quantities.

Syncs automatically with Google Sheets.

Option to track who did the stock take and when.

Daily Stock Count Schedule:

The app should suggest which items to count each day (e.g., divide full stock list over the week).

Sends a daily reminder or notification for which items need to be checked.

Warehouse Transfers:

Function to move stock from one warehouse to another.

Quantities deducted from the source warehouse and added to the destination warehouse.

Low Stock Notifications:

Automatically monitors stock levels.

Sends notifications or emails when an item falls below a set reorder threshold.

Manufacturing Module:

Ability to book out raw materials and book in finished goods.

Example 1: Pork bones — book out 25kg → return 24kg → 1kg recorded as sawdust/waste.

Example 2: Wors — use beef mince, fat, and spice as inputs → finished product added to stock.

Sales Deduction Module:

Automatically deducts daily sales from stock (data imported from a sales sheet or entered manually).

Updates current stock levels in real time.

Data Management & Syncing:

All data must sync live with Google Sheets.

Easy to edit product names, stock levels, and warehouse data directly from Sheets.

Requirements:

Must be built using AppSheet and linked to Google Sheets.

Mobile- and tablet-friendly interface for use on the floor.

Scalable design to add more warehouses or items later.

Deliverables:

Fully functional AppSheet app connected to Google Sheets.

Working low-stock notification and daily stock schedule.

User guide or short training video explaining how to use and maintain the app." (client-provided description)