The Scenario
SKU corrections came down from the warehouse team on Friday. An Excel sheet called 'SKU Corrections' — 45 rows — each with variant_id and corrected_sku. Barcodes were reprinted last week. Loyverse's records still have the old SKUs.
The weekend shift starts in two hours. Every scan at checkout will either hit the wrong product or fail entirely until the correction is applied.
The bad version:
- Open Loyverse's product editor. Search for each variant by the old SKU or by item name. Click into the variant. Update the SKU field. Save.
- 45 variants across however many parent items. Each one is a search, a navigate, an edit, a save.
- Three variants in, you've already had to scroll through 12 results to find the right one because the item name search is returning everything with a similar name.
The weekend shift supervisor is already at the location. The SKUs need to be right before customers start scanning items.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your correction table and updates each variant's SKU in Loyverse directly — no product editor navigation.
Open the SheetXAI sidebar and paste this prompt:
Excel sheet 'SKU Corrections' lists variant_id and corrected_sku for 45 rows — update each variant's SKU in Loyverse
What You Get
- All 45 variants updated with the corrected SKUs from the workbook.
- Each row's result written to column C: 'Updated' or the specific error if a variant_id wasn't found.
- No silent failures — every row gets a status before you close the workbook.
What If the Data Is Not Quite Ready
Some variant IDs in the sheet have extra whitespace from a copy-paste
Excel 'SKU Corrections' — trim whitespace from the variant_id column before matching against Loyverse, then update SKUs for all matched rows; write status in column C
You also need to update prices on the same variants
Excel 'Price Update' has variant_id, new_price, new_cost, new_barcode for 80 rows — update all three fields on each variant in Loyverse; write 'Updated' or the error in column E
You want to verify all variant IDs exist before making any changes
Excel 'SKU Corrections' — first check each variant_id in column A against Loyverse and flag any that don't exist in column C, then update SKUs only for the rows that returned a valid match
Full SKU correction run in one shot
Excel 'SKU Corrections' — trim variant_id, skip rows where either column is blank, verify each variant_id exists in Loyverse before updating, apply the corrected_sku for all valid rows, write status in column C: 'Updated', 'Not found', or the error message
Try It
Get the 7-day free trial of SheetXAI and open your corrections workbook before the shift starts, then ask SheetXAI to push all SKU updates to Loyverse in one pass. See also bulk import product catalog and the Loyverse integration overview.