Switching POS without re-typing your products
The biggest fear when changing point of sale is a week of typing. What you can bring over from your old system or spreadsheet, what you cannot, and a step-by-step plan that keeps the shop open.
Many shops already have their products, prices and customer balances in a spreadsheet. With an hour of tidying and a careful import, that file becomes a working till before lunch. A plan, hour by hour.

A surprising number of shops in the UAE run on a spreadsheet: one sheet of products with prices, one of customers who owe money, one of suppliers. It works until the shop grows: two people edit the file, a price changes on the shelf but not in the sheet, and nobody knows which copy is the latest.
The good news is that the spreadsheet is already most of the work of starting a till. Our article on switching from another POS covers moving from an old system. This one is for the Excel shop, and it fits in a morning.
Never import your only copy. Save a copy of the file, then in the copy:
Do the same for the customers' sheet (name, phone, balance owed) and suppliers (name, phone, balance you owe).
Open the import, choose the file and look at the guess for each column: what the system thinks it is, and why. Correct the ones it got wrong. Then read the dry run before anything is written: how many products will be added, updated or skipped, and why each skipped row was skipped.
A typical first dry run finds a few dozen problems: prices with text, missing names, two products with one barcode. Fix them in the file, not one by one in the till, and run the check again.
Import the customers with their balances on a chosen date — the morning you start. Each balance becomes an "opening balance" line on the customer's account, so the statement starts with the right figure. The same for suppliers.
Do not import old sales. They belong in the old file, which you keep.
Your spreadsheet's quantities are probably approximate. Import them as opening stock, then spend half an hour counting the fifty products you sell most and correcting those. The rest can be counted shelf by shelf over the following weeks. See a stock-take that adds up.
Before customers see the new till, ring up ten typical baskets: a scanned product, a product without a barcode, a weighed item, a customer on account, a return. Check the receipt and the stock after each. Fix the printer and the drawer now, not at 6 p.m.
Keep the spreadsheet for reference, read-only. From now on, prices change in one place.
An import is one batch. If you notice the next day that the prices column was mapped to cost, undo the whole import and run it again rather than fixing a thousand products by hand.
Bring your data is in every plan of CreekPOS Online: Excel (.xlsx), CSV, TSV and TXT files, headings in English, Arabic, Hindi or Urdu, a guess for every column with its reason, a dry run with its findings, opening balances and stock, and undo within 30 days. No file? Download the empty template in your language. See the manual chapter and the features page.
This article is general information as of its date, not legal or tax advice. Rules change; check the official source or ask your accountant before acting.

The biggest fear when changing point of sale is a week of typing. What you can bring over from your old system or spreadsheet, what you cannot, and a step-by-step plan that keeps the shop open.

How to plan and run a stock-take in a small UAE shop in one evening, with zones, two-person teams, recounts and variance valued at cost, so the numbers can be trusted.

Moving from an old cash register, a notebook or an Excel sheet to a POS takes one weekend if the product list is ready first. A two-day plan for UAE shops.
CreekPOS Online free for 14 days, or the program on your PC for 14 days. Every feature, no card.
See also: when the spreadsheet stops being enough
Search by feature, screen or task. Open a guide and share its link with your team.