Adding Ribbon image links in your CSV Product File

Whether you have uploaded your images to the Ribbon server or are using links hosted on your website, you can now match the product images links with the corresponding products on your CSV product file. There are two methods for adding image URLs;

• Manually (easy)
• Using 2 options for excel formulas (advanced)
  • Concatenate 
  • V-Lookup

Adding image URLs manually

The easiest way to add the URLs to you product file is to manually copy and paste the URLs for each product into your Product file. If there are several image URL for the same SKU you can separate them with a coma.

Adding image URLs using one of two excel formulas

Another method that may be less time consuming but a little more advanced is to match up URLs with your product file using excel formulas. This allows you to match multiple links at once.

There are two methods to do this, concatenate or V-lookup. Both are bulk matching methods that assume that the image file names are exactly the same as the SKUs for the corresponding product in the product file. Example, if the product SKU is RT-3421, then the image file name must be RT-3421.jpg (or whatever file format you are using).

-

Concatenate Method

Using concatenate combines text from different sources into one cell. This is the easier method but it will not let you know if there are any missing image links

• From your image export file
  • copy the first part of any one of the image URLs
    • exclude the item SKU at the end of the URL

• Back to your product file
  • Insert a new column next to the SKU columns

• • click in the cell next to the first SKU

• • Use the following formula
    • =CONCATENATE("link",reference cell,"file extension")
      • "link" is the copied image URL (without the specific SKU)
      • reference cell is the value that will be added to the URL link
      • "file extension" is the .jpg or specific file extension for the image
      • Example from sample below: =CONCATENATE("https://s3.amazonaws.com/meetribbon.com/images/60756cd4f5c8cf0ca2ad695c/assets/",A2,".jpg")

• • • Copy the formula down column B

• • Copy all cells in column B and Paste Values only in the "Image URL" column

• • For any variant SKUs copy and paste the URL from the "Image URL" column to the "Variant Image" column

-

V Lookup Method (advanced)

This is the more advanced method and it will let you know if you have any missing image links

• Make sure SKU is in column A of both product file and image export
  • The SKUs in column A of both files must match exactly
• Create a second tab (temporary) on the Product file. Keep the name 'Sheet1'
  • Paste the image name and image URL columns (from image export) into the blank tab

• • Select all values in column A (not header or image name) and do a 'Find and Replace' (Ctrl F)
  • Click the 'Replace' tab in the search box
    • Type the file extension (.jpeg, .jpg, .png, etc [don't forget the dot in front of the extension]) in the 'Find what' bar
    • Keep the 'Replace' bar empty

• • • Click 'Replace all'
      • This will remove the .extension from the image title and just leave the SKU as the title

• Go back to Product file
  • Insert a column next to SKU
  • select cell next to top most SKU
  • Write V Lookup formula
    • =VLOOKUP(A2,'Sheet1'!lookup range,2,FALSE)
      
      • Important note: The lookup range needs to correspond to all the "SKU Name" and "Image URL" rows in the 'Sheet1' 
        •  In this example the range we are using is $A$2:$B$6
        • The $A$2 should stay constant
        • The $B$6 will change and will be $B$(the last row of the field)
          • Eg. If your Sheet1 range has 250 rows the range will be $B$250

• • • The URL for the corresponding photo will now be in Cell B2

• • • • Copy the formula down the B column to show image URLs for all SKUs in column a

• • Copy all values in column B and Paste Values only into Image URL column

• • For any variant SKUs copy and paste the URL from the "Image URL" column to the "Variant Image" column

Save your product file as a CSV