This instruction only works when using Microsoft Excel on Windows.

On this page

A. Export your orders with Line item image links in CSV format

B. Convert image URLs link to actual images


A. Export your orders with Line item image link in CSV format

Steps

From your ShopBase admin, go to Orders > All orders.
Select orders that you want to fulfill (by filtering or in the next step)
Select Export.



On the new popup, select "Customize export fields" then choose the fields you want to export. In this instruction, there are Name, Lineitem Name, Lineitem Image added.



Click Export to file when you finish.

Then you'll be able to download your order CSV file. Open this file by Microsoft Excel:




B. Convert image URLs link to actual images

1. Enable the Developer Tab in Microsoft Excel

Right-click on any of the existing tabs on our ribbon.
This opens a menu of options, select Customize the Ribbon.



Select the Developer checkbox and click OK.



The Developer tab is now visible.



2. Convert image URLs to actual images

Open the downloaded file in Microsoft Excel.
Select Developer Tab and click Visual Basic to open the Microsoft Visual Basic for Applications window.



Click Insert > Module.



Paste the following code in the Module Window.

Sub URLPictureInsert()
Rows("2:7").RowHeight = 60
Dim Pshp As Shape
Dim xRg As Range
Dim xCol As Long
On Error Resume Next
Application.ScreenUpdating = False
Set Rng = ActiveSheet.Range("C2:C7")
For Each cell In Rng
filenam = cell
ActiveSheet.Pictures.Insert(filenam).Select
Set Pshp = Selection.ShapeRange.Item(1)
If Pshp Is Nothing Then GoTo lab
xCol = cell.Column + 1
Set xRg = Cells(cell.Row, xCol)
With Pshp
.LockAspectRatio = msoFalse
If .Width > xRg.Width Then .Width = xRg.Width * 2 / 3
If .Height > xRg.Height Then .Height = xRg.Height * 2 / 3
.Top = xRg.Top + (xRg.Height - .Height) / 2
.Left = xRg.Left + (xRg.Width - .Width) / 2
End With
lab:
Set Pshp = Nothing
Range("A2").Select
Next
Application.ScreenUpdating = True
End Sub




Note:

1. In the above code: Rows("2:7") is the range of line item rows. RowHeight = 60 is the height of the row you want to set. C2:C7 is the range of cells which contains the URL addresses you want to extract the images. You should change the cell references to your need.
2. With this code, you can not specify the size of the extracted images to your need.
3. The above code only can extract the actual images into the cells besides your URL column, you can not specify cell to output the images.

Then press F5 key or click Run to run this code.



After that, all corresponding pictures have been extracted from the image URLs to the adjacent column at once, and the images will be placed at the center of your specific cells, see screenshot:



Please wait some time for the code to finish, this will depend on the number of the rows that the file has. (It takes about 10 minutes for the 650-line file.)
Save the file in xlsx format to keep the file work properly when you send it to others.
Was this article helpful?
Cancel
Thank you!