I’m looking for an automation expert who can help building a forecasting and reorder system that automatically keeps all warehouses and sales channels stocked.
Scope - Collect inventory & sales data from Amazon (FBA DE, FBA UK, FBM) and JTL (3PL warehouse) - Forecast demand and calculate reorder points (ROP = daily sales × lead time + safety stock) - Automatically create and send purchase or production orders (PDF via email) to the OEM - Track ETAs, inbound shipments, and send alerts for low stock or delays - Google Sheets dashboard for live monitoring, order logs, and forecasting
Setup - n8n (preferred) or Python, optionally combined with Google Apps Script
Integrations: - Amazon API / Flatfile - JTL API or CSV - Gmail or SMTP for order emails - Google Sheets (for tracking & reports) - Modular structure to easily add new channels (e.g. Shopify) - Handles both single-level and multi-level BOMs (some kitting at 3PL, some at OEM)
Deliverables - Fully working automation (forecast → reorder → email) - Configurable lead times and safety stock - Google Sheets dashboard or alert system - Short documentation on how to extend SKUs or channels
Please include: - Your preferred approach (n8n, Python, or Apps Script hybrid) - Estimated time & cost - What data or API access you’ll need
I’m happy to pay more if we build something more solid and scalable together, but please note that payment is only made for working results. Looking forward to your proposals and ideas!
Diseño de Hardware IoT para PdM Category: Arduino, C++, Programming, Electrical Engineering, Electronics, Embedded Systems, Mechanical Engineering, PCB Design And Layout, PCB Layout, Product Design Budget: $250 - $750 USD
06-Nov-2025 11:02 GMT
Documents verification based in Kampala, Uganda. Category: Customer Service, Data Collection, Photo Editing, Photography, Project Management, Report Writing, Video Editing, Video Production Budget: $10 - $50 USD
06-Nov-2025 11:02 GMT
Real Estate Marketing Presentation Category: Article Writing, Business Development, Content Creation, Content Writing, Copywriting, Graphic Design, Marketing, Real Estate Budget: ₹12500 - ₹37500 INR
06-Nov-2025 11:01 GMT
消费电子产品 3D 建模 Category: 3D Animation, 3D CAD, 3D Design, 3D Graphic Design, 3D Modelling, 3D Print Design, 3D Rendering, Solidworks Budget: $10 - $30 USD
Data Analyst for Sales Optimization Category: Business Analysis, Data Analysis, Data Analytics, Data Collection, Data Management, Data Mining, Data Processing, Data Visualization Budget: $2 - $8 USD