
To move from Excel or a notebook to a POS, clean your product list (name, price, cost, barcode, category), count opening stock, choose the cut-over day, train your cashiers and run both systems for a few days if you can. A clean import saves days of typing and starts your reports with accurate data.
Key takeaways
- Clean the product list first.
- Count opening stock on a quiet day.
- Pick a cut-over date and train beforehand.
- Run in parallel for a few days if possible.
- Review reports in the first week.
01The move in six steps
- 01Clean the listOne row per product; consistent names, prices, costs and categories.
- 02Add barcodesUse manufacturer codes or plan labels.
- 03Count stockRecord opening quantities.
- 04ImportWe load the list into the POS.
- 05TrainPractice sales, voids and cash-up before go-live.
- 06Go liveSwitch on a quiet day and support the first shifts.
02Spreadsheet columns that help
| Column | Example |
|---|---|
| Name | Cooking oil 1L |
| Barcode | From the pack or ours |
| Category | Groceries |
| Cost price | What you pay your supplier |
| Selling price | What the customer pays |
| Opening stock | Quantity counted |
03Let us help
04Frequently asked questions
Can you import my Excel file?
Yes; we help clean and import it.
Do I need to stop trading to switch?
No; pick a quiet period and we support the cut-over.
What about old sales history?
Usually you start fresh; keep your old files for reference.
