The Problem With Getting Workbook Data In and Out of Loyverse
You have an Excel workbook full of data — 600-row stock counts from a physical inventory walk, variant pricing tables after a seasonal revision, customer records from a system you're migrating away from. You need it in Loyverse, or you need Loyverse data back in the workbook, and neither direction is straightforward.
Loyverse handles point-of-sale well for small retail and hospitality operations. But its data doesn't move easily. The moment you need to bulk-push 50 vendors before setting up purchase orders, or pull three months of receipts for a revenue analysis, you're either in the Loyverse UI clicking through records one at a time or wrestling with a CSV that needs cleanup before it's usable.
Below are the four common ways teams handle this. Only the last one scales.
Method 1: Manual CSV Export and Paste
The default for Excel users is exporting a CSV from Loyverse, opening it in Excel, and reconciling it against the workbook by hand. Column headers don't match. Formats differ. You spend 45 minutes cleaning before you can actually do the analysis you sat down to do.
Going the other direction is worse: entering items or customers into Loyverse one at a time through the product or customer editor, field by field, for however many rows your workbook has.
For a one-time setup with a handful of records, you live with it.
Once you're doing this for 200 customers migrated from a legacy system, or 120 menu items for a new location opening next week, the manual pace stops making sense.
And here's the part that costs the most over time: every time the workbook changes, you're back doing it again. The two sources drift apart with no automated way to re-sync.
Method 2: Power Automate
Power Automate has a Loyverse connector. You can build a flow that triggers on an Excel table row change, calls the Loyverse API, and creates or updates the corresponding record.
Quick check before going further — do you know what a flow trigger is? A dynamic content expression? An HTTP action with JSON body construction? If any of those feel opaque, this path will cost you more time than it saves. Skip ahead to Method 3 or 4.
For those who stayed: the flow works, once built. You wire up the trigger, map the fields, handle the nested variant structure in Loyverse's data model, deal with authentication.
But one trigger fires one row. Bulk-importing 80 variants through a trigger-per-row flow means 80 separate API calls, and when row 27 returns an error the rest still fire — you have no clean rollback and a partial import sitting in Loyverse.
You probably just need the price corrections applied so the new retail prices go live before the weekend. You probably have no idea how to build a Power Automate flow with error handling and a retry policy. So the task gets passed to whoever manages your automations, and now you're checking in with them Friday afternoon hoping it's done.
Method 3: The Previous Generation — Connector Add-Ons
Until recently, the best option for repeatable workbook-to-Loyverse workflows was a category of add-ons that let you configure field mappings manually, save templates, and run imports on demand. You tagged which column mapped to which Loyverse field, saved the config, and ran it when ready.
That was a real step forward from manual. Imports were consistent, the config survived between sessions, and anyone on the team could run it without rebuilding the mapping from scratch.
But you were still responsible for designing the mapping, handling field validation, and debugging when Loyverse rejected a row. The tool got the data through the pipe — the thinking about what to include, how to handle errors, what to do when a required field is blank — was still entirely yours. And if the workbook's column layout changed, the config silently broke.
This was the previous generation. It worked, but it asked a lot of whoever was running it.
The Easy Way: Using SheetXAI in Excel
There is a different way. SheetXAI is an AI agent that lives inside your Excel workbook. It reads the worksheet, understands the structure, and through its built-in Loyverse integration it can push to or pull from Loyverse for you. No field-mapping template, no automation flow, no pre-cleaning required. You just ask.
Example 1: Bulk-import inventory items from a workbook
Excel sheet 'SKU Master' has columns A–F: product name, SKU, category, price, cost, barcode for 120 items — bulk-create all of them in Loyverse as inventory items
SheetXAI reads the column layout, maps each field to Loyverse's item schema, and creates all 120 records in one operation.
Example 2: Push a physical stock count to Loyverse
Sheet 'Recount' has sku, store_name, and new_stock_level — look up variant IDs by SKU and store IDs by name, then set inventory levels in Loyverse
It resolves the lookups, matches the IDs, and pushes all 600 rows of corrected quantities in a single pass.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with Loyverse data — a product table, a customer list, a stock count — then ask it to do one of the tasks above. The Loyverse integration is included in every SheetXAI plan.
More Loyverse + Excel guides
Bulk Import a Product Catalog Into Loyverse From a Google Sheet
Load hundreds of items and variants into Loyverse in one shot from a structured spreadsheet.
Bulk Update Variant Pricing and Barcodes in Loyverse From a Google Sheet
Push seasonal price revisions and barcode corrections across dozens of variants without touching Loyverse one row at a time.
Bulk Import a Customer Database Into Loyverse From a Google Sheet
Migrate hundreds of customer records including loyalty points from any source into Loyverse in a single operation.
Push a Physical Stock Count Into Loyverse From a Google Sheet
Reconcile counted quantities against live inventory levels across multiple store locations in one pass.
Bulk Import a Supplier Directory Into Loyverse From a Google Sheet
Register all your vendors in Loyverse at once before setting up purchase orders.
Bulk Create Tax Rate Configurations in Loyverse From a Google Sheet
Push a full set of tax rules into Loyverse before a new fiscal year without clicking through the UI twelve times.
Bulk Create Promotional Discounts in Loyverse From a Google Sheet
Get an entire set of sale-event discount rules live in Loyverse from a single spreadsheet operation.
Sync a Product Category Structure Into Loyverse From a Google Sheet
Create or overwrite your full category tree in Loyverse from a reorganized spreadsheet in one shot.
Bulk Create Item Modifier Groups in Loyverse From a Google Sheet
Load all your add-on and cooking-preference modifier groups into Loyverse before service opens.
Export Loyverse Receipts to a Google Sheet for Sales Analysis
Pull a full month of POS receipts into a spreadsheet with line-item detail for top-seller and peak-hour analysis.
Export Loyverse Employee Shift Logs to a Google Sheet for Payroll
Pull shift records for any date range into a spreadsheet to calculate hours worked per employee.
Export a Full Inventory Snapshot From Loyverse to a Google Sheet
Pull every variant's stock level across all store locations into a spreadsheet for auditing or reorder planning.
Export the Loyverse Product Catalog to a Google Sheet
Pull every item and variant with SKU, price, cost, and barcode into a spreadsheet for catalog reconciliation.
Export Loyverse Customers to a Google Sheet for CRM and Loyalty Campaigns
Pull your full customer list with loyalty points and spend totals into a spreadsheet to identify top customers.
Generate a Cross-Store Sales Summary From Loyverse in a Google Sheet
Pull receipts data and produce a pivot-ready store-by-store revenue breakdown without leaving your spreadsheet.
Export Loyverse Payment Type Configurations to a Google Sheet for Auditing
List every payment method across all store locations in a spreadsheet to audit and standardize your setup.
Bulk Update Item Images in Loyverse From a Google Sheet
Replace product photos across sixty-plus items in one operation using image URLs stored in a spreadsheet.
Export the Loyverse Supplier Directory to a Google Sheet
Pull every vendor record into a spreadsheet to share with accounts-payable or build a master vendor list.
Bulk Delete Discontinued Items From Loyverse Using a Google Sheet
Remove a list of obsolete items or variants from Loyverse in one sweep using IDs stored in a spreadsheet.
Export the Loyverse Store Directory to a Google Sheet
Pull every location record with address, phone, and timezone into a spreadsheet for a store-locator data file.