How to import your catalog from a CSV file

If your catalog lives in Excel or your POS, exporting it to CSV is the fastest way to load it all into Boleani. Here is how.

1. 1

   Build the file with the right headers

   The first row is the headers. Boleani recognizes: name, price, description, category, variations, stock and sku (it accepts synonyms like product, rate, section, reference). For appointment businesses, also duration (service minutes) and capacity (clients at once). Only "name" is required.

   name	price	category	variations
   Classic burger	9.00	Burgers	Add-on: Cheese(+1) | Bacon(+1.5)
   Lemonade	3.00	Drinks	Size: Glass | Pitcher(+2.5)
   Medium pizza	14.00	Pizzas	Crust: Thin | Regular

   name	price	category	variations	stock	sku
   Boleani tee	22.00	Apparel	Size: S | M | L | XL	40	TEE-001
   Steel bottle	29.00	Accessories	Color: Black | Silver(+4)	15	BTL-014
   Cap	15.00	Accessories		0	CAP-007

   name	price	category	duration	capacity	description
   Haircut	20.00	Salon	30	2	Cut and styling
   Dental checkup	60.00	Health	45	1	Initial assessment
   Property viewing	0	Real estate	60	1	Guided unit tour

   name	category	description
   Business hours	Info	Monday to Friday 8am-6pm; Saturday 9am-1pm.
   Return policy	Policies	Returns accepted within 30 days with a receipt.
   Order status	Orders	Ask for the order number and check its status in the system.

   The price can include a currency symbol and separators; Boleani cleans it automatically (e.g. "$12.50" or "12,50"). For services: "duration" in minutes (e.g. 60) and "capacity" as a number (1 = one at a time). If omitted, Boleani uses 30 min and 1 client.

2. 2

   Save the file as CSV (UTF-8)

   From Excel or Google Sheets, choose "Save as" or "Download as" and select CSV. Prefer UTF-8 encoding so accents and special characters read correctly.

3. 3

   Open Connections and pick "CSV File"

   In the dashboard, go to "Catalog & Menu", open Integrations / Connections and select "CSV File".

4. 4

   Drag the file and import it

   Drag your CSV into the upload area (or select it). Boleani processes the rows and creates your products with name, price, category and variations in seconds.

5. 5

   Review the result in your catalog

   Go to "Catalog & Menu" and check that products, prices and variations came in correctly. You can edit any item by hand if needed.