SyncTool has no separate "bulk image upload" action. Images are attached automatically as part of an ordinary Products import. The easiest way to give several products the same image is to point every item number at the same image file in a single column in your source list — you only need to keep one copy of the image.
Save the image in one place on disk, for example C:\ProductImages\shared.jpg. You only need one copy — several products can point at the same file. Supported file types: .jpg, .jpeg, .png, .webp, .gif and .tif.
Create a CSV/Excel file (or SQL query) with two columns: one with the item number and one with the path to the image. Enter the same image path next to every item number the image should be attached to:
Item number | Image |
SKU123 | C:\ProductImages\shared.jpg |
SKU456 | C:\ProductImages\shared.jpg |
SKU789 | C:\ProductImages\shared.jpg |
The image path in the column can be:
a full local path (for example C:\ProductImages\shared.jpg),
a file name or a relative path that exists in the Image folder parameter, or
a web URL (for example https://.../shared.jpg), which SyncTool downloads automatically.
Select the Products action in SyncTool.
Point at your CSV/Excel file (or SQL query) with the item numbers as the source.
Map the item-number column to Identifier in the column mapping.
Map the image column to Primary image (PrimaryImageUrl). If you want to attach several images per product, there are also Image 1…Image 12 (ImageUrl1–ImageUrl12).
Optionally set the following parameters:
Parameter | Example | Explanation |
Delete existing images (DeleteExistingImages) | true/false | True: removes the product's existing images before the new one is added. False: keeps them and adds the new one alongside. |
Image folder (ImageFolder) | C:\ProductImages | Optional. Base folder placed in front of the image column if it contains only file names instead of full paths. |
Run Compare first to see the changes, then run Update Sapera. SyncTool creates the image as media and attaches it to each of the listed products.
Test with 2-3 item numbers before you run the whole list, and afterwards check a couple of the products in Sapera to confirm that the image was attached correctly.
If you do not want an image column in the source list, SyncTool can instead find the images automatically from the file name. Put the images in a folder, named after the pattern <ItemNumber><Separator><sequence number>, for example SKU123_1.jpg, SKU456_1.jpg.
Note: this route requires one physical copy of the image per item number (the same image copied and renamed for each item number), and only .jpg, .jpeg, .gif and .tif are matched this way. The source list must still have an Identifier column, but no image column.
Parameter | Example | Explanation |
Image folder (ImageFolder) | C:\ProductImages | The folder scanned for image files. |
Image no. separator (ImageNoSeparator) | _ | Separator used in the file names between item number and sequence number. |
See also Action: Products and the overview SyncTool – actions.
