Migrating to Compazz POS from Busy 21, Atrex, QuickBooks POS & Legacy Nigerian Systems
The authoritative field mapping, export sanitisation, and cutover runbook for retail owners, pharmacy managers, and accountants transitioning from legacy desktop systems to Compazz.
No More Desktop Database Crashes
Say goodbye to corrupted Microsoft Access or Visual FoxPro files from sudden power cuts. Compazz stores local cache safely in browser/desktop IndexedDB and syncs to cloud automatically.
Multi-Branch Real-Time Control
Replace manual nightly email transfers and phone reconciliations. Monitor register activity, sales, variance, and stock across all branches live from your phone.
AI Anomaly & Theft Prevention
Tired of suspicious line voids, unrecorded cash transfers, and missing stock? Compazz logs every cashier action and flags unusual shrinkage patterns immediately.
Select Your Current Software System
Click your existing system to view specific export instructions, column mapping rules, common traps, and copyable CSV templates.
Busy 21 / Busy Accounting
Dominant in Alaba, Idumota, Trade Fair, and Kano for auto parts, pharma distribution, and electronics.
Core Export Traps in Busy 21 & How to Fix Them
Barcode vs Item Alias
Standard Item Master exports omit barcodes or place them in the Item Alias column.
Item Code and Item Alias. Compazz maps Alias straight to barcode.Cost Price Exporting 0.00
Exporting standard Cost without inventory recalculation leaves costs at 0.00, ruining Compazz gross margin reporting.
Last Pur. Price or Avg Cost.Dual Unit Multiplier Blowout
If Busy tracks in Cartons but your POS sells by Piece, exporting Main Units causes a 24x inventory shortfall.
Step-by-Step Export Instructions from Busy 21
- Log in to Busy 21 with administrative access.
- Go to: Display > Inventory Summaries > Godown-wise Stock Status.
- Select the specific Godown representing the Compazz outlet you are setting up.
- Press Alt + P (Print) and choose Export to File > MS Excel or Delimited Text.
- Under column layout, select:
Item Name,Item Code,Item Alias,Item Group,Sale Price,Last Pur. Price,Closing Qty, andMin. Level. - Save the file and upload directly to Compazz. Compazz automatically detects Busy headers.
Item Name,Item Code,Item Alias,Item Group,Sale Price,Last Pur. Price,Closing Qty,Min. Level "Emzor Paracetamol 500mg 10x10s","EMZ-001","8901234567890","Analgesics",1500,1100,85,15 "Lonart DS Tablets 6s","LON-002","8909876543210","Antimalarial",3200,2650,42,10 "Amoxil 500mg Capsules 100s","AMX-003","8904561237890","Antibiotics",4500,3750,28,8 "Dettol Antiseptic Liquid 250ml","DET-004","5000123456789","Toiletries",2200,1780,30,5
Master Field Mapping Matrix
How Compazz's intelligent ingestion engine matches source headers from each platform.
| Compazz Target Field | Type | Busy 21 Header | Atrex POS Header | QuickBooks POS | Retail Man | Implementation Notes |
|---|---|---|---|---|---|---|
| Product Name (name)Required | Text | Item Name | Description | Item Name | Details | Preserve brand, strength, and unit (e.g., Panadol Extra 500mg 10x10s). |
| SKU (sku)Required | Text (Unique) | Item Code | Stock Code | Item Number | Part Number | Unique internal product code. Auto-generated if left empty. |
| Barcode (barcode) | Text (Scannable) | Item Alias / Barcode | UPC / Alt Code | ALU / UPC | Barcode | Scanned at checkout. ALU or Item Alias often contains the real barcode. |
| Selling Price (unit_price)Required | Currency (NGN) | Sale Price / MRP | Price A / Price 1 | Regular Price | Sell Price | Standard POS retail selling price in Naira. Compazz strips ₦ and commas. |
| Cost Price (cost_price) | Currency (NGN) | Last Pur. Price / Avg Cost | Average Cost / Last Cost | Order Cost / Avg Cost | Buy Price | Essential for accurate gross margin and End-of-Day profit analytics. |
| Stock Quantity (quantity_on_hand)Required | Number | Closing Qty / Balance | Quantity On Hand | Qty On Hand / Qty 1 | In Stock | Physical on-shelf count for the destination outlet. Replace negatives with 0. |
| Category (category) | Text | Item Group | Category / Department | Department | Group | Category for reporting and till filtering. Hierarchies are automatically flattened. |
| Reorder Level (reorder_level) | Number | Min. Level | Reorder Point | Reorder Pt | Reorder Level | Triggers low-stock warnings and WhatsApp automated reorder alerts. |
The 7 Golden Rules of Clean POS Migration
Complete these checks before clicking import to guarantee 100% data integrity on Day 1.
1. Declare an Inventory Movement Freeze
Never export data while cashiers are actively selling or storekeepers are receiving goods. Announce a stocktaking freeze after closing or before opening.
2. Spot-Check Top 20 Fast Movers Physically
Count your top 20 revenue-driving items on the shelf. If the software count diverges from physical reality, correct it in the file before importing.
3. Purge Negative Stock Numbers
Replace negative numbers like -4 or -12 with 0. Compazz enforces strict stock accountability and prevents phantom negative balance distortions.
4. Backfill Missing Cost Prices
Ensure every row has an accurate cost price. Compazz uses cost prices to compute live gross profit, cashier shrinkage variance, and tax totals.
5. Audit Duplicate Barcodes
Ensure no two distinct items share the same barcode. If a product lacks an authentic manufacturer barcode, leave it blank; Compazz will identify it by unique SKU.
6. Separate Quantities by Outlet Branch
For multi-store retailers (e.g. QuickBooks Multistore or Busy multi-godown), export separate CSV files for each branch so branch counts stay clean.
7. Retain an Unedited Legacy Archive Backup
Always save the original, unmodified export and database backup (.bak, .dbf, .qbw) on external storage before running cleanups.
How to Import Your Cleaned File into Compazz
Compazz provides two flexible pathways for ingestion: the Web Dashboard for bulk initial setup and the POS app for offline floor loading.
Web Dashboard Ingestion
Recommended for store owners and accountants
- 1.Log in at app.compazz.app and verify the destination outlet is active in the top selector.
- 2.Navigate to Inventory > Products in the sidebar.
- 3.Click Import Products in the top action bar.
- 4.Drag and drop your
.csvor.xlsxfile. Compazz auto-detects column headers. - 5.Review the preview table and click Start Import. Batches process automatically with an error/warning audit log.
POS Till / Tablet Ingestion
For retail terminals, Windows touchscreens & iPads
- 1.Open the Compazz POS application on your Windows PC, Mac, iPad, or Android tablet.
- 2.Log in with Manager or Owner staff credentials.
- 3.Tap Products > Import / Sync in the management drawer.
- 4.Select your spreadsheet from local device storage or an attached USB drive.
- 5.Items are loaded straight into local offline IndexedDB and synced to cloud in the background.
Frequently Asked Migration Questions
Why does Busy 21 export cost prices as 0.00?
Busy 21 relies on an inventory valuation recalculation engine. If transactions, batch receives, or opening stock were posted without running "Housekeeping > Recheck Inventory Valuation", the cost price column will output 0.00. To resolve this, run inventory recalculation in Busy or select the "Last Pur. Price" column during export.
How do I fix the broken rows in Atrex "Stock-by-Code" exports?
Do not print the "Stock-by-Code" report to a text file. The report generator includes page headers, dashed divider lines, and text word wraps that shatter rows in Excel. Instead, use "File > Maintenance > Data Export > Inventory Items" to export a clean, unpaginated comma-delimited CSV file directly from the database.
How do I import QuickBooks POS Multi-Store quantities into Compazz?
QuickBooks POS Multistore exports inventory with distinct columns: Qty 1 (HQ), Qty 2 (Branch 2), Qty 3 (Branch 3), and Total Qty. Create separate CSV files for each branch: keep the product metadata, rename that specific branch's quantity column to "Quantity On Hand", remove the other branch columns, and upload into the corresponding Compazz outlet.
Will Compazz accept Naira currency symbols (₦) and commas in my Excel file?
Yes. The Compazz inventory importer automatically strips Naira signs (₦, NGN), dollar signs ($), and formatting commas (e.g. "₦1,500.50" parses cleanly as 1500.50). It also normalizes boolean status fields and trims accidental leading/trailing spaces.
What happens if two products have the same barcode?
Compazz enforces unique barcode constraints to prevent cashiers from scanning one item and accidentally billing a different product. During import, the first product with the barcode is accepted, and subsequent duplicates are flagged in the import summary report so you can correct them.
Can I import directly from my smartphone or tablet POS?
Yes. While the Compazz Web Dashboard offers comprehensive preview mapping on desktop, the Compazz POS app on Android, iPad, Windows, and macOS also includes a direct file importer under Products > Import / Sync.
Need Hands-On Migration Assistance?
Migrating a high-volume supermarket (10,000+ SKUs), complex pharmacy chain, or legacy multi-store network? Our dedicated Nigerian implementation team can inspect your database exports, sanitize your pricing, and perform the cutover for you.