Airtable Inventory & Orders System
Budget / Salary$250–750
TypeFreelance project
LocationRemote
Posted20 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.
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.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.