The Scenario
The bakery did a full photo shoot last week. Sixty products, all new images, all uploaded to the photography team's shared folder as URLs in a Google Sheet: column A has the item ID, column B has the new image URL.
The current product photos in Loyverse are the ones from the soft launch — low-res, shot on a phone. The menu display board and the online ordering page pull from Loyverse. Until the images are updated, the new photos aren't live anywhere.
The bad version:
- Open Loyverse's product editor. Find item 1 by name. Click into the image section. Delete the existing photo. Paste the new URL or upload from the URL. Save.
- Sixty items. Each one is a search, a click-in, a delete, a paste, a save.
- By item 20 you've been doing this for 40 minutes and you realize you need to double-check whether "delete existing and upload new" is the right sequence or whether Loyverse lets you just replace in place.
The photographer is asking when the new shots will be live. The answer is "after someone clicks through sixty product records."
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your item ID and image URL columns, replaces the current image on each Loyverse item, and moves through all 60 rows without you touching the product editor.
Open the SheetXAI sidebar and paste this prompt:
Sheet 'Item Images' has item_id and image_url for 60 rows — delete the existing image for each item and upload the new one from the URL in column B
What You Get
- All 60 items in Loyverse updated with the new product images from the URLs in column B.
- Each row's result written back to column C: success confirmation or the error message if an item ID wasn't found or the URL was unreachable.
- No partial updates without notice — every row gets a status.
What If the Data Is Not Quite Ready
The sheet has item names instead of item IDs
Sheet 'Photo Update' has item_name and new_image_url — look up each item by name in Loyverse, find its ID, delete the existing image, and upload the new one from the URL in column B; flag any names that didn't match a Loyverse item in column C
Some items have multiple images and you only want to replace the first one
Sheet 'Item Images' has item_id and image_url — for each item, replace only the primary (first) image with the new URL in column B, leave any additional images untouched
The image URLs are not publicly accessible yet — you need to verify them first
Sheet 'Item Images' has item_id and image_url — before updating, verify that each URL in column B returns a 200 status when fetched; flag any that are unreachable in column C, then update Loyverse only for the rows with accessible URLs
Full image refresh in one shot
Sheet 'Item Images' — trim whitespace from item_id and image_url columns, skip rows where either column is blank, verify each URL is accessible, flag unreachable ones in column C, update Loyverse images for all accessible rows, write 'Updated' or the error in column C
Try It
Get the 7-day free trial of SheetXAI and open your photo update sheet, then ask SheetXAI to push all new images to Loyverse before the menu board refreshes tonight. See also bulk import product catalog and the Loyverse integration overview.
