BangiPOS Desktop|$1,200 Lifetime Licence or $20/month · Installed offline POS & inventory management.
BangiPOS - Own Your Business
Inventory & Stock Control · 6 min read

Preparing a Product Spreadsheet for Clean POS Import

Clean spreadsheets guarantee clean POS reporting from hour one. Structure every item on one flat row containing SKU Code, Barcode, Clean Item Name, Category, Unit, Purchase Cost Price, Retail Selling Price, Wholesale Price (if used), Current Quantity, and Reorder Minimum — removing currency letters (`UGX`), merged cells, and duplicate rows before upload.

Author: Bangi Integrated Technologies Editorial Team · Reviewed by BangiPOS Systems Engineering Desk · Updated 2026-11-11

Six spreadsheet errors that silently corrupt first imports

Excel often turns 13-digit EAN barcodes into scientific notation (`8.90123E+12`), ruining scanner recognition forever if saved improperly as text. Format barcode columns explicitly as Text before pasting factory digits.

Common mistakes to avoid

  • —Saving Excel files after Excel silently mangled 13-digit barcodes into `E+12` scientific numbers.
  • —Leaving Cost Price equal to zero across half the sheet, making initial Profit Reports falsely report 100% margins.
Key Reference Summary

Quick evaluation comparison

Excel ColumnCorrect Clean FormatBroken Format to Fix
BarcodeText format: `6291041002314`Scientific notation: `6.29104E+12`
Cost & Sell PricePure digits: `25000`Mixed text: `"UGX 25,000 /="`
QuantitiesValid zero/positive integer or mlText notes like `"about half bottle"`
Questions & Answers

Frequently asked questions

Direct operational answers verified against current BangiPOS capabilities.

Can BangiPOS engineers check my Excel sheet before installation day?+

Yes. Book Data Migration (/services/data-migration/) or send sample rows to our onboarding engineer so schema errors are fixed beforehand.

Continue exploring related workflows

Written by Bangi Integrated Technologies Editorial Team · Reviewed by BangiPOS Systems Engineering Desk · Updated November 2026.

See this exact workflow tested live on your products

Share a few SKUs or your shop scenario with our Kampala specialist team.