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 data categories:
1. Products
2. Product Matrix
3. Services
4. Gift Cards
5. Customer
6. Employee
7. Employee services
For each data category, you can download an import template in any of these formats:
- XLSX
- XLS
- CSV
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 ...
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 ...
Growth Marketing Dynamic Content
Growth Marketing Dynamic Content Guide The following tags will import dynamic content from your brand into your email: %CustomerFirstName% - This will pull first name from customer DB %CustomerLastName% - This will pull last name from customer DB ...