Applies to Version(s): 3.9.x  Series

Complexity Level: Advanced

Estimated Time for Completion: 15 minutes


Overview 

Sometimes our clients ask, "I exported all of my products into a spreadsheet, but why is the Image URL column empty?" Well, that column is only used when your product images are hosted externally on a separate server or service. So how can you find your product image URLs if you host them in PinnacleCart? This article will tell you how.


Note: This article shows how to use Concatenate in Microsoft Excel. If you're using another software for your .csv files, you will need to look up how to do the operation specifically in that software.


Getting Your Image URLs into an Excel Spreadsheet

    1. In your admin area, click Products & Categories > Browse Products on the left side.

    2. On the products list page, click Bulk Actions and select Export.

export products

    3. In the pop-up, choose Export all products in the current search result, then click Check All. Click Export.

bulk export products


    4. You should then see the products.csv file downloading in your browser. 

    5. Once downloading is done, open the file. In the example below, we've opened the file in Excel.

    6. Right-Click on Column A and choose Insert. This should place a column to the left of your Product ID column.

insert button excel

    7. The column header should read URL to Product Images or something similar. Every row for this column should be the full URL to the product image directory. This directory would be your store URL plus /images/products/

For example https://mytotallyawesomestore.com/images/products

URL product images header


Note: Images you upload to products are automatically renamed to use the product ID in the name, followed by the file extension. For example, a product with the ID of strawberry_pie would have .jpg image named strawberry_pie.jpg.


8. Right-click on the Product ID column again (which is now column B), and choose Insert again. The column header should read something like Image Type. Each row should then show the image file type for that specific product.


If you know all your images are .jpgs, for example, then this part should be easy. Every row would read .jpg. However, if you have different file types, a bit more research would be involved. This might include using your File Manager to navigate to the /images/products folder to see each image type. As mentioned in the note above, you can tell which image is meant for each product because the image name matches the product ID.

image type


9. Now, go to the column for Image URL. This should be around column A L. You will want to type the following formula: =CONCATENATE(A2,C2,B2) then hit enter. This will merge your first column with the URL, your Product ID column, and your image file column into one line, thus creating the full URL to your image.


insert excel formula


10. Next, click on the column you just entered that formula into. At the bottom right of the highlighted border is a tiny square. Double-click it and it will fill out the rest of your column with the same formula. Now every product will contain the image URL in this column. 

auto fill column


11. From there, you can copy the text of the column, right-click on the highlighted rows, choose Paste Special, then choose Text. This will replace the formula with the actual text. Now you can remove the first two columns of the spreadsheet.



Links to Related Articles 

Exporting Products Into A Spreadsheet


If you didn't get your question answered, please contact the Pinnacle Cart Support Team. To submit a ticket, go to the My Account drop-down menu at the top right of the admin area and select Support.