How to Import Images to OpenCart via CSV Using URLs
Need to massively add new products to OpenCart or update already existing ones? You’ve got the information in the file? Then most likely you are looking for tool to help you import the data into OpenCart, since by default this functionality is not offered in back-end.
Considering import extension to use, make sure that it supports import of images located remotely, since very often suppliers give spreadsheets with image URLs listed, instead of sending actual folders with images that, by the way, are usually big in size. In addition, sometimes it's simply faster and easier to reference an image from an external URL, rather than searching through files and folders, looking for exact image name related to appropriate product.
If you are still reading, you most likely think that import of remote images must be difficult. Well, actually it isn’t, if you are using Store Manager for OpenCart. With the application there is no need to download each image to your computer/upload to your FTP and type each image name in front of corresponding item. These operations take too much time and can be eliminated completely.
Store Manager for OpenCart imports multiple remote images and places them at your FTP (folder image/data), the same time establishing relations with the products for which they were uploaded.
Image URL needs to be of the format as in the following example -
Picture should not be direct php-request and it needs to have extension at the end.
Image formats accepted, depend upon the allowed image extensions predefined in OpenCart itself (.jpg, .png, .gif, .sfw).
Multiple Image URLs for One Product
If you would like to better showcase your products, showing the its pictures taken from different angles, it is not a problem, just specific way of picture placement in the file is needed.
In OpenCart you can add main image to the product as well as multiple additional images. For that in the file you need to have columns: ‘Image’ and ‘Extra Images’.
So to add multiple pictures from URLs is possible by adding a few links in ‘Extra images’ row of your file. Important to separate them by some delimiter symbol (without blanks). Have a look at these examples -
http://mysite.com/img1.jpg*http://mysite.com/img2.jpg*http://mysite.com/img3.jpg (asterisk symbol in between)
or something like
http://mysite.com/img1.jpg|http://mysite.com/img2.jpg|http://mysite.com/img3.jpg (pipe symbol)
In case you have got each additional image in separate column in the file, it is not a problem. There is no need to manually adjust the file, since it is possible on-the-fly during import with the help of special expression rule.
Where 1, 2, n denote numbers of columns in your file where you have images; and pipe and asterisks as possible variants of separators used.
This rule will merge the separate columns with images into one and this way adapt the file to necessary format.
Settings necessary for upload of OpenCart images are the following:
- correctly link columns with images from your file to database fields, where records on pictures should be placed
- in case you are having multiple image URLs in the file (as was mentioned above), you need to indicate separator used
- check the box to upload images (see above screen-capture).
Try to import images by URL today, while your competitors spend days on downloading images manually!