Bulk-Importing Product Images via Dropbox
You can bulk-import product images into Acenda by hosting them on a service like Dropbox and using direct links to build an import file.
1. Choose Your Link Extraction Method
Acenda requires a direct path to your image file. Choose the method that best fits your technical comfort level to get these links.
Option A: The Simple Way (No Macros)
If you want to skip Excel macros and incognito windows, use a dedicated link generator.
Host your images in a public Dropbox folder.
Copy the Folder Link (ensure it is set to "Anyone with the link can view").
Use a tool like the Paperform Dropbox Link Generator or Yasir Kula's Tool.
These tools will output a list of Direct Download URLs that are already formatted for Acenda.
Option B: The Standard Way (Excel Macro)
Use this if you prefer to keep your data entirely within Excel.
Copy Images as Links: Open your Dropbox folder in an Incognito window, highlight your images, and press Ctrl+C.
Extract with Macro: Paste into Excel cell A1. Use the following code in the Visual Basic Editor (
Alt+F11):VB.Net
Sub ExtractHL() Dim HL As Hyperlink For Each HL In ActiveSheet.Hyperlinks HL.Range.Offset(0, 1).Value = HL.Address Next End Sub
Run the Macro: This will place the raw Dropbox URLs into Column B.
2. Format Links for Acenda (Critical)
Acenda cannot "read" standard Dropbox preview links. You must modify the URLs in your spreadsheet using Find and Replace (Ctrl+H):
Step | Find What | Replace With | Reason |
1 |
|
| Bypasses the Dropbox web interface. |
2 |
|
| Forces the browser to serve the raw image data. |
Pro Tip: A valid link should look like this: https://dl.dropboxusercontent.com/scl/fi/xyz/image.jpg?raw=1
3. Prepare the Import File
Create a CSV file (UTF-8 encoded) with the following headers:
sku: Your unique product identifier.
images.default.main.url: The direct download link for the primary image.
images.default.1.alternate.url: (Optional) For additional images.
4. Import into Acenda
Navigate to Imports/Exports > Import.
Click + New Import and select Catalog.
Upload your CSV and map your columns to the corresponding Acenda image fields.
Important: If updating existing products, check Overwrite any records that have the same ID.
Click Start Import.