Revo Support

With Revo XEF, you can import CSV files separated by ";". The first row must contain the header with the field names exactly as described below.

Before you start

There are two importers

Check which one to use for each type of data.

Before you start: there are two importers

New importerFree headers · column mapping

Used for Groups and Categories. Access it from Catalogue → Groups. To import groups, press Import. To import categories, first open the group you want to add them to and, from inside it, press Import. The system lets you map the columns, so the CSV does not need headers with exact names.

It is also used for modifier categories, from Catalogue → Modifiers.

Legacy CSV importerStrict headers

Used for all other imports. Access it from revoxef.works/tools/import. In this importer, the headers must match exactly the ones shown in each section. Price rates use their own URL.

If you start from the importer's template, delete the instruction lines before the header: the first row must be the header, with the fields separated by ;. You can delete any optional columns you do not need.

Catalogue

Create and update your catalogue

Import groups, categories, products, containers and selling formats.

Catalogue

1Import groups

New importer

Free headers: when you upload the CSV, match each column to its field in Map the fields.

To create or update groups in bulk, go to Catalogue → Groups and press Import. The new groups importer opens.

The new importer

With the new importer, the columns in your CSV file do not need specific names. When you upload the file, the system lets you Map the fields, linking each column in your file to the corresponding REVO field.

Fields available for mapping:

Field to map	Requirement	Description	Additional information
Nombre	Required	The main name of the group.	Free text.
Translations	Critical	Translations for multi-language.	Essential: Map it to the name column. Otherwise, it will be created with the generic name "New Item".
Id	Optional	Identifier of the group in the system.	Only filled in for updates.
Activo	Optional	Defines whether the group is active or not.	0 (Inactive), 1 (Active).
Impuesto	Optional	The tax linked to the group.	Enter the internal numeric ID of the tax.
Analytical group	Optional	The corresponding analytical group.	Enter the numeric ID.
Impresora	Optional	The assigned ticket printer.	Enter the numeric ID.
Printer group	Optional	The assigned printer group.	Enter the numeric ID.
Status flow	Optional	The kitchen status flow (KDS).	Enter the numeric ID.
Extra ID	Optional	Additional field for integration identifiers.	Free alphanumeric text.

CSV example · Import groups

Nombre	Bebidas	Comida	Postres
Traduccion	Bebidas	Comida	Postres
ID			15
Activo	1	1	1
Impuesto	1	2	2
Grupo_Analitico	3	4	5
Impresora	2	4	4
Grp_Impresoras	0	2	0
Flujo_Estados	1	1	2
Extra_ID	EXT-001	EXT-002	EXT-003

2Import categories

New importer

Free headers: when you upload the CSV, match each column to its field in Map the fields.

To import categories in bulk, go to Catalogue → Groups, open the group you want to add the categories to and, from inside the group, press Import. The new categories importer opens.

The new importer

It works exactly like the groups importer: you can upload any CSV and map the columns manually.

Fields available for mapping:

Field to map	Requirement	Description	Additional information
Grupo	Required	The group the category belongs to.	Enter the numeric ID or the exact name of the parent group.
Nombre	Required	The category name.	Free text.
Translations	Critical	Translations for multi-language.	Essential: Map it to the name column. Otherwise, it will be created with the generic name "New Item".
Id	Optional	Internal identifier of the category.	Only filled in for updates.
Activo	Optional	Defines whether the category is active or not.	0 (Inactive), 1 (Active).
Impuesto	Optional	The tax linked to the category.	Enter the numeric ID.
Analytical group	Optional	The corresponding analytical group.	Enter the numeric ID.
Impresora	Optional	The assigned ticket printer.	Enter the numeric ID.
Printer group	Optional	The assigned printer group.	Enter the numeric ID.
Status flow	Optional	The kitchen status flow.	Enter the numeric ID.
Extra ID	Optional	Additional field for external integrations.	Free alphanumeric text.

CSV example · Import categories

Nombre	Refrescos	Cervezas	Tapas
Grupo	Bebidas	Bebidas	Comida
Traduccion	Refrescos	Cervezas	Tapas
ID			32
Activo	1	1	1
Impuesto	1	1	2
Grupo_Analitico	6	6	7
Impresora	2	3	5
Grp_Impresoras	0	0	2
Flujo_Estados	1	1	2
Extra_ID	EXT-010	EXT-011	EXT-012

3Import modifier categories

New importer

Free headers: when you upload the CSV, match each column to its field in Map the fields.

To import modifier categories in bulk, go to Catalogue → Modifiers and press Import. The new modifier category importer will open.

The new importer

It works exactly like the groups importer: you can upload any CSV and map the columns manually.

Fields available for mapping:

Field to map	Requirement	Description	Additional information
Nombre	Required	The name of the modifier category.	Text of at least 3 characters. Example: Punto de cocción.
Min	Required	Minimum of the minimum and maximum modifier setting.	Whole number of 1 or more and not greater than Max. Example: 1.
Max	Required	Maximum of the minimum and maximum modifier setting.	Whole number between 1 and 1000, equal to or greater than Min. Example: 1.
Id	Optional	Identifier of the modifier category.	Numeric ID.
Activo	Optional	Defines whether the modifier category is active or not.	0 (Inactive), 1 (Active).
Oculto	Optional	Defines whether the modifier category is hidden or not.	0 (Visible), 1 (Hidden).
Translations	Optional	Translations for multi-language.
Selección	Optional	Previous setting: whether there is a selection.	0 (No selection), 1 (With selection). Deprecated.
Last field, unnamed	Optional	Previous setting: whether the selection is mandatory or optional.	0 (Mandatory), 1 (Optional). Deprecated.

CSV example · Import Modifier Categories

Nombre	Punto de cocción	Salsas	Guarnición
Activo	1	1	1
Oculto	0	0	0
Min	1	1	1
Max	1	3	1

In the importer, mandatory fields have an asterisk (*). Selección and the last unnamed field are deprecated: they are replaced by Min and Max, which require app 4.3 or later.

4Import productsPRODUCTS

Legacy CSV importerStrict headers

name;nameKitchen;buttonName;price;photo;order;active;info;isOpen;cookDuration;type;hasInventory;usesWeight;category_id;super_group_id;extra_id;minQuantity;report_category_id;config;tax_id;printer_id;printer_group_id;modifier_category_id;modifier_group_id;costPrice;useAverageCostPrice;displayInventory;allergies;dish_order_id;barcode;unit_id;extra_attributes;nutrition;kds_status_flux_id

Option for importing products and setting them up through a CSV file.

With Revo XEF, you can import CSV files separated by ";". The first row must contain the header with the field names exactly as described below.

ImportantThe field names in the header must be exactly the same as written here. No capital letter at the start, no spaces, no ":" symbol.
Correct: category_id
Incorrect: Category_id / CATEGORY_ID / category id

Exact header	Requirement	Description	Additional information
category_id	Required	Category ID. Before importing, create the structure manually to get this ID.	Enter a numeric ID.
name	Required	Product name.	Free text (minimum 3 characters).
super_group_id	Optional	ID of the analytical group assigned to the product.	Enter a numeric ID.
price	Optional	Retail sale price.	Use a dot for decimals. Example: 10.20
costPrice	Optional	Internal cost price.	Use a dot for decimals. Example: 8.20
type	Optional	Defines the operational nature of the product.	0: Product, 1: Menu, 2: Container, 3: Starter, 4: Format, 5: Gift card, 6: Management only, 7: Kit.
active	Optional	Visibility status on the POS.	0 (Inactive), 1 (Active). If omitted, all are activated.
hasInventory	Optional	Unit and stock control.	0 (No control), 1 (With control).
displayInventory	Optional	Shows the remaining units in the app.	0 (Not shown), 1 (Shows stock).
usesWeight	Optional	Links to a scale.	0 (No weight), 1 (Uses weight).
allergies	Optional	Allergies linked to the product.	Enter the numeric IDs separated by semicolons (e.g. 1;5;14).
ALLERGEN IDS0No allergens (null)1Eggs2Sesame3Lupin4Mustard5Fish6Celery7Crustaceans8Peanuts9Molluscs10Soy11Tree nuts12Sulphites13Dairy14Gluten
isMenu	Optional	Defines whether it acts as a menu grouper.	0 (Not a menu), 1 (Menu-type product).
shouldAppearInMenuList	Optional	Whether it can be selected inside other menus.	0 (Off), 1 (On).
isOpen	Optional	Requires entering a price manually when selling.	0 (Fixed price), 1 (Open product).
order	Optional	Display order within the category.	Use numbers: 1, 2, 3, etc.
barcode	Optional	Product barcode.	Numeric value or EAN.
tax_id	Optional	Default product tax.	Numeric ID.
printer_id	Optional	Default direct printer for the product.	Numeric ID.
printer_group_id	Optional	Default direct printer group.	Numeric ID.
modifier_group_id	Optional	Product-specific modifier group.	Numeric ID.
modifier_category_id	Optional	Modifier category assigned to the product.	Numeric ID.
photo	Optional	Product image.	File name and extension.
info	Optional	Extended product description.	Free text.
buttonName	Optional	Short alternative name.	To show on the app's button panel.
nameKitchen	Optional	Different name for preparation tickets.	Free text.
dish_order_id	Optional	Course order.	Numeric ID.
unit_id	Optional	Selling unit ID.	Numeric ID.
extra_id	Optional	External or Nielsen code, if applicable.	Alphanumeric text.
useAverageCostPrice	Optional	Average cost calculation.	0 (Off), 1 (On).
cookDuration	Optional	Estimated preparation time.	Value in seconds (for KDS).
minQuantity	Optional	Minimum quantity when adding the product.	Numeric value.
extra_attributes	Optional	Special attributes.	Numeric ID.

ImportantNote that setting the printer or modifiers directly on products can cause problems later. If it is set per product, you will have to change or remove it one by one. If it is set on the category or group, it can be changed in a few clicks.

CSV example · Import products

category_id	10	15	25
super_group_id	3
name	Café Solo	Coca Cola	Menú Diario
price	1.30	1.80	12.50
costPrice	0.20	0.50	4.00
type	0	0	1
active	1	1	1
hasInventory	1	1	0
displayInventory	0	0	0
usesWeight	0	0	0
allergies			1;5;14
isMenu	0	0	1
shouldAppearInMenuList	0	0	1
isOpen	0	0	0
order	1	2	3
barcode	84123456	84123457
tax_id	1	1	2
printer_id	2
printer_group_id	1
modifier_group_id	4
modifier_category_id	5
photo	cafe.jpg	cola.jpg	menu.jpg
info	Arábica	Refresco	Completo
buttonName	Café S	Coca C	Menu Dia
nameKitchen	CAFE SOLO	COCA COLA	MENU DIARIO
dish_order_id	0	0	0
unit_id	2	2	1
extra_id	EX-001	EX-002	EX-003
useAverageCostPrice	0	1	0
cookDuration	120	0	0
minQuantity	1	1	1
extra_attributes	0	0	0

5Update productsPRODUCTS UPDATE

Legacy CSV importerStrict headers

Same header as the template for Import products, with id as the first column.

Option for updating or adding information to existing products through a CSV file.

As the ID is required, we recommend starting from a previously exported REVO product list.

Exact header	Requirement	Description	Additional information
id	Required	Unique identifier of the product in the database.	Internal REVO numeric ID.
super_group_id	Optional	ID of the analytical group assigned to the product.	Enter a numeric ID.

CSV example · Update products

id	100	101
category_id	10	15
super_group_id	3
name	Café Solo Intenso	Coca Cola Zero
price	1.40	1.90
costPrice	0.22	0.55
type	0	0
active	1	1
hasInventory	1	1
displayInventory	0	0
usesWeight	0	0
allergies	14
isMenu	0	0
shouldAppearInMenuList	0	0
isOpen	0	0
order	1	2
barcode	84123456	84123457
tax_id	1	1
printer_id	2
printer_group_id	1
modifier_group_id	4
modifier_category_id	5
photo	cafe_new.jpg	colaz.jpg
info	Nuevo	Zero
buttonName	Intenso	Coca Z
nameKitchen	CAFE INTENSO	COCA ZERO
dish_order_id	0	0
unit_id	2	2
extra_id	EX-001	EX-002
useAverageCostPrice	0	1
cookDuration	120	0
minQuantity	1	1
extra_attributes	0	0

6ContainersCONTAINERS

Legacy CSV importerStrict headerscategory_id;name;photo

Containers are folders where you can group products. They are a "fourth level" after Groups, Categories and Products.

Exact header	Requirement	Description	Additional information
category_id	Required	ID of the category where the folder will be.	Numeric ID.
name	Required	Display name of the container/folder.	Free text.
photo	Optional	File name of the cover photo.	File name and image.

CSV example · Containers

category_id	10	15	17
name	CAFÉS	AGUAS	VINOS TINTOS
photo	carpeta_cafes.jpg	carpeta_aguas.jpg	carpeta_vinos.jpg

7Container productsCONTAINER ITEMS

Legacy CSV importerStrict headersorder;active;item_id;main_item_id;dish_order_id

Links products to an existing container.

You can get the IDs by hovering over the pencil icon in the back-office.

Exact header	Requirement	Description	Additional information
main_item_id	Required	ID of the parent container (folder).	Numeric ID.
item_id	Required	ID of the products you want to put inside.	Numeric ID.
order	Optional	Display order within the container.	Numeric value.
dish_order_id	Optional	Default course applied in this folder.	Numeric ID.
active	Optional	Product status in the folder view.	0 (Inactive), 1 (Active).

CSV example · Container products

main_item_id	15	15	15
item_id	140	141	142
order	1	2	3
dish_order_id	0	0	0
active	1	1	1

8Selling formatsITEM SELLING FORMATS

Legacy CSV importerStrict headersactive;quantity;price;order;format_id;item_id;combination_group_id;unit_id

Import products with selling formats (mixed drink, neat, shot, etc.).

Exact header	Requirement	Description	Additional information
item_id	Required	Base product ID.	Numeric ID.
format_id	Required	ID of the configured selling format.	Numeric ID.
price	Required	Sale price for this format.	Use a dot for decimals.
quantity	Required	Exact quantity to deduct from general stock.	Use decimals according to the unit.
unit_id	Required	Stock unit of measure ID.	Numeric ID.
order	Required	Display order in the drop-down.	Numeric value.
combination_group_id	Required	ID of the forced mixed-drink group (if applicable).	Enter 0 if not applicable.

CSV example · Selling formats

item_id	196	196	196
format_id	3	4	5
price	12.00	11.00	3.00
quantity	1.00	1.00	0.20
unit_id	7	7	7
order	1	2	3
combination_group_id	2	0	0

Inventory

Adjust the stock in your warehouses

Add stock, set the exact stock after a count or move it between warehouses.

Inventory

9Add inventoryINVENTORY ADD

Legacy CSV importerStrict headersitem_id;quantity;warehouse_id

Adds stock to your products, especially useful the first time.

If you have several warehouses, repeat the product ID with different warehouse_id.

Exact header	Requirement	Description	Additional information
item_id	Required	IDs of the products to stock.	Numeric ID.
quantity	Required	Quantity you want to ADD to stock.	Positive numeric value.
warehouse_id	Required	ID of the warehouse receiving the stock.	Numeric ID.

CSV example · Add inventory

	A	B	C
1	item_id	quantity	warehouse_id
2	100	150	1
3	102	150	1
4	100	500	2

10Set/count inventoryINVENTORY SET

Legacy CSV importerStrict headersitem_id;quantity;warehouse_id;defaultQuantity;alert

Sets the exact stock of your products. Ideal after an inventory count.

Exact header	Requirement	Description	Additional information
item_id	Required	Product IDs.	Numeric ID.
quantity	Required	Exact physical quantity to set.	Numeric value that overwrites the previous one.
warehouse_id	Required	Warehouse ID.	Numeric ID.
defaultQuantity	Optional	Reference / ideal stock quantity.	Numeric value.
alert	Optional	Minimum stock to receive an order alert.	Numeric value.

CSV example · Set inventory

item_id	100	110
quantity	100	232
warehouse_id	1	1
defaultQuantity	200	400
alert	10	20

11Move inventoryINVENTORY MOVE

Legacy CSV importerStrict headersitem_id;quantity;warehouse_id;to_warehouse_id

Moves stock between warehouses.

Exact header	Requirement	Description	Additional information
item_id	Required	IDs of the products to move.	Numeric ID.
quantity	Required	Exact quantity to move.	Numeric value.
warehouse_id	Required	Source warehouse ID.	Warehouse that subtracts (numeric ID).
to_warehouse_id	Required	Destination warehouse ID.	Warehouse that adds (numeric ID).

CSV example · Move inventory

item_id	100	102
quantity	100	100
warehouse_id	1	1
to_warehouse_id	2	2

Vendors

Prepare the purchasing module

Import vendors and link them to your products.

Vendors

12Import vendorsVENDORS

Legacy CSV importerStrict headers

Import vendors in bulk to use the purchasing module.

Exact header	Requirement	Description	Additional information
name	Required	Vendor name.	Free text (minimum 3 characters).
address	Required	Main billing/delivery address.	Free text.
nif	Required	Tax ID.	Company or personal tax ID, etc.
city	Optional	City or town.	Free text.
state	Optional	Province or state.	Free text.
country	Optional	Vendor's country.	Free text.
postalCode	Optional	Postal code.	Alphanumeric.
web	Optional	Corporate website.	URL format.
email	Optional	Email address for orders.	Valid email.
phone	Optional	Contact phone.	Numeric.
notes	Optional	Internal notes and remarks.	Free text.
shouldBeNotified	Optional	Notify the vendor of status changes.	1 (Notify), 0 (Do not notify).

CSV example · Import vendors

name	Proveedor 1	Proveedor 2
address	Gran Via, 30	Via Laietana, 222
nif	A58818501	B54416504
city	Madrid	Barcelona
state	Madrid	Barcelona
country	España	España
postalCode	28010	08010
web	www.prov1.es	www.prov2.com
email	pedidos@prov1.es	info@prov2.es
phone	+34 912345678	+34 931234567
notes	Alimentación	Refrescos
shouldBeNotified	1	0

13Vendor productsVENDORS ITEMS

Legacy CSV importerStrict headers

Links products to your vendors to use the purchasing module.

Exact header	Requirement	Description	Additional information
vendor_id	Required	ID of the vendor created in the system.	Numeric ID.
item_id	Required	ID of the REVO product it supplies.	Numeric ID.
reference	Optional	Product reference code in the vendor's catalogue.	Alphanumeric.
pack	Optional	Units in each purchase pack/box.	Numeric value.
costPrice	Optional	Agreed cost price.	Use a dot for decimals.
unit_id	Optional	Purchase unit of measure ID.	Numeric ID.
tax_id	Optional	ID of the purchase tax.	Numeric ID.

CSV example · Vendor products

vendor_id	1	1
item_id	100	102
reference	REF-01	REF-02
pack	24	24
costPrice	0.25	0.30
unit_id	1	1
tax_id	2	2

Customers and gift cards

Load customers and gift cards

Import customers and gift cards, or top up existing cards.

Customers and gift cards

14Import customersCUSTOMERS

Legacy CSV importerStrict headers

active;name;last_name;nif;email;phone;language;photo;level;nationality;birth_date;gender;allergies;promotions_accepted;web;notes;extra_id;extra_attributes;remember_token;prevent_deletion;vat_validation;address_name;address_address_line_2;address_street_address;address_postal_code;address_city;address_state;address_country;address_geolocation;address_notes

Import customers in bulk.

Exact header	Requirement	Description	Additional information
name	Required	Customer or company name.	Free text (minimum 3 characters).
address_country	Conditional	Country.	Required if the tax ID or any other address field is entered. ISO 3166-1 alpha-2 code (example: ES).
address_street_address	Conditional	Street address.	Required if the tax ID or any other address field is entered.
address_postal_code	Conditional	Postal code.	Required if the tax ID or any other address field is entered.
address_city	Conditional	City or town.	Required if the tax ID or any other address field is entered.
address_state	Conditional	Province or state.	Required if the tax ID or any other address field is entered.
nif	Optional	Tax ID.	If entered, the address becomes required.
active	Optional	Customer status.	0 (Inactive), 1 (Active).
email	Optional	Email address.	Valid email format.
phone	Optional	Contact phone.	Must include the international prefix to be valid (e.g. +34644847774 OK, 644847774 NOT OK).
language	Optional	Preferred language for communications.	ISO code (es, en, fr...).
nationality	Optional	Nationality.	Free text.
birth_date	Optional	Customer's date of birth.	Strict format: YYYY-MM-DD.
gender	Optional	Gender.	Male, Female or Other.
allergies	Optional	Customer's allergies.	IDs separated by semicolons (e.g. 1;5;14).

web	Optional	Company website.	URL.
notes	Optional	Customer notes or preferences.	Free text.
extra_id	Optional	Assignment to a Customer Group.	Numeric ID.
address_notes	Optional	Home delivery notes.	Free text.

CSV example · Import customers

name	Hugo Reyes	Maggie Greene
address_country	ES	ES
address_street_address	Gran Via, 30	Calle de La Paz, 11
address_postal_code	28010	46003
address_city	Madrid	Valencia
address_state	Madrid	Valencia
nif	A58818501	V51218667
active	1	1
email	hugo@mail.com	maggie@mail.com
phone	+34600123456	+34600654321
language	es	en
nationality	Española	Británica
birth_date	1980-05-15	1992-10-22
gender	Male	Female
allergies	14
web	www.hugo.es
notes	Plato especial	Mesa con vistas
extra_id	1	2
address_notes	Dejar en recepcion	Llamar al timbre

15Gift cardsGIFT CARDS

Legacy CSV importerStrict headerscampaign_id;customer_id;active;uuid;total;balance;extra_attributes

Import gift cards in bulk into the back-office.

Exact header	Requirement	Description	Additional information
uuid	Required	Unique identification code of the card.	Can contain text and numbers.
total	Required	Initial balance.	Must be numeric.
active	Optional	Defines whether the card is already active.	0 (Inactive), 1 (Active).
balance	Optional	Actual remaining balance.	Fill in only if it differs from the total.
campaign_id	Optional	Linked promotional campaign.	Numeric campaign ID.
customer_id	Optional	Customer linked by name.	Numeric customer ID.

CSV example · Gift cards

uuid	00000123456	TR1234567	Pedro Gonzalez
total	100.00	50.00	75.00
active	1	1	1
balance	100.00	25.00	75.00
campaign_id	1	1	2
customer_id			405

16Reload gift cardsGIFT CARDS RELOAD

Legacy CSV importerStrict headersuuid;reloadAmount

Import top-ups to gift cards.

Exact header	Requirement	Description	Additional information
uuid	Required	Exact code of the existing gift card.	Alphanumeric.
reloadAmount	Required	Amount to add to the current balance.	Numeric, using a decimal point.

CSV example · Reload cards

	A	B
1	uuid	reloadAmount
2	00000123456	100.00
3	00000789100	100.00

Price rates and employees

Import price rates and employees

Set prices by rate and create or update employees.

Price rates and employees

17Price ratesPRICE RATES

Legacy CSV importerStrict headers

To import price rates, go to: https://revoxef.works/thrust/prices/import

Exact header	Requirement	Description	Additional information
ID	Required	Base product identifier.	Numeric ID.
priceable_id	Required	Identifier of the price within the referenced product.	Numeric ID.
table_price_id	Required	Identifier of the rate the price applies to.	Numeric ID.
price	Required	Amount you want to set for the indicated rate.	Price with a dot for decimals.
priceable_type	Required	Base item type.	Use exactly the value in the table below.

Values for priceable_type:

Type	Value to enter in the column
Products	`App\Models\Menu\MenuItem`
Menu products	`App\Models\Menu\MenuMenuPivot`
Modifiers	`App\Models\Menu\Modifier`
Selling format	`App\Models\Menu\ItemSellingFormatPivot`
Mixed drinks	`App\Models\Menu\Combination`

CSV example · Price rates

ID	100	101	102
priceable_id	902	870	331
table_price_id	2	2	2
price	4.00	3.00	1.50
priceable_type	App\Models\Menu\MenuItem	App\Models\Menu\MenuMenuPivot	App\Models\Menu\Modifier

18EmployeesEMPLOYEES

Legacy CSV importerStrict headers

name;active;surname;pin;username;email;nif;phone;notes;password;photo;identifier;permission_id;cashier_id;back_permission_id;extra_id;config;profile_id

Import employees in bulk.

Exact header	Requirement	Description	Additional information
name	Required	Employee name.	Free text.
pin	Required	Access PIN for the iPad POS.	Numeric value.
permission_id	Required	App security permission.	Numeric ID.
active	Optional	Employee status on staff.	0 (Inactive), 1 (Active).
surname	Optional	Surname.	Free text.
username	Optional	Username for the web back-office.	Short text without spaces.
password	Optional	Secret password for the back-office.	Alphanumeric.
email	Optional	Email address.	Valid email.
phone	Optional	Contact phone.	Numeric.
notes	Optional	Internal notes.	Free text.
profile_id	Optional	Default employee profile.	Numeric ID.
photo	Optional	Avatar.	File name and extension.
cashier_id	Optional	Default assigned cashier.	Numeric ID.
identifier	Optional	POS security key identifier.	Hexadecimal value (NFC, QR...).
back_permission_id	Optional	Back-office permission level.	Numeric ID.
nif	Optional	Employee ID number.	Alphanumeric.

CSV example · Employees

name	Fran	Lucía
pin	1111	2222
permission_id	1	2
active	1	1
surname	Marjolaine	Kailey
username	Fran	Lucia
password	pass123	pass456
email	fran@mail.com	lucia@mail.com
phone	600111222	600333444
notes	Encargado	Camarera
profile_id	2	1
photo	fran.jpg	lucia.jpg
cashier_id	0	0
identifier	1A2B3C	4D5E6F
back_permission_id	2	1
nif	12345678A	87654321B

19Update employeesUPDATE EMPLOYEES

Legacy CSV importerStrict headers

Updates the information of existing employees. Start from the employee list exported as CSV.

Exact header	Requirement	Description	Additional information
id	Required	Unique internal identifier of the employee.	Numeric ID generated by REVO.

CSV example · Update employees

id	2	3
name	Maria	Pedro
pin	1122	3344
permission_id	1	2
active	1	0
surname	Garcia	Lopez
username	maria	pedro
password	marIa24!	pEdro24!
email	maria@mail.com	pedro@mail.com
phone	600999888	600777666
notes		Baja
profile_id	2	1
photo	maria.jpg	pedro.jpg
cashier_id	0	0
identifier	7G8H9I	0J1K2L
back_permission_id	1	3
nif	11111111C	22222222D

Import XEF

Before you start: there are two importers

Catalogue

The new importer

The new importer

The new importer

Inventory

Vendors

Customers and gift cards

Price rates and employees

Contact

Support