The Scenario
The bakery refreshed all 60 product photos last week. The photographer delivered a spreadsheet: 'Photo Update' with two columns — item_name in column A and new_image_url in column B. The bakery owner needs those images in Loyverse before the weekend, when the menu display board pulls the updated photos.
It's Thursday afternoon.
The bad version:
- Open Loyverse's product editor. Search for item 1 by name. Navigate to the image section. Delete the existing photo. Paste the new URL. Save.
- 60 items. Each one is a search, a navigate, a delete, a paste, a save.
- On item 22, the search for "Blueberry Croissant" returns three results because there's a "Blueberry Croissant (Mini)" and a "Blueberry Croissant (Large)" too. She spends 90 seconds figuring out which one to update.
The display board refreshes Friday evening. The images need to be in Loyverse before then. At 3 minutes per item, 60 items is a 3-hour job starting now.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your item names and new image URLs, looks up each item in Loyverse by name, and replaces the image — all 60 in one pass.
Open the SheetXAI sidebar and paste this prompt:
Excel 'Photo Update' has item_name and new_image_url — look up each item by name in Loyverse and replace its current image with the new one
What You Get
- All 60 Loyverse items updated with new product images from the URLs in column B.
- Each row's result written to column C: 'Updated' or the error message if a name didn't match or the URL was unreachable.
- Items with multiple name matches flagged for manual review rather than applying to the wrong product.
What If the Data Is Not Quite Ready
Some item names in the workbook don't exactly match Loyverse item names
Excel 'Photo Update' — for each item_name in column A, look up the closest match in Loyverse by name (case-insensitive, trimmed whitespace); if there's exactly one match, update the image; if there are multiple, flag in column C as 'Multiple matches — review'; write status in column C
Some image URLs point to private or expired storage links
Excel 'Photo Update' — before updating each item, verify the image URL returns a 200 status; flag any unreachable URLs in column C as 'URL unavailable'; update Loyverse images only for rows with accessible URLs
The workbook has item IDs instead of item names
Excel 'Photo Update' has item_id and new_image_url — delete the existing image for each item and upload the new one from the URL in column B; write status in column C
Full image refresh in one shot
Excel 'Photo Update' — trim whitespace from item_name and image URL, verify each URL is accessible, flag unreachable ones in column C, look up items in Loyverse by name (exact match), update images for all matched rows, write 'Updated' or error in column C
Try It
Get the 7-day free trial of SheetXAI and open your photo update workbook on Thursday, then ask SheetXAI to push all new images to Loyverse before the display board refreshes on Friday evening. See also export product catalog and the Loyverse integration overview.