Upload product photos via CSV

Upload product photos in bulk via CSV file, using links to your image hosting provider.

The image URL shared must be a link that has public access. If it is a private link or has security measures we cannot convert that link to our CDN (Cin7 Core link). We save the image in Cin7 Core by converting that image link to a Cin7 Core link.

Any link can be used but it has to be publicly accessible. Once images have been imported to Cin7 Core the privacy settings can be changed back to private.

Prerequisites

• Create products and services

• You will need the Inventory: Products and familiespermission in order to export and import product information via CSV.
  

Dropbox

In this example, we will use Dropbox as the image host.

1. Select Inventory from the main menu, then Products.

2. Click Export, then Images and attachments. This downloads a CSV file.

3. Generate a link of the image file from Dropbox. This is not a direct link to the image file itself, but rather to an interstitial page that frames the image and gives you options for downloading the file. In this format, you can't embed it, but this will be fixed in the next step.
   

4. After you copy the public Dropbox link to your clipboard, just change ?dl=0 to ?raw=1 at the end of the URL. This will change the link to one that will work. The link should look like this: https://www.dropbox.com/s/mn5smjgwtlbndqu/dropbox-dropdown.png?raw=1

5. Enter the image URL and file names into the downloaded Images and attachments CSV template.

6. In Cin7 Core, click Import, then Images and attachments to upload the CSV file back into Cin7 Core and update your product images.

Google Drive

Google Drive images were previously supported, however, changes in Google Drive API means that this is now only available through a fairly complex and time-consuming workaround. We recommend using Dropbox for image upload if possible.

Google Drive links must be shared with visibility to Anyone with the link for this trick to work.

Extract Google Drive URL

1. Select Inventory from the main menu, then Products.

2. Click Export, then Images and attachments. This downloads a CSV file.

3. First, extract the default image URL provided from Google Drive. This URL is not publicly accessible and must be changed to make it suitable for the upload.
   

4. Populate the CSV file using the default image URLs provided by Google Drive.

5. Use Find & Replace to change the default URLs:

   • Find: https://drive.google.com/file/d/

   • Replace with: https://drive.google.com/uc?export=download&id=
     

6. Next, remove the unwanted characters which appear after file ID using find and replace:

   • Find: /view?usp=sharing

   • Replace with:
     

7. The amended URL then looks like: https://drive.google.com/uc?export=download&id=1dz03s56XdDXOMbzqg6u1XU-ftNv9_as9.

8. In Cin7 Core, click Import, then Images and attachments to upload the CSV file back into Cin7 Core and update your product images.
   

• Publish to everyone.4.log-2010416261.zip30 KB