AI-CLOUD.GR

We work with leading AI providers.

ClaudeGeminiOpenAIAWSVertex AIDatabricksDeepSeekCerebrasQwenStability AI

Guide

How to stop using Excel for stock without stopping the business

Excel is a very good tool for getting a warehouse started. At some point, though, the file itself becomes the problem, with two versions going round, a wrong formula and only one person who knows how it works. This guide shows how to tell that the time has come and how to make the move without risk.

First the honest answer: you may not need to

With a few items, a few movements a day and one person keeping the file, Excel is enough. No software will spare you from recording every movement, because you need to do that anyway. Stay with Excel and take another look at the signs below in a few months.

The signs that Excel is no longer enough

  • More than one person writes in the same file, and at some point there are two “latest” versions.
  • You also sell online, and the web shop takes orders for goods that have already run out.
  • Stocktaking turns up differences nobody can explain.
  • To find out what sells, someone spends an afternoon on filters and pivot tables.
  • Only one person understands the file, and when they are away the warehouse waits.
  • You cannot see who changed a number, or when.

Step 1: import the sheet as it is

Do not start by cleaning the spreadsheet to fit some template. The table of items and stock is imported as it is, with your own columns and names. Duplicates and gaps appear in a list once the import is done, and you fix them from there.

Step 2: run both in parallel for a while

For a while every movement is recorded both in the software and in the spreadsheet. It means double work, but it is the only way to see that the software gives the same numbers before you hand the warehouse over to it. Once the two have agreed for a few weeks in a row, you can close the spreadsheet.

Step 3: one stock count to lock in the start

On the day the software becomes the only source, count the goods, or at least the items that move most. The software puts the system figure and the counted one side by side and lists the differences. From then on you work with clean numbers.

Step 4: one rule for the team

What takes longest is getting the team used to recording every movement as it happens. A simple rule such as “nothing leaves the warehouse unless it is written down” does more good than any feature of the software.

What you gain

  • Stock that everyone can see, each as far as their role allows, with no copies of files.
  • A history of every movement showing who did what and when, which is never erased.
  • The online shop and the warehouse stop disagreeing.
  • You ask in plain words instead of wrestling with filters, e.g. “which items did not move this quarter”.
  • The data is yours and you can take it back out as a table whenever you like.

Where to go next

If you do not even have a spreadsheet yet, start with the guide how to keep track of stock in a shop. If you are ready for software, see warehouse software or, if you sell to trade customers, inventory and sales software. If you want us to do the move, see Services. If you are thinking of building it yourself with a chat, first read what is missing when ChatGPT writes the program.

Frequently asked questions

Do I have to tidy the spreadsheet before importing it?

No, you import it as it is. Any duplicates or gaps appear in a list afterwards and you fix them from there.

How long should the parallel run last?

As long as it takes for the two figures to agree without surprises, which is usually a few weeks. After that there is no reason to keep going.

Can I go back to Excel if it does not suit me?

Yes. You can export the data as a table whenever you like, and the software’s code belongs to you.

How much does the move cost?

You do not sign up to a subscription, and the cost is the same however many people in the warehouse open the software. You pay with credits bought in advance and spent with use, plus a daily hosting fee for each active project (see Pricing). If you want us to do the move, ask for a quote.

Upload your spreadsheet as it is

You sign up for free, with no card. Describe how your warehouse runs, upload the sheet you already keep and see what software comes out of it.