The Scenario
System audit is next Tuesday. The compliance team sent a checklist item: remove all discontinued SKUs from Loyverse before the auditor reviews the catalog. The grocery store manager has a Google Sheet with 35 item IDs — products that were delisted three months ago but never removed from the POS system.
They're still showing up in search results at checkout. Staff have started marking them unavailable manually, which doesn't actually remove them — it just hides them inconsistently across registers.
The bad version:
- Search for item 1 by ID or name in Loyverse. Open the product record. Find the delete option. Confirm the deletion.
- 35 items. Each one is a search, a click-in, a confirmation dialog.
- Some items have variants. Loyverse may or may not remove the variants when you delete the parent — you have to check.
- By item 20 you've been doing this for 30 minutes and you've lost track of whether you deleted item 12 or just navigated away.
The audit is in five days. The catalog needs to be clean.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your list of item IDs and deletes each one from Loyverse in a single pass — no UI navigation, no confirmation dialog clicking.
Open the SheetXAI sidebar and paste this prompt:
Sheet 'Discontinue' has item_id in column A for 35 rows — delete all these items from Loyverse
What You Get
- All 35 items deleted from Loyverse, including their associated variants.
- Each row's result written back to column B: 'Deleted' or the specific error returned if an item ID wasn't found or couldn't be deleted.
- A final count: "35 of 35 items deleted" or a breakdown showing which succeeded and which need manual review.
What If the Data Is Not Quite Ready
The sheet has variant IDs instead of item IDs
Sheet 'Dead SKUs' lists variant_id in column A for 50 discontinued variants — delete all of these variants from Loyverse, write status in column B
Some items may have already been deleted in a previous cleanup pass
Sheet 'Discontinue' has item_id in column A — before deleting each item, check if it still exists in Loyverse; skip items that are already gone with a note 'Already removed' in column B, delete the rest and write 'Deleted' in column B
You want to export the items' data before deleting them
Sheet 'Discontinue' has item_id in column A — for each item, fetch its current name, category, and variant count from Loyverse and write to columns B/C/D as a backup record, then delete the items and write the deletion status in column E
Full audit-ready cleanup in one shot
Sheet 'Discontinue' — for each item_id in column A: fetch the item name from Loyverse and write to column B as an audit record, then delete the item; write 'Deleted' or the error in column C; at the bottom, write a summary row: total deleted, total failed, total not-found
Try It
Get the 7-day free trial of SheetXAI and open your discontinued items sheet before the audit, then ask SheetXAI to clear the full list from Loyverse in one sweep. See also export product catalog and the Loyverse integration overview.