← All work
E-COMMERCEIN-HOUSE

E-commerce Operations System

Operations software for a company that runs online sales for product distributors. It follows each order from the platform's purchase order to the shopper's door: the delivery, the invoice, the dark stores, and each sale in the app.

Interactive. One purchase order. Each line is matched to a product by its barcode, and the warehouse stock shows that two lines cannot be filled. The truck delivers to the platform, and the invoice is checked against the order. Vans then move the stock to three dark stores, and the products go live on the shopper's phone. Shoppers order across the city, and riders deliver inside 15 minutes. The system counts each sale and the stock left in each dark store. Press a stage to go to it. If you leave it alone, it runs the tour again. The names and numbers are demo data.

OPEN FULL SCREEN ↗

One order record, from the order to the invoice.

The business holds no stock and makes no deliveries. It lists the products, forecasts demand, manages orders, ads and promotions, and follows each order to the door. The data must be correct, because the client's sales figures come from it.

Orders, invoices and stock in separate files
One record for each order

The purchase order, the delivery and the invoice are on the same lines. You see what was ordered, what was delivered and what was billed.

A guess when a line does not match
An empty field with a red flag

If there is doubt, the field stays empty and the line is reported. The system does not invent a barcode, a price or a case pack.

Stock in cases, read as pieces
Pieces = cases × case pack

The case pack comes from the warehouse file. A pack written "1X12" means 12. Stock that is not known is never shown as 0.

A monthly report built by hand
A report made from the posted invoices

Sales by customer and by brand, the service level, the wins and the problems. AI agents write the briefs. A person sends the report.

Seven checks on each order.

The value of the system is in the checks. Each one stops a wrong number before it gets to a report.

  1. Each line is one product

    A line is matched by its barcode or by the platform's own code. A leading zero is the same barcode. A line with no match is reported as unknown.

  2. The lines equal the printed total

    The sum of the lines must equal the total on the order. A difference is recorded and shown. A line is never changed to make it fit.

  3. Numbers as on the invoice

    The invoice number, the date, the quantities and the totals must equal the paper. If the paper shows two numbers for one line, the system stops and asks.

  4. Short and missing lines are counted

    A line delivered with less than ordered is "short". A line not delivered is "out of stock". The same product missed on two orders goes to the client.

  5. Expiry is flagged early

    Stock with 60 days or less is red. Stock with 120 days or less is amber. When batches are merged, the lowest shelf life is kept.

  6. Dark-store stock and sell-out

    The system tracks the units on the shelf in each dark store and each sale to a shopper. Low stock in one store becomes a refill request to the client.

  7. A person sends

    The agents prepare the briefs and the monthly report. Nothing goes to a client until a person sends it.

Do your order figures come from three different files?

Tell us what you have. We tell you if there is a fit.

Tell us what you have