Stock control

Importing stock levels and bins from a spreadsheet

When you move to PlanIt EPOS your products come in from price lists, and your stock comes in from one spreadsheet: a row per product with what is on the shelf. The same import shelves the whole catalogue if it has a bin column.

Where
Menu → Stock Management → Import stock levels
Who
Owners
Time
About 5 minutes
  1. 1

    Prepare the file

    A spreadsheet or CSV, one row per product, with a SKU or barcode that matches your catalogue and the quantity on the shelf. A cost column is optional and updates the product’s cost. A bin column is optional and sets where each product lives — a file with just SKU and bin is fine, and shelves the catalogue without touching quantities.

  2. 2

    Say which column is which

    Drop the file in. Each column is listed with its first row; tell the app which one is the SKU or barcode, which is the quantity, and the cost and bin if you have them. Press Match against the catalogue.

  3. 3

    Choose set or add

    Set stock to these quantities is for an opening count or a full recount. Add to current stock is for a delivery you have on a spreadsheet. The preview shows, for every matched product, on hand now, the figure in the file and the change.

  4. 4

    Check the summary and apply

    Rows in the file, matched, not matched, products changing, bins changing and the change in stock value are totalled before anything happens. Unmatched rows are listed so you can add those products first. Each change becomes a ledger movement in your name; nothing is deleted.

Questions merchants ask

My file has both a SKU and a barcode. Which should I use?

Whichever matches the catalogue most reliably. Barcodes are unambiguous; SKUs are easier to read if you are checking the preview by eye.

Can I run it more than once?

Yes. Set mode replaces the figure each time; Add mode adds on top, so use Set if you are re-running a correction.

Not covered here?

Ask PlanIt inside the app answers questions from your own data and opens the right screen. For anything else, support is a message away and goes to someone who understands trade counters.

Try PlanIt EPOS on your own counter

Fourteen days free, no card, set up in an afternoon. Or book a 30-minute demo with someone who understands trade counters and we will use your products, your pricing and your account customers.

Monthly subscription · No long-term contract · Onboarding included