In this training, you will learn how to import your data into FranPOS which makes it easier to set up your company.

  • Settings >> Import/Export >> Import

On this page, you will see sections for the following tabs: 

1. INVENTORY - Import your invetory database 

2. SERVICES - Import your service database 

3. CUSTOMER & EMPLOYEES - Import your customers and employees database 

4. OTHER - Import other data 

5 AUDIT LOG - Audit logs of imports 

For each data category, you can download an import template in any of these formats:


When you have your file filled with data to import, you can click on "select files..." to begin the import process.

Each section also contains a location-selector to choose additional locations to import data into (if your profile has multi-location access).

Additionally, the Product and Service sections give you toggles to alter the behavior of your import. For example, if you want to import a product spreadsheet without affecting price or stock quantity, you can toggle off those fields to prevent them from being overridden with new data.


Video Tutorial 

    • Related Articles

    • Product Import File

      In this training, you will learn more information about the product import file. *Product Name* The display name on the POS, required. SKU The main barcode. If you leave this blank, we will auto-generate one for you. Product Code Alternative ...
    • Product import draft

      In this training, you will learn more information about the product import file. Fileds with asterisks are mandatory (example *Product Name*), without values in them the import will fail. Field name Description Notes CID Location ID *Product Name* ...
    • Export

      In this training, we will learn how to export data from FranPOS. Data will be exported into an Excel (CSV) file which you can keep for your record or make any changes. Settings >> Import/Export >> Export Select Category to Export your data Video ...
    • How to setup Mailchimp

      This article will describe how to set up FranPOS with your MailChimp Account. Follow the step to create a API key 1. Go into your MailChimp Account 2. Select API Keys from Extras API keys provide full access to your MailChimp account, so keep them ...
    • GL - Add/Edit

      In this training, you will learn how to add & edit using GL Code management. To add and edit GL codes, the user has to select 'Advanced Settings' on the lateral menu and select 'GL Account Manager'. Edit GL Account Codes 1. The user will be able to ...