Select Page
View Categories

Import Sales

5 min read

Import Sales – Step-by-Step Guide

📥 Import Sales – Bulk Import Sales Data #

1. Navigate to “Import Sales” #

  1. Log in to your restaurant management system.
  2. In the sidebar, click Sales.
  3. Under Sales, select Import Sales.
  4. The import sales page will open showing:
    • A File Upload section for selecting your data file.
    • Detailed Instructions for preparing your import file.
    • A Template Download option for proper file formatting.
    • An Imports history table showing previous import attempts.

2. Understanding Sales Import #

Sales Import allows you to bulk upload sales data from external sources. This is useful for:

  • Data Migration – Moving sales data from another system.
  • Bulk Entry – Adding multiple sales records at once.
  • Historical Data – Importing past sales for reporting and analysis.
  • Integration – Syncing data from external sales channels or POS systems.
  • Backup Restoration – Restoring sales data from backups.
Important: Always backup your existing data before performing bulk imports. Incorrect imports can affect your sales records and inventory.

3. Download and Prepare Import Template #

  1. Click the 📥 Download template file button to get the correct format.
  2. Open the downloaded template file in Excel or similar spreadsheet software.
  3. The template contains all required columns with proper headers.
  4. Review the column structure before adding your data:
    • Do not modify column headers or their order.
    • Follow the exact format shown in the template.
    • Ensure all required fields are populated.
  5. Save your completed file in CSV format for import.

4. Required Import Fields #

Based on the instructions, your import file must include these fields:

Field NameDescriptionRequiredFormat/Notes
Invoice NoUnique invoice numberYesMust be unique in system
Customer nameCustomer full nameYesText format
Customer Phone numberCustomer contact numberNoEither customer email or phone number required
Customer EmailCustomer email addressNoEither customer email or phone number required
Sale dateDate of saleYesDate format should be “dd-mm-yyyy” (e.g., 15-01-2024)
Product NameName of product soldYesIf the product name not single and combo only, no product sku required
Product SKUProduct stock keeping unitNoEither product name not single and combo only, no product sku required
QuantityNumber of items soldYesNumeric value
Product UnitUnit of measurementNoe.g., pieces, kg, liters
Unit PricePrice per unitYesNumeric value
Item TaxTax amount per itemNoNumeric value
Item DiscountDiscount per itemNoNumeric value
Item DescriptionAdditional item detailsNoText description
Order TotalTotal order amountYesNumeric value
Location NameBusiness locationYesMust match existing location
Added ByStaff member nameNoMust match existing user
Payment StatusPayment completion statusNoPaid, Pending, Partial
Custom Field 1-4Additional custom dataNoOptional custom fields

5. Prepare Your Import File #

  1. Data Validation:
    • Ensure all required fields are filled.
    • Verify date format is “dd-mm-yyyy” (e.g., 15-01-2024).
    • Check that customer email or phone number is provided.
    • Confirm product names match existing products or provide SKU.
    • Validate numeric fields (quantities, prices, totals).
  2. Data Consistency:
    • Use consistent location names that exist in your system.
    • Ensure invoice numbers are unique.
    • Verify staff names match existing users.
    • Check that payment status values are valid.
  3. File Format:
    • Save file as CSV (Comma Separated Values).
    • Use UTF-8 encoding to preserve special characters.
    • Keep file size reasonable (under 10MB recommended).

6. Upload and Import Sales Data #

  1. Click Choose file button in the “File To Import” section.
  2. Select your prepared CSV file from your computer.
  3. The filename will appear next to the button (currently shows “No file chosen”).
  4. Click the purple Upload and review button.
  5. The system will:
    • Validate your file format and structure.
    • Check for required fields and data consistency.
    • Display a preview of the data to be imported.
    • Show any errors or warnings that need attention.
  6. Review the preview carefully before confirming the import.

7. Review Import History #

The Imports section shows your import history:

ColumnDescription
Import batchUnique identifier for each import session
Import timeDate and time when import was processed
Created ByUser who performed the import
InvoicesNumber of invoices successfully imported
ActionAvailable actions (View details, Download report, etc.)

Use this history to track import success and troubleshoot any issues.

8. Import Process Steps #

Follow these steps as outlined in the instructions:
  1. Upload sales data in excel format – Use the provided template.
  2. Choose business location and column by which tax lines will be grouped – Select appropriate settings.
  3. Choose respective sales lines for each column – Map your data columns correctly.
  4. Review and confirm – Check all data before final import.

9. Common Import Errors and Solutions #

ErrorCauseSolution
Invalid date format Date not in dd-mm-yyyy format Reformat dates to dd-mm-yyyy (e.g., 15-01-2024)
Duplicate invoice number Invoice number already exists Use unique invoice numbers or check existing records
Product not found Product name/SKU doesn’t match system Verify product names or create products first
Invalid location Location name doesn’t exist Use exact location names from your system
Missing required field Required column is empty Fill all required fields before import
Invalid numeric value Non-numeric data in price/quantity fields Ensure all numeric fields contain valid numbers

10. Best Practices for Sales Import #

  • Start Small – Test with a small batch of data first.
  • Backup First – Always backup your database before large imports.
  • Validate Data – Check data accuracy in your source system before export.
  • Use Template – Always use the provided template for correct formatting.
  • Check Dependencies – Ensure customers, products, and locations exist before import.
  • Monitor Progress – Watch the import process and check for errors.
  • Verify Results – Review imported data in the sales reports after completion.
  • Document Process – Keep notes on successful import procedures for future use.

11. Post-Import Verification #

  1. Check Sales Reports – Verify imported sales appear in reports.
  2. Validate Totals – Ensure imported amounts match your source data.
  3. Review Customer Records – Check that customer information imported correctly.
  4. Verify Inventory – Confirm inventory levels updated if applicable.
  5. Test Functionality – Ensure imported sales work with other system features.
  6. Generate Reports – Create reports to validate data integrity.

12. Troubleshooting Import Issues #

IssuePossible CauseSolution
File upload fails File too large or wrong format Reduce file size, ensure CSV format
Import partially successful Some rows have errors Check error log, fix issues, re-import failed rows
System performance slow Large import affecting system Import during off-peak hours, smaller batches
Data appears incorrect Column mapping or format issues Review template, check data mapping
Import button disabled File validation failed Fix validation errors shown in preview

13. Data Preparation Checklist #

Before importing, ensure:
  • ✅ Downloaded and used the official template
  • ✅ All required fields are populated
  • ✅ Date format is dd-mm-yyyy
  • ✅ Invoice numbers are unique
  • ✅ Customer email or phone provided
  • ✅ Product names/SKUs match system records
  • ✅ Location names are exact matches
  • ✅ Numeric fields contain valid numbers
  • ✅ File saved as CSV format
  • ✅ Data backed up before import

14. Done! 🎉 #

You can now successfully import bulk sales data into your restaurant management system. Remember to always test with small batches first and verify your results after each import!

What are your Feelings

  • Happy
  • Normal
  • Sad