Customers: Import 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:

1. Name: First name(s) of the customer.
   
2. Surname: Last name(s) of the customer.
   
3. 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.
   
4. Email: Customer’s email address.
   
5. Address: Street name and number.
   
6. AddressDetails: Additional address info such as floor, apartment, building, etc.
   
7. PostalCode: Postal code.
   
8. Points: Loyalty points the customer might have.
   

It’s very important to keep the same column names and order. These fields feed the database in Last.App, and if a column is added, removed, or renamed, the system may not read the file correctly, and the customers won’t be visible.

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.

Important: The only required field is the phone number.

name	surname	phoneNumber	email	address	addressDetails	postalCode	points
Andrés	Perez	+34678123123	juan.perez@prueba.com	C. Prueba de Cañones, 2	Piso 3, puerta 1	41500	100
Camila	Juan	+34789123123		Camí del Sant Crist, 50	Bajos 2		0

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

  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 accessed directly from the Admin Panel. Manage the Customer ...

• Promotions: Overview

  Promotions Section In the Promotions section of Last.app, you can configure everything related to the customer loyalty program. This is also where you can create and manage all types of promotions for your restaurant. Below, we explain each part in ...

• Promotions: Creating Discounts

  How to create a discount promotion in Last.App In the Promotions section, you'll find the Discounts area. From here, you can create new promotions by following these steps: Create a New Promotion Click the “+” button to open a dialog box with ...

• Bookings Manager

  In the Last.App admin panel, under the “Reservation Manager” section, you can centrally manage all reservations for your restaurant. From here, you can: View upcoming (future) and past reservations. Search for reservations by name, phone number, ...

• Home

  Keep Track of Everything Happening in Your Restaurant With Last.app, you can monitor everything that’s going on in your restaurant in real time. From this section, you’ll be able to view various daily statistics for your venue. You’ll see your total ...

• Popular Articles

• Getting Started: Muting LastPOS

  Mute 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 ...

• Getting Started: Enable or Disable Products and Modifiers from the POS

  Enable or Disable Products and Modifiers from the POS In LastPOS, 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 ...

• Getting Started: How to Process Payments

  How to Process Payments When it’s time to charge a bill, LastPOS allows you to do it in several ways: All together Split evenly or by amount By individual items Below, we explain how to manage each payment method. Paying the Full Amount Open the bill ...