The Scenario
The weekly stock count wrapped up two hours ago. Three teams, three stores, 600 rows — variant ID, store ID, counted quantity — all recorded in a single Google Sheet by floor staff with handheld scanners. The data is in. The discrepancies are in there too: items that show 12 units in Loyverse but only 8 were actually on the shelf.
Until the system reflects the real numbers, any sale of those variants is a potential stockout that nobody will catch in time.
The bad version:
- You export Loyverse's inventory report, open it alongside the stock count sheet, and manually compare row by row.
- You find the discrepancies and go into Loyverse's inventory adjustment tool, search for each variant by name, find the right store, enter the corrected quantity.
- 600 rows across three stores means potentially hundreds of adjustments. You're still doing this at midnight.
Every hour those numbers are wrong in the system is an hour where the POS is working from bad information.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your stock count table and updates inventory levels in Loyverse for every row — all stores, all variants, in one pass.
Open the SheetXAI sidebar and paste this prompt:
Sheet 'Stock Count' has columns: variant_id, store_id, counted_quantity — batch-update inventory levels in Loyverse for all 600 rows
What You Get
- All 600 inventory records updated in Loyverse to match the counted quantities in the sheet.
- Each row's result written back to column D: success confirmation or the specific error returned if a variant ID or store ID wasn't found.
- No silent failures — every row gets a status.
What If the Data Is Not Quite Ready
The sheet has SKUs and store names instead of IDs
Sheet 'Recount' has sku, store_name, and new_stock_level — look up variant IDs by SKU and store IDs by store name, then set inventory levels in Loyverse for each matched row; flag any SKU or store that didn't resolve to a Loyverse ID
Some rows have negative quantities from counting errors
Sheet 'Stock Count' — before updating, flag any rows where counted_quantity is less than 0 in column D with the note 'Negative quantity — check', skip those rows, then update all remaining rows in Loyverse
You only want to update rows where the count differs from current Loyverse levels
Sheet 'Stock Count' — for each variant_id and store_id pair, fetch the current inventory level from Loyverse, compare it to counted_quantity, update only the rows where they differ, and write the previous and new quantities in columns D and E
Full recount reconciliation in one shot
Sheet 'Stock Count' — trim whitespace from all ID columns, convert counted_quantity to integers, flag rows with missing variant_id or store_id, skip blanks, update all valid rows in Loyverse, write a reconciliation note in column D: 'Updated from X to Y' or the error message
Try It
Get the 7-day free trial of SheetXAI and open your stock count sheet right after the walk — then ask SheetXAI to push all corrected levels to Loyverse before the next shift starts. See also export full inventory snapshot and the Loyverse integration overview.