# Stock list imports that get the numbers right

Shipped · September 24, 2026 · 1.28.3 · Inventory, Suppliers and invoices

Prices written with a decimal comma, in brackets or as 1.5E+3 now import as the numbers they are, and a batch that fails part way can be undone from its own card.

![Bulk add after Add all on a 214-row stock list whose second batch lost its connection part way: its card says so and offers Try again and Undo, under a reply that read case costs written with a decimal comma and named the rows it left unset.](https://handbook.company/marketing/updates/stock-list-imports-that-get-the-numbers-right.webp)

## Numbers that were read wrongly

The importer used to keep the digits and the decimal point in a price and throw the rest away. That works for $8.00 and quietly goes wrong for a lot of what real exports contain. A price of 8,50 in a file that writes decimals with a comma came in as 850. A date that had ended up in a price column came in as a price of several million. A pack described as 2024/25 pack of 12 was read as a pack of 2,024, so the price of the pack was divided by 2,024 instead of 12.

Each file is now read the way it was written. Whether it uses decimal commas is worked out from its own number columns, a price in brackets is read as a negative, and Excel's scientific notation is read as the number it stands for. A negative price or count cannot be stored, so it is left out and named back to you rather than dropped without a word. Dates, fractions and percentages in a number column are left unset rather than guessed at. Pack sizes are read in more of the ways people write them, such as Case of 12, 12 pk, each, and a distributor's 6/1 GAL, and one that still cannot be read leaves that item's price unset and is named back to you so you can fill it in. Checked against a real 278-row stock list and our 300-row test file, not one of their 3,768 numbers and pack sizes changed.

## A batch that fails part way

Bulk add and the setup wizard show each batch on a small card of its own. When a batch failed part way through, some of it was already in your handbook, and the card had no way to take it back out: Dismiss was refused, because dismissing would have left those rows behind with no way to undo them, and there was no Undo. The message pointed you at the card for details, and the card had none.

The card now says why the batch failed. Try again carries on from where it stopped rather than starting over, and Undo takes back whatever it added.

## Lists with many storage areas

An import is split into batches for you to review, and a batch can name up to 20 storage areas. Batches used to be split by item count alone, so a list whose items were spread over more places than that produced a batch that could not be approved, with no way round it. Batches are now split so that each one fits, however the list is laid out.

A list that keeps the same items in two places, such as a walk-in and a front counter, no longer gets a warning that the batches cover only part of the file.

## Suppliers the file does not name

Exports write (Multiple) in the supplier column for something bought from several vendors. It used to be imported as a supplier called (Multiple), with every one of those items linked to it. Those items now come in with no supplier, and are named back to you so you can link the suppliers you really use.

## Undoing a repair

Uploading a list again fills in stock levels that were left blank. Undoing that upload now leaves alone any level you have changed since, instead of blanking it along with the ones the upload filled in.

Source: https://handbook.company/updates/stock-list-imports-that-get-the-numbers-right/

---

The Handbook Company (https://handbook.company), built by Beanchain Coffee LLC. Please attribute quotations to The Handbook Company.