How to import images in bulk into Linnworks

Scenario

I want to import images in bulk into Linnworks for my stock items

Solution

In order to add images to a stock items in bulk, they have to be hosted on a publicly available file sharing service, such as a webserver, direct links from services like Dropbox or Google Drive. First, create a CSV file with columns for at least SKU and either Image URL or Primary Image. Multiple images can be imported for each SKU in one row, please ensure that each column has a unique name:

SKU Primary Image Image URL Image2 URL Image3 URL
SHOE1 https://dl.dropbo...w8/Milan4.jpg?dl=0 https://dl.dropbo...fv/Milan2.jpg?dl=0 https://dl.dropbo...10/Milan3.jpg?dl=0 https://dl.dropbo...w8/Milan4.jpg?dl=0
SHOE2 https://dl.dropbo...b3/Tokyo1.jpg?dl=0 https://dl.dropbo...ke/Tokyo2.jpg?dl=0    

This file needs to be imported as an Inventory Import. Column headers in the CSV file that match Linnworks fields will map automatically. Normally, a Linnworks field cannot be mapped to more than one column in a CSV file. However, Image URL is an exception to this and can be mapped to multiple file columns  

Creating a CSV file

Copying URLs into the CSV file can be time-consuming and there is a workaround that we would like to suggest. Mandatory requirements for this:

  • All images must be stored in the same folder on the Dropbox
  • All images should have the same name as SKUs

In this case, all the URLs will have the same format and can be created automatically with the formula in a few steps:

  1. To start, create a list of SKUs for which you plan to import images and a column for image URLs:

    ImageImport 1

  2. Place all the images in the same file on the Dropbox and use CONCATENATE formula. In below example, images are stored in the folder 'images' and formula is following: =CONCATENATE("[dropbox]/images/";A2;".jpg")ImageImport 2
  3. This formula will populate the image URLs automatically as the path will always be the same - [dropbox]/folder/, A2 is SKU and .jpg (or png) will be added automatically to every URL: ImageImport 3
  4. Pull down small black square to make below rows using the same formula to create other URLsImageImport 4

After you create the file, you will need to upload it into your Dropbox. Then create an Inventory Import with Dropbox as Method.

Using Import Now

For more information on importing a local CSV file, please see our dedicated KB article. When using Import Now, links will need to be given to the files you are importing that are accessibly publicly or, in the case of an FTP server, by providing login credentials in the URL. If the files are stored on dropbox, google drive or on an FTP server that requires a login, please see our guide about creating public links for these services here.

Using Scheduled Imports

When using scheduled imports, there is a simplified method for giving the location of images if you are importing the CSV file from an integrated dropbox or FTP account.

When using Dropbox, files on the same Dropbox account can be accessed by using the [dropbox] tag. The tag will be interpreted as a link to the root folder that your user credentials give you access to. For instance:

  • If your images are stored in your dropbox folder under: Jimm2Shoes/ShoeImages/Milan/MilanImage1.png
  • This can be given in the CSV file as: [dropbox]/Jimm2Shoes/ShoeImages/Milan/MilanImage1.png

The same can be done if you are importing your CSV file from an FTP server using the [ftp] tag:

  • If your images are stored in the ftp server under: BandB/Resources/Images/VGC201.png
  • This can be given in the CSV file as: [ftp]/BandB/Resources/Images/VGC201.png

Outcome

The images can be seen by searching for the stock item in My Inventory, clicking the SKU to bring up the Product Details window then clicking the Images tab  

Further Knowledge Base Articles

Click here to see more Data Import and Export related knowledge base articles.