[intro]Before you begin this Guide it’s essential that you have exported your Products to a spreadsheet beforehand. [/intro]
In this Guide, you’ll learn how to update your Product Images using a spreadsheet. Although this can be done quite easily within the Add/Edit Product window, if your Product has a lot of Variants, or you have a lot of Products where you want to update the Product Images, then the quickest method is to use spreadsheets to make all of these changes in one go.
[remember]Before you begin, you need to ensure that you have uploaded all of the new Product Images to the File Manager of your EKM online shop. If you’re not sure how to bulk upload your Product Images, then this Guide will help you. [/remember]
Preparing your Spreadsheet
1. When you have opened the file, you should have a spreadsheet which looks something like this:
2. The first thing you need to do to the spreadsheet is to add the ‘Edit’ command so that when you upload the file back to your EKM online shop, the system knows that some extra details have been added to an existing Product. Click the A column to highlight it, and then click the Find & Select icon on the top right-hand corner. In the drop-down menu, select Replace:
3. In the window that appears, add the word ‘Product’ in the Find What field and the words ‘Edit Product’ in the Replace With field, before clicking the Replace All button:
4. This action will amend the ‘Product’ and ‘Product Variant’ rows to read ‘Edit Product’ and ‘Edit Product Variant’ accordingly. When you upload your spreadsheet onto your EKM online shop, the system will be aware that some of the data for the Products has been amended.
Updating the Image Addresses
5. To begin, you need to delete the rows containing any Products that you don’t wish to change the Product Images on. You can do this by highlighting these rows and right-clicking them, before selecting Delete from the drop-down menu:
6. Your next step is to scroll along your spreadsheet until you see the Image1, Image2, Image3, Image4 and Image5 headers:
7. You now need to delete the ImageAssigned text from each of the columns. You can do this by highlighting the cells and then clicking the Delete button on the right-hand side of your keyboard:
8. The next step is to scroll along to the Image1Address, Image2Address, Image3Address, Image4Address and Image5Address columns:
9. The contents of these columns will refer to your old Product Images, so you need to delete the image addresses from here, by highlighting the cells and pressing the Delete key on the right-hand side of your keyboard:
[tips]If you are changing the images on a Product that was different Colour Variants, it’s a good idea to colour the cells for each Variant Colour before you begin pasting in the new Product Image addresses.
1. To do this, look for the VariantItem column that references the different Colour Variants. On my spreadsheet, this is column AP:
2. Highlight the rows on the left-hand side for each individual colour:
3. Then click the paint icon to select the relevant colour for those rows:
10. You then need to copy the image addresses for your new Product Images from the File Manager and paste these into the relevant cells for Image1Address, Image2Address, Image3Address, Image4Address and Image5Address. You can do this by right-clicking the address beneath the image within File Manager and selecting Copy:
[remember]Image1Address is the main Product Image, whilst Image2Address, Image3Address, Image4Address and Image5Address are the additional Product Images. Ideally, you need to have five images for each Product and ensure that there are no spaces when you add images.
As an example, if you only have three images, you need to make sure you populate Image1Address, Image2Address and Image3Address and not Image1Address, Image2Address and Image4Address. Don’t leave any gaps! [/remember]
11. When you have finished populating the Image1Address, Image2Address, Image3Address, Image4Address and Image5Address columns for each Product you're changing the Product Images on, your next step is to save your spreadsheet by clicking the symbol in the top left-hand corner:
You then need to save your changes, before uploading your spreadsheet back on your EKM online shop.
- Uploading your spreadsheet onto your EKM online shop
- Hiding your Categories
- Adding Custom Meta Data to your Categories
[contact] If you need our help with your EKM online shop, contact your Account Manager or Customer Support, who will be able to point you in the right direction. We're open from 8am-6pm weekdays and 9am-5.30pm on the weekends. If you'd like to suggest a feature or an upgrade on any of the EKM platforms, please let us know on the EKM Suggestions board. If you have a non-account specific question ask the EKM Team, join us in EKM Community. [/contact]