HomeProjectsA stock control app

Demo

Stock control app for a shop

Try a stock control app built for a shop: you record what comes in and what you sell, and it tells you when it is time to reorder. The shop, Sa Botiga de Prova, is made up; the app really works (the demo is in Spanish).

When the stock does not add up

A shop selling Mallorca products sells over the counter and on its website. One summer Saturday the sobrasada runs out in the shop, but the website keeps offering it, and on Monday someone has to write to the customers who bought it to apologise. Nobody recorded the last box that went out, or they recorded it somewhere else.

Many shops start with an Excel sheet, and that is a fine way to start. The trouble comes when several people edit the same file, when online sales do not lower the stock by themselves, or when you want the reorder alert on your phone.

Ready-made inventory software solves much of this, and for many shops it is enough. If the way you work does not fit it, an app of your own does only what you need, with your names and your steps.

What you can try in the demo

  • Products and their stock

    Fifteen sample products, each with its code, unit, minimum and current stock. On a phone, every product shows as a card.

  • Deliveries and sales

    You record what arrives from the supplier or what you sell, and the stock changes at once. If you try to sell more than is left, the app will not let you.

  • The reorder alert

    When a product reaches its minimum or drops below it, «Reponer» (reorder) appears, and the top of the page shows how many products need it.

  • The history

    Every movement, newest first, and you can show only those of one product.

  • Search and download

    Search by code or name, with or without accents, and download the list as a spreadsheet that opens in Excel.

  • Start again

    One button brings back the sample data. Nothing you do is saved or leaves your browser.

How it is built

It is an app you use in the browser, on the shop's computer or on a phone, with nothing to install. It follows the same rules as a good spreadsheet: stock is what comes in minus what goes out, and the alert goes off at the minimum.

In a real version, the data lives on a server with backups, and each person signs in with their own user, so you always know who recorded each movement.

If you sell online, the app can lower the stock with every order: online shops such as WooCommerce and Shopify let another program read and change the stock of their products.

What a real version adds

  • Your products, imported from your Excel file.
  • Several people at once, each with their own user.
  • Stock that drops by itself with every sale in your online shop.
  • Alerts on your phone when something drops below its minimum.
  • Barcodes read with the phone's camera.

How long it takes

Simple internal tool: 3-6 weeks

Counted from when we have your material: texts, photos and access to accounts. Exact dates go in the written proposal.

Learn more: Custom apps

Frequently asked questions

Is it a real business?

No. Sa Botiga de Prova does not exist: it is a made-up business that shows how we work. The names, data and prices in the demo are samples.

Can I move my Excel file into the app?

Yes. If your products are in a spreadsheet, we import them at the start, with their codes and minimums, and check with you that the stock adds up before you leave Excel behind.

Does it work on a phone?

Yes, in the phone's browser, with nothing to install. Try the demo on your phone: every product shows as an easy-to-read card.

Does it connect to my online shop or my till?

With the most widely used online shops, yes: they let programs read and change the stock. With the till it depends on the model and on what its maker allows; we look at it with you on the first call.

Can we meet in person?

Yes, we can set a date in the video call.

Learn more

Shall we talk about your project?

Tell us what you need and we'll explain how we would do it, with no commitment.

Book a free call