Airtable Inventory & Orders System

via Freelancer ·

Budget / Salary$250–750
TypeFreelance project
LocationRemote
Posted40 minutes ago
I need a clean, well-structured Airtable base that lets me stay on top of both inventory and customer orders in one place.

Inventory tracking
• A dedicated table should store every item with its name, SKU, photos, category, reorder level, storage location, and current quantity.

Order management
• A separate orders table must capture customer details, items ordered, status, and delivery information.
• When I change an order’s status to “Fulfilled,” the linked item quantities must decrease automatically—no manual adjustments.

Workflow expectations
1. Easy-to-use forms (or Airtable Interface) for adding new products and recording incoming orders.
2. Automations or scripts that handle the stock deduction and flag items at or below their reorder level.
3. Clear views and filters so I can see low-stock items, pending deliveries, and recent transactions at a glance.

Please build the base, configure the automations, and walk me through how to maintain it going forward. I’m already familiar with Airtable basics, so concise documentation or a brief loom video is all I’ll need for hand-off.
javascript software architecture inventory management mysql airtable automation database management
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.