Importing Images and Product Attributes via the Product Import Tool | BG_051
In this tutorial, we will learn how to include images and product attributes as part of the batch upload process for products.
1. Navigate to Upload Folders
First, we need to create a folder location to upload product imagery
2. Click on Add New Upload Location
3. Enter a name and description
4. Enter the folder name ProductImage
5. Check the folder as Active
6. Click on Insert
7. Click on Manage
8. Click on Upload and select a file (or files) to upload
9. Click close
10. The image name as seen here is what will be input into the batch import Excel sheet
This includes the file extension, so for this file we would use "Banner.png"
11. Navigate to Product Attributes
Next, we will create some product attributes and associated values.
Other tutorials are available discussing the creation of attributes in further detail.
12. Click on Add new
13. Type "SampleAttribute"
14. Click on Save
15. Navigate to Product Attribute Values
16. Expand the attribute
17. Click on Add
Add one or more attribute values
18. Navigate to Product Management
19. Click on Import from Excel
20. Download and modify your product Excel file
Add two new columns to the end of the sheet named ProductImage and ProductAttributes.
Within ProductImage, enter the image name you would like to use as it appears in the Upload location.
Within ProductAttributes, enter the name of the attribute(s) you would like to use.
21. Select the file from the upload menu
22. Select the corresponding upload location
23. Check Allow any value for specification attribute
24. Click on Import from Excel
25. Products will be updated or created with the image and attribute data included
26. Click on SampleAttribute
In this video, I'm sharing additional information on how to use the Batch Upload Tool for uploading multiple photos to a product at once. I highlight that using this tool will overwrite any existing images associated with the product, which is crucial to note. I also walk through the process of preparing an Excel file with the necessary image links separated by a pipe symbol
How to Use the Batch Upload Tool for Multiple Product Images
1. Introduction to the Batch Upload Tool 0:00
-
This video provides additional information on using the Batch Upload Tool.
-
The focus is on uploading multiple photos to a product at once.
2. Important Note on Existing Images 0:18
-
When using the batch import tool, existing images on the product will be deleted and replaced by the new images being uploaded.
3. Setting Up the Example 0:36
-
Example product: 'image upload test' with one existing image.
-
Goal: Upload multiple images to the product.
4. Preparing the Upload Folder 1:02
-
Ensure you have an upload folder ready.
-
Example images: 'connect.png' and 'storefront.png'.
5. Exporting to Excel 1:10
-
Export your entire database to Excel.
-
Locate the row for the specific product you want to update.
6. Adding the Product Image Column 1:20
-
Ensure there is an additional column labeled 'product image' in the Excel document.
7. Formatting for Multiple Images 1:34
-
To upload multiple images, list each image name (including extension) separated by a pipe symbol (|).
8. Re-importing the Excel File 2:08
-
Select the modified Excel file for import.
-
Choose the relevant upload location for the images.
9. Checking for Errors 2:21
-
Confirm that no errors occurred during the import process.
10. Verifying the Upload 2:35
-
Refresh the product page to see the changes.
-
Check that the existing image has been replaced and the new images are visible.
11. Conclusion 2:55
-
Successfully uploaded multiple images to the product using the batch import tool.
Link to Loom
bulk image upload, batch product import, add images to products, upload multiple product photos, import product attributes, Excel product upload, product image update, how to import product data, uploading pictures for items, attribute-based product import