Importing Product Images From Dropbox
After uploading your product images to a file storage service like Dropbox, you can then generate and use their respective links to import those images to Acenda and your connected sales channels. To do so, follow these steps:
Upload all your product images to a folder in Dropbox. To do so, go to All Files, click Upload or Drop, then Folder, select your image folder, and click Upload. Select the Dropbox folder in which to upload the image folder and then click Choose Location.
Your folder will appear under All Files. Hover over the folder, click Share, and click Copy Link.
Press Ctrl+Shift+N to open an incognito or private browsing window. Paste the folder link in the URL box.
Highlight all the images you want to create links for. If the images are in subfolders, you must open the subfolders first. Press Ctrl+C or right click to copy them.
Open a new Excel spreadsheet. Paste the contents into column A.
Go to the Developer tab, and click Visual Basic on the left hand side. Click Insert, then click Module and paste the following code in the box to the right:
Sub ExtractHL()
Dim HL As Hyperlink
For Each HL In ActiveSheet.Hyperlinks
HL.Range.Offset(0, 1).Value = HL.Address
Next
End Sub
Click out of Visual Basic. Click Macros (to the right of the Visual Basic button you clicked earlier) and click Run.
Add a new tab to your spreadsheet. On the first sheet, highlight columns A and B and copy them into columns A and B of Sheet2.
With columns A and B highlighted on Sheet2, click the Data tab and then click Remove Duplicates. Ensure only column B is checked in the pop up box and click OK.
You will now have the image names in column A and their respective Dropbox links in column B.
Press Ctrl+F and click the Replace tab. Enter dl=0 in the ‘Find what’ field and enter raw=1 in the ‘Replace with’ field and then click Replace All.
The links will then be able to be viewed by anyone. Confirm this by pasting one in an incognito or private browsing window.
Open a new spreadsheet in Excel.
In one tab paste the following headers into the first row: sku, images.default.main.url, and images.default.swatch.url. The main image (images.default.main.url) and sometimes swatch image (images.default.swatch.url) are required. Acenda allows up to 15 alternate images. To add them, insert more headers such as images.default.1.alternate.url, images.default.2.alternate.url, images.default.3.alternate.url, etc.
Use the image names and links you created in steps 1-12 to populate the new spreadsheet with the image links (placed under the main image column and if applicable, the swatch image and alternate image columns) and their respective product SKUs.
Once finished inputting data, save the file as a CSV UTF-8 which is the only file type supported by the import.
Now go to Import/Exports, click the Import tab, and click + New Import. Select ‘Catalog’ from the Import Type dropdown and then select the file you just saved as a CSV UTF-8 by dropping it or browsing.
You will now see a list of all your file’s attributes (source headers) next to data mapping fields. In the ‘Select Field’ box choose the Acenda mapping to use for that attribute. You can only use a mapping once per upload. The system will automatically find the closest match if your header is already an Acenda mapping. Check the box to the attribute’s left to enable it.
To save the upload file format for future use, check the box next to ‘Save custom import profile for future use’ and give the profile a name in the box which appears once checked. You can then select that saved profile from the ‘Import Profile’ dropdown where it says ‘- - Custom Import Profile - -’ to automatically map future image uploads with the same column headers your initial upload used.
If the upload contains only new SKUs leave the next two boxes unchecked. If adding new SKUs as well as updating existing SKUs check the ‘Overwrite any records that have the same ID’ box, and if only updating existing products check the ‘Only update existing records’ box.
Click Start Import.