The Scenario
The franchise group is building a store-locator feature for their website. The web developer asked for a data file: all Loyverse store records with name, address, contact email, phone, and creation date — in an Excel workbook, formatted for the CMS import.
The franchise's regional manager has Loyverse access. He's never pulled store-level data out of Loyverse before. The developer is waiting.
The bad version:
- He opens Loyverse. Navigates to store management. Clicks into each store's settings.
- Copies name, address, phone, email, and creation date into an Excel workbook manually.
- 12 stores. Five fields each. About 60 manual data entries.
- Sends the workbook to the developer. Gets a reply: "Creation date is formatted inconsistently — some are MM/DD/YYYY, some are YYYY-MM-DD. Can you standardize?" He goes back and reformats.
A one-minute task from a data-access standpoint took 40 minutes because there was no export path.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It pulls all store records from Loyverse and writes them to the workbook in the format the CMS developer needs — one call.
Open the SheetXAI sidebar and paste this prompt:
Export all Loyverse stores to Excel 'Store Directory' with name, address, contact email, phone, and creation date
What You Get
- All 12 store records written to 'Store Directory' with the five columns specified.
- creation_date formatted consistently as YYYY-MM-DD.
- Data sorted by store name by default — ready for the CMS import.
What If the Data Is Not Quite Ready
The CMS needs address as separate fields (street, city, country)
Export all Loyverse stores to 'Store Directory' with store_id, name, street_address, city, country, phone, contact_email, timezone — sort by country then city
The developer needs the timezone in UTC offset format rather than IANA names
Export all Loyverse stores to 'Store Directory' with name, address, phone, contact_email — convert each store's timezone to a UTC offset string (e.g. America/Chicago becomes UTC-6) and write in column E
She wants to add a region grouping column for the website's filter feature
Export all Loyverse stores to 'Store Directory' with store_id, name, address, city, country, phone, contact_email — add a 'region' column: classify US stores as 'North America', UK stores as 'Europe', etc.
Full CMS-ready store data file in one shot
Export all Loyverse stores — write to 'Store Directory' with store_id, name, street_address, city, country, phone, contact_email, timezone, creation_date — sort by country then city — format creation_date as YYYY-MM-DD — add a header row and a count row at the bottom showing total store count
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook when the developer's request comes in, then ask SheetXAI to pull all Loyverse store records in the format the CMS import needs — the data file is ready before you write the reply. See also export payment type configurations and the Loyverse integration overview.