Quick Start Guide for Bulk Image Butler - Excel Mode

Welcome!

We're thrilled you've installed Bulk Image Butler. Here's a quick guide to help you get started!

Overview

Bulk Image Butler has two modes. Now, let's learn about the Excel Mode. In this mode, you export product images to an Excel file, make edits, and then import the Excel file back to sync with your store.

Steps in Excel Mode:

  1. Export the Excel file.

  2. Edit the Excel file: add new images, update existing images, or delete images.

  3. Import the Excel file.

Let's get started!

Export the Excel file

  1. Go to Bulk Image Butler > Product Images.

  2. Click More, then Export Excel.

  3. In the confirmation box, select the default options and click Confirm.

  4. Wait for the export to complete, then click Download to get the Excel file.

Edit the Excel File

Open the exported Excel file.

Understanding Each Column

TitleDescription

Product Title

The product's title, indicating which product this data belongs to. Do not modify this column.

Image Url

The current image URL for display purposes. Do not modify this column.

Image AltText

The image's AltText. Edit this to update the alt text in your store.

Image Position

The image's position. Edit this to reorder images. Leave blank for new images to be placed last.

Variants

The variants the image belongs to. Separate multiple variants with commas. Each variant can have one image.

Action

The action to perform: A (Add), D (Delete), U (Update). This is the most important column.

New Image Path

The path to the new image. Supports URLs or relative paths for images in a zip file.

Product ID

The product's ID. Do not modify this column. Ensure it's correct when adding new images.

Image ID

The image's ID. Do not modify this column. Used for deleting or updating images.

Adding Images

  1. Add two new rows under Straw Large Capacity Bag and fill in the Product Title and Product ID correctly.

  2. Add image details:

    • URL: https://cdn.pixabay.com/photo/2024/01/11/12/46/pitbull-8501582_640.jpg

    • Local image: german-shorthaired-pointer-8655457_1280.webp (inside a zip file).

Fill in the Action column with A for Add and provide the image path in New Image Path.

Updating Images

  1. For frog sku, update Image AltText, Position, and Variants.

  2. Make sure to fill in the Action column with U for Update.

Deleting Images

  1. For the image you want to delete, fill in the Action column with D for Delete.

Import Excel

  1. Go to Bulk Image Butler > Product Images.

  2. Click More, then Import Excel.

  3. In the pop-up window, upload the Excel file and the image zip file. Click Confirm.

The system will validate each row in the Excel file and then redirect to the task details page. You can review and remove changes if needed. Click Start Task to execute the task.

Conclusion

That's it! You've completed the Excel Mode tutorial. Thank you for reading. Feel free to explore other documentation. If you have any questions, please contact us.

Last updated