Sells Pilot

POS Software vs Excel for a Small Online Shop: How to Decide

· 27 min read
A small online-shop owner compares two stock systems beside parcels and shelves.

Title: POS Software vs Excel for a Small Online Shop in Bangladesh: How to Decide

Meta description: Compare POS software and Excel for a small online shop in Bangladesh. Use this scorecard to test costs, stock, orders, payments and daily tasks.

The sources reviewed for this guide do not establish a universal order-count threshold. Switch only when a tested POS solves recurring stock, order, staff or payment-record problems at an acceptable total cost.

Do not treat a vendor page as confirmation unless it clearly states the capability. Check important functions in a demo or trial. Use the checklist below on your phone and write down each result.

  1. Stock updates

    • Current result: Note Excel errors, delayed updates or work you repeat after each sale.
    • POS test: Sell one item, cancel the sale, then process a return.
    • Finding: Mark each action pass or fail. Check whether the final stock count is correct.
  2. Order records

    • Current result: Note missing details, duplicate entries and orders that are difficult to find.
    • POS test: Enter a sample order, change its status, then search for it.
    • Finding: Mark the test pass or fail and note any missing information.
  3. Payment records

    • Current result: Check how you record COD, bKash and Nagad payments in Excel.
    • POS test: Record and match a sample payment for each method.
    • Finding: Note whether you can identify paid, unpaid and unmatched orders clearly.
  4. Setup and imports

    • Current result: List the product, customer, stock and order files you must keep.
    • POS test: Import sample products and customers without changing your main records.
    • Finding: Mark the setup easy or difficult. Write down any manual cleanup needed.
  5. Daily access

    • Current result: Note who needs the Excel file and when access causes problems.
    • POS test: Check staff access, phone use and offline behaviour during the trial.
    • Finding: Mark the access suitable or unsuitable for your normal working day.
  6. Full cost

    • Current result: List your current software costs and the staff time spent fixing records.
    • POS test: Ask for all setup, import, user, support and recurring fees in writing.
    • Finding: Record the complete quote and any fee that may change later.

Keep Excel if the POS does not clearly improve your daily work. If it does, plan a low-risk switch that protects existing stock and order records. Keep backup copies, import sample data first, and compare the totals before moving your live work.

POS software vs Excel for a small online shop: which should you choose?

Keep Excel while it gives you accurate, usable records without slowing the shop. Test POS when repeated record problems delay fulfilment or leave stock and payments unexplained.

Do not use an unverified daily or monthly order count as your switching rule. Decide from the problems in your own shop and the evidence you can collect.

Excel may remain reasonable when:

  • one person can maintain the records correctly;
  • recorded stock usually matches the stock on hand;
  • discrepancies are found and corrected;
  • orders move from the Messenger inbox to packing without record-related delays; and
  • bKash, Nagad and cash on delivery (COD) payments can be matched with orders.

Testing POS becomes worthwhile when overselling keeps happening or staff enter the same details repeatedly. Another warning sign is stock changing without a clear record of what happened.

Slow reporting can also point to a problem. Pay attention when people update disconnected Excel files, notebooks and Messenger messages.

Use this decision scorecard

Mark each area controlled, problem or not checked. Do not turn the marks into a universal pass score. Use them to decide what a POS trial must improve.

Stock accuracy

  • Status: Check whether recorded stock matches the products physically on hand.
  • Warning sign: Overselling or unexplained stock differences keep returning.
  • Evidence: Count actual stock and compare it with the Excel balance.

Order handling

  • Status: Check whether orders move from the Messenger inbox to packing without record delays.
  • Warning sign: Customer details are copied repeatedly, missed or placed in the wrong parcel slip.
  • Evidence: Note duplicate entry, missing details and parcels delayed by record problems.

Staff accountability

  • Status: Check whether each stock, order or payment change can be traced clearly.
  • Warning sign: People alter disconnected records, but nobody can identify who made a change.
  • Evidence: Review recent corrections and see whether the person and reason were recorded.

Payment reconciliation

  • Status: Check whether every bKash, Nagad and COD payment matches an order.
  • Warning sign: Payments, courier collections, return parcels or refunds remain unmatched.
  • Evidence: Make a list of entries that still need investigation after completing the daily checks.

Time spent

  • Status: Check whether entry, checking and reporting fit around customer replies and packing.
  • Warning sign: Corrections or reports regularly delay messages, packing or parcel handover.
  • Evidence: Note which record tasks interrupt other work and why they take longer.

Total cost

  • Status: Check whether the current process remains manageable without repeated losses or avoidable labour.
  • Warning sign: Record errors and manual work may cost more than changing the system.
  • Evidence: Write down confirmed losses, correction work and every cost quoted for the new software.

Use these findings before comparing POS and inventory software. For total cost, ask each provider about:

  • subscription charges;
  • setup and data migration;
  • staff training;
  • required hardware;
  • charges for additional users; and
  • ongoing support.

Record each item as confirmed, not included or not answered. Include a cost only when the provider gives it in a written quote.

A long feature list does not prove that software will help your shop. A prepared demo may also skip awkward parts of daily work.

Use your real product records during the trial. Follow these steps:

  1. Receive an order from the Messenger inbox.
  2. Check available stock and reserve the product.
  3. Record a bKash, Nagad or COD payment method.
  4. Prepare the parcel and its parcel slip.
  5. Process a cancelled order or return parcel.
  6. Check whether stock, payment and order reports remain correct.

Switch only if the trial follows this workflow and improves the problems you recorded. If it does not, keep Excel for now or test another option.

How POS, inventory software and ecommerce tools differ

Choose software by the work it completes, not by the label on its website. “POS,” “inventory,” “ERP,” “automation” and “ecommerce” may appear on products with different features.

A seller uses a phone and laptop beside stock, parcels and a cash drawer.
First identify which parts of selling and stock control the system must handle.

If your shop uses Excel, assess the spreadsheet you actually maintain. Check who enters orders, payments, stock changes, courier details and returns. Also check whether those entries stay accurate during a busy day.

A spreadsheet may suit your shop when the current process works reliably. The real question is whether you can find an order, confirm payment and check stock without searching several files.

For this comparison, assess whether a POS records sales, payments and related stock changes. Do not rely on the POS label alone. Ask the vendor to show how online orders, partial payments, cash on delivery (COD) and return parcels affect the same records.

The table below is a practical testing framework, not a set of universal software definitions.

Label used by a vendor Task to test for your shop Evidence to ask for
Excel or spreadsheet Record orders, payments, stock and courier details in your current file Enter a sample order, change its status and find any missing entry
POS Record a sale, its payment status and the related stock change Process online, counter, COD and returned orders
Inventory management Record stock coming in and going out Show purchases, sales, damages, exchanges and returns
Order management Keep each order visible from confirmation to delivery or return Put Messenger, website and counter orders into the working list
Website builder Let a customer view products and place an order Show where the order appears and how staff process it
Courier tool Prepare a parcel booking and follow its current delivery status Match the booking, parcel slip, COD amount and return parcel with the order
Payment account Match received money or a refund with the correct order Find a bKash or Nagad payment and mark the related order correctly

A product may appear relevant to several rows. That does not prove it completes every listed task. Confirm each required step inside the product, preferably on the phone you use for daily work.

StoreX shows why labels need care. StoreX’s page, read 7 October 2026, describes it as a Bangladeshi ecommerce automation platform and website builder. The description does not call it POS software. Compare its demonstrated tasks with your needs instead of automatically placing it in the POS category.

Make a simple task list before opening vendor pages:

  1. Write where orders arrive, such as the Messenger inbox, website or counter.
  2. Mark where you currently record the sale, payment status and available stock.
  3. Add packing, the parcel slip, courier booking, COD collection and the return parcel.
  4. Note who updates each record and when they do it.
  5. Decide which steps must share one order record and which can remain separate.
  6. Ask every vendor to demonstrate those exact steps with one sample order.
  7. Repeat the test with a cancelled order and a return parcel.

During the demonstration, do not accept only a dashboard tour. Ask to create an order, receive a partial payment, book delivery and record a return. Then check whether the payment, stock and order status still agree.

If combining chat, website and counter orders matters, first map your Facebook order management flow. Compare products by completed tasks after that. Do not assume two products work alike because both use words such as “automation,” “ERP,” “inventory” or “ecommerce.”

How to find out whether Excel is costing your shop time or money

Do not judge Excel by frustration alone. Document where work repeats, where records fail, and what a replacement must improve.

1. Draw your present order path

Follow one order from the first message to the final payment record. Write the tool, file or notebook used at each stage:

  1. Enquiry arrives through the Messenger inbox, website or another channel.
  2. Customer details and the order are confirmed.
  3. The correct product, size and colour are deducted from stock.
  4. bKash, Nagad, bank or COD payment status is recorded.
  5. Courier booking and the parcel slip are prepared.
  6. Delivery, cancellation or the return parcel is recorded.
  7. Courier collections, payments and returns are reconciled.

Draw an arrow whenever information is copied between places. Mark who copies it and where corrections usually happen.

2. Keep a time and failure log

Track the work for one representative week. If your shop receives too few orders that week, continue until the log reflects normal trading.

Include regular orders, delivery updates and returns. Avoid using an unusually quiet period as your baseline.

Record time spent on:

  • copying customer or order details;
  • correcting duplicate or wrong records;
  • checking whether stock is available;
  • finding payment or delivery information;
  • preparing sales, stock or payment reports.

Record start and finish times instead of estimating later. Do not use another shop’s order count or working hours as your benchmark.

Beside the time log, count observable failures. Include oversold products, missed orders, duplicate entries, unexplained stock adjustments, unrecorded returns and payment mismatches. Note the affected order or product so each problem can be checked.

3. Separate needs from conveniences

Label each desired feature essential or convenient. An essential requirement protects a process you must complete accurately. A convenience may reduce effort but should not decide the purchase by itself.

Requirement Possible label Question to ask yourself
Stock by size and colour Essential Could a wrong balance cause an unavailable item to be confirmed?
Exporting records Essential for some shops Do you need files for reporting, backup or other work?
Return stock updates Essential Must a returned sellable item become available again?
Receipt printing Convenient for some shops Do customers or counter sales actually require printed receipts?

Your labels may differ. Base them on your workflow, not a vendor’s feature list.

4. Rewrite problems as testable results

Avoid requirements such as “better stock control.” Write an action and the result you expect.

  • A returned parcel must restore the correct size and colour, when appropriate.
  • Each manual stock adjustment must show the user and reason.
  • A confirmed order must reduce the correct variant only once.
  • A cancelled order must follow your chosen stock-restoration rule.
  • The payment record must match the related order and collection record.
  • An export must contain the fields needed for your existing report.

Add the evidence you will inspect, such as a stock history, order record or exported file.

5. Set a clean starting baseline

Before assessing any replacement, physically count stock by product variant. Reconcile open orders, return parcels, payment records and unexplained adjustments. Our guide to keeping stock records for an online shop explains a simple routine.

Save the corrected stock list and note when it was checked. Otherwise, inaccurate starting data may be mistaken for a problem caused by the new software.

How to test POS software before switching from Excel

Test your real order flow, not the vendor’s prepared demonstration. Use the same data and scenarios for every shortlisted system.

A seller tests software while picking and packing a garment from stock.
Test the software with the same steps used for a real order.

1. Prepare a small import file

Copy a manageable sample from your corrected Excel records. Include:

  • products and product variants;
  • opening stock for each variant;
  • customer records;
  • historical orders with different statuses.

Keep the original file unchanged. Ask the vendor to import the copy while you watch. Do not accept only a statement that importing is supported.

Afterwards, compare the imported row count and total opening stock with your source file. Check every rejected row and confirm that Bangla text remains readable. If the test file is genuinely small, compare every imported row with the original.

For a larger test file, write down your sample rows before the import. Include rows with Bangla text, product variants, customers and every order status in the file. Compare every field in those selected rows, not only the product name or order number.

Ask for an error report showing rejected rows, missing fields and duplicate records. Check whether errors can be corrected and imported again without creating duplicates.

2. Enter your normal orders

Run each order from beginning to end, including its payment and stock effects. Use products from the test file rather than the vendor’s sample catalogue.

  1. Enter a Facebook order received through the Messenger inbox.
  2. Place a website order, if you sell through a website.
  3. Record a counter sale, if customers can buy in person.
  4. Record a partially paid order and its remaining balance.
  5. Cancel an order before dispatch and inspect the restored stock.
  6. Exchange one product variant for another.
  7. Process a cash on delivery (COD) return and inspect its order, payment and stock records.
  8. Make a manual stock correction and record its reason.

Write down the expected result before each test. This prevents an attractive screen from distracting you from an incorrect stock balance.

3. Test daily controls and difficult conditions

Create low stock for one test item. Observe what the system does. Ask whether that behaviour needs configuration or another service.

Next, ask two permitted users to change records at nearly the same time. Check user permissions and whether the audit history identifies who changed what. Try this with a sensitive action, such as changing stock or cancelling an order.

Open the reports you actually need. Filter them, compare totals with the sample orders, and export the underlying data. Confirm that exported files contain the fields required by your existing reports.

Use the system from the phone you normally carry. Check text size, search, variant selection and the screens needed to complete an order. Ask what happens when internet access is interrupted, then test that situation safely during the trial. Check whether unfinished or repeated transactions appear after reconnection.

4. Make integrations prove themselves

Ask the vendor to demonstrate every claimed website, payment, courier or accounting integration live. A slide, logo or verbal promise is not enough.

For each integration, ask:

  • Is it native, manual or supplied by a third party?
  • Which information moves between the systems?
  • Does syncing happen automatically or require an action?
  • How are failed or duplicate transfers handled?
  • Is setup, usage or support charged separately?

Hishabee’s website, read 7 October 2026, advertised a seven-day free trial. Its blog, also read that day, said sellers could download its app, add products and share a store link. These claims support trying that stated flow only. They do not confirm imports, reports, permissions, offline use or other POS functions. Recheck the offer before relying on it.

5. Keep evidence and score every option equally

Save screenshots, error reports, exported files and written vendor answers. Record results using the same worksheet for every system.

Scenario Evidence to keep Result
Data import Import summary and error report Pass, partial or fail
Orders and returns Order, stock and payment records Pass, partial or fail
Permissions and history User settings and audit record Pass, partial or fail
Reports and exports Report screenshot and exported file Pass, partial or fail
Mobile and interrupted internet Screenshots and observed outcome Pass, partial or fail
Integrations Live demonstration and written explanation Pass, partial or fail

Mark a result “partial” when staff must add manual work or another service. Do not switch until failures affecting your required workflow are resolved in writing or accepted knowingly.

How much does POS software cost for a small online shop?

There is no single market-wide price for every shop. Calculate your full cost from a written quote, expected usage and required hardware.

One vendor’s published plans cannot show the cost of the wider POS market. Use published prices only to shortlist options. Then compare complete written quotes prepared for your shop.

Ask for an itemised quote

Send the same request to every shortlisted vendor. Ask whether each item is included, optional or charged separately:

  • Subscription and billing period
  • Setup and account configuration
  • Excel data cleaning and import
  • Staff training
  • Additional users or employees
  • Orders above the plan limit
  • Support and maintenance
  • Software upgrades
  • Integrations
  • Tax
  • Required phone, computer, scanner, printer or other hardware
  • Contract cancellation and data export

Ask for the answer in writing. Also ask how long the quote remains valid and which charges can change.

Save each quote in one phone folder. Give the file a clear name containing the vendor and quote date. This will help when comparing renewal terms or discussing a disputed charge later.

Use published prices only as a starting point

StoreX’s plan page, read 7 October 2026, published these yearly prices and limits:

Plan Published price per year Employees Orders per month Published extra-order charge
Basic ৳11,880 2 500 ৳2
Regular ৳23,880 5 1,500 ৳1.50
Advanced ৳59,880 10 5,000 ৳1

StoreX’s published yearly prices therefore ranged from ৳11,880 to ৳59,880. The same page showed unlimited products but no free tier or trial.

This is one vendor’s published range, not a general POS market range. It does not show what every Bangladeshi provider charges.

These details also do not establish which POS functions StoreX provides. They do not confirm charges for setup, migration, training, hardware, tax or integrations.

Recheck the current plan page before buying. Then obtain a written quote covering your shop’s users, orders, equipment and data.

Complete one worksheet for each option

Copy the blocks below into your phone’s Notes app. Complete a separate copy for every vendor. Leave each amount blank until the vendor confirms it in writing.

  1. Annual committed cost

    • Your requirement: Required plan, users and contract period
    • Vendor’s written answer: Plan, billing period, renewal terms and cancellation terms
    • Amount: ৳________
  2. Likely overage cost

    • Your requirement: Expected monthly orders above the included limit
    • Vendor’s written answer: Extra-order charge and calculation method
    • Amount: ৳________
  3. Setup

    • Your requirement: Account, product, stock and invoice configuration needed
    • Vendor’s written answer: Included work, excluded work and separate charges
    • Amount: ৳________
  4. Data import

    • Your requirement: Excel files and records that must be moved
    • Vendor’s written answer: Included files, cleaning work and correction charges
    • Amount: ৳________
  5. Training

    • Your requirement: People needing training and the tasks they must learn
    • Vendor’s written answer: Training format, included sessions and extra charges
    • Amount: ৳________
  6. Additional users

    • Your requirement: Total people needing their own access
    • Vendor’s written answer: Included users and the charge for additional users
    • Amount: ৳________
  7. Hardware

    • Your requirement: Phone, computer, scanner, printer or other required devices
    • Vendor’s written answer: Required models, purchase source and replacement responsibility
    • Amount: ৳________
  8. Support and upgrades

    • Your requirement: The support channels and response level your shop needs
    • Vendor’s written answer: Included support, exclusions, upgrade terms and recurring charges
    • Amount: ৳________
  9. Integrations

    • Your requirement: Website, accounting or other tools that must connect
    • Vendor’s written answer: Available connection, setup work and recurring charges
    • Amount: ৳________
  10. Tax

    • Your requirement: A complete invoice showing the final payable amount
    • Vendor’s written answer: Whether applicable tax is included or added
    • Amount: ৳________
  11. Exit and data export

    • Your requirement: Files needed if you stop using the software
    • Vendor’s written answer: Export format, included assistance and additional charges
    • Amount: ৳________

After completing the blocks, add these totals separately:

  • One-time switching costs: setup, data cleaning, import, training and new hardware
  • Annual recurring costs: subscription, support, integrations and expected overages
  • First-year estimated total: switching costs plus annual recurring costs
  • Later estimated annual total: recurring costs without completed switching work

For overages, compare expected monthly orders with the plan allowance. Ask the vendor to show its calculation in writing.

Do not assume how a vendor counts partial months, cancelled orders or returned orders. Ask before accepting the quote. A low plan price can become misleading when required extras are missing.

Calculate ROI from your own records

Calculate return on investment, or ROI, using the same method for every option. This prevents different assumptions from changing your comparison.

ROI item How to calculate it Your figure
Monthly hours saved Measured time before POS minus measured time during a test period
Monthly value of time saved Monthly hours saved × chosen hourly labour value
Demonstrated monthly losses avoided Errors or losses that testing showed the system would prevent
Monthly demonstrated benefit Time value plus demonstrated losses avoided
Annual demonstrated benefit Monthly demonstrated benefit × 12
First-year cost One-time switching costs plus annual recurring costs
Later annual cost Annual recurring costs only
First-year net result Annual demonstrated benefit minus first-year cost
Later annual net result Annual demonstrated benefit minus later annual cost

If you work alone, write down the hourly labour value you chose. Treat it as your assumption, not a verified cash saving.

For paid staff, use your payroll records when valuing saved work time. Do not count time twice if it neither reduces cost nor creates useful work.

Compare the annual benefit with first-year and later annual costs separately. This shows whether setup and switching costs change the first-year result.

Count only savings supported by your records or a test period. There is no universal payback result or order threshold in the sources reviewed for this guide.

How to check bKash and payment integration before buying POS software

A bKash account, QR code or transaction history does not prove that a POS connects to bKash. Before buying, make the vendor demonstrate the complete payment workflow using your shortlisted plan.

Separate the account from the POS connection

bKash’s merchant page, read 8 October 2026, lists the Merchant App, Merchant QR and counter payments. It also lists round-the-clock collection and transaction history. These are bKash Merchant features. They do not prove that a particular POS can import, match or reconcile those payments.

Ask the POS vendor to run these tests live:

  1. Record a bKash payment against a specific order.
  2. Show the bKash transaction reference inside the order record.
  3. Correct a wrong amount without hiding the change history.
  4. Record a full or partial refund and show how the records match.
  5. Show where payment fees appear in sales, cash and profit reports.
  6. Reconcile the POS total with the bKash transaction history.
  7. Record COD separately from prepaid bKash orders.
  8. Process a returned parcel after its COD order was recorded.

Use another test for Nagad or any payment gateway. One working connection does not prove that other payment methods connect the same way.

Check Account evidence alone POS proof to request
Payment received Wallet history or QR payment Payment matched to the correct order
Reference Transaction reference exists Reference is stored and searchable in the POS
Fees Wallet shows its transaction POS records the relevant fee correctly
Refund Refund handled outside the order Order, payment and refund records agree
COD return Courier or manual record exists Returned parcel updates payment and order status
Reconciliation Separate totals can be viewed POS total can be checked against wallet records

Check which bKash account you will connect

The Personal Retail Account is intended for micro and small retail and f-commerce businesses. This comes from its bKash page, read 8 October 2026. Another bKash page read that day says an online business without a trade licence may open one.

Customers can pay this account through QR, the bKash Payment Gateway or manual account-number entry through USSD. The bKash page says limits apply. That information still does not prove your chosen POS connects to these routes. Ask the vendor to test each route you plan to use.

For a fuller account comparison, see our guide to bKash merchant and Personal Retail Accounts.

The Personal Retail Account page, read 8 October 2026, lists these opening requirements:

  • The applicant’s NID.
  • A mobile number registered against that NID, with no bKash account already opened on it.
  • Proof of SIM ownership.
  • The nominee’s NID, where applicable.

To self-register, open bKash’s Personal Retail Account registration page. For NID verification, dial *16001# and provide the last four digits of your NID.

The same page, read 8 October 2026, says the account works through the bKash Merchant App or *247#. It also says a personal bKash account cannot be converted into a Retail Account. Therefore, prepare an eligible unused mobile number before starting registration.

Recheck charges and limits before signing

A bKash page read 8 October 2026 describes the Personal Retail Account charges as a promotional offer. It says the offer will run until further notice. The page lists customer-payment receipts and merchant-payment receipts as free. Making a merchant payment costs 0.20%, while sending money to a customer costs ৳5.

The same promotion says cash-out up to ৳5,000 is free during the first three months. It also gives 1.3% as the charge for a future bank-transfer phase. Do not assume that future facility is already available.

That page publishes payment-receive limits of ৳30,000 per transaction and ৳30,000 daily. It gives a monthly payment-receive limit of ৳500,000 and a maximum momentary balance of ৳500,000.

Recheck the current bKash terms before buying because promotional charges and limits may change. Then get the POS vendor’s supported payment routes, fee handling, refund process and reconciliation method in writing.

How to move from Excel to POS without losing stock or order records

Move in controlled stages. Keep a verified backup, set a precise cutover time, and check records during the change.

A shop owner checks physical stock while moving records between two systems.
Count physical stock and keep the old records available during migration.
  1. Clean and back up the spreadsheets. Standardise product names, SKUs, and variant labels such as size or colour. Save an untouched copy of every spreadsheet before editing, merging, or importing anything.

    Mark suspected duplicates instead of deleting them immediately. Compare order IDs, phone numbers, SKUs, payment references, parcel slips, Messenger messages, and source files. Similar names may belong to different customers, while repeated products or orders may be valid.

    You may merge confirmed duplicate customer or product records after preserving their history. Never delete an order unless you confirm it is duplicated. Preserve its linked payment, stock movement, courier booking, and COD settlement records first.

  2. Set the cutover rules. Choose the exact date and time when the POS becomes the master record. Decide how you will control sales, cancellations, returns, purchases, exchanges, and stock adjustments during the physical count.

    The safest option is to pause stock-changing work while you count and import quantities. If you cannot pause, record every movement after the count in a separate cutover log. Apply those movements before making the POS the master record.

    Immediately after cutover, reconcile or recount every affected SKU and variant. Also write down which system holds each open order, COD parcel, exchange, and return already in progress.

  3. Start with a limited pilot. Use selected products or let a staff member process orders first. Check stock movements, orders, and payments against parcel slips, payment records, Messenger orders, and physical stock. Fix each mismatch before expanding the pilot.

  4. Stop unofficial parallel records quickly. Keep the old spreadsheet available for checking, but make it read-only after cutover. Do not allow the spreadsheet and POS to become separate editable master records. Record every post-cutover correction in the POS with a clear reason.

  5. Set controls before wider use. Decide who may change stock, cancel orders, edit prices, or view reports. Create standard adjustment reasons and approval rules for damaged items, missing stock, exchanges, and returns. Train everyone on the same workflow, then record how software problems will be reported and handled.

  6. Test recovery and courier workflows. Export products, customers, orders, and stock adjustments. Open the exported files and confirm that product details, order history, quantities, and references remain usable. Read the cancellation terms and ask how your data is returned if the service fails or you leave it.

For any advertised courier service integration, test the complete journey yourself. Book a parcel, save its tracking reference, check the delivered status, reconcile the COD settlement, and process a return. Confirm how and when returned stock becomes available again in the POS. Do not assume the connection covers a step until that step works in your pilot.

Before final cutover, keep a signed checklist covering the stock count, movement log, open orders, unresolved returns, usable exports, and responsibility for each remaining issue.

Use the worksheet to make your POS decision

Use the completed worksheet to choose one of three paths. Do not switch because a demo looked impressive.

Decision box

Decision Choose this when What to do next
Stay with Excel Your spreadsheet handles essential work, and no tested option offers enough benefit for its cost and disruption. Fix the specific spreadsheet weaknesses already listed in your worksheet.
Test another system Important requirements remain untested, unclear or dependent on a salesperson’s verbal answer. Test another suitable POS, inventory or order-management system using the same requirements.
Switch systems One system passes every essential requirement, the full cost is acceptable, and your shop is ready to move. Set a migration plan, assign responsibility and keep Excel available for checking old records.

Mark the chosen path at the top of the worksheet. Beside it, write the evidence that supports your decision. Use passed, failed or not checked for each essential requirement. A promise without a working test or written confirmation should remain not checked.

Do not hide a failed essential requirement inside a good overall score. If accurate stock after a return is essential, failure there can stop the switch. Features that are merely useful should not outweigh a failure in daily order handling.

If the answer is still unclear, choose test another system. Write exactly what remains uncertain and what evidence would settle it. This gives you a clear next task instead of an open-ended search.

Finally, save the dated worksheet with the person responsible for the decision. Reopen it when your order process, team, product range or operating needs change.

Common questions

Facebook inbox, website এবং courier-এর অর্ডার কি একই জায়গায় রাখা যাবে?

সম্ভব হতে পারে, তবে সরাসরি পরীক্ষা ছাড়া ধরে নেবেন না যে সব অর্ডার একই রেকর্ডে থাকবে। একটি Facebook inbox order ও একটি website order তৈরি করতে বলুন। এরপর courier booking, tracking reference, COD collection, cancellation এবং return সেই order record-এ দেখা যায় কি না পরীক্ষা করুন। শুধু dashboard, logo বা “automation” লেখা প্রমাণ নয়।

আমার Excel-এর product, customer, stock ও sales records কি POS-এ import করা যাবে?

Import করা যেতে পারে, কিন্তু vendor-কে sample file দিয়ে ফল যাচাই করতে হবে। মূল Excel file অপরিবর্তিত রেখে একটি copy দিন। Import শেষে row count, opening stock, Bangla text, product variants, customers এবং order status মিলিয়ে দেখুন। Rejected row ও missing field-এর report নিন। সংশোধিত file আবার import করলে duplicate তৈরি হয় কি না তাও পরীক্ষা করুন।

শুধু phone দিয়ে POS চালাতে পারব, আর internet বন্ধ হলে কী হবে?

এটি softwareভেদে বদলায়, তাই নিজের phone এবং interrupted internet দিয়ে trial করতে হবে। Order entry, search, variant selection, payment ও return-এর প্রয়োজনীয় screen ব্যবহার করে দেখুন। Internet বন্ধ করে একটি নিরাপদ sample transaction চালান। সংযোগ ফেরার পরে unfinished বা duplicate transaction তৈরি হয়েছে কি না দেখুন। Computer, scanner বা printer বাধ্যতামূলক কি না লিখিতভাবে জেনে নিন।

এক system-এ bKash, Nagad, COD payment এবং returned parcel রাখা যাবে?

রাখা সম্ভব কি না live test ছাড়া নিশ্চিত হবেন না। প্রতিটি payment method দিয়ে sample order record করুন এবং paid, unpaid ও unmatched status পরিষ্কার দেখা যায় কি না দেখুন। এরপর COD return, partial payment ও refund চালিয়ে order, stock, payment এবং courier collection মিলছে কি না যাচাই করুন। আলাদা wallet transaction history থাকলেই POS integration প্রমাণ হয় না।

আমার order কম হলে Excel ছেড়ে POS software নেওয়া কি লাভজনক হবে?

এই guide-এর জন্য দেখা sources কোনো universal order-count threshold ঠিক করে না। Excel রাখুন যদি একজন মানুষ সঠিকভাবে stock, order ও payment record সামলাতে পারেন। সিদ্ধান্তের জন্য স্বাভাবিক trading period-এ repeated entry, correction time, overselling, missed order এবং payment mismatch লিখে রাখুন। Trial-এ POS এসব সমস্যা কমায় কি না এবং demonstrated benefit পুরো খরচের চেয়ে গ্রহণযোগ্য কি না তুলনা করুন।

Subscription-এর বাইরে setup, training বা extra-user fee থাকতে পারে কি?

থাকতে পারে, তাই subscription price দেখে মোট খরচ ধরে নেবেন না। Vendor-এর কাছ থেকে itemised written quote নিন। সেখানে setup, Excel cleaning, import, training, additional users, support, upgrades, hardware, integrations, tax, order overage, cancellation এবং data export আলাদা করে লিখতে বলুন। প্রতিটি বিষয় confirmed, not included বা not answered হিসেবে রাখুন; মৌখিক প্রতিশ্রুতিকে confirmed cost ধরবেন না।

Sources

Figures and claims about other companies are taken from the page named, as it read on the date shown.

More guides