The Scenario
Seasonal price revision hit this week. Your boutique manager sent over a Google Sheet: 80 clothing variants with item ID, variant ID, new price, updated cost, and corrected barcode. Corporate approved the changes yesterday. The sale window opens Saturday morning.
The sheet is sitting in your inbox. Loyverse has all 80 variants in it, each needing to be updated individually.
The bad version:
- You search for each item by name in Loyverse's product editor.
- You find the specific variant, click into it, update the price field, update the cost, fix the barcode if it changed.
- You do this 80 times. Some items have 4 variants each, so "80 variants" means navigating through 20 parent items and clicking into each variant tab.
- Halfway through, you lose track of which rows you've already done and have to cross-reference the sheet manually.
The window closes Friday night. You have two days. Nobody should be spending those two days on this.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your variant update table, maps each row to the correct Loyverse variant by ID, and applies all the changes in one pass. You don't open Loyverse until you're confirming the results.
Open the SheetXAI sidebar and paste this prompt:
Sheet 'Price Update' has columns: item_id, variant_id, new_price, new_cost, new_barcode — update all 80 variants in Loyverse with these values
What You Get
- All 80 variants updated in Loyverse with the new prices, costs, and barcodes from the sheet.
- Each row's result — success or the specific error returned — written back to column F so you have a clean audit trail.
- Rows where variant_id doesn't match anything in Loyverse are flagged, not silently skipped.
What If the Data Is Not Quite Ready
Only some fields need updating — the rest should stay as-is
Sheet 'Price Update' has variant_id, new_price, and new_cost — the barcode column is blank for rows where it didn't change; update only price and cost for each variant, leave barcode untouched on blank rows
The sheet has variant IDs but some rows have typos or wrong-format IDs
Sheet 'Price Update' — before updating, verify each variant_id in column B exists in Loyverse; flag any that return a not-found error in column F, then apply updates only to the rows that matched
You have SKUs instead of variant IDs
Sheet 'SKU Corrections' has columns: sku, new_price, new_cost — look up each variant in Loyverse by SKU, then apply the new price and cost from the sheet to the matched variant
Full revision with cleanup in one shot
Sheet 'Price Update' — trim whitespace from variant_id column, convert new_price and new_cost from text to decimal numbers, skip any rows where variant_id is blank, update all remaining variants in Loyverse, write status in column G: 'Updated' or the error message returned
Try It
Get the 7-day free trial of SheetXAI and open your price-revision sheet, then ask SheetXAI to push all the changes to Loyverse before your sale window opens. See also bulk import product catalog for adding new items, and the Loyverse integration overview.