
Automated Purchase Order Flow (n8n or Python)
- or -
Post a project like this€115(approx. $135)
- Posted:
- Proposals: 19
- Remote
- #4435187
- Expired
Blockchain Developer, Technology, CV & Cover Letter Specialist and Creative & Business Systems Strategist
⭐⭐⭐⭐⭐ Top-rated freelancer/Full-Spectrum IT Services | Web & App Dev, Python, C, UI/UX, Graphic Design | Trusted & Affordable

2401736246460256231481197277827321961181845612404505113144125041591119264021074983012363338
Description
Experience Level: Expert
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!
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!
Florian L.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
23 Jan 2026
Germany
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-

Hi Florian,
Can you provide sample access to your Amazon FBA/JTL accounts or CSV exports so I can verify API connectivity and data structure before finalizing the workflow?
Thanks
Naresh
1140819
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies