Importing and Exporting Items in Bulk

Managing your inventory efficiently is crucial to running a successful business. Our POS system provides a convenient way to import and export items in bulk, allowing you to easily update your stock or transfer data between systems. In this guide, we will walk you through the steps for importing and exporting items using a CSV file.

Importing Items in Bulk:

Importing items in bulk allows you to quickly add or update multiple products in your inventory. Follow these steps to ensure a smooth import process:

Step 1: Download the CSV Template

To get started, download the CSV template from your POS system. This template provides the necessary structure for the import process, ensuring all fields are correctly aligned.

  • Navigate to the Items section in your POS system (Menu > Items).
  • Click the More Options icon. A pop-up menu will appear on your screen.
    Backoffice Import Item Menu
  • Select Import Items and download the CSV template.

Step 2: Fill Out the Template

Once you have the template, open it in a spreadsheet program (such as Excel or Google Sheets). The template will contain the following fields:

  • Code: A unique identifier for each item.
  • SKU: Stock Keeping Unit (optional, but recommended for tracking).
  • Unit: The unit of measurement (e.g., pieces, kg, liters).
  • Barcode: The item's barcode (optional, used for scanning).
  • Name: The product name.
  • Category: The category the product belongs to (e.g., Electronics, Clothing).
  • CostPerItem: The cost price for the item.
  • RetailPrice: The selling price of the item.
  • Tax: Applicable tax percentage for the item.
  • EnablePOSSales: Whether the item is available for sale in-store (Yes/No).
  • EnableOnlineSales: Whether the item is available for online sales (Yes/No).
  • LoyaltyPointsEachSale: The number of loyalty points awarded for each sale of this item.
  • ShortDescription: A brief description of the item.

Note: Ensure that all fields are correctly filled out, and the data types match the expected format. For instance, decimal values should be used for CostPerItem, RetailPrice, and Tax. Empty or null fields for decimals and integers will automatically default to zero.

Step 3: Save the File

Once you've filled out the template, save the file in .csv format. This format is required for the import process.

Step 4: Upload the CSV File

  • Return to the POS system's Items section.
  • Click on Import Items.
    • Backoffice Import Item Menu
  • Upload your filled-out CSV file, and the system will begin processing your data.

Step 5: Review and Confirm

After uploading, the system will validate your data. If there are any errors (such as missing required fields or invalid data formats), you will be prompted to correct them. Once the validation is successful, your items will be added to the inventory.




Exporting Items in Bulk

Exporting items allows you to download your entire inventory into a CSV file, which can be used for reporting, backups, or transferring data to other systems.

Step 1: Navigate to Export Items

  • Navigate to the Items section in your POS system (Menu > Items).
  • Click the More Options icon. A pop-up menu will appear on your screen.
  • Select Import Items and download the CSV template.

Step 2: Download the CSV File

After selecting your options, click Export. The POS system will generate a CSV file containing your inventory data, which you can then download and open in a spreadsheet program.

Tips for Importing and Exporting Items

  • Back up your data: Before importing large batches of items, consider exporting your current inventory as a backup.
  • Data validation: Ensure that your CSV files are free of errors before importing to avoid issues with data entry.
  • Use unique codes: Always use unique item codes to prevent conflicts when importing or updating items.

By using the bulk import and export features, you can easily manage large inventories and ensure your POS system stays up to date with minimal manual input.

You may also like: