Ecommerce & retail / Connected operations
Know what to reorder before stock becomes a problem.
Sales, stock commitments, incoming deliveries and supplier rules come together in a replenishment process the buyer can follow.
Explore the project
What changed
Consistent stock checks and prepared supplier orders, with the reasoning behind each recommendation visible.
01 / The problem
Where things got stuck.
The buyer exported sales, checked inventory, looked up supplier lead times and investigated open purchases before preparing each order.
Available stock, reserved units, draft purchases and confirmed deliveries were easy to confuse. By the time the information was assembled, the position could already have changed.
02 / What we built
What we built.
We connected Shopify, inventory records, supplier settings and purchasing through a scheduled n8n workflow with explicit calculation rules. Recommendations retain the stock, demand and lead-time information behind them.
Approved repeat purchases can be issued within agreed limits. Unusual demand, new suppliers and larger purchases become drafts for the buyer. Issued orders, confirmations and receipts feed subsequent checks without treating a draft as stock on the way.
03 / How it works
Connected from
start to finish.
- 01
Bring stock together
Combine sales, available units, commitments and existing orders.
- 02
Calculate the need
Apply demand periods, lead times, minimum quantities and pack sizes.
- 03
Choose the path
Issue authorised repeats or prepare a draft with the calculation attached.
- 04
Keep it current
Feed supplier confirmations, delays and receipts into the next stock check.
04 / The difference
A better working day.
Before
- Sales and stock figures were assembled manually.
- Incoming purchases needed separate investigation.
- Order reasoning was difficult to reconstruct.
After
- Scheduled checks assemble a consistent planning view.
- Drafts, issued orders and confirmed deliveries stay distinct.
- Recommendations retain their inputs and calculation basis.
05 / Inside the build
The details that
make it dependable.
Only approved suppliers and repeat purchases within quantity and spending limits qualify for automatic ordering. The buyer can adjust or hold a recommendation. Missing supplier settings and uncertain product matches are flagged before purchasing. Existing recommendations and purchase references prevent repeated orders for the same shortage. The core calculation does not require AI.
- Shopify
- Sales activity and product identifiers
- Inventory database
- On-hand quantities, reservations and receipts
- Google Sheets
- Supplier lead times, pack sizes and ordering rules
- n8n & calculation service
- Stock checks and explained recommendations
- Purchasing system
- Drafts, issued orders and supplier references
- Slack
- Buyer notifications and exceptions
