A photoshoot comes back as a folder of 400 files named after SKUs. Shopify wants you to open each product, click Add media, find the right files, upload, wait, then point the right one at the right variant. For a new season that is a full day of dragging, and the failure mode is a photo on the wrong product, which nobody notices until a customer does.

The spreadsheet route turns it into three steps: upload the folder, let the filenames say where things go, and push.

How filenames decide placement

The convention is SKU_1.jpg, SKU_2.jpg — the SKU says which variant, the trailing number says which position. A file with no trailing number is that product's first image.

The parsing is forgiving about everything except the SKU. Separators, capitalisation and zero padding vary depending on whether the files came off a phone, a camera or a Dropbox export, and all of that is tolerated. The trailing number is read as the position and everything before it is the SKU — which matters, because plenty of real SKUs contain underscores and hyphens themselves.

What it will not do is guess. A file it cannot read a SKU from is reported as unmatched rather than attached to something approximately similar, on the principle that a photo on no product is a smaller problem than a photo on the wrong one.

Accepted formats are JPEG, PNG, WebP, GIF, HEIC and AVIF, up to 20MB per file and 100 files per batch.

Why the upload step exists

Shopify will not read an image out of your Google Drive. It needs a URL it can fetch, which is why SheetSync puts the file into your own Shopify Files first and hands you back the CDN URL to paste into the sheet.

This is the single most common thing people get wrong, so the check is explicit: a Google Drive or Docs share link is rejected with a message telling you to upload the file instead, and anything that is not an http(s) address — a local path, or a formula that came out as text — is caught at the row rather than failing at Shopify with something unhelpful.

What the Images sheet holds

One row per image, with Product ID, Variant ID, Product Name, Variant Name, Image ID, Image URL, Alt Text and Action.

The important column is Image ID. A row with an Image ID is an image that already exists in Shopify — editing its Alt Text updates it. A row with an Image URL and no Image ID is you saying "put this picture on this product", and that is what creates an attachment.

After a push the new Image IDs are written back into the sheet. That write-back is not cosmetic: without it, the next push would read the same row as a fresh instruction and attach the same photo again.

Products, variants, and why one row can be two jobs

In Shopify an image belongs to a product. A variant image is a product image that has also been pointed at a variant — it is not a separate thing. So a row naming a variant produces two pieces of work: create the media on the product, then point it at that variant.

This is worth internalising because it explains the Action column, below, and it explains why you cannot give a variant a photo that is not also in the product's media.

Shopify caps a product at 250 media items, and that ceiling is checked before anything is sent.

Unpinning a variant image: the Action column

Every row carries an Action — Keep, which is what everything says when it comes out of Shopify, or Remove.

Remove detaches; it does not delete. Taking the variant off leaves the photo exactly where it was, in the product's media. That is the entire point: the library survives, the pinning does not. This is the fix for the common situation where every variant was given its own mockup and you have since moved to rendering them from one photo — unpicking that by hand in the admin is variant-by-variant work.

There is deliberately no "remove from the product" option, because in Shopify that is a delete, and a dropdown is not where anyone should be able to destroy their photo library.

A blank Action cell means Keep. So does a dash, which is what sits in rows that have nothing to remove.

Step by step

  1. Name your files SKU_1.jpg, SKU_2.jpg and so on.
  2. Open the Product Images page in SheetSync and create or connect an images spreadsheet.
  3. Upload the folder. You get back a URL per file, plus a list of anything whose SKU could not be read.
  4. Paste the URLs into the Image URL column on rows for the right products, leaving Image ID blank.
  5. Fill in Alt Text while you are there — the images are in front of you and it will not be this easy again.
  6. Sync. Review the preview, then approve.
  7. Check that the new Image IDs came back into the sheet.

Practical notes

Upload the folder, not the files

Drop a folder of photos into SheetSync, paste the URLs into your sheet, and attach them in one sync.

Try SheetSync today
← Bulk edit image alt text