KB CloudERP - Help Center
Feature RequestRoadmapAPICompany
  • Overview
    • About
    • Changelog
    • Support
  • Knowledge Base
    • Get Started
      • How to register your business in KB CloudERP?
      • How to do a quick setup of business settings?
      • How to setup your company details?
      • How to setup multiple business locations/warehouse?
      • How to set up a bank/cash?
      • How to add payment accounts in KB CloudERP?
      • How to setup and edit payment methods?
      • How to setup tax rates, tax groups & disable tax?
      • How to setup an invoice scheme?
      • How to setup invoice layout?
      • How to add types of service?
      • How to change the theme color?
    • Import
      • Import products using Excel file templates
      • Import opening stock using Excel template
      • Import contacts using Excel file templates
      • Import sales using Excel file templates
    • Users
      • How do you setup roles?
      • How to add user?
      • How to assign location to user?
      • How to add commission agents?
    • Contacts
      • Add supplier & customers
      • Add customer groups
      • Add opening balance & payments
      • Add advanced balance
      • Add credit limit for customers
      • View customer & supplier ledger
    • Products
      • Add product category
      • Add product units
      • Add product variations
      • Add products
      • Add product types
      • Add opening stock
      • Duplicate product
      • Product warranty
      • Printing labels/barcode
      • Product selling price groups
      • Product expiry settings
      • What is stock transfer?
      • What is stock adjustment?
      • Product stock history
      • Edit products (bulk edit)
      • Delete products (bulk delete)
      • How to do price update?
      • Product tax types
    • Purchase
      • Adding purchase
      • Purchase order
      • Purchase requisition
      • Purchase payment
      • Purchase invoice
      • Different purchase price
      • Purchase with excise/custom duty
    • Sales/Sell
      • POS screen guide
        • Finalize sales options
        • Tender change
        • Adding payments from contact
        • Previous sale amount in sales
        • Use case of suspended sales
        • Rounding mechanism explained
        • Adding bonus or free items at sale
        • Featured products in the POS screen
        • Display product unit price in POS
        • Shipments, home delivery, or parcel management
        • Cash denomination
      • Sales subscriptions
      • Sales services
      • Sales return
      • Sales order
      • Discounts by brand, category, location
      • Displaying QR code in invoice
      • Gift receipt
      • Proforma invoice
      • Invoice external URL
    • Expenses
      • Add expense categories
      • Add expenses
      • Add recurring expenses
      • Add expenses refund
      • Add payroll expenses
    • Reports
      • How to check reports?
      • Cash register report
      • Stock expiry report
      • How to export your data/reports?
    • Notifications
      • Notifications templates
        • Ledger notifications
        • Customer notifications
        • Supplier notifications
      • How to setup SMS notifications
      • How to setup email notifications
      • Auto send notifications
    • Custom Labels
      • Custom payments
      • Contact custom fields
      • Products custom fields
      • Location custom fields
      • User custom fields
      • Purchase custom fields
      • Purchase shipping custom fields
      • Sell custom fields
      • Sale shipping custom fields
      • Type of service custom fields
    • Settings
      • How to search in settings?
      • Disable tax rates
      • Decimal precision for currency & quantity
      • Disabling printing receipts on the POS screen
      • Enable customer reward points
      • Stock accounting methods
      • Lot number/IMEI serial tracking
    • Modules
      • Accounting Module
      • Restaurant Module
        • Add tables
        • Add modifiers
        • Add table bookings
        • Enable service staff
        • Enable service staff pin
        • Kitchen dashboard
        • Kitchen orders
        • All orders & line orders
      • HRM Module
        • Payroll management
        • Shift management
        • Holidays management
        • Leave management
        • Attendance management
        • Essentials module
        • What is a sales target?
      • Project Management
      • CRM Module
      • Advance Repair
      • HMS Module
      • Manufacturing
        • Settings
        • Permissions
        • Using for repackaging and selling
      • WooCommerce
      • Spreadsheet
      • Catalogue QR
      • Partnership
    • Integrations
      • Google Map
      • Chat GPT
      • WooCommerce
      • Khalti
    • Tips & Tricks
      • Keyboard shortcuts for POS
      • Improve browser based print (Receipts or other)
      • Create shortcuts for web
      • Browser full-screen mode or distraction-free mode
      • Barcode scanner trick
      • Reusing product barcodes
  • Help and FAQ
    • Troubleshoot
    • Hardware Support
      • How to add a barcode scanner?
      • How setup label weighing scale?
      • How to setup thermal printer for receipt printing
      • Barcode printer support
      • How to setup a printer to open cash drawer automatically?
    • FAQ
Powered by GitBook
On this page
  • Steps to import sale
  • Errors you might face while importing
  1. Knowledge Base
  2. Import

Import sales using Excel file templates

When you are switching from another system and maintain sales on the excel file, you can use this feature by importing a bulk sales using excel file.

Steps to import sale

  1. Go to Sale > Import Sale

  2. Click the ‘Download Template’ button to download the template file.

  3. Once downloaded, open it and add the required details. While adding the details follow the instructions mentioned on the import sale page itself.

  4. Save the Excel file and upload it by clicking the choose file button and pressing the submit button.

  5. Change it accordingly and proceed.

Errors you might face while importing

Common Error:

It may display some error after uploading if some data added in the Excel file is not as mentioned in the instructions.

Error 1: “Group sell line by” field in import sale:

While importing an Excel file for import sale you have to select the option "Group Sell Line By".

This field is used for the system to know which lines need to be in a single sale.

For example, if you add an Invoice_Number column in the Excel import file, then all lines from one sale will have the same Invoice_Number.

In this case, you need to select the Invoice_Number option in the “Group Sell Line By” dropdown field.

Error 2: “You cannot select a field twice” Issue and Solution:

You may encounter this issue while you import an Excel file using the Sale Import feature.

This issue happens when the same option name is chosen for multiple columns in the import table

If you want to remove any column during import, you can select the skip option in the dropdown.

PreviousImport contacts using Excel file templatesNextUsers

Last updated 11 months ago