
Order Management Hub: from Excel to one system for orders, suppliers and the warehouse
Real-time orders from PrestaShop, allocation by supplier, automatic emails with cutoffs, picking and checks, for 70–100 orders a day.
Industry
Multi-supplier e-shop
Platform
Custom web
0 Excel
the whole flow in one system
7
sales reps, each with their own view
Cutoff
no supplier order sent late
The client
A PrestaShop e-shop with 70–100 orders a day, dozens of suppliers, 7 sales reps who each manage their own suppliers, and sales through Skroutz as well.
The need
Every order was copied into Excel. Sales reps emailed each supplier by hand, picking lists were written on paper and order statuses were changed in the e-shop one by one.
As volume grew, so did the errors: supplier orders that missed the cutoff, products nobody knew which supplier they belonged to, and customers left waiting without updates.
Order Management Hub: from Excel to one system for orders, suppliers and the warehouse
The solution
We built a central system that does not replace any of the business's tools; it connects them.
Orders in real time
Every new order arrives automatically from PrestaShop, with all its lines. Each line is matched to its supplier. Anything without a supplier is shown separately for matching, so nothing gets lost.
Suppliers without manual emails
The system groups lines by supplier and builds the order email from a ready template. Every supplier has its own cutoff time, and the dashboard shows who is on time, who is closing soon and who has passed.
Warehouse, picking and checks
Anything in stock goes straight to picking; anything missing goes to "To order". The warehouse logs deliveries, the picker ticks off each item, and the order is checked before it ships. The status updates in the e-shop automatically.
Features
01
Dashboard
Today's orders, to invoice, to check, lines without a supplier, and cutoffs per supplier.
02
Automatic import
PrestaShop orders arrive in real time, and order history was migrated.
03
Allocation by supplier
Every line to the right supplier and the right sales rep.
04
Supplier emails
Automatic, from templates, with alerts before the cutoff.
05
Warehouse
Stock, deliveries, Skroutz stock import from file.
06
Picking & checks
A list per order, a tick per item, confirmation before shipping.
07
Status sync
PrestaShop statuses mapped to the warehouse flow.
08
Activity log
Every change recorded with user and time.
How it works
1
New order
Arrives from PrestaShop.
2
Allocation
Lines by supplier and sales rep.
3
Stock or order
In stock goes to picking, missing goes to To order.
4
Supplier email
Sent before the cutoff.
5
Delivery
The warehouse logs what arrived.
6
Picking & checks
A tick per item, confirmation.
7
Invoicing & shipping
The status updates in the e-shop.
User roles
Administrator
settings, suppliers, users, history
Sales rep (×7)
only their own suppliers, sending orders
Picker
picking list, a tick per item
Viewer
read-only for reports
Integrations
- PrestaShop

- Skroutz
What we delivered
- Web app with roles
- Real-time PrestaShop integration
- Order history migration
- Supplier email templates
- Status mapping
- Activity log
- Training
How we worked
Καταγραφή της ροής με την ομάδα
Αντιστοίχιση όλων των καταστάσεων παραγγελίας
Υλοποίηση σε κύκλους
Παράλληλη λειτουργία με το Excel μέχρι να σταθεροποιηθεί
Υποστήριξη και βελτιώσεις
Next steps
Automatic customer updates on every status change and performance reports per supplier.

Next app
E-shop with physical stores — Inter-store transfers on PDAs, without internet, with document matching and ERP sync
Contact
Let's talk about your next step.
Tell us where you are today. We'll get back to you soon with a first proposal.
210 9951416 · (718) 784-5255
