Hi. How can we help?

Importing images in bulk

In Retail POS, you can manually upload images while creating new products individually. For existing products, you can use the import function to upload images in bulk.

Formatting your image upload file

You can either download the template and enter your product information or download and modify a copy of your inventory file.

To download and prepare your inventory file:

  1. Navigate to Catalog > Products.
  2. (Optional) Filter your list to include only the products you want to update.
  3. Click Export list.
  4. Select your preferred file format from the dropdown. Your file will automatically download.

    Export list dropdown showing file type options.

  5. Open the file in Google Sheets or Excel.
  6. In the spreadsheet, delete the rows for any products you don't need to update.
  7. Delete all columns except for id, handle, sku, and name.

    Spreadsheet with only id, handle, SKU, and name columns displayed.

  8. Rename the id column to product_id.
  9. Add a new column and name it image_url. If adding multiple images, continue to add columns image_url_2, image_url_3, etc. You can add up to five images at a time in this way.

    Spreadsheet with product_id, handle, SKU, name, and image_url columns displayed.

    If your product has variants, you can add 1 variant image in this way by creating a variant_image column. The image you link to will automatically apply to the parent variant of your listed product. You can add more variant images manually by editing the product.

    Spreadsheet with multiple image_url columns and variant_image column.

Values in the product_id, sku, and handle columns must be an exact match to the values in Retail POS. If you modify these fields, your images may fail to import correctly.

Preparing image URLs

To upload images to Retail POS, you need to use an external image hosting service and provide the direct URLs to your images. These URLs must link directly to an image, not a folder or wider website. Once you've uploaded the images, they are saved on Lightspeed servers and the original URLs are no longer needed.

  1. Format your images to .JPEG, .JPG, or .WEBP file types at a maximum size of 10 MB.
  2. Upload your image files to an external image hosting service like Dropbox. Google Drive is not recommended due to limited fetch requests.
  3. In Dropbox or similar, copy the direct URLs to the uploaded images and paste them into the image columns in your spreadsheet. Add only one link per cell.

    The process for copying direct image URLs varies by image hosting service, but generally you can click on the image > Share > update the view permissions if needed > Copy link. Test the link in an Incognito window to verify it links directly to the image.

  4. If you're using Dropbox, find and replace any instances of dl=0 with raw=1 in your image links.

The product_id values will be matched to products in Retail POS. If no match is found, the sku and handle values will be used instead. Do not modify these values, or images may fail to import correctly.

Importing your image spreadsheet file

  1. Navigate to Products.
  2. Click Import.

    Products page with Import button emphasized.

  3. Drag and drop your file or click Select a file to upload... and choose your file.

    Import products page with option to Select a file to upload...

  4. Click the Additional details tab.

    Map columns page with Additional details tab emphasized.

  5. In the Product images section, use the Spreadsheet column dropdowns to map each column.

    Product images section showing Product Image 1 dropdown options.

    As you map each spreadsheet column, the Import status column will change from Unmapped to Mapped.

    Product images section with several Product Image columns mapped and Import statuses showing as Mapped.

  6. When finished, click Import matched fields.
  7. If a warning appears, click Continue anyway.

You'll be automatically redirected to the Products page, and your product images will upload. When uploading is finished, you'll see a dot on your notification header icon.

Products page with notification icon emphasized, showing notification dot.

You can click the notification header icon to confirm a successful upload.

Notifications pop-out showing that the import was completed with all images imported.

If you see a notification stating that some images couldn't be uploaded, click View skipped images (CSV). A .CSV file will automatically download. Open the file in a spreadsheet program and fix the issues noted within, then reupload your edited file.

What's next?

Adding standard, variant, and composite products

Add different types of products to your inventory.

Learn more

Importing products in bulk

Use a spreadsheet to import many products at once.

Learn more

Attachments

Was this article helpful?