The Scenario
You opened a new café location three weeks from now. You have the entire menu — 120 items across 8 categories, each with size variants and individual prices — sitting in a Google Sheet that the kitchen manager built out over the past month. The sheet is clean. The categories are right. The variants are laid out in columns.
Loyverse is installed on the new iPad POS. It's empty.
The bad version:
- You open the Loyverse product editor and start creating items one at a time — name, category, then a separate step for each variant with its price.
- Forty items in, you realize you transposed Small and Medium prices on a row of drinks. You go back and fix them manually.
- Three hours later you're through 80 items, the coffee is cold, and the lunch rush starts in 45 minutes.
This isn't a data problem. It's a sequencing problem disguised as one. The menu exists — it's just trapped in a format that can't talk to Loyverse directly, and every minute you spend on manual entry is a minute not spent on the things that actually need your attention before opening day.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the spreadsheet structure, understands what you're looking at, and through its built-in Loyverse integration it creates items, variants, categories, and prices in a single operation. No export, no manual field mapping.
Open the SheetXAI sidebar and paste this prompt:
Read the 'Menu' sheet — column A is item name, B is category, C/D/E are variants Small/Medium/Large with prices in columns F/G/H — create all items and their variants in Loyverse
What You Get
- 120 items created in Loyverse with their respective categories assigned.
- Each item gets three variants (Small, Medium, Large) with the correct price from columns F, G, and H.
- If a category doesn't yet exist in Loyverse, SheetXAI creates it first.
- Any rows with missing required fields are flagged with an error note written back to the sheet in column I — nothing silently skips.
What If the Data Is Not Quite Ready
The variant columns are inconsistent — some items only have one size
Read 'Menu' sheet — some items have all three size variants in columns C/D/E and F/G/H, others only have a single price in column F with columns G/H blank — create each item with however many variants are populated, skipping blank size columns
The category names in the sheet don't match existing Loyverse categories
Read 'Menu' sheet — column B has category names; before creating items, check which categories already exist in Loyverse, create any that are missing, then create all items assigned to the correct category
Items are spread across multiple tabs by category
Combine items from the 'Hot Drinks', 'Cold Drinks', and 'Food' sheets — each has the same column layout: A is item name, C/D/E are variant names, F/G/H are prices — create all items in Loyverse with the tab name as the category
Full cleanup and load in one shot
Read 'Menu' sheet — trim whitespace from all name columns, convert price columns F/G/H from text to numbers, skip any rows where column A is blank, create all remaining items and their variants in Loyverse, write a status note in column I for each row indicating success or the error returned
One prompt handles the cleaning, the validation, and the creation without you reviewing each step in between.
Try It
Get the 7-day free trial of SheetXAI and open your menu spreadsheet — even if it's not perfectly formatted — then ask SheetXAI to load it into Loyverse. For related operations, see how to bulk update variant pricing or sync your category structure, and the Loyverse hub overview for all supported operations.