How do I bring my products and customers over from another point-of-sale program?

Export your data from the old program, then open Settings, Import from another system, choose the file and press Read and analyse. The till shows how each column will be imported before anything changes. A backup is made first.

The import window after a file has been analysed.
The import window after a file has been analysed.
  1. In the old program, export products, customers and suppliers. CSV or Excel is the safest choice.
  2. Open Settings and the tile Import from another system.
  3. Choose the Exported file and press Read and analyse.
  4. The till reads the file and says what it recognised. For each table, choose what it is (Products, Customers, Suppliers, Categories, or not imported), and check which column feeds each field. Sample values are shown.
  5. Adjust if needed:
  • Prices: if prices come out 100 times too large, choose the division by 100;
  • Numbers use a decimal comma (12,50);
  • Update products and customers that already exist (same barcode, item code or phone);
  • Import stock quantities as opening stock (new products);
  • Import customer balances and loyalty points (new customers).
  1. Press Preview, read the warnings (products without a price, repeated barcodes, rows without a name), then Import now.

What it reads

Supported: CSV, Excel (.xlsx, .xls), JSON, XML, SQLite databases, SQL dump files, dBase (.dbf), Access (.mdb, .accdb) and ZIP files with any of these. Recognised directly: Loyverse, Square, Shopify, Lightspeed Retail, Odoo, uniCenta oPOS.

If the columns are not recognised

Enter a one-time Ironloom key and press Analyse with Ironloom AI. Only the table names, column names and 5 sample rows per table are sent to Ironloom; your full data stays on this computer. A key covers one migration and is bought on the Ironloom POS site.

Good to know

  • The file is read on this computer. Nothing is sent anywhere unless you choose the Ironloom AI analysis in the next step.
  • A full backup is made before importing. To undo the import, restore that backup in Settings > Backups.
  • Sales history of the old program is not imported: keep the old program’s reports for your records.
  • After importing, check a few products at the till and a few customer balances before trading.

For: Owner since version 1.0.2

Did this help?

Print this article · Contact support