The Scenario
The e-commerce manager is doing a catalog reconciliation. The Shopify catalog has 310 SKUs. Loyverse has the source-of-truth product data. She needs to export everything from Loyverse — item_id, item_name, category, variant_id, variant_name, sku, sell_price, cost_price — and compare it against the Shopify export sitting in another Excel workbook.
She has Loyverse access. She's done this kind of reconciliation before. She has not done it with Loyverse data specifically.
The bad version:
- Open Loyverse. Navigate to product export. Download CSV.
- Open in Excel. The CSV has variants grouped under items with blank cells for repeated item-level fields — item_name is only on the first row of each item group, blank on the rest.
- She needs variant_id and item_id in the export. The CSV only has internal reference codes, not the actual API IDs she'd need for Shopify reconciliation.
- Spend 30 minutes filling down item names and trying to figure out which column contains the actual Loyverse variant_id.
The reconciliation was supposed to take an hour. The data cleanup is now the whole afternoon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It pulls the full Loyverse product catalog with all fields at the variant level — no grouped rows, no blank cells — in whatever column structure she specifies.
Open the SheetXAI sidebar and paste this prompt:
Export every Loyverse item and variant to Excel 'SKU Master' with item_id, item_name, variant_id, variant_name, sku, sell_price, cost_price, and category
What You Get
- Every Loyverse item and variant written to 'SKU Master', one row per variant.
- item_name and category repeated on every row — no blank cells from a grouped layout.
- item_id and variant_id as Loyverse API IDs, ready for reconciliation or system import.
- sell_price and cost_price as numbers.
What If the Data Is Not Quite Ready
She only needs items in a specific category for a partial reconciliation
Export all Loyverse items in the 'Apparel' category and their variants to Excel 'SKU Master' with item_id, item_name, category, variant_id, variant_name, sku, sell_price, cost_price
She wants to cross-reference against the Shopify export in the same workbook
Fetch all Loyverse items and variants, write to 'Loyverse SKUs' worksheet with sku, sell_price, item_name, variant_name — then compare against 'Shopify SKUs' worksheet column A (sku): flag any Loyverse SKUs not present in Shopify in column E with 'Missing from Shopify'
She wants the data sorted by category and item name
Export all Loyverse items and variants to 'SKU Master' with item_id, item_name, category, variant_id, variant_name, sku, sell_price, cost_price — sort by category ascending then item_name ascending
Full SKU master export in one shot
Export every Loyverse item and variant to Excel '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 Excel workbook, then ask SheetXAI to pull the full Loyverse product catalog with API-level IDs — reconciliation-ready in one call. See also export inventory snapshot and the Loyverse integration overview.