Push a Physical Stock Count Into Loyverse From an Excel workbook

The Scenario

Three store teams counted physical stock over the weekend. All 600 rows came back in a single Excel workbook: SKU in column A, store name in column B, counted quantity in column C. The workbook is sitting in the shared drive.

Loyverse's inventory numbers are what they were on Friday. The physical count says some of those numbers are wrong by a meaningful amount — items that show 20 units in the system but only 6 were on the shelf.

Every sale of an overstated item until the correction runs is a potential oversell.

The bad version:

• Export Loyverse's inventory report. Open it. Cross-reference it against the stock count workbook row by row.
• For every discrepancy, go into Loyverse's inventory adjustment tool: search for the item, find the right variant, find the right store, enter the corrected count.
• 600 rows, unknown number of discrepancies. Even if only 20% of rows need adjustment, that's 120 manual inventory edits.

The stores open in three hours. The count is sitting in the drive.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Excel workbook. It reads your stock count table and pushes corrected inventory levels to Loyverse for every row — all variants, all stores.

Open the SheetXAI sidebar and paste this prompt:

Excel 'Recount' sheet 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

What You Get

• All inventory levels updated in Loyverse to match the counted quantities in the workbook.
• Variant IDs and store IDs resolved automatically from SKU and store name — no manual ID lookup needed.
• Each row's result written to column D: success or the specific error if an SKU or store name didn't resolve.

What If the Data Is Not Quite Ready

The workbook has variant IDs and store IDs directly — no lookup needed

Excel 'Stock Count' sheet has variant_id, store_id, counted_quantity for 600 rows — batch-update inventory levels in Loyverse for all rows; write status in column D

Some counted quantities are clearly wrong (negative or over 9999)

Excel 'Recount' sheet — before updating, flag any rows where new_stock_level is negative or greater than 9999 in column D with 'Quantity out of range', skip those rows, then update all remaining rows in Loyverse

You only want to update rows where the count differs from current Loyverse inventory

Excel 'Recount' — for each row, fetch the current inventory level from Loyverse for that SKU and store, compare to new_stock_level, update only rows where they differ, write the old and new values in columns D and E

Full reconciliation run in one shot

Excel 'Recount' — trim whitespace from sku and store_name, skip rows where either is blank, look up variant and store IDs, flag any that don't resolve, update inventory in Loyverse for all valid rows, write 'Updated from X to Y' or the error in column D

Try It

Get the 7-day free trial of SheetXAI and open the stock count workbook before the stores open, then ask SheetXAI to push all corrected levels to Loyverse in one pass. See also export inventory snapshot and the Loyverse integration overview.