Customers: Import Database into Last.app
How to import a customer database into Last.App?
If you want to import an existing customer database into Last.App, follow the step-by-step guide below.
Step 1: Create the Import File
Each external platform generates a file with the customer data it stores. It's important to convert this file into the format required by Last.App for the import to be successful.
You can find the official Last.App customer import format at the following link.
Below is an explanation of each column and the type of information it must contain:
- Name: First name(s) of the customer.
- Surname: Last name(s) of the customer.
- PhoneNumber: Customer's phone number, preferably with country code. A tip: to make sure the "+" sign is recognized as text in the spreadsheet, place a single quote before the plus sign like this →
+34. - Email: Customer’s email address.
- Address: Street name and number.
- AddressDetails: Additional address info such as floor, apartment, building, etc.
- PostalCode: Postal code.
- Points: Loyalty points the customer might have.
If you’re missing some information for a customer, it’s fine to leave the field blank.
Here’s an example of two customers: one with complete data and one with some missing fields.
In the first case, the profile will be created with all the information filled in.
In the second case, the customer profile will be created without an email or postal code.
Step 2: Save the file
Once you have filled out the file with the correct customer data, you need to save it as a CSV file (Comma-Separated Values).
If you're working in Google Sheets, go to File > Download > Comma-separated values (.csv).
Step 3: Upload the file to Last.App
Once you have your CSV file ready, go to LastAdmin > Customers. There you’ll see the Import icon in the customer section.
Clicking on this icon will open your file explorer. Select your CSV file and click "Open". This will begin the import process, and you’ll see a confirmation message in the top-right corner of the screen indicating whether the file was uploaded successfully.
After the import is complete, the customers will appear in the admin panel once the data syncs with the server. This sync process can take up to 45 minutes, so you may not see the imported customers immediately.
All customers imported this way will show “CSV Import” as their source.
Related Articles
Customers: Managing Your Customer Database
Simplify customer management by keeping everything in one place If the Customer Module is activated, the system will automatically gather and manage your customer database using the different sources available to your restaurant. This database can be ...Integrations: Honei
What is Honei? Honei is a digital ordering and payment platform that allows in-house customers to place and pay for their orders directly from their mobile phones—without the need for staff intervention. How does the integration with Last.app work? ...Integration: Catcher
What does the integration between Last.app and Catcher do? The integration between Last.app and Catcher allows all closed sales from Last.app to be automatically sent to your Catcher system for accounting, analysis, or synchronization with other ...Integrations: TheFork
What is TheFork? TheFork is a reservation platform where customers can book a table online and, in many cases, prepay for their meal directly through TheFork app. How does the integration with Last.app work? This is a bidirectional integration ...Integrations: Google Bookings
Last.app Integration with Google Bookings The integration between Last.app and Google Bookings allows your customers to make reservations directly from Google Maps and the Google search engine. This feature boosts your restaurant’s online visibility ...
Popular Articles
Getting Started: Muting LastPOS
When a new order is received in LastPOS, the primary device (the "Master") emits a sound to notify staff. If you'd like to mute the system, you can easily do so by following these steps: How to Mute LastPOS Open the side menu by tapping the ...Integrations: FreshKDS
How to integrate FreshKDS with Last.app The integration between Last.app and FreshKDS allows you to automatically send kitchen items from your POS to KDS (Kitchen Display System) devices, optimizing kitchen operations and improving communication ...Getting Started: Enable or Disable Products and Modifiers from the POS
Enable or Disable Products and Modifiers from the POS In Last.app, you can easily enable or disable a product or modifier directly from the POS. The change will automatically apply across your POS system, delivery platforms, and online store — all at ...Getting Started: The Structure of LastPOS
The Structure of LastPOS LastPOS is the platform that enables end-to-end management of any food service establishment. It is built around two main components: POS (Point of Sale): The core system for managing in-house and takeaway operations. ...Getting Started: Table Functions
How to Manage Your Tables From the table layout view, you have several options to manage your tables. In this article, we’ll walk you through the table management menu and the view options menu. Table Management When you select a table, you can ...