Image Downloads & Uploads

DropBox

All you have to do is change the ?dl=0 to ?dl=1

When it has an =1 at the end, it will trigger an instant download rather than loading the web viewer of the file.

Google Drive

• You don’t need a “.jpeg” file path to download, the file path just needs to cause a download to happen right away.
• In Google Drive, a share link will take you to a web page with the browser viewer. This is no good because you would have to individually download each image.
  https://drive.google.com/file/d/DRIVE_FILE_ID/view
  
• Copy each Google Drive share link and paste them into an Excel spreadsheet column.
• Use the Find & Replace function to remove "/view" from the end of the URL.
• Use the Find & Replace function to replace the Google Drive share link with https://drive.google.com/uc?export=download&id=DRIVE_FILE_ID
  

Convert WIX Image URL

You cannot just right-click and copy an image from a WIX website. Use this spreadsheet link to convert to a standard image URL.

Website Image Upload Link

• Make sure all image file names are the product SKUs with the same number of characters.
• Copy all the SKUs onto an Excel spreadsheet column.
• Upload all images to the website library in a new folder.
• Click on an image to get the URL
  https://irp.cdn-website.com/site_id/dms3rep/multi/image_sku.jpeg
• Copy the same image URL down all the rows of the spreadsheet
  
• In the next column, use the formula: REPLACE(old_text, start_num, num_chars, new_text)
  old_text = The column with the image URLs
  start_num = The position of the character in old_text that you want to replace.
  num_chars = The number of characters in old_text that you want REPLACE.
  new_text = The column with the image_sku that will replace characters in old_text.
  Click here for examples
• Add a new worksheet tab to paste the actual values into a column (don't paste the formula)