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.

Catalogue

Import groups Import categories Import products Update products Create containers Add products to a container Import selling formats

Inventory

Add stock Set the exact stock level Move stock between warehouses

Vendors and customers

Import vendors Link products to vendors Import customers

Cards, price rates and employees

Import gift cards Reload gift cards Import price rates Import employees Update employees

BEFORE YOU START: THERE ARE TWO IMPORTERS

NEW IMPORTER

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

FIELD	REQUIREMENT	DESCRIPTION	ADDITIONAL INFORMATION
Name	Required	The group's main name.	Free text.
Translations	Critical	Translations for multiple languages.	Essential: Map this field to the name column. Otherwise, it will be created with the generic name "New Item".
Id	Optional	Group identifier in the system.	Fill in only for updates.
Active	Optional	Defines whether the group is active.	0 (Inactive), 1 (Active).
Tax	Optional	Tax associated with the group.	Enter the tax's internal numeric ID.
Analytical group	Optional	The corresponding analytical group.	Enter the numeric ID.
Printer	Optional	The assigned order 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.

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

FIELD	REQUIREMENT	DESCRIPTION	ADDITIONAL INFORMATION
Group	Required	The group the category belongs to.	Enter the numeric ID or exact name of the parent group.
Name	Required	The category name.	Free text.
Translations	Critical	Translations for multiple languages.	Essential: Map this field to the name column. Otherwise, it will be created with the generic name "New Item".
Id	Optional	Internal category identifier.	Fill in only for updates.
Active	Optional	Defines whether the category is active.	0 (Inactive), 1 (Active).
Tax	Optional	Tax associated with the category.	Enter the numeric ID.
Analytical group	Optional	The corresponding analytical group.	Enter the numeric ID.
Printer	Optional	The assigned order 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.

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

EXACT HEADER	REQUIREMENT	DESCRIPTION	ADDITIONAL INFORMATION
category_id	Required	Category ID. Before importing, create the structure manually to obtain this ID.	Enter the numeric ID.
name	Required	Product name.	Free text (at least 3 characters).
super_group_id	Optional	ID of the analytical group assigned to the product.	Enter the numeric ID.
price	Optional	Retail price.	Use a decimal point.Example: 10.20
costPrice	Optional	Internal cost price.	Use a decimal point.Example: 8.20
type	Optional	Defines the product's operational type.	0: Product, 1: Menu, 2: Container, 3: Admission, 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 enabled.
hasInventory	Optional	Unit and stock tracking.	0 (Not tracked), 1 (Tracked).
displayInventory	Optional	Displays the remaining units in the app.	0 (Hidden), 1 (Show stock).
usesWeight	Optional	Links to a weighing scale.	0 (Does not use weight), 1 (Uses weight).
allergies	Optional	Allergens associated with the product.	Enter numeric IDs separated by semicolons (e.g. 1;5;14). ALLERGEN IDs: 1: Eggs 2: Sesame 3: Lupin 4: Mustard 5: Fish 6: Celery 7: Crustaceans 8: Peanuts 9: Molluscs 10: Soy 11: Nuts 12: Sulphites 13: Dairy 14: Gluten
isMenu	Optional	Defines whether it acts as a menu grouping.	0 (Not a menu), 1 (Menu-type product).
shouldAppearInMenuList	Optional	Whether it can be selected within other menus.	0 (Disabled), 1 (Enabled).
isOpen	Optional	Requires a price to be entered 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 printer assigned directly to the product.	Numeric ID.
printer_group_id	Optional	Default printer group assigned directly.	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.	Filename and extension.
info	Optional	Extended product description.	Free text.
buttonName	Optional	Short alternative name.	Displayed on the app's buttons.
nameKitchen	Optional	Alternative name for preparation tickets.	Free text.
dish_order_id	Optional	Dish serving order.	Numeric ID.
unit_id	Optional	Sales unit ID.	Numeric ID.
extra_id	Optional	External or Nielsen code, if applicable.	Alphanumeric text.
useAverageCostPrice	Optional	Average cost calculation.	0 (Inactive), 1 (Enabled).
cookDuration	Optional	Estimated preparation time.	Value in seconds (for KDS).
minQuantity	Optional	Minimum quantity when adding a product.	Numeric value.
extra_attributes	Optional	Special attributes.	Numeric ID.

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

EXACT HEADER	REQUIREMENT	DESCRIPTION	ADDITIONAL INFORMATION
id	Required	Unique product identifier in the database.	Internal REVO numeric ID.
super_group_id	Optional	ID of the analytical group assigned to the product.	Enter the numeric ID.

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

EXACT HEADER	REQUIREMENT	DESCRIPTION	ADDITIONAL INFORMATION
category_id	Required	ID of the category where the folder will be located.	Numeric ID.
name	Required	Display name of the container or folder.	Free text.
photo	Optional	Cover image filename.	Image filename.

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

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

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

item_id	quantity	warehouse_id
100	150	1
102	150	1
100	500	2

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

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 add inside.	Numeric ID.
order	Optional	Display order within the container.	Numeric value.
dish_order_id	Optional	Default dish order applied to this folder.	Numeric ID.
active	Optional	Product status within the folder view.	0 (Inactive), 1 (Active).

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	Selling price for this format.	Use a decimal point.
quantity	Required	Exact quantity to deduct from the overall stock.	Use decimals according to the unit.
unit_id	Required	ID of the stock measurement unit.	Numeric ID.
order	Required	Display order in the drop-down list.	Numeric value.
combination_group_id	Required	ID of the enforced combination group (if applicable).	Enter 0 if not applicable.

EXACT HEADER	REQUIREMENT	DESCRIPTION	ADDITIONAL INFORMATION
item_id	Required	ID of the products to restock.	Numeric ID.
quantity	Required	Quantity you want to ADD to the stock.	Positive numeric value.
warehouse_id	Required	ID of the warehouse receiving the stock.	Numeric ID.

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 or ideal stock quantity.	Numeric value.
alert	Optional	Minimum stock level that triggers an order alert.	Numeric value.

EXACT HEADER	REQUIREMENT	DESCRIPTION	ADDITIONAL INFORMATION
item_id	Required	ID of the products to transfer.	Numeric ID.
quantity	Required	Exact quantity to move.	Numeric value.
warehouse_id	Required	Source warehouse ID.	Warehouse from which stock is deducted (numeric ID).
to_warehouse_id	Required	Destination warehouse ID.	Warehouse to which stock is added (numeric ID).

EXACT HEADER	REQUIREMENT	DESCRIPTION	ADDITIONAL INFORMATION
name	Required	Vendor name.	Free text (at least 3 characters).
address	Required	Main billing or delivery address.	Free text.
nif	Required	NIF or tax identifier.	CIF, DNI, etc.
city	Optional	City or town.	Free text.
state	Optional	Province or state.	Free text.
country	Optional	Country where the vendor is based.	Free text.
postalCode	Optional	Postal code.	Alphanumeric.
web	Optional	Corporate website.	URL format.
email	Optional	Email address for orders.	Valid email address.
phone	Optional	Contact phone number.	Numeric.
notes	Optional	Internal notes and remarks.	Free text.
shouldBeNotified	Optional	Notify the vendor of status changes.	1 (Notify), 0 (Do not notify).

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

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 supplied by the vendor.	Numeric ID.
reference	Optional	Product reference code in the vendor's catalogue.	Alphanumeric.
pack	Optional	Units in each purchase pack or box.	Numeric value.
costPrice	Optional	Agreed cost price.	Use a decimal point.
unit_id	Optional	ID of the purchasing measurement unit.	Numeric ID.
tax_id	Optional	ID of the input tax on purchases.	Numeric ID.

EXACT HEADER	REQUIREMENT	DESCRIPTION	ADDITIONAL INFORMATION
name	Required	Customer name or company name.	Free text (at least 3 characters).
address_country	Conditional	Country.	Required if a NIF or any other address field is entered. ISO 3166-1 alpha-2 code (example: ES).
address_street_address	Conditional	Street address.	Required if a NIF is entered.
address_postal_code	Conditional	Postal code.	Required if a NIF is entered.
address_city	Conditional	City or town.	Required if a NIF is entered.
address_state	Conditional	Province or state.	Required if a NIF is entered.
nif	Optional	NIF or tax identifier.	If entered, the address becomes mandatory.
active	Optional	Customer status.	0 (Inactive), 1 (Active).
email	Optional	Email address.	Valid email format.
phone	Optional	Contact phone number.	Must include the international dialling code to be valid (e.g. +34644847774 valid, 644847774 invalid).
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.

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

Import XEF

BEFORE YOU START: THERE ARE TWO IMPORTERS

CATALOGUE

THE NEW IMPORTER

THE NEW IMPORTER

INVENTORY

VENDORS

CUSTOMERS AND GIFT CARDS

PRICE RATES AND EMPLOYEES

Contact

Support

EXACT HEADER	REQUIREMENT	DESCRIPTION	ADDITIONAL INFORMATION
uuid	Required	Unique card identification code.	Can contain text and numbers.
total	Required	Initial balance generated.	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 different from the total.
campaign_id	Optional	Associated promotional campaign.	Numeric campaign ID.
customer_id	Optional	Customer assigned to the card by name.	Numeric customer ID.

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

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.

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 price rate to which the price applies.	Numeric ID.
price	Required	Amount you want to set for the specified price rate.	Price with a decimal point.
priceable_type	Required	Base element type.	Use the exact value from the table below.

TYPE	VALUE TO ENTER IN THE COLUMN
Products	App\Models\Menu\MenuItem
Menu items	App\Models\Menu\MenuMenuPivot
Modifiers	App\Models\Menu\Modifier
Selling format	App\Models\Menu\ItemSellingFormatPivot
Combinations	App\Models\Menu\Combination

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 privilege.	Numeric ID.
active	Optional	Employee status in the workforce.	0 (Inactive), 1 (Active).
surname	Optional	Surname.	Free text.
username	Optional	Username for accessing the web back-office.	Short text without spaces.
password	Optional	Back-office password.	Alphanumeric.
email	Optional	Email address.	Valid email address.
phone	Optional	Contact phone number.	Numeric.
notes	Optional	Internal notes.	Free text.
profile_id	Optional	Default employee profile.	Numeric ID.
photo	Optional	Visual avatar.	Filename and extension.
cashier_id	Optional	Assigned default cash register.	Numeric ID.
identifier	Optional	POS security key identifier.	Hexadecimal value (NFC, QR...).
back_permission_id	Optional	Back-office privilege level.	Numeric ID.
nif	Optional	Employee's national identity number (DNI).	Alphanumeric.

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

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