Bulk Import a Supplier Directory Into Loyverse From an Excel workbook

The Scenario

The vendor list for the restaurant chain is in an Excel workbook called 'Vendor List' — 40 rows, each with supplier_name, country, currency, and notes. These are the vendors who will be linked to purchase orders once the Loyverse account is fully set up.

The ops manager asked you to "get the suppliers in Loyverse" yesterday afternoon. It's now the next morning and the purchasing team is waiting on the supplier records to exist before they can start creating purchase orders.

The bad version:

• Open Loyverse's supplier creation form. Enter supplier_name. Enter country. Enter currency. Enter notes. Save.
• 40 suppliers. Each is a form open, four field entries, a save.
• On supplier 18 you notice "notes" in your workbook contains commas, and the Loyverse notes field behaves oddly with certain punctuation. You test a few and decide to skip the notes field for now.

This is a data transfer problem dressed up as a supplier setup task. The data exists. It just can't move on its own.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Excel workbook. It reads your vendor list and bulk-creates all 40 suppliers in Loyverse in one operation.

Open the SheetXAI sidebar and paste this prompt:

Excel 'Vendor List' has supplier_name, country, currency, and notes — bulk-create all vendors as Loyverse suppliers

What You Get

• All 40 supplier records created in Loyverse with the fields from the workbook.
• Any rows with a missing required field flagged in column E rather than silently dropped.
• A count written at the end: "40 of 40 suppliers created" or a breakdown of successes and failures.

What If the Data Is Not Quite Ready

Some suppliers already exist in Loyverse from a previous import

Excel 'Vendor List' — before creating each supplier, check if a record with the same supplier_name already exists in Loyverse; skip duplicates and write 'Already exists' in column E; create all new ones

The workbook has contact details that need to be included

Excel 'Vendor List' has supplier_name, country, currency, notes, contact_person, email, phone — create all 40 suppliers in Loyverse including all available contact fields

You want to add a default payment term column that isn't in Loyverse but needs to be noted in the spreadsheet

Create all 40 suppliers in Loyverse from the Excel 'Vendor List' — write the Loyverse supplier_id returned for each row back to column F so the purchasing team can reference it for purchase orders

Full vendor setup in one shot

Excel 'Vendor List' — trim whitespace from supplier_name, skip rows where it's blank, check each supplier against Loyverse for duplicates by name, create all new ones, write 'Created' / 'Duplicate skipped' / error in column E

Try It

Get the 7-day free trial of SheetXAI and open your vendor workbook, then ask SheetXAI to register all suppliers in Loyverse before the purchasing team needs to create their first order. See also export supplier directory and the Loyverse integration overview.