This article is also available in:
This article will guide sellers to convert product images from product image links in CSV files to make order fulfillment more time-saving and accurate. When processing multiple orders at the same time, inserting product pictures in CSV file helps sellers know exactly about products to send customers by opening and checking the information in CSV file.

In this section:

A. Export your orders with Line item image link in CSV format
B. Convert image URLs link to actual images

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

Step by Step Tutorial

From your ShopBase admin, go to Orders > All orders.

Select orders that you want to fulfill.


Select Export.


On the new popup, click Selected ... orders in Exports section, choose Customize export fields in Export template.
After that, choose the fields you want to export. In this instruction, there are three required fields such as Name, Lineitem Name, Lineitem Image. You can select these fields by pressing the + corresponding to the information fields in the Available Fields column in the Customize export fields section. After being selected, these fields will be displayed in the Fields To Export column as shown below.


Click Export to file when you finish.


Note:

Please check carefully to ensure the information fields in the columns are clearly separated, avoiding the case of erroneously converting from linking product images to product images.

B. Convert image URLs link to actual images

Step by Step Tutorial

Open the downloaded CSV file in section A with Microsoft Excel, right-click on any white space in the icon range. A drop-down menu appears then select Customize the Ribbon.


Select Developer then choose OK.


The Devleoper tab will display on Microsoft Excel.


In Developer tab, choose Visual Basic to open the Microsoft Visual Basic for Applications window window.


When Microsoft Visual Basic for Applications window opens, choose 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:

In the code above, there are some customizing values ​​you can change like Rows ("2: 7") to define the scope of all lines of product information in the CSV file (in this example it is line 2 through 7), RowHeight = 60 is the height of the lines in the CSV file (60 pixels in this example), ActiveSheet.Range ("C2: C7") is the coordinates of the cells containing the link. the product image (in this example it is from cell C2 to cell C7).

With this code, you can not specify the size of the extracted images to your need.

The code above can extract only 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.


Note:

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.

Then, all images converted from product image links will immediately display the right column of Lineitem Image column corresponding to each product as shown below:



Related articles

Fulfill order manually
Fulfill orders by CSV files
Fulfill order via PrintHub
Fulfill order via Ali Dropship Connector
Fulfill order via CrossPanda
Was this article helpful?
Cancel
Thank you!