The Scenario
A handoff landed in your inbox this morning. The person who managed the online store catalog left last month. Their successor sent a Slack message: "I need all the Loyverse products with variant-level detail so I can reconcile with Shopify. SKU, price, cost, barcode — everything."
You're the one who has Loyverse access. You're not the one who's going to do the reconciliation. You just need to get the data out.
The bad version:
- Open Loyverse's product export. Download the CSV.
- Open it. The export format puts variants as separate rows but doesn't carry the item-level attributes down to each variant row — so item name shows on the first variant row and is blank on the rest.
- Forward the CSV to the catalog manager. Get a reply 20 minutes later: "The item names are only on the first row of each item. Can you fix it?" Go back, write a fill-down formula, re-export a cleaned version.
The actual work took 10 minutes. Getting to a usable file took 45.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It pulls the complete Loyverse product catalog — every item, every variant — and writes it to a sheet in the structure your catalog manager can actually use.
Open the SheetXAI sidebar and paste this prompt:
List all items in Loyverse including all variants and write to sheet 'Product Catalog' with columns: item_name, category, variant_name, sku, barcode, price, cost
What You Get
- Every Loyverse item and variant written to the 'Product Catalog' sheet, one row per variant.
- Item name and category repeated on every row — no blank cells from a grouped export format.
- SKU, barcode, price, and cost at the variant level, not collapsed to a single row per item.
- Ready to filter, sort, or hand off without any cleanup.
What If the Data Is Not Quite Ready
The catalog manager needs item IDs and variant IDs for the reconciliation
List all Loyverse items and variants and write to 'Product Catalog' with item_id, item_name, category, variant_id, variant_name, sku, barcode, sell_price, cost_price
You only need products in a specific category
List all Loyverse items in the 'Beverages' category including all variants and write to 'Beverages Catalog' with item_name, variant_name, sku, price, cost, barcode
You want items sorted by category and then by item name
List all Loyverse items and variants, sort by category ascending then item_name ascending, write to 'Product Catalog' with item_name, category, variant_name, sku, barcode, price, cost
Full SKU master export in one shot
Export every Loyverse item and variant to 'SKU Master' with item_id, item_name, category, variant_id, variant_name, sku, sell_price, cost_price, barcode — sort by category then item_name — add a header row and a count row at the bottom showing total items and total variants
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, then ask SheetXAI to pull the full Loyverse product catalog into it — you'll have something usable in under two minutes. See also export inventory snapshot and the Loyverse integration overview.