Export stock and sales from your ERP
Run the item export you already use: item number, available stock and one column per month of sales. Add customer orders, incoming orders, carton size, purchase price and supplier if your ERP has them. Exact, AFAS, SAP Business One, Microsoft Dynamics, Odoo or any system that writes Excel or CSV will do.
Drop the file on the Import screen
POplanner finds the columns by name in English, German or Dutch and shows how it read each one. Next month it remembers your choices, keeps your decisions and adds the new month of sales.
Review the plan
Each item shows months of stock today and after the order. Items below your reorder point get an order quantity that tops up to your cover target, rounded to full cartons. Open any line to see the sum and change it.
Work through the checks
Spikes, stock-out months, one-customer items and odd purchase prices each get a card. Keep the safe quantity, use the formula or set the line to zero. POplanner reminds you before export if a flagged line is still open.
Check the season dates and export the orders
Seasons ahead shows which order has to leave this week by sea, and which can still go by air. Then export one Excel file per supplier, most urgent lines first, ready to email. Log what you ordered in the PO tracker.
From ERP export to supplier orders in five steps.
The monthly purchase run in POplanner, start to finish. The first time we go through it with you. After that it is the same five steps each month.
poplanner.app/app
OverviewWaiting for your exportOrdering for: All suppliersImport
Drop your stock and sales exportExcel or CSV, straight from your ERP
Reading stock-and-sales-sep.xlsx
- 14 of 14 columns recognised
- 111 items from 4 suppliers
- Sales from Oct 2024 to Sep 2026
- Stock, reserved and on order
stock-and-sales-sep.xlsx
Purchase plan · Sep 2026 snapshot
70 lines to order across 4 suppliers
Order value€06,282 units
Lines to order0of 111 items
Suppliers0one order each
Stock after ordering0.0 moyour target: 5 months
Before this order33 of 111 items stocked for 5 months
After this order103 of 111 items stocked for 5 months
StockedNeeds an orderMore than enoughNo sales yet
Open planReview orders
BBBrightblock Toys21 lines2,140 u€34,880Checked
PPPuffin Plush Co.24 lines2,310 u€18,906Checked
TWTidewater Puzzles & Games17 lines1,402 u€16,740Checked
SFSparkfield RC & Science8 lines430 u€16,500Checked
70 lines · 6,282 units · €87,026 · full cartonsExport all
READY TO SEND
Brightblock.xlsxPuffin-Plush.xlsxTidewater.xlsxSparkfield.xlsx
Try steps 3 to 5 now with a sample toy wholesaler. Open the demo.
Next order
Your next order, worked out line by line.
Open the demo with a sample toy wholesaler, or ask for a walkthrough with your own export.
Sample data, nothing to uploadNothing to installYour ERP stays untouched
Brightblock Toys21 lines · ready
Puffin Plush Co.24 lines · ready
Tidewater Puzzles & Games17 lines · ready
Sparkfield RC & Science8 lines · ready
Stocked for 5 months103 of 111 items