Product & Opening Balance Migration
BangiPOS engineers clean, format, and import your existing spreadsheets, handwritten stock books, or legacy POS CSV exports into BangiPOS so you launch with accurate opening quantities, supplier unit costs, and customer receivable balances on day one.
Kampala On-Site & Remote Screen-Share · Direct Engineer Guidance
How product & opening balance migration runs
- 01
Export & Audit
Inspect your existing spreadsheet for blank prices, duplicate barcodes, and text typos.
- 02
Schema Normalize
Align units, brands, expiry columns, and supplier names to clean BangiPOS fields.
- 03
Sandbox Import
Test import into a staging database and verify stock valuation sum matches.
- 04
Production Cutover
Load validated catalogue into your live counter computer before morning opening.
What is included — and what falls outside base scope
Included Deliverables & Prerequisites
- Template mapping and deduplication of SKU names and barcodes
- Import of cost prices, retail prices, reorder minimums, and expiry dates
- Opening supplier payables and customer debt/credit balances (where clean records exist)
- Validation report matching imported total stock value against your spreadsheet
- Product spreadsheet (.xlsx, .csv) with product name, selling price, cost price, and quantity
- Store freeze window during final import so live counter sales do not shift mid-upload
Explicit Exclusions
- —Reconciling missing historical years of unrecorded paper receipts from scratch
- —Cracking encrypted databases belonging to proprietary third-party vendors
Frequently asked questions
Direct operational answers verified against current BangiPOS capabilities.
Can you migrate my data if I currently track items only in WhatsApp or Excel?+
Yes. We provide a clean Excel template, help clean duplicate item names, and import everything accurately before go-live.
What if most of my shop products have no barcodes?+
BangiPOS generates clean internal SKUs during import so unbarcoded items can be searched rapidly or tagged with barcode stickers.
Written by Bangi Integrated Technologies Editorial Team · Reviewed by BangiPOS Systems Engineering Desk · Updated November 2026.
Ready to schedule your store onboarding?
Speak with our technical desk on +256 701 175 101 or submit a request call so we prepare your installer and CSV templates.