The Scenario
The retail buyer's quarterly review is at 9 AM Thursday. She needs an inventory snapshot — all 850 variant rows across all 3 store locations — sorted by store and category, with anything below reorder threshold flagged.
It's Tuesday evening. She knows the data is in Loyverse. She doesn't have a clean way to get it into a spreadsheet.
The bad version:
- Open Loyverse's inventory report. Export store 1. Open in Sheets. Export store 2. Open in another tab. Export store 3. Open in a third tab.
- Combine them manually into one sheet. Reorder the columns to match the format the buying team uses.
- Write a formula to flag items below reorder threshold — which is stored in a separate reference sheet, so this becomes a VLOOKUP across two tabs.
- It's 11 PM. The review is in 10 hours.
The data exists. The question is whether it can be assembled into something useful before Thursday morning.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It pulls the full inventory state from Loyverse — all variants, all stores — and writes it to the sheet in the structure you specify in one call.
Open the SheetXAI sidebar and paste this prompt:
Fetch all Loyverse inventory levels across all stores and write to sheet 'Inventory Snapshot' with columns: item_name, variant_name, sku, store_name, quantity_in_stock, cost
What You Get
- 850 rows written to the 'Inventory Snapshot' sheet, one row per variant per store.
- Item name, variant name, SKU, store name, stock quantity, and cost pulled from Loyverse and written to the exact columns specified.
- Data sorted by store then item name by default — ready to filter or pivot.
What If the Data Is Not Quite Ready
You only need inventory for one specific store
Pull the current inventory for store 'Westside' from Loyverse into sheet 'Stock Check' with sku, item_name, variant, stock_level, and cost — sort by category then item_name
You want to add a reorder flag based on a threshold in column G of a reference sheet
Fetch all Loyverse inventory across all stores, write to 'Inventory Snapshot' with item_name, sku, store_name, quantity_in_stock — then for each row, check the 'Reorder Thresholds' sheet where column A is sku and column B is threshold; if quantity_in_stock is below the threshold, write 'Below threshold' in column E, otherwise write 'OK'
You want items grouped and subtotaled by category
Fetch all Loyverse inventory across all stores, write to 'Inventory Snapshot' grouped by category — for each category, list all variants with sku, store_name, quantity_in_stock, and cost, then add a subtotal row showing total units across all stores for that category
Full pre-review snapshot in one shot
Fetch all Loyverse inventory across all 3 stores — write to 'Inventory Snapshot' with item_name, category, variant_name, sku, store_name, quantity_in_stock, cost — sort by store then category then item_name — add a column F 'Status' with 'OK' or 'Low stock' based on whether quantity is above or below 5 units — add a summary row at the top showing total SKU count, total units, and count of low-stock items
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet on Tuesday evening, then ask SheetXAI to pull the full inventory snapshot from Loyverse in time for your Thursday review. See also export product catalog and the Loyverse integration overview.