The Scenario
The restaurant chain's new Loyverse account is configured. Menus are in. Stores are set up. But purchase orders can't be created yet because there are no suppliers in the system. The procurement team's master vendor list — 40 suppliers with company name, contact person, email, phone, and address — has been sitting in a Google Sheet for two weeks.
The general manager wants purchase orders flowing by end of the week.
The bad version:
- You open Loyverse's supplier creation form and start filling in each record by hand: name, contact, email, phone, address.
- 40 suppliers, maybe five fields each, is 200 individual field entries if nothing goes wrong.
- On supplier 22 you realize the contact name column in the sheet is "Contact Person" and you've been reading "Primary Contact" — a column that only exists in your head. You go back and check.
This isn't the kind of work that needs thinking. It needs to not exist.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your supplier directory and registers all 40 vendors in Loyverse in a single operation.
Open the SheetXAI sidebar and paste this prompt:
Sheet 'Suppliers' has name, contact_name, email, phone, and address for 40 rows — create all of them as suppliers in Loyverse
What You Get
- 40 supplier records created in Loyverse with all contact details from the sheet.
- Any rows with a missing required field flagged in column F with a specific error note.
- A confirmation 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
The sheet has supplier contacts split across two tabs
Combine suppliers from the 'Domestic Vendors' and 'International Vendors' sheets — both have the same column layout: name, contact_name, email, phone, address — create all of them as suppliers in Loyverse, noting which tab each came from in column F
Some suppliers are already in Loyverse from a previous partial import
Sheet 'Suppliers' — before creating each supplier, check if a record with that email already exists in Loyverse; skip duplicates and note 'Already exists' in column F, create all new ones
The address is split across separate street/city/country columns
Sheet 'Suppliers' has name, contact_name, email, phone, street, city, country — concatenate street, city, and country into a single address field, then create all supplier records in Loyverse
Full import with deduplication in one shot
Sheet 'Suppliers' — trim whitespace from all columns, skip rows where name is blank, check each email against existing Loyverse suppliers and skip duplicates, create all new suppliers, write status in column G: 'Created', 'Duplicate skipped', or the error returned
Try It
Get the 7-day free trial of SheetXAI and open your vendor master sheet, then ask SheetXAI to register all your suppliers in Loyverse before purchase orders start. See also export supplier directory and the Loyverse integration overview.